Connection to database not working

[psychomantum]

Hi,
I'm fairly new to php and mysql, but I've been reading up and am starting my own website on my own server using Apache 2.0.40 on RedHat 8.0

I decided to test mysql and php with this little php code:

<?php

$linkID = mysql_pconnect("localhost", "******", "******");

if($linkID != FALSE)
{
print "Persistent connection established";
}
else
{
print "Hey, it don't work";
}
?>

(username and password changed by me)

I get this error when I visit the page I put this code on:

Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/Admin/mysqltest.php on line 12

Any suggestions?

[Joan Garnet]

Maybe it has something to do with this:

Code: Select all

Note: Note, that these kind of links only work if you are using a module version of PHP

http://www.php.net/manual/en/function.m ... onnect.php

[psychomantum]

Ok, added the modules to httpd.conf, now I get this:

Warning: SAFE MODE Restriction in effect. The script whose uid is -1 is not allowed to access /var/www/html/Admin/mysqltest.php owned by uid 0 in Unknown on line 0

Warning: Failed opening '/var/www/html/Admin/mysqltest.php' for inclusion (include_path='.:/usr/share/pear') in Unknown on line 0

Any ideas?

[Joan Garnet]

* http://www.devshed.com/Talk/Books/ProPHP/print_html

sql.safe_mode boolean
MySQL has it’s own safe mode. If you set this to TRUE, mysql_connect and mysql_pconnect will ignore any host, user and password information you supply. This means you can only connect to the MySQL database as the user the web server is running as.

* http://www.pt.horde.org/faq/admin/print.php#t7
"undefined function: mysql_pconnect()"

Code: Select all

This error occurs when IMP is configured to use MySQL, but PHP was not built with support for MySQL. Rebuild PHP, ensuring that MySQL support is compiled in, and that the line 
   extension = mysql.so
appears in your php.ini (or php3.ini in PHP version 3). 

[Joan Garnet]

More interesting links:
http://www.zend.com/manual/ref.mysql.php

The behaviour of these functions is affected by settings in php.ini.
Table 1. MySQL Configuration Options

Name Default Changeable
mysql.allow_persistent "On" PHP_INI_SYSTEM
mysql.max_persistent "-1" PHP_INI_SYSTEM
mysql.max_links "-1" PHP_INI_SYSTEM
mysql.default_port NULL PHP_INI_ALL
mysql.default_socket NULL PHP_INI_ALL
mysql.default_host NULL PHP_INI_ALL
mysql.default_user NULL PHP_INI_ALL
mysql.default_password NULL PHP_INI_ALL
mysql.connect_timeout "0" PHP_INI_SYSTEM

[psychomantum]

ok, so how do I turn it off?