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
