#49299 [Opn]: misconfigured socket on php cli

ID: 49299 User updated by: david at ols dot es Reported By: david at ols dot es Status: Open Bug Type: MySQL related Operating System: Linux debian PHP Version: 5.2.10 New Comment: 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 Previous Comments: ------------------------------------------------------------------------ [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