Page 1 of 1

Plesk is not detecting Mysql 5

Posted: Sun Feb 17, 2008 9:20 pm
by anwarpp
Hi -

I have a new Centos 4.6 server with the following.

Plesk - 8.3.0 cos4.build83071218.20
Mysql - 5.0.51 1.el4.art
mysqlclient14 - 4.1.22 2.el4.art
PHP - 5.2.5 4.el4.art


With this combination, phpinfo() would not even list mysql support initially, which I resolved by changing

extension_dir = /usr/lib/php4

to

extension_dir = /usr/lib/php/modules

in /etc/php.ini

Now the problem is, Plesk does not seem to detect MySql. When I try to install Drupal (using the Plesk Site Applications list), I get the following.

Database (mysql, version >= 3.0.0) (available: none, suitable: no)

So how can I make Plesk detect the MySql 5 server ?

Thanks,
/app

Posted: Mon Feb 18, 2008 1:48 pm
by breun
Do you have the proper php-mysql package installed?

Posted: Mon Feb 18, 2008 4:36 pm
by anwarpp
I guess so. What I have is as follows.

php-mysql 5.2.5 4.el4.art

Basically, whatever is the current update available on ART.

Posted: Sat Feb 23, 2008 3:45 am
by anwarpp
Anyone ??????? :(

Posted: Sat Feb 23, 2008 6:10 am
by breun
Do you have any PHP scripts running that use MySQL so you can confirm whether php-mysql is working? Have you tried checking the output phpinfo() to see whether MySQL is accessible (and what version). Plesk itself uses MySQL, so it seems MySQL itself is ok.

Posted: Sat Feb 23, 2008 7:06 am
by anwarpp
Yes, phpinfo() does report both "mysql" and "mysqli" sections, with the "Client API Version" as "4.1.22".

The issue seems to be limited to Plesk detecting MySQL5 correctly. Like you said, both MySQL and PHP are working fine by themselves (and with each other). It is only Plesk that is having trouble detecting the installed MySQL 5 installation.

/app