ID: 49299
User updated by: david at ols dot es
Reported By: david at ols dot es
Status: Bogus
Bug Type: MySQL related
Operating System: Linux debian
PHP Version: 5.2.10
New Comment:
mysql_config correctly reports the socket:
[src]# mysql_config --socket
/tmp/mysql.sock
no change has been made to mysql, no upgrade, no change, nothing, we
where only upgrading php, with previous php version all worked ok.
in the other hand php cli with -n does not read at all php.ini
Previous Comments:
------------------------------------------------------------------------
[2009-08-20 09:50:57] j...@php.net
By default the socket is that (or whatever mysql_config says it is). If
you have changed your mysql configuration, then you need to change it in
your php.ini as well. No bug here.
------------------------------------------------------------------------
[2009-08-20 07:01:28] david at ols dot es
sorry, the apache module has the same problem, it only works ok if the
socket is defined in php.ini by mysql.default_socket = /tmp/mysql.sock ,
if left empty trying to connect to localhost produces a "Warning:
mysql_connect(): Can't connect to local MySQL server through
socket '/var/run/mysqld/mysqld.sock' (2)" error altough phpinfo shows
MYSQL_SOCKET /tmp/mysql.sock
------------------------------------------------------------------------
[2009-08-19 20:29:37] david at ols dot es
Description:
------------
mysql_connect uses wrong socket
Reproduce code:
---------------
#!/usr/local/bin/php -n
<?php
$base="/usr/local/exim";
$lnk=mysql_connect('localhost','root','password');
?>
Expected result:
----------------
script must connect to mysql server
Actual result:
--------------
Warning: mysql_connect(): Can't connect to local MySQL server through
socket '/var/run/mysqld/mysqld.sock' (2)
echo "<?php phpinfo(); ?>" | /usr/local/bin/php -n | grep sock
reports:
MYSQL_SOCKET => /tmp/mysql.sock
mysql.default_socket => no value => no value
PHP compiled with ./configure --with-mysql
--with-mysql-sock=/tmp/mysql.sock
no default socket configured in php.ini
Apache module version works ok, but same code executed wiht php cli
seems to use a socket defined elsewhere
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=49299&edit=1
