From:             [EMAIL PROTECTED]
Operating system: Unix
PHP version:      4.0.6
PHP Bug Type:     MySQL related
Bug description:  Cannot connect to mysql server

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


-- 
Edit Bug report at: http://bugs.php.net/?id=11863&edit=1



-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to