Latest MySQL Broke Plesk

[Intelehost]

I have been reading on forums, and trying all kinds of different fixes that people have shown results with but I am not having any luck.

Currently Plesk shows the following in the database section.

Warning: The last attempt to control this database server failed.

When I try to create a database with installatron or even within plesk I get an error and it says cannot communicate with the Database server. It creates the database but not the users and thats what is causing the issue.

I have tried the database upgrade, repair, and all of the fixes throughout the various forums.


psa ~]# rpm -qa | grep -i mysql-

perl-DBD-MySQL-3.0007-2.el5
mysql-libs-5.1.50-1.el5.art
mysql-5.1.50-1.el5.art
mysql-libs-5.1.50-1.el5.art
mysql-server-5.1.50-1.el5.art
asl-php-mysql-5.2.13-1.el5.art
php-mysql-5.2.14-2.el5.art
mysql-server-5.1.50-1.el5.art
mysql-5.1.50-1.el5.art


Any Ideas?

[Intelehost]

I forgot to add that I am running Cent OS 5 x64 and plesk 9.5.2 in a VM

uname -a
Linux 2.6.32.16-2.art.x86_64 #1 SMP Wed Jul 7 13:28:00 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

[scott]

No, I don't get that on any system I'm running. Anyone else?

[Intelehost]

I opened an ASL support ticket a while back the last time that my server yum upgraded from msql 5.0.90 to 5.1 and I had to go through the process of downgrading and then everything worked fine. Somehow the system upgraded itself via automated yum again and now I have a semi working mysql server.

The databases they are already in the server work fine but I cannot add any new users so plesk and installatron freak out.

I see other people are using 5.1.50 perfectly so thats why I am so confused... I tried to downgrade it like I did last time and I am getting all kinds of errors this time around.

[mneese77]

I have the same versions of php, mysql, plesk, asl, on down the line...

For testing and to verify my system is working properly, I just created a new DB, with a new user, new password...no problems at all.

The only difference is I have a dedicated server, not a VM (virtual server, I assume)....

[Intelehost]

hmm... it seems I always have ghost issues on my production box well hopefully someone on here can help because short of setting a whole new box over and performing a plesk migration I do not know how to fix this issue. Especially if no one else seems to be having the same problem.

[mneese77]

Is the mysql server "localhost" or some alternative database server, such as 1and1 does for their shared hosting?

When you upgraded your mysql, did you complete the process as described by Bruen somewhere in this forum...you might search for the threads on that , because there are several important additional steps beyond simply yum update...he solved many issues for many people with the steps fully described (if remember correctly)...

Let us know how its going, there may be other issues that warrant attention...

[Intelehost]

As far as I know it is setup however plesk installs it. All of my applications that use databases are setup to point to localhost so I would assume thats how it is.

As far as following the instructions I followed them off of a post here and yea they were pretty detailed. Everything appeared to be ok until I noticed I couldn't add any more users and plesk could not communicate with the database.

Is it possible to start those steps over again and rectify the issue that way?

[Highland]

Did you follow the steps outlined here?

http://www.atomicorp.com/wiki/index.php/Mysql

If you skipped step 4 I could see you having the issues you've described.

[Intelehost]

I can say that what originally happened was a yum upgrade that had tons of packages... I didn't see mysql in there until it was all said and done. At that point I performed the rest of the steps listed in here including the step 4 of upgrading the database. it ran through and I did the repair lines as well. If fixed some things and I ran them all multiple times because it said sometimes you have to run it twice.

Mysql is running, the databases that were installed and the users that were there prior to the upgrade are functioning fine... I have a lot of database driven websites that all work fine still... the problem is just that plesk is not communicating with the database server and I cannot add new database users... it will let me add databases... just not users... kind of odd... is there a plesk update that may fix this?

[Intelehost]

[root@psa ~]# rpm -qa | grep -i psa
psa-fcgi-2.4.0-2
psa-proftpd-1.3.3-2.el5.art
psa-pylibplesk-9.5.2-cos5.build95100504.10
psa-qmail-1.03-cos5.build95100504.10
psa-ftputil-2.1.1-0.98221
psa-libpam-plesk-9.5.2-cos5.build95100504.10
psa-api-rpc-9.5.2-cos5.build95100504.10
psa-passwd-3.1.2-cos5.build95100504.10
psa-migration-manager-9.5.2-cos5.build95100504.10
psa-migration-agents-9.5.2-cos5.build95100504.10
psa-mod_fcgid-1.10-3
psa-selinux-9.5.2-cos5.build95100504.10
psa-logrotate-3.7-cos5.build95100504.10
psa-proftpd-xinetd-1.3.2e-cos5.build95100504.10
psa-qmail-rblsmtpd-0.70-cos5.build95100504.10
psa-mail-qc-driver-1.0.0-cos5.build95100504.10
psa-9.5.2-cos5.build95100504.10
psa-awstats-configurator-1.0.0-cos5.build95100504.10
psa-miva-9.5.2-cos5.build95100504.10
psa-turba-2.3.3-cos5.build95100504.10
psa-mnemo-2.2.3-cos5.build95100504.10
psa-mimp-1.1.3-cos5.build95100504.10
psa-atmail-1.03-6.el5.art
psa-mod-fcgid-configurator-1.0-14
psa-php5-configurator-1.5.3-cos5.build95100504.10
psa-mail-driver-common-9.5.2-cos5.build95100504.10
psa-autoinstaller-3.6.0-100413.11
psa-imp-4.3.6-cos5.build95100504.10
psa-backup-manager-9.5.2-cos5.build95100504.10
psa-atis-1.0-46
psa-kronolith-2.3.3-cos5.build95100504.10
psa-spamassassin-9.5.2-cos5.build95100504.10
psa-pear-1.4.9-20060517.1
psa-hotfix5-8.6.0-8.6.0-cos5.build86080930.03
psa-locale-base-en-US-9.5.2-2010041911
psa-api-9.5.2-cos5.build95100504.10
psa-mailman-configurator-9.5.2-cos5.build95100504.10
psa-horde-3.3.6-cos5.build95100504.10
psa-watchdog-2.0.3-cos5.build95100504.10
psa-ingo-1.2.3-cos5.build95100504.10
psa-updates-9.5.2-cos5.build95100504.10

[Intelehost]

Is it safe to say that I should consider rolling back? the bad thing is... I upgraded all of the databases... so I don't know if I even can at this point.

[Kalimari]

Mysql is running, the databases that were installed and the users that were there prior to the upgrade are functioning fine... I have a lot of database driven websites that all work fine still... the problem is just that plesk is not communicating with the database server and I cannot add new database users... it will let me add databases... just not users... kind of odd... is there a plesk update that may fix this?

Not sure about the possibility of rolling back, it sounds like user privileges are messed up. The 'mysql_upgrade' command should ensure GLOBAL PRIVILEGES are set correctly for admin (under plesk) or root, but to double check:

Code: Select all

mysql -uadmin -p`cat /etc/psa/.psa.shadow`
mysql> SELECT * FROM mysql.user WHERE User='admin';

If you see Y for all privileges, try flushing them:

Code: Select all

mysql> FLUSH PRIVILEGES;

If you see an N, reset admin privileges (ensure you copy/paste the following mysql command as a single line, otherwise you'll revoke privileges and may not be able to grant them after):

Code: Select all

mysql> REVOKE ALL PRIVILEGES ON *.* FROM 'admin'@'localhost'; GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0; FLUSH PRIVILEGES;

If you are uncertain (or curious) of these commands, read up first and be clear on what you are doing. Start here: http://dev.mysql.com/doc/refman/5.0/en/grant.html

Good luck.

[mneese77]

..... plesk admin should be as user...

here is a referrence page for setting users:
http://dev.mysql.com/doc/refman/5.0/en/ ... leges.html

run this command to optimize databases, and it will only work if plesk admin is the user...which is what you want...if it doesn't run, then you have to setup plesk admin as user...

Code: Select all

mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --auto-repair --check --optimize --all-databases

[Intelehost]

Mysql is running, the databases that were installed and the users that were there prior to the upgrade are functioning fine... I have a lot of database driven websites that all work fine still... the problem is just that plesk is not communicating with the database server and I cannot add new database users... it will let me add databases... just not users... kind of odd... is there a plesk update that may fix this?

Not sure about the possibility of rolling back, it sounds like user privileges are messed up. The 'mysql_upgrade' command should ensure GLOBAL PRIVILEGES are set correctly for admin (under plesk) or root, but to double check:

Code: Select all

mysql -uadmin -p`cat /etc/psa/.psa.shadow`
mysql> SELECT * FROM mysql.user WHERE User='admin';

If you see Y for all privileges, try flushing them:

Code: Select all

mysql> FLUSH PRIVILEGES;

If you see an N, reset admin privileges (ensure you copy/paste the following mysql command as a single line, otherwise you'll revoke privileges and may not be able to grant them after):

Code: Select all

mysql> REVOKE ALL PRIVILEGES ON *.* FROM 'admin'@'localhost'; GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0; FLUSH PRIVILEGES;

If you are uncertain (or curious) of these commands, read up first and be clear on what you are doing. Start here: http://dev.mysql.com/doc/refman/5.0/en/grant.html

Good luck.

Ya I tried running some of these commands and just keep getting syntax errors... I tried reading up on the link you included as well and to be honest its over my head I don't quite understand it.