#23492 [Fbk]: mysql_connect() sometimes fails to use password

ID: 23492 Updated by: sniper@php.net Reported By: dziugas dot baltrunas at m-1 dot lt Status: Feedback Bug Type: MySQL related Operating System: FreeBSD 4.8-RELEASE PHP Version: 4.3.1 New Comment: And did the 'earlier php version (?)' have this problem when it was using the 3.23.55 mysql?? Previous Comments: ------------------------------------------------------------------------ [2003-05-06 18:33:04] sniper@php.net Under what webserver are you getting this? Does it make any difference if you use the bundled mysql library instead? (don't pass any path to --with-mysql) ------------------------------------------------------------------------ [2003-05-06 01:18:14] dziugas dot baltrunas at m-1 dot lt here is snip from phpinfo() about mysql: MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 4.0.12 MYSQL_MODULE_TYPE external MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/usr/local/include/mysql MYSQL_LIBS -L/usr/local/lib/mysql -lmysqlclient mysql servers lives not in the same place webserver does. earlier php was compiled with 3.23.55 client library, then I decided to compile it with 4.0.12. it didn't make sense. I'm not sure it's PHP bug natively, but I'm mainly curious about why it "fails to use password" ? one more thing to say - these systems are loaded enough, i.e. mysqladmin reports 15.968 queries per second, so I said before, it's hard to repeat this error in, to say, normal conditions. ------------------------------------------------------------------------ [2003-05-05 16:25:21] sniper@php.net What makes you think it's PHP bug, and not bug in the fairly new Mysql4 ?? Did this happen with Mysql 3.23.xx ? Are you using the bundled mysql library or did you compile PHP with the mysql4 client library? Check your phpinfo() output for mysql section for the API version. Does this happen with CLI or with some server module? ------------------------------------------------------------------------ [2003-05-05 09:43:12] dziugas dot baltrunas at m-1 dot lt As I said, seems like password retrieval makes no difference. I have connectdb() function which look like this: function connectdb() { global $mysql_host, $mysql_user, $mysql_pass, $dbid; $dbid = mysql_connect( $mysql_host, $mysql_user, $mysql_pass); if(!$dbid) { $file = fopen("/tmp/mysql-err", "a+"); $line = $_SERVER['PHP_SELF'] . ":" . date("Y-m-d H:i:s"); $line .= ":$mysql_host:$mysql_user:$mysql_pass - $dbid:" . mysql_error() . "\n"; fputs($file, $line); fclose($file); } return $dbid; } and here is what gets logged into /tmp/mysql-err: /index.php:2003-05-05 14:30:53:db1.m-1.lan:public:secret - :Access denied for user: 'public@10.10.12.254' (Using password: NO) so function retrieves the password fine. ------------------------------------------------------------------------ [2003-05-05 09:29:18] nicos@php.net Thanks for the report. Do you retrieve your password from any dynamic way or is it static? ------------------------------------------------------------------------ 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/23492 -- Edit this bug report at http://bugs.php.net/?id=23492&edit=1