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 = 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 AM Matt Raible <m...@raibledesigns.com> wrote: > 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’t 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 = > 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/classes/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/. > > I have the following in WEB-INF/classes/roller-custom.properties, but > there is no log file written to /tmp/roller.log. > > installation.type=auto > mediafiles.storage.dir=/tmp/mediafiles > search.index.dir=/tmp/searchindex > log4j.appender.roller.File=/tmp/roller.log > database.configurationType=jdbc > database.jdbc.driverClass=com.mysql.jdbc.Driver > > database.jdbc.connectionURL=jdbc:mysql://localhost:3306/rollerdb?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8 > database.jdbc.username=scott > database.jdbc.password=tiger > > > On Jun 10, 2025, at 18:07, Dave <snoopd...@gmail.com> 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 PM Matt Raible <m...@raibledesigns.com> > wrote: > > > >> Hello y’all, > >> > >> I’m trying to install the latest version of Roller on Tomcat 11.0.8 and > >> getting the following error at startup: > >> > >> 09-Jun-2025 20:42:00.658 INFO [main] java.util.ArrayList.forEach Name = > >> rollerdb Ignoring unknown property: value of "jdbc/roller" for > "mappedName” > >> property > >> > >> Does Roller work with the latest version of Tomcat? I’m 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-guide.adoc#51-create-a-database-for-roller > >> > >> I’m using MySQL 9.3.0 and I had to use the following command for things > to > >> work. > >> > >> GRANT ALL PRIVILEGES ON rollerdb.* TO 'scott'@'localhost’; > >> > >> Cheers, > >> > >> Matt > >
