Roller 5.2.2 login hanging with
"Williams, David A." <[email protected]> Tue, 18 Jun 2019 19:43:07 +0000
| Newsgroups | gmane.comp.java.roller.user |
|---|---|
| Message-ID | <SN6PR09MB2925BB5932A58F93D7CD650D9FEA0@SN6PR09MB2925.namprd09.prod.outlook.com> |
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]