MySQL not listed as plesk service after updating to 10.3

[�lexM]

Hello,

OS: CentOS 5
Panel version: 10.3 updated from 10.2

I updated MySQL (using updater), and then updated Plesk from 10.2 to 10.3. MySQL is running but it is not listed as plesk service in control panel.

I cannot access to MySQL configuration or start/restart/stop it using control panel.

When I go to the updater it shows MySQL as a new component to install but when I try to install it its log says: "Patch will not be installed since it is already applied."

Is there a way to reintegrate MySQL into Plesk services?

Thank you!

ÀlexM

 

[IgorG]

What is version of MySQL you have now?

 

[�lexM]

MySQL version is: 5.1.52

Thank you.

 

[IgorG]

Did you try to refresh Server Components? What is status of MySQL server there?

 

[�lexM]

Restarted server and now I can manage it.

Thank you.

 

[rivan]

Same problem; OS: Linux 2.6.24-29-generic (Ubuntu), updated from 10.2 to 10.3;
server restart didn't help... What to try next?

 

[Amin Taheri]

what does this command show as output?

rpm -qa | grep -i mysql

 

[rivan]

dpkg --get-selections | grep -i mysql
gave me following:

libdbd-mysql-perl install
libmysql-ruby1.8 install
libmysqlclient15off install
mysql-client-5.0 install
mysql-common install
mysql-server-5.0 install
php5-mysql install

 

[Amin Taheri]

Mine for example looks like this:

mysqlclient15-5.0.90-1.el5.art
mysql-libs-5.1.58-1.el5.art
mysql-connector-odbc-3.51.26r1127-1.el5
perl-DBD-MySQL-3.0007-2.el5
mysql-server-5.1.58-1.el5.art
asl-php-mysql-5.2.17-1.el5.art
mysql-5.1.58-1.el5.art
ruby-mysql-2.7-200705221400
php-mysql-5.3.6-3.el5.art
mysql-cluster-5.1.58-1.el5.art

NOte that the one bolded above is one that I have that you dont and is pretty important. Im not sure if your distro uses that package or not so it could be nothing.

Does mysql run and accept connections?



Here are some samples for RHEL/Centos - please adjust for your OS

# netstat -an | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:59367 127.0.0.1:3306 ESTABLISHED
tcp 0 0 127.0.0.1:3306 127.0.0.1:59367 ESTABLISHED

# service mysqld status
mysqld (pid 6033) is running...

# ps aux | grep mysql | grep -v grep
root 5941 0.0 0.0 4684 2312 ? S Jul15 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql

mysql 6033 0.0 1.0 125156 39184 ? Sl Jul15 1:55 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock

# cat /var/run/mysqld/mysqld.pid
6033

# stat /var/lib/mysql/mysql.sock
File: `/var/lib/mysql/mysql.sock'
Size: 0 Blocks: 0 IO Block: 4096 socket
Device: fd00h/64768d Inode: 9044087 Links: 1
Access: (0777/srwxrwxrwx) Uid: ( 27/ mysql) Gid: ( 27/ mysql)
Access: 2011-07-16 13:01:14.000000000 -0700
Modify: 2011-07-15 12:01:53.000000000 -0700
Change: 2011-07-15 12:01:53.000000000 -0700


# mysql -uadmin -p`cat /etc/psa/.psa.shadow ` -e "select @@VERSION;"
+-----------+
| @@VERSION |
+-----------+
| 5.1.58 |
+-----------+

 

[rivan]

Thanks for your reply!

Info from my server:

netstat -an | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

ps -e | grep -i mysqld
1542 ? 00:00:00 mysqld_safe
1581 ? 02:50:40 mysqld


ps aux | grep mysql | grep -v grep
root 1542 0.0 0.0 3948 604 ? S 17:02 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 1581 62.2 0.8 489180 70144 ? Sl 17:02 171:13 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root 1582 0.0 0.0 5072 772 ? S 17:02 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld

cat /var/run/mysqld/mysqld.pid
1581

mysql.sock - no such file...


select @@VERSION;
+------------------------+
| @@VERSION |
+------------------------+
| 5.0.51a-3ubuntu5.8-log |
+------------------------+

 

[�lexM]

"MySQL server support" still appears as a new component to install.

My rpm -qa | grep -i mysql:

libmysqlclient15-5.0.77-4.el5_5.4.11053110
plesk-mysql-5.1-11053110
perl-DBD-MySQL-3.0007-2.el5
mysql-libs-5.1.52-11053110
ruby-mysql-2.7-200705221400
mysql-server-5.1.52-11053110
mysql-connector-odbc-3.51.26r1127-1.el5
php-mysql-5.1.6-27.el5_5.3
mysql-5.1.52-11053110

Thanks,

ÀlexM

 

[Amin Taheri]

It would seem like its there and working so I wouldnt be too worried about it - is there somethign in Plesk itself that isnt working due to this, or is this really only a issues where it doesnt display on that one UI page?

 

[mixosp]

MySQL service is missing on Plesk 11

Same issue here.

I recently updated from Plesk 10.4 to 11.0.9 on CentOS 5.4 and under "Services management" i can't see MySQL service listed. So there is not option to start/stop from the panel.

Otherwise MySQL is running fine on server.

I asked for support on my hosting provider and they believe this is an issue with new version of Plesk.

Any tip on this issue will be appreciated..

Mike

 

[abdi]

I hadn't noticed this, but critically doing so, actually its true MySQL is missing in service management! And I have checked with several servers but same thing ...Must be a BUG!

 

[IgorG]

I have checked Service Management in Plesk 10.2/10.3/10.4.4 and not found ability to start/stop MySQL service there.
I would be very strange if this ability would be there because Plesk psa database works on MySQL database engine. And if you stopped MySQL service, you will not be able to start it after that, because Plesk has ceased to work without connection to psa database.