php 5.1.6 with mysql 5.0.27

tilk · 01-31-2007, 03:30 AM

Hello,

I have a plesk 8 server on a fedora core 5 installed automatically by plesk autoinstaller.
Everything in plesk is ok, i can create domains, sites and databases via the plesk phpmyadmin.

But the sites can not connect to the db.
The phpinfo indicate the it was not compiled with the option with-mysql.

How can i change this ? I am new with Linux system and i don't know how to re-compile php module ...
Do i have to uninstall php first ? how ?
Where can i find the folder to compile php ?
PHP : 5.1.6.2
MySql : 5.0.27
Apache : 2.0

Thanks.
A

tbutttbutt · 01-31-2007, 08:32 AM

You need to install the php-mysql support files to get mysql working with php. They should be on your Fedora CDs.

tilk · 01-31-2007, 11:10 AM

Tanks for your answer.

I think the php-mysql module is already installed.

Code:

[root@pl02 ~]# rpm -qa|grep -i mysql
mysql-5.0.27-1.fc5.remi
perl-DBD-MySQL-3.0004-1.FC5
MySQL-shared-compat-5.0.27-0
php-mysql-5.1.6-1.2
ruby-mysql-2.7-200610021749
mysql-server-5.0.27-1.fc5.remi

[root@pl02 ~]# rpm -qa|grep -i php
php-imap-5.1.6-1.2
phpDig-1.85-80017
php-soap-5.1.6-1.2
php-xml-5.1.6-1.2
phpWiki-1.3.11-80030
php-mysql-5.1.6-1.2
phpMyFamily-1.4.1-80022
php5-ioncube-loader-3.0-06110709
php-pdo-5.1.6-1.2
php-mbstring-5.1.6-1.2
phpBB-2.0.19-80012
phpMoney-1.3-80027
phpwebsite-0.10.2-80014
php-5.1.6-1.2
psa-php5-configurator-1.1.0-fc5.build81061129.23
phpAds-2.0.7-80015
phpsurveyor-0.98-80030
php-gd-5.1.6-1.2
phpBugTracker-1.19-80022
php-pear-1.4.9-1.2
phpBook-1.50-80020
php-sqlite-5.1.6-1.1
[root@pl02 ~]#

tbutttbutt · 02-01-2007, 07:02 AM

You hahe to recompile Apache with mysql, if you want to. But you don't have to do that because mysql works fine as a module.

There must be some other files left uninstalled. Check all the files you have on CD with 'mysql' as part of the name.

tilk · 02-12-2007, 09:50 AM

Well .. I ve searched enough for now, i am going to recompile php with mysql.

Can anyone tell me how to do that, in which directory i must enter the command to recompile ?
PHP was automatically installed by the plesk installer.

tbutttbutt · 02-13-2007, 02:23 AM

As I said earlier, you have to recompile Apache with mysql, not PHP. You can do that in the directory where the Apache source is. Look at the Apache site for all the details.

tilk · 02-14-2007, 02:41 AM

Hello,

I've found what was missing ...
When you check the option mysql in the fedora core 5 setup, you have to click on more package and select the php-mysql not selected by default ...
I installed PLesk server and it's running with mysql now.

I suppose the the php-mysql package seen two replies before is the plesk php-mysql package used only for the plesk interface server.

Thanks for your reply