Hi,
I've setup an Apache 2.2.3, PHP 5.2.0, MySQL 5.0.27 on a Solaris 9 system.
The install appeared to go well. To test the Apache/PHP/MySQL integration,
I added a simple test.php to the Apache document folder, consisting of:
<?php
phpinfo();
?>
When I access the URL/test.php, it displays as expected. That is, I see the
PHP version, date, configure command and detail about all of the modules,
including curl, gd, IMAP, and MySQL. Looks like a perfectly normal
rendition of phpinfo(). So it looks great, like everything works.
But then I try to load a web app on the server, like SMF or phpBB, they both
tell me that I don't have MySQL configured.
I don't understand why the phpinfo() command would show the MySQL config
info, yet the web apps would think that MySQL was not configured.
So I created another test php file, mysqltest.php, with these lines:
<?php
$link = mysql_connect('localhost', 'testuser', '*******');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
Now, as testuser, I can login to the database using the command line "mysql
-u testuser -p" and entering the password.
But when I try accessing the above file, I get no output in the browser, but
in the apache errlog file, I get:
PHP Fatal error: Call to undefined function: mysql_connect() in
/opt/apache-php/apache/htdocs/mysqltest.php on line 2
So it looks like my PHP install just doesn't even know about the
'mysql_connect' function.
extensions_dir = /opt/apache-php/php4/lib/php/extensions, and that dir does
contain the mysql.so file. If I move it out of that folder and rerun
phpinfo(), it displays without showing any MySQL config data.
Any help? I'm just stuck! My directive for MySQL inclusion for the PHP
./configure command was:
--with-mysql=shared,$BLIB/mysql
...where $BLIB was set to /opt/apache-php/libs
Thanks,
Ted
