#23492 [Opn->Bgs]: mysql_connect() sometimes fails to use password

ID: 23492 Updated by: edink@php.net Reported By: dziugas dot baltrunas at m-1 dot lt -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: FreeBSD 4.8-RELEASE PHP Version: 4.3.1 New Comment: Not a PHP bug then. Previous Comments: ------------------------------------------------------------------------ [2003-05-08 09:11:40] dziugas dot baltrunas at m-1 dot lt Sorry for this long story. I just realized that it's mysql bug itself: <menulis@sala: menulis>$ while true; do mysql -hdb1 -upublic -psecret -e'quit'; done ERROR 1045: Access denied for user: 'public@10.10.12.254' (Using password: NO) ERROR 1045: Access denied for user: 'public@10.10.12.254' (Using password: NO) ERROR 1045: Access denied for user: 'public@10.10.12.254' (Using password: NO) ERROR 1045: Access denied for user: 'public@10.10.12.254' (Using password: NO) ERROR 1045: Access denied for user: 'public@10.10.12.254' (Using password: NO) ERROR 1045: Access denied for user: 'public@10.10.12.254' (Using password: NO) ERROR 1045: Access denied for user: 'public@10.10.12.254' (Using password: NO) ERROR 1045: Access denied for user: 'public@10.10.12.254' (Using password: NO) these errors appear occasionaly, each after 10-20 seconds. thank you guys anyway, I will try to report it to MySQL. ------------------------------------------------------------------------ [2003-05-08 09:01:33] dziugas dot baltrunas at m-1 dot lt one more thing I've figured out: 372 Connect Access denied for user: 'public@10.10.12.254' (Using password: YES) 373 Connect public@10.10.12.254 on these are lines from mysql.log on the same time when php reported: [08-May-2003 16:53:28] PHP Warning: mysql_connect() [<a href='http://www.php.net/function.mysql-connect'>functi on.mysql-connect</a>]: Access denied for user: 'public@10.10.12.254' (Using password: NO) in /my/web/place/edit/config-global.php on line 232 ------------------------------------------------------------------------ [2003-05-08 08:15:10] dziugas dot baltrunas at m-1 dot lt Today I recompiled PHP with bundled mysql library as you recommended but the problem still persists: [08-May-2003 16:09:48] 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 /my/web/space/lib/mysql.php on line 10 here is info from "my error log": /index.php:2003-05-08 16:09:48:db1.m-1.lan:public:secret - :Access denied for user: 'public@10.10.12.254' (Using password: NO) here "public" is the username and "secret" is the password. current phpinfo() about mysql: Active Persistent Links 0 Active Links 0 Client API version 3.23.49 MYSQL_MODULE_TYPE builtin MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE no value MYSQL_LIBS no value ------------------------------------------------------------------------ [2003-05-07 07:13:29] dziugas dot baltrunas at m-1 dot lt thanks for the comments. we are using Apache/1.3.27. actually, I can't asure that this problem was with earlier versions of PHP, i.e. < 4.3.1, because only from version 4.3.0 I started to write every warning/error to the file. I will try to find time to recompile php with bundled version of mysql, because I can't do this during the peak hours. Futhermore, I'm building php from FreeBSD mod_php4's port and "by default" it tries to find installed mysql-client. One more thing which needs to be mentioned - this issue occurs in "web portals" which are build from different files, i.e. using include/require functions. I'm still concerned about the error of not using password (Using password: NO), because AFAIK this error is being produced by mysql library as well as the whole possible mysql_error() output. maybe this error could mean something different? ------------------------------------------------------------------------ [2003-05-06 18:33:50] sniper@php.net And did the 'earlier php version (?)' have this problem when it was using the 3.23.55 mysql?? ------------------------------------------------------------------------ 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