Intermittent error with MySQL and phpBB

From: DrClaw (drclaw_at_NOSPAMhotmail.com)
Date: 09/28/03 

Date: Sun, 28 Sep 2003 21:46:02 +1000

I am having intermittent access problems with MySQL and phpBB... I am unsure
if it is a problem with MySQL, FreeBSD or php, so i figured i'd try my luck
here, as you people seem to know your stuff (tm)

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.

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 script to confirm this next time the error occurs - it's
going to dump the attempted connection values to file), so therefore if the
password/hostname is incorrect, it should fail every single time, not
intermittently.

I have pretty much confirmed that PHP is using the correct password/hostname
combination - error just occured again and i logged the details used.

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:
'phpBB@localhost' (Using password: YES)

Error message from /var/log/messages :
Sep 25 23:24:59 apone httpd: PHP Warning: mysql_connect(): Access denied
for user: 'phpBB@localhost' (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 :)

Relevant Pages

  • Re: Slightly OT; Opinions on Forum type software
    ... I participate on several sites that use phpbb with mysql. ... Does your host charge monthly for MySQL (which is _not_ the same as MS SQL ... Host supports PHPBB and Snitz type forums (and will install them for small ... I like the look of php better than snitz, but I suppose the can both be ...
    (microsoft.public.frontpage.client)
  • Re: Slightly OT; Opinions on Forum type software
    ... dunno how/why they run phpbb with access but they said they did. ... Actually I have another Linux host that has MySQL for free, but I really wanted to try Windows server this time around. ... | the database to get your forums online. ... As for Snitz vs. phpbb, ...
    (microsoft.public.frontpage.client)
  • Re: MySQL 4.x questions...
    ... > I installed MySQL server 4.1.0_1 to support the PostNuke CMS and the phpBB ... Both users groups tell me that there's a mysql ... connecting using the unix socket will ...
    (freebsd-questions)
  • Re: Useful phpbb installation guide
    ... > I still have problems with MySQL currupting database tables. ... I have run phpbb successfully using the latest MySQL 4.1.3-beta kit ... InnoDB engine work perfectly, and yes the MyISAM bug is still present... ...
    (comp.os.vms)
  • [UNIX] PHPBB BBcode Process Vulnerability (DoS)
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... WSS has found a vulnerability in <http://www.phpbb.com/> phpBB, ... Will cause the following data to be saved to the database: ... whitecell$ mysql -uuser -ppasswd ...
    (Securiteam)
Loading