OpenEMM Technical Support Forum

1) created a new db in plesk 8, redhat core 4, latest version of everything, called openemm, and a user called openemm.

2) Did this as root: mysql -u openemm -p openemm <openemm.sql
(entered the password for openemm)

I get:

ERROR 1044 (42000) at line 992: Access denied for user 'openemm'@'%' to database
'openemm'

The error is from the following line of the script:

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

The question is, who is agnitas? Is it a user I have to setup?

Having got beyond (I think) the simple errors I am now having trouble resolving this one which I think may be similar to yours? I'm still trawling the user forum to see if it's answerred elsewhere. I am using

Suse Linux Enterprise 10 SP1
MySQL 14.12 Dis 5.0.26 for suse-linux
OpenEMM 5.4.0
Java 1.6

When I point my browser at:

http://192.168.1.7:8081/logon.do?action=0

I get...

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))

I was being daft (as usual) - the error I got was due to the fact that although I had created the database I hadn't imported the schema. To do that I followed the instructions for the Linux install (page 22):

mysql -u root openemm < /home/openemm/openemm.db

I don't use a password on my test system so I ommit the -p.