PHP---Fatal Error mysql_connect function!

smonsivaes

Fatal error: Call to undefined function: mysql_connect() in /var/www/html/php/mysqlconnect.php on line 2
...this is the problem i am having.

RedHat 8.0
Running Apache 2.0.40
compiled in modules:
core.c
prefork.c
http_core.c
mod_so.c

MySQL 3.23.52

PHP 4.2.2 installed as a DSO module
run phpinfo() and it does show --with-mysql=shared,/usr

(note that i do not know if this --with-mysql statement is correct..my libmysqlclient.so is in /usr/lib/mysql ...? is this correct? )

i installed PHP as an RPM since im still newbish in compiling

note: i am able to run PHP scripts on the web server and it does parse the code correctly but my problem is when i try to connect to mysql using a simple script like so to test the connection.
<?php
$conn = mysql_connect("localhost", "user", "pass");
echo "$conn";
?>

any help or point in the right direction is very much appreciated!

smonsivaes

Well i figured out the problem on my own, so ill post what fixed this problem on MY setup.

Apparently using the default install of Apached 2 and PHP ,Redhat 8.0 does not place the "mysql.h" anywhere in the system.
Being that the RHL 80 PHP4.2.2 is compiled to use the local mysql header file for defining the mysql functions (--with-mysql=shared,/usr).
Well since mysql.h wasnt installed to begin with it never worked. ---now i know what you would think...why not uninstall PHP and compile it yourself to use its own header files for mysql....well i tried that only to find out that RH 8 does install the Apache apxs file used to compile PHP!

Seems to me they just rushed RH 8 without properly making sure everything was configured with the proper dependency files in place. ENOUGH about that though.....my fix....clean install of RH 8 without Apache 2, PHP and Mysql. I compiled all myself after installation defining one main folder with Apache, PHP and MySQL in sub-folders so i would know where all the necessary files would be. Worked Great afterwards.

My suggestion if your having this problem and dont want to go through the mess i did is to stick with RH 7.3 until 8.0 gets the kinks worked out in later releases, dont get my wrong though...i still think 8.0 ROCKS!!!