[wplug] MySQL and phpBBS

[Wise, Jeremey]

Resolution to this for archive of the user group:

The issue was that within Webmin you must create two separate accounts
for the use of the database. One called "user" with access from anywhere
but a second one must also be created for "user" from "localhost". This
fixed the database access issue and allowed successful installation.

Thanks all for the replies.

PS: If there is anyone who runs phpBBS I am looking for a few side
things

1) Way to change the default template (skin) of the website via file
system edit (I changed it to one which totally broke the interface to
use it and need to revert back to the default but don't know how.

2) Way to imbed the phpBB into a webpage while maintaining my server
side side menu (for website consistency).



-----Original Message-----
From: Bill Moran [mailto:wmoran at potentialtech.com] 
Sent: Wednesday, November 30, 2005 9:56 AM
To: General user list
Cc: Wise, Jeremey
Subject: Re: [wplug] MySQL and phpBBS

"Wise, Jeremey" <jeremey.wise at agilysys.com> wrote:

<snip>

> [root at venus]# mysql -u mywebsite -p mywebsite <
>
/var/www/html/mywebsite/Members/BullitenBoard/phpBB2/install/schemas/mys
> ql_schema.sql
> Enter password:
> ERROR 1045: Access denied for user: 'mywebsite at localhost' (Using
> password: YES)
> [root at venus mysql]# mysql -u msdba -p mywebsite <
>
/var/www/html/landofthevisigoths/Members/BullitenBoard/phpBB2/install/sc
> hemas/mysql_schema.sql
> Enter password:
> [root at venus mysql]#
> 
> ***** 
> I must be missing something simple here. I checked user permissions in
> mysql and user is listed with full rights and password has is same as
> mydba which means their the same. Under database permissions user
> 'mywebsite' is listed with full rights for the database. 
> 
> My opinion is that this is a stupid setup error on the mysql side. 
> 
> Any thoughts?

I think I finally know what's happening.  You're user permissions aren't
set up they way you think they are.

MySQL does some juggling when checking permissions to see which account
gets used when logins are attempted.  For example, you could have a
certain user with permissions and password used when logging in from
the localhost, while having another user (with the exact same name)
with completely different permissions and password that is used when
logging in from any other machine.  This is particularly likely if you
use wildcards for the hostname when creating users - wildcards aren't
always interpreted they way you would expect.  MySQL attempts to
optimize
your user table.

I would suspect that your priviledge tables aren't set up to work they
way you expect.  A likely cause of this is that you have another user
that has a different password or different priviliges that's being used
instead of the account you would expect.  Possibly there's an "anyone"
at localhost account that's taking precendence?  (just a guess)

Have a read here and see if it helps:
http://dev.mysql.com/doc/refman/4.1/en/privileges.html

If you can't figure it out, feel free to post your user table (scrub the
passwords first) and I'll see if I can figure out the problem.

-- 
Bill Moran
Potential Technologies
http://www.potentialtech.com