php mysql_connect error

compu73rg33k · 04-08-2004, 11:58 PM

I'm using Debian and I got apache2 php4 and mysql all installed. I tried to install an invision forum. After I tried to make the forum this is the error I received:

Code:

Fatal error: Call to undefined function: mysql_connect() 
in /var/www/forum/sm_install.php on line 342

Now I know it's something wrong with the php. I installed the php4-mysql module thing and it's still not working.

trickykid · 04-09-2004, 02:25 AM

Do you have mysql enabled for php? Check your php.ini file first..

compu73rg33k · 04-09-2004, 10:23 AM

what do I look for?

I have three php.ini files which one do I wanna edit?
/etc/php4/apache/php.ini
/etc/php4/apache2/php.ini
/etc/php4/cgi/php.ini

Longinus · 04-09-2004, 12:58 PM

make a file called phpinfo.php

inside type in:

<?php

phpinfo();

?>

save that and then give us a link to that (http://yourserver/phpinfo.php)

compu73rg33k · 04-09-2004, 03:23 PM

http://64.53.159.50/phptest.php

Yeah I created that before here it is

Longinus · 04-09-2004, 03:59 PM

yeah you dont have php enable with mysql... i had the same problem

your going to have to recompile php

first:

cd /var/log/packages/
removepkg php*

that will remove php

and download the complete source code from http://www.php.net/downloads.php

and then follow the instructions here http://www.php.net/manual/en/install.apache2.php
to get the basic idea to configure/compile/install it

make sure you do :

./configure --with-mysql

to enable mysql when you get to that step

compu73rg33k · 04-09-2004, 06:34 PM

ight but I'm using debian so I do apt-get remove php right?

Longinus · 04-09-2004, 07:07 PM

ive never used debian but yeah which ever you use to uninstall apps

compu73rg33k · 04-12-2004, 12:58 PM

I already have apache2 installed I did apt-get install apache2 with Deb. Do i have to reinstall that too?

Matt Collier · 04-26-2004, 10:23 AM

Like many other Debian pkgs, php4 is crippled by default for security purposes. mod_php4 doesn't have mysql support enabled, but it is compiled in as a loadable module.
All you have to do is open /etc/php4/apache2/php.ini and uncomment the line

extension=mysql.so

then reload apache2

(sorry for the very late reply, but i browsed in with a similar problem and i'm sure others may too, so this reply is mainly for google)

compu73rg33k · 04-26-2004, 03:50 PM

it's okay I jus reloaded everything and it's all working well

http://quacktasticquotes.kicks-ass.org

makko · 04-02-2005, 05:37 AM

well mine still aint working i get this error;

PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php/extensions/mysql.so' - libmysqlclient.so.12: cannot open shared object file: No such file or directory in Unknown on line 0
[Sat Apr 2 14:36:50 2005] [notice] Apache/1.3.31 (Unix) mod_ssl/2.8.18 OpenSSL/0.9.7d PHP/4.3.9 configured -- resuming normal operations

and mysql.so is in that exact position, but for some reason apache aint seeing it. i'm on Slackware10 mysql 4.1.10a

regards,
Makko.