OpenEMM Technical Support Forum

Posted: **Wed Feb 09, 2011 9:36 pm**

Thought I did everything that instructions said... But got this error.

An error occurred
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))

Posted: **Wed Feb 09, 2011 10:33 pm**

Something is wrong with your MySQL permissions. OpenEMM tries to connect to database "openemm" via user "agnitas" (and PW openemm) but MySQL does not grant access. Please check password and permissions for user agnitas.

File openemm-6.2sql contains code

Code: Select all

GRANT DELETE, INSERT, UPDATE, LOCK TABLES, SELECT, ALTER, INDEX, CREATE TEMPORARY TABLES, DROP, CREATE ON openemm.* TO 'agnitas'@'localhost' IDENTIFIED BY 'openemm';

FLUSH PRIVILEGES;

at the end to create user agnitas with required permissions.

Posted: **Thu Feb 10, 2011 2:00 am**

I found out that I had "missed 1 step" only installed 1 db. I hate it when I get in a hurry! Thanks!

OpenEMM Technical Support Forum

Can't log in after :8080 Ubuntu Linux 10.04

Can't log in after :8080 Ubuntu Linux 10.04

Re: Can't log in after :8080 Ubuntu Linux 10.04

Re: SOLVED: Can't log in after :8080 Ubuntu Linux 10.04