#23492 [Opn->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: Open +Status: Feedback Bug Type: MySQL related Operating System: FreeBSD 4.8-RELEASE PHP Version: 4.3.1 New Comment: 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? Previous Comments: ------------------------------------------------------------------------ [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? ------------------------------------------------------------------------ [2003-05-05 08:54:22] dziugas dot baltrunas at m-1 dot lt We are currently using MySQL 4.0.12. This bug occurs occasionaly and there is no way to guess what makes it appear. Even if there are "hardcoded" username and password into the function, i.e. not passing variables to it, like mysql_connect("mysql.host", "public", "secret"), PHP reports Warning: [05-May-2003 14:06:17] PHP Warning: mysql_connect() [<a href='http://www.php.net/function.mysql-connect'>function.mysql-connect</a>]: Access denied for user: 'public@10.10.12.254' (Using password: NO) in /var/www/sala.lt/htdocs/skundai/classes/db.php on line 10 So the problem is that warning (or mysql_error() message) about not using password is not correct. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=23492&edit=1