Linux Problem - apache and mysql

help! ive just got a new linux server, but apache and mysql cant see each other, i run

<?php

phpinfo();

?>

and mysql doesnt come up as a installed service thingy, but i can create new tables and stuff in mysql via telnet?? anyone have ideas?? im starting to get despriate

thanks in advance!


Ben Rowe

ok on a new note, i got mysql running, but i cant do mysql_connect, it gives me the following error msg

Fatal error: Call to undefined function: mysql_connect() in /var/www/html/test.php on line 2

does anyone have any ideas???? thanks


Ben

Hey. Did you build PHP with MySQL support (./configure --with-mysql)? ALso, did you restart Apache once you were done (apachectl -restart).

Give those two things a go and let me know how you go.

I got to the configure part and in went through alright, but then when i said 'make' thats when it came up with an error. command not found!

How are you installing mysql and php? If you have mysql as an rpm and you are installing php from source you might run into some problems with PHP finding the header files...you will need to specify the location of the header files. I always suggest to install mysql as source or rpm...binary, many users run into problems with PHP compiled from source. If both are from rpm, just make sure you have the php-mysql rpm installed or it might be mysql-php...cant remember--i use postgresql...


If you need any help, let me know.