PhpMysql with ISP-Server Setup - Ubuntu 5.10 "Breezy Badger"

I followed the setup ISP-Server Setup - Ubuntu 5.10 "Breezy Badger",
The problem i have is that phpmysql is not running, when i do the command php-m, phpmysql is not in the list.
I didn't comment out de php things, because i don't setup ispconfig.
I tried the solutions mentioned below.

1. Reinstal php4-mysql by running:
apt-get install php4-mysql
root@drbyte:apt-get install php4-mysql
Reading package lists... Done
Building dependency tree... Done
php4-mysql is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

2. Uncommented the line in php.ine wich reads mysql.so
/etc/init.dapache2 restart, still no phpmysql running.

I also searched the internet for a week of 2 now, but still haven't found a solution for this. I found that there a lot of pepople who have also this problem.

When i run a php script in a terminal wich connects to a mysql database i get the following error.

Fatal error: Call to undefined function mysql_select_db() in /var/www/usnet/inc/optimize_database_2.php on line 8

I hope to find a solution with help from this forum.

 

I did locate php.ini, below the output.
/etc/php4/apache2/php.ini
/etc/php4/cli/php.ini
/etc/php5/cli/php.ini
/usr/share/doc/php4-common/examples/php.ini-dist
/usr/share/doc/php4-common/examples/php.ini-paranoid
/usr/share/doc/php4-common/examples/php.ini-recommended
/usr/share/doc/php5-common/examples/php.ini-dist
/usr/share/doc/php5-common/examples/php.ini-paranoid
/usr/share/doc/php5-common/examples/php.ini-recommended
/usr/share/php4/php.ini-dist
/usr/share/php5/php.ini-dist

I didn't install php5?, but i looked in both php.ini's, the one in
/etc/php4/apache and the one in /etc.php4/cli, in both file's mysql.so is uncommented.

 

See below the output of php -v

root@drbyte:# php -v
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20041030/mysql.so' - /usr/lib/php5/20041030/mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP 5.0.5-2ubuntu1.2 (cli) (built: Mar 8 2006 08:18:34)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v2.0.5, Copyright (c) 1998-2004 Zend Technologies

So you are right how, i use php5, strange.
How can i go back to php4?

 

root@drbyte:# which php
/usr/bin/php

root@drbyte:# ls -la /usr/bin/php
lrwxrwxrwx 1 root root 21 2006-03-19 10:38 /usr/bin/php -> /etc/alternatives/php (cyan color)

root@drbyte:# ls -la /etc/alternatives/php
lrwxrwxrwx 1 root root 13 2006-03-25 16:36 /etc/alternatives/php -> /usr/bin/php5 (green color)

So the last line is where it goes wrong, but now i don't know how to correct this.

 

Yes there is a file php4 in /usr/bin.

1. What is the best way to remove the /usr/bin/php
rm /usr/bin/php

2. Is this the way to create a new symlink
ln -s /usr/bin/php4 ./usr/bin/php

3. What about the other link /etc/alternatives/php

I just want to know for sure before my server stops working....

 

Don't remove it!

Just run

Code:

rm -f /etc/alternatives/php
ln -s /usr/bin/php4 /etc/alternatives/php

 

This is great !!!
Everything is running fine now, i really appreciate this help.
Solved the problem in a few days, after searching the internet for 2,5 weeks.

Thanks again Till & Falko -> great job and support. !!!!

 

Do i need to run the following command to fix the inconsistence of the alternatives database ?

update-alternatives --config php

 

You can do so, but it's not necessary.
http://www.hants.lug.org.uk/cgi-bin/wiki.pl?LinuxHints/UpdateAlternatives

 

Thanks for the fast reply.
I will update it, so everything is like it should be...