Use a different MySQL port than the default 3306

Use this forum for questions regarding installation, upgrading and configuration of OpenEMM

Moderator: moderator

ZenRoe
Posts: 4
Joined: Wed May 21, 2008 3:20 pm
Location: Switzerland
Contact:

Use a different MySQL port than the default 3306

Post 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
ZenRoe
Posts: 4
Joined: Wed May 21, 2008 3:20 pm
Location: Switzerland
Contact:

Solution found ...

Post 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.
Post Reply