Plesk is not detecting Mysql 5

anwarpp · Unread post by **anwarpp** » Sun Feb 17, 2008 9:20 pm

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

breun · Unread post by **breun** » Mon Feb 18, 2008 1:48 pm

Do you have the proper php-mysql package installed?

anwarpp · Unread post by **anwarpp** » Mon Feb 18, 2008 4:36 pm

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.

anwarpp · Unread post by **anwarpp** » Sat Feb 23, 2008 3:45 am

Anyone ???????

breun · Unread post by **breun** » Sat Feb 23, 2008 6:10 am

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.

anwarpp · Unread post by **anwarpp** » Sat Feb 23, 2008 7:06 am

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