Re: Installing Roller 6.1.5 on Tomcat 11

--000000000000683dfa0637a2fd18
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

The log message below seems to indicate that Roller is trying to do "jndi"
configuration instead of what you asked for, which is "jdbc". That makes me
wonder if your roller-custom.properties file is being found, but the logs
seem to indicate that it is being found.

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

There does not seem to be any error message that says the app fails to load
and that is frustrating.

Try putting the JDBC driver jar in the Tomcat ./lib directory if you have
not already tried that.

Hope that helps.

Dave


On Wed, Jun 11, 2025 at 8:56=E2=80=AFAM Matt Raible <[email protected]=
> wrote:

> I was able to get things to start with apache-tomcat-9.0.106. This allowe=
d
> 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
> Exception       Roller has encountered and logged an unexpected exception=
.
>
> In the Tomcat logs, it has the same error message about mappedName.
>
> 11-Jun-2025 06:33:29.239 INFO [main] java.util.ArrayList.forEach Name =3D
> rollerdb Ignoring unknown property: value of "jdbc/roller" for "mappedNam=
e"
> property
> 11-Jun-2025 06:33:29.293 INFO [main]
> org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanne=
d
> 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 classpa=
th
> File path :
> /Users/mraible/Downloads/apache-tomcat-9.0.106/webapps/roller/WEB-INF/cla=
sses/roller-custom.properties
> (To run eclipse junit local tests see docs/testing/roller-junit.propertie=
s)
> Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver
> class is `com.mysql.cj.jdbc.Driver'. The driver is automatically register=
ed
> via the SPI and manual loading of the driver class is generally unnecessa=
ry.
> 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/.
>
> 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?autoRe=
connect=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:
> >
> > Hi Matt,
> >
> > 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.
> >
> > Dave
> >
> > On Mon, Jun 9, 2025 at 10:56=E2=80=AFPM Matt Raible <matt@raibledesigns=
.com>
> wrote:
> >
> >> Hello y=E2=80=99all,
> >>
> >> I=E2=80=99m trying to install the latest version of Roller on Tomcat 1=
1.0.8 and
> >> getting the following error at startup:
> >>
> >> 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
> >>
> >> 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?
> >>
> >> I also noticed that the install guide has back ticks in the MySQL
> commands
> >> when it should have single quotes.
> >>
> >> mysql> grant all on rollerdb.* to scott@`%' identified by `tiger';
> >>
> >> mysql> grant all on rollerdb.* to scott@localhost identified by
> `tiger';
> >>
> >>
> https://github.com/apache/roller/blob/roller-6.0.x/docs/roller-install-gu=
ide.adoc#51-create-a-database-for-roller
> >>
> >> I=E2=80=99m using MySQL 9.3.0 and I had to use the following command f=
or things
> to
> >> work.
> >>
> >> GRANT ALL PRIVILEGES ON rollerdb.* TO 'scott'@'localhost=E2=80=99;
> >>
> >> Cheers,
> >>
> >> Matt
>
>

--000000000000683dfa0637a2fd18--