PHPBB2 Integration -- Rights to SQL DB

This is a help desk ticket that Alex helped me with. I thought I'd post it in case others need help.

--------

Hi Alex,

I am having trouble getting the configuration with amember to work with PHPBB2.

But before the issue.... I see conflicting forum posting.

Does this configuration plug in integrate to a SINGLE SIGN ON between phbBB2 and amember? It's the only reason I bought it.

***** The answer to this is "YES" it works.

My technical issue is:

I get the following error:

"phpbb Board Db and Prefix - incorrect value. Error: select command denied to user: 'amember@localhost' for table 'phpbb_users'

I have triple checked the board db and prefix.

The board DB is: datbase name
Prefix is: phpbb_

However, the forum is on

http://FORUM.mysite.org

but the amember script is at

http://www.mysite.org

Please advise if it's not possible to do it that way (2 different urls).

------------ Yes, it's possible, as long as the database sits on the same system.


I reinstalled and re-uploaded EVERYTHING.

I cannot get anyone into AMEMBER as a member now. ... which is the same problem as teh PHPBB plugin

I cannot add people manually from the configuration, nor through the payment processor. I get this error.

MYSQL ERROR:
Table 'amember.users' doesn't exist
in query:
SELECT COUNT(*) FROM users WHERE username='afd' AND (user_email '' OR user_password md5('af') )

I went into MYSQL. The "users" table doesn't exist. There is a members table though.

I saw the post that refers to "implementing a plug in but not setting up."

This fixed the issue. Because the plug in wasn't correctly configured, it casued amember to bomb out writing the members table. When I disabled the plugin, it worked.

So, should I add a table through MYSQL for users? Or, is this not goign to work because I'm using PHPBB2??

REPLY FROM ALEX---

Yes, it works with PHPBB2

You need to set phpDB and prefix in plugin configuration page to
databasename.databaseextension_

If you will get this error:
phpbb Board Db and Prefix - incorrect value. Error: select command denied to
user: 'amember@localhost' for table 'phpbb_users'

In your host CP -> MySQL manager grant access permissions for aMember's MySQL user to access phpBB MySQL database then try again.


this worked!!!


By using the following code in the SQL Query through php MyADMIN (logged in as "ROOT") Have to be in as root@localhost (which is the super user account).

Go into SQL Section (run an SQL Query)

Put the following in (everything between the quotes " " -- but NOT the quotes)

"GRANT ALL PRIVILEGES ON user_base TO 'real_user'@localhost IDENTIFIED BY 'real_password'; "


where

user_base = database name (the new database that will contain PHPBB)
real_user = amember database USER name
real_passwrod = amember user password

by the way, yes, you also use the single quotes in the line ' ' and the ; at the end