Bug #1118 Updated: MySql fails to work with mod_auth_mysql

ID: 1118 Updated by: zeev Reported By: mark-junk@domino.com Status: Closed Bug Type: MySQL related Assigned To: Comments: First, check the return value from *every* MySQL function call you make. From your file it's not clear at all where PHP fails. The only that's obvious is that the mysql_query() call fails. The fact that mysql_error() returns nothing also implies that mysql_connect() failed right from the beginning. The bottom line is that mod_auth_mysql doesn't affect PHP's behavior in any way, whether it's compiled into the server or dynamically loaded. Your problem is most probably unrelated, as Rasmus said, there's a good chance your mysql_connect() fails because of an invalid username (never rely on the runtime username, unless you *really* know what you're doing and perfectly understand the difference between uid's, euid's, and the way MySQL uses them to determine the current default username; You're much better off explicitly supplying the username and password). Start with a simple script, something like: <? error_report(E_ALL); if (!mysql_connect($username)) { print "mysql_connect() failed\n"; } ?> That would probably give us all the clues we need. Full Bug description available at: http://ca.php.net/bugs.php3?id=1118 -- PHP Development Mailing List http://www.php.net/ To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net For help: php-dev-help@lists.php.net