mysql problem

[redskin]

gday

I recently setup a new server at work with the following details

debian         testing sarge
kernel         2.6.9 no patches
hardware       i386

libdbd-mysql-p 2.9003-3
libmysqlclient 3.23.56-2
libmysqlclient 4.0.22-2
mysql-client   4.0.22-2
mysql-common   4.0.22-2
mysql-server   4.0.22-2
php4           4.3.9-1
apache         1.3.33-1

The programmer put the db on there and it was working fine
then all of a sudden we get this error

Fatal error: Call to undefined function: mysql_connect() in /home/apache/www/admin/dbtable.php on line 8

This is line 8

Fatal error: Call to undefined function: mysql_connect() in /home/apache/www/admin/dbtable.php on line 8

Ive restarted apache and mysql can quite configure out firstly
if its a apache php mysql or system error

Any help would be greatly appreciated
thanks

Paul
Cable Layers WA

[Ricky]

Is this the solution for you ? ---> Fatal error: Call to undefined function: mysql_connect()

[nih]

Is this the solution for you ? ---> Fatal error: Call to undefined function: mysql_connect()

I and many others have the same problem, it's something to do with a recent build of Sarge cocking things up.

The symptoms are: basically everything obvious is set correctly and mysql is running. I'm also using this guide as a starting point.

My setup is apache2, php4 and mysql.

Has anyone found a solution for this one yet?

[Ricky]

hmm.
What I think is that it is PHP error not the mysql error!
I think I found the reason, I think you are using PHP 5  which don't contains mysql client library and that is why there is undefined funtion error..

What you have to do is reinstall php using source ie not rpm with proper method, you can find that in php 5 installation manual !

[nih]

hmm.
What I think is that it is PHP error not the mysql error!
I think I found the reason, I think you are using PHP 5  which don't contains mysql client library and that is why there is undefined funtion error..

What you have to do is reinstall php using source ie not rpm with proper method, you can find that in php 5 installation manual !

In actual fact I am using the current stable release of PHP 4.

In the end I gave up and moved to Fedora Core 3 and all my problems disappeared.

[Ricky]

hmm.
What I think is that it is PHP error not the mysql error!
I think I found the reason, I think you are using PHP 5  which don't contains mysql client library and that is why there is undefined funtion error..

What you have to do is reinstall php using source ie not rpm with proper method, you can find that in php 5 installation manual !

In actual fact I am using the current stable release of PHP 4.

In the end I gave up and moved to Fedora Core 3 and all my problems disappeared.

It is so b'coz your fedora core 3 consist of php with all the required library ~

[nih]

hmm.
What I think is that it is PHP error not the mysql error!
I think I found the reason, I think you are using PHP 5  which don't contains mysql client library and that is why there is undefined funtion error..

What you have to do is reinstall php using source ie not rpm with proper method, you can find that in php 5 installation manual !

In actual fact I am using the current stable release of PHP 4.

In the end I gave up and moved to Fedora Core 3 and all my problems disappeared.

It is so b'coz your fedora core 3 consist of php with all the required library ~

That's right. I was surprised at how nice Fedora was to set up. It still had a few problems, but not nearly as many as Debian Sarge.

I had avoided anything Redhat previously because I'd been told Redhat stuff in general wasn't as pleasant as Debian - quite frankly apart from some installers and some wizards to an end user they're damn near identical.

I would strongly urge anyone who feels out of their depth with other distros to try Fedora. It's not a lightweight OS - just easier to set up.

[mudface]

Checkout URL Fatal error: Call to undefined function: mysql_connect() again i posted a half solution there and am working on the rest of it.

[wrodrigues201]

Got it to work with Debian Sarge.

Added to php.ini

extensions = mysql.so

Commented out the following.
;extension_dir = /usr/lib/php4/20020429-zts/
;include_path = ".:/usr/share/php"