Page 1 of 2
Latest MySQL Broke Plesk
Posted: Wed Sep 01, 2010 10:10 am
by 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?
Re: Latest MySQL Broke Plesk
Posted: Wed Sep 01, 2010 10:15 am
by 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
Re: Latest MySQL Broke Plesk
Posted: Wed Sep 01, 2010 11:08 am
by scott
No, I don't get that on any system I'm running. Anyone else?
Re: Latest MySQL Broke Plesk
Posted: Wed Sep 01, 2010 11:11 am
by 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.
Re: Latest MySQL Broke Plesk
Posted: Wed Sep 01, 2010 2:22 pm
by 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)....
Re: Latest MySQL Broke Plesk
Posted: Wed Sep 01, 2010 2:43 pm
by 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.
Re: Latest MySQL Broke Plesk
Posted: Wed Sep 01, 2010 2:56 pm
by 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...
Re: Latest MySQL Broke Plesk
Posted: Wed Sep 01, 2010 4:24 pm
by 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?
Re: Latest MySQL Broke Plesk
Posted: Thu Sep 02, 2010 8:27 am
by 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.
Re: Latest MySQL Broke Plesk
Posted: Thu Sep 02, 2010 8:43 am
by 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?
Re: Latest MySQL Broke Plesk
Posted: Thu Sep 02, 2010 8:46 am
by 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
Re: Latest MySQL Broke Plesk
Posted: Thu Sep 02, 2010 9:02 am
by 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.
Re: Latest MySQL Broke Plesk
Posted: Thu Sep 02, 2010 10:54 am
by Kalimari
Intelehost wrote: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:
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.
Re: Latest MySQL Broke Plesk
Posted: Thu Sep 02, 2010 11:51 am
by 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
Re: Latest MySQL Broke Plesk
Posted: Thu Sep 02, 2010 12:34 pm
by Intelehost
Kalimari wrote:Intelehost wrote: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:
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.