Page 1 of 1

Use a different MySQL port than the default 3306

Posted: Wed May 21, 2008 3:24 pm
by ZenRoe
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:
  • 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))
Thanks: Peter

Solution found ...

Posted: Wed May 21, 2008 3:43 pm
by ZenRoe
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.