Hi,
We have several environments with instances of Roller running. Our
production instance is still 4.1 but we're preparing 5.2.2 to replace it.
The homepage loads fine (so it seems the DB connection is fine) but
login.rol times out, eventually with a 500 error.
Roller-custom.properties says:
installation.type=manual
mediafiles.storage.dir=/usr/share/tomcat/rollerdata/mediafiles
search.index.dir=/usr/share/tomcat/rollerdata/searchindex
database.configurationType=jdbc
database.jdbc.driverClass=com.mysql.jdbc.Driver
database.jdbc.connectionURL=jdbc:mysql://<our DB
host>:3306/rollerdb522?useUnicode=true&useFastDateParsing=false&characterEncoding=UTF-8
database.jdbc.username=<our user name>
database.jdbc.password=<our password>
database.jdbc.removeAbandoned="true"
database.jdbc.removeAbandonedTimeout="60"
database.jdbc.logAbandoned="true"
database.jdbc.testOnBorrow="true"
database.jdbc.validationQuery="SELECT 1"
mail.configurationType=properties
mail.hostName=localhost
comment.throttle.enabled=true
We're using the roller db for authentication rather than OAUTH or LDAP.
The only intentional differnce between the environment where this works and
where login is timing out is in the working environment, MySQL is running
locally; in the timing out environment, MySQL is on a separate host (as noted,
the db connection seems fine as the main page loads). One rabbit hole I tried
was TCPDump between tomcat server and db host: in both working and non-working
cases, I see DB query when the main page is loaded and no DB query when
login.rol is called from the command line.
I welcome any troubleshooting pointers,
-David
--------------------------------------------
David Williams
Chief, Website Management Branch
Information Management Services
U.S. Patent & Trademark Office
U.S. Department of Commerce
Madison West, 4D35
Alexandria, VA 22314
1-571-272-3877
[email protected]
