ID: 32081
User updated by: subscription at nazarenko dot net
Reported By: subscription at nazarenko dot net
-Status: Closed
+Status: Open
Bug Type: MySQLi related
Operating System: Linux SuSE 9.3 (64bit)
-PHP Version: 5.0.4
+PHP Version: 5.0.5 and 5.1 CVS
New Comment:
Sorry, you comment is not true.
Both mysql*_connect functions, if called this way:
mysql_connect('','user','password')
mysqli_connect('','user','password')
do use mysql*.default_host/mysql*.default_socket from the php.ini. See
my example with mysqli_connect() above.
It is ONLY mysqli_real_connect() called this way:
mysqli_real_connect($db_obj, '', 'user', 'password')
that does not use the values from php.ini.
Just to dismiss the argument completely I have tried setting all
mysqli.default_* parameters in the php.ini to proper values (safe mode
off) and then calling mysqli_real_connect() this way:
$db=mysqli_init();
mysqli_real_connect($db);
I am still connection error and see that the mysqli_real_connect() is
trying to use the hard-coded socket value, which is different from the
php.ini
Previous Comments:
------------------------------------------------------------------------
[2005-09-07 13:48:21] [EMAIL PROTECTED]
The defaults are only used if you don't pass any parameters to these
connect functions.
------------------------------------------------------------------------
[2005-09-07 11:40:00] subscription at nazarenko dot net
Tried the php5-200509070630 snapshot.
The settings in the php.ini file are:
error_reporting = E_ALL
display_errors = On
mysqli.default_socket = "/srv/mysql/mysql.sock"
mysqli.default_host = localhost
Used this code for testing:
<?
$db = mysqli_connect('','user','password');
var_dump($db);
close ($db);
echo "---------------------------\n";
$dbr = mysqli_init();
var_dump (mysqli_real_connect ($dbr, '', 'user', 'password'));
mysqli_close($dbr);
?>
This produces the following ouput:
object(mysqli)#1 (0)
---------------------------
Warning: mysqli_real_connect(): (HY000/2002): Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
bool(false)
So it confirms that mysqli_real_connect() is still ignoring the php.ini
setting.
------------------------------------------------------------------------
[2005-09-05 23:38:14] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5-win32-latest.zip
------------------------------------------------------------------------
[2005-09-05 15:36:55] subscription at nazarenko dot net
I have to reopen this bug.
mysqli_connect() treats the mysqli.default_socket OK.
mysqli_real_connect() still takes the hardcoded value and ignores the
php.ini setting
------------------------------------------------------------------------
[2005-02-25 01:00:01] [EMAIL PROTECTED]
This bug has been fixed in CVS.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
Thank you for the report, and for helping us make PHP better.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/32081
--
Edit this bug report at http://bugs.php.net/?id=32081&edit=1
