I am having intermittent access problems with MySQL and phpBB... I am unsure if it is a problem with MySQL, FreeBSD or php, leaning towards MySQLso i
figured i'd try my luck here. I setup a small forum (7-8 users) that uses phpBB, and I am getting intermittent "access denied" errors when accessing the database. They occur completley randomly, sometimes I get a string of 5 or 6, whereas I got 1 for the first time in 2 days today. The rest of the time the database performs Flawlessly. I have upgraded my MySQL config settings to my-medium.cnf. mod_php4 is the current release version (updated it from the ports tree yesterday), and apache is current also (also upgraded). After referring to the online MySQL documentation, it would seem that this should only occur when the user does not have access at the specified host, or the password is incorrect. As far as I can tell from the phpBB layout/settings, the password, hostname, username are all set in a central config file on install, and are never modified again (I have edited the error producing code to confirm this), so the password/hostname is correct. Any suggestions as to why this would be occurring? It seems to me that MySQL is having errors checking the users password / login details, but I am unsure how to test this. I have enabled logging on the MySQL side of things, and it pretty much echos the error message given my httpd : 030928 20:24:25 465 Connect Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Error message from /var/log/messages : Sep 25 23:24:59 apone httpd: PHP Warning: mysql_connect(): Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in /usr/local/www/data/phpBB2/db/mysql4.php on line 48 phpBB 2.0.6 mysql Ver 13.5 Distrib 4.1.0-alpha, for portbld-freebsd5.1 (i386) 5.1-RELEASE FreeBSD 5.1-RELEASE #2 Thanks for your help - all comments welcome :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
