Can't log in after :8080 Ubuntu Linux 10.04

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

Moderator: moderator

seemeinhi
Posts: 2
Joined: Wed Feb 09, 2011 9:28 pm

Can't log in after :8080 Ubuntu Linux 10.04

Post by seemeinhi »

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))
maschoff
Site Admin
Posts: 2628
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

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

Post by maschoff »

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.
OpenEMM Maintainer
seemeinhi
Posts: 2
Joined: Wed Feb 09, 2011 9:28 pm

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

Post by seemeinhi »

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