[RESOLVED] Loading openemm-2013.sql to MySQL database

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

Moderator: moderator

liongate
Posts: 27
Joined: Wed Sep 25, 2013 7:20 am

[RESOLVED] Loading openemm-2013.sql to MySQL database

Post by liongate »

I am using Plesk and have created the openemm database but when I try to import the openemm-2013.sql file into it I am receiving the following message:
QL query:

GRANT DELETE ,
INSERT ,

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

MySQL said:

#1044 - Access denied for user 'openemm'@'localhost' to database 'openemm'
I have created a database user named openemm. What's causing this problem? Is there a password somewhere in openemm-2013.sql that needs to be set for the openemm user? It does appear that the database became populated, and I see the offending script appears at the very end of the openemm-2013.sql file.
Last edited by liongate on Thu Oct 17, 2013 2:57 pm, edited 1 time in total.
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Loading openemm-2013.sql to MySQL database

Post by maschoff »

Did you use MySQL user "root" to create the OpenEMM database?
OpenEMM Maintainer
liongate
Posts: 27
Joined: Wed Sep 25, 2013 7:20 am

Re: Loading openemm-2013.sql to MySQL database

Post by liongate »

I could not use MySql user root because Plesk 11 establishes admin as root and does not permit creation of a MySql root account.
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Loading openemm-2013.sql to MySQL database

Post by maschoff »

IMHO, this is the reason why the database does not work.
OpenEMM Maintainer
liongate
Posts: 27
Joined: Wed Sep 25, 2013 7:20 am

Re: Loading openemm-2013.sql to MySQL database

Post by liongate »

maschoff wrote:IMHO, this is the reason why the database does not work.
I haven't got to the point where I know whether the DB will work or not -- only that I couldn't CREATE it using the command line as instructed in the install guide.
liongate
Posts: 27
Joined: Wed Sep 25, 2013 7:20 am

Re: Loading openemm-2013.sql to MySQL database

Post by liongate »

Okay -- I've got it figured out. There are TWO databases, i.e. openemm-2013.sql and openemm_cms.sql, that have to be imported. When I did the import from the SSH command line, the import actually worked, although I did receive an error at the end. Once I got the second DB installed, I can log in to the administrative panel.
liongate
Posts: 27
Joined: Wed Sep 25, 2013 7:20 am

Re: Loading openemm-2013.sql to MySQL database

Post by liongate »

I understand what was happening how. The database was loading, but the last line, which created and granted access to the agnitas@localhost user was not running. I was able to accomplish this through the Plesk control panel or at the mysql> prompt so now the correct permissions have been assigned.
Post Reply