[RESOLVED]Problems installing openEMM on Centos 6 & Plesk 11

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]Problems installing openEMM on Centos 6 & Plesk 11

Post by liongate »

I am trying to install openEMM on a Centos 6 VDS and have run into a snag. I am following the instructions on this page: http://www.roothelp.net/install-openemm-on-centos-6-x/. Everything has gone along fine until I reached the following commands:

Code: Select all

service mysqld start

/usr/bin/mysql_secure_installation

cd /usr/share/doc/OpenEMM-2013/

mysqladmin -u root -p create openemm
The service starts fine, but when I run /usr/bin/mysql_secure_installation I get the following:

In order to log into MySQL to secure it, we'll need the current password for the root user. If you've just installed MySQL, and you haven't set the root password yet, the password will be blank, so you should just press enter here.

Enter current password for root (enter for none):

This is where the problems start. Apparently Plesk 11 does not create a root user account, using "admin" instead. None of my passwords work here, neither my actual SSH root password, my admin password, or any other password I've assigned. I even started mysql with this script to ensure I had the correct root password:

Code: Select all

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
I tried this to ensure I had the correct password: /usr/local/psa/bin/admin --show-password

None of this has worked, and I am unable to run the command. How can I get around this? If I skip that command (GoDaddy support advised me that it was only configuring MySql, which is already installed with Plesk) and try to run

Code: Select all

mysqladmin -u root -p create openemm
I am again asked for a root password and none work. I also tried this command instead, using the admin password but still had the same problem.

Code: Select all

mysqladmin -u admin -p create openemm
I suspect I'll have to create a database called openemm through Plesk. Any ideas?
Last edited by liongate on Thu Oct 17, 2013 3:04 pm, edited 1 time in total.
liongate
Posts: 27
Joined: Wed Sep 25, 2013 7:20 am

Re: Problems installing openEMM on Centos 6 running Plesk 11

Post by liongate »

Incidentally, yes -- I did try to press enter with no password and still was rejected. There must be a workaround to get openEMM installed on this system -- any suggestions?
liongate
Posts: 27
Joined: Wed Sep 25, 2013 7:20 am

Re: Problems installing openEMM on Centos 6 running Plesk 11

Post by liongate »

The solution to this for me was to create the database from the Plesk control panel, then create the user agnitas@localhost through the control panel. In Plesk 11 you have to navigate to the user accounts through the server tab to assign full privileges to the DB user.
Post Reply