- Cause: javax.servlet.ServletException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot create PoolableConnectionFactory (Access denied for user 'agnitas'@'localhost' (using password: YES)); nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'agnitas'@'localhost' (using password: YES))
Use a different MySQL port than the default 3306
Moderator: moderator
Use a different MySQL port than the default 3306
I just installed OpenEMM on a very busy server. The database is listening on port 6606 rather than 3303. Is there a property file which allows me to change this value ? I assume I got to do this because I run into the following:
Solution found ...
Dig harder ..... I found the property file:
./webapps/core/WEB-INF/classes/emm.properties
Thats what I changed:
jdbc.url=jdbc:mysql://localhost:6606/openemm
And it works.
./webapps/core/WEB-INF/classes/emm.properties
Thats what I changed:
jdbc.url=jdbc:mysql://localhost:6606/openemm
And it works.