Bug #11863 Updated: Cannot connect to mysql server

ID: 11863 Updated by: derick Reported By: veins@kheos.net Old-Status: Open Status: Feedback Bug Type: MySQL related Operating system: PHP Version: 4.0.6 Assigned To: Comments: Hello, can you make a page with <?php phpinfo(); ?> available to us? Derick Previous Comments: --------------------------------------------------------------------------- [2001-07-03 16:44:53] veins@kheos.net Yeah, the server is actually running as i can connect to it from console. The socket is set srwxrwxrwx so it is also ok i presume. The exact same configuration used to work with php-4.0.5 :/ --------------------------------------------------------------------------- [2001-07-03 16:41:17] veins@kheos.net Yeah, the server is actually running as i can connect to it from console. The socket is set srwxrwxrwx so it is also ok i presume. The exact same configuration used to work with php-4.0.5 :/ --------------------------------------------------------------------------- [2001-07-03 16:32:07] derick@php.net It works fine here. Are you sure MySQl is actually running, and are the permissions on the socket correct? Derick --------------------------------------------------------------------------- [2001-07-03 16:28:24] veins@kheos.net I am using php-4.0.6 with MySQL-3.23.39 and there seems to be a problem with connecting to the database server. Problem that didn't happen with any previous version (even php-4.0.5 that i was using till today). phpinfo() shows a correct configuration and correct path to the socket, mysql server works correctly from console and i'm not using the bundled libraries (tried them also and it gave the same error). This was reproductible under OpenBSD-2.7-stable, OpenBSD-2.8, OpenBSD-2.8-stable, OpenBSD-2.9, OpenBSD-2.9-stable, Linux Debian (current), Linux RedHat 7.0, Linux Slackware 7.1 and probably others. Configuration flags of PHP are: --with-apache=/usr/local/apache --with-mysql=/usr/local/mysqlc --with-openssl=/usr/local/ssl --with-gd=/usr/local/gd --with-jpeg-dir=/usr/local --with-png-dir=/usr/local --with-zlib-dir=/usr/local --with-ttf=/usr/local --enable-apc --enable-calendar --enable-bcmath --enable-track-vars MySQL related configuration directives in php.ini are: mysql.allow_persistent = Off mysql.max_persistent = 0 mysql.max_links = 1000 mysql.default_port = 3306 mysql.default_socket = /usr/local/mysqlc/var/mysql.sock mysql.default_host = localhost MySQL was compiled with the following flags: --enable-static --localstatedir=/usr/local/mysqlc/var --with-libwrap=/usr --with-mysqld-user=mysqlc --with-unix-socket-path=/usr/local/mysqlc/var/mysql.sock --with-tcp-port=3306 --without-bench --without-mit-threads Error returned: Warning: Can't connect to local MySQL server through socket '/usr/local/mysqlc/var/mysql.sock' (13) in /home/www/k/kheos.net/test.php on line 3 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/usr/local/mysqlc/var/mysql.sock' (13) in /home/www/k/kheos.net/test.php on line 3 Script that returned the error: <? mysql_connect("localhost","joeuser","joepassword"); ?> By the way, if someone would care to write a patch for: http://www.php.net/bugs.php?id=11767 I'd appreciate it cause i got poor C skills ;p --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=11863&edit=2