Re: Installing Roller 6.1.5 on Tomcat 11

--Apple-Mail=_82FA4780-4F93-4531-A0B8-C0CDF5AD12CB
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

I was able to get things to start with apache-tomcat-9.0.106. This =
allowed me to create tables and a user. After that, creating a new =
weblog or navigating to the Main Menu doesn=E2=80=99t work.
Unexpected Exception

Status Code	500
Message	Filter execution threw an exception
Type=09
Exception	Roller has encountered and logged an unexpected =
exception.

In the Tomcat logs, it has the same error message about mappedName.=20

11-Jun-2025 06:33:29.239 INFO [main] java.util.ArrayList.forEach Name =3D =
rollerdb Ignoring unknown property: value of "jdbc/roller" for =
"mappedName" property
11-Jun-2025 06:33:29.293 INFO [main] =
org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was =
scanned for TLDs yet contained no TLDs. Enable debug logging for this =
logger for a complete list of JARs that were scanned but no TLDs were =
found in them. Skipping unneeded JARs during scanning can improve =
startup time and JSP compilation time.
Roller Weblogger: Successfully loaded custom properties file from =
classpath
File path : =
/Users/mraible/Downloads/apache-tomcat-9.0.106/webapps/roller/WEB-INF/clas=
ses/roller-custom.properties
(To run eclipse junit local tests see =
docs/testing/roller-junit.properties)
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new =
driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically =
registered via the SPI and manual loading of the driver class is =
generally unnecessary.
INFO  2025-06-11 06:33:30 [main] all - EclipseLink, version: Eclipse =
Persistence Services - =
4.0.5.v202412231137-a96b873527f305f932543045c8679bb1de8d3a43

I downloaded the MySQL driver (mysql-connector-j-9.3.0.jar) from =
https://dev.mysql.com/downloads/connector/j/.=20

I have the following in WEB-INF/classes/roller-custom.properties, but =
there is no log file written to /tmp/roller.log.

installation.type=3Dauto
mediafiles.storage.dir=3D/tmp/mediafiles
search.index.dir=3D/tmp/searchindex
log4j.appender.roller.File=3D/tmp/roller.log
database.configurationType=3Djdbc
database.jdbc.driverClass=3Dcom.mysql.jdbc.Driver
=
database.jdbc.connectionURL=3Djdbc:mysql://localhost:3306/rollerdb?autoRec=
onnect=3Dtrue&useUnicode=3Dtrue&characterEncoding=3Dutf-8&mysqlEncoding=3D=
utf8
database.jdbc.username=3Dscott
database.jdbc.password=3Dtiger

> On Jun 10, 2025, at 18:07, Dave <[email protected]> wrote:
>=20
> Hi Matt,
>=20
> I could be wrong, but I would not expect Roller to work on Tomcat 11
> because the Java EE package names have changed from javax.* to =
jakarta.*. I
> think we need a Roller 7 that moves from javax to jakarta.
>=20
> Dave
>=20
> On Mon, Jun 9, 2025 at 10:56=E2=80=AFPM Matt Raible =
<[email protected]> wrote:
>=20
>> Hello y=E2=80=99all,
>>=20
>> I=E2=80=99m trying to install the latest version of Roller on Tomcat =
11.0.8 and
>> getting the following error at startup:
>>=20
>> 09-Jun-2025 20:42:00.658 INFO [main] java.util.ArrayList.forEach Name =
=3D
>> rollerdb Ignoring unknown property: value of "jdbc/roller" for =
"mappedName=E2=80=9D
>> property
>>=20
>> Does Roller work with the latest version of Tomcat? I=E2=80=99m using =
Java 17 on
>> macOS Sequoia. I created a roller-custom.properties in =
WEB-INF/classes. The
>> guide never seems to specify where this file should go, but ChatGPT =
helped
>> me out. Do I need to add a JDBC driver to WEB-INF/lib as well?
>>=20
>> I also noticed that the install guide has back ticks in the MySQL =
commands
>> when it should have single quotes.
>>=20
>> mysql> grant all on rollerdb.* to scott@`%' identified by `tiger';
>>=20
>> mysql> grant all on rollerdb.* to scott@localhost identified by =
`tiger';
>>=20
>> =
https://github.com/apache/roller/blob/roller-6.0.x/docs/roller-install-gui=
de.adoc#51-create-a-database-for-roller
>>=20
>> I=E2=80=99m using MySQL 9.3.0 and I had to use the following command =
for things to
>> work.
>>=20
>> GRANT ALL PRIVILEGES ON rollerdb.* TO 'scott'@'localhost=E2=80=99;
>>=20
>> Cheers,
>>=20
>> Matt


--Apple-Mail=_82FA4780-4F93-4531-A0B8-C0CDF5AD12CB--