mysql_connect problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux