By iNickster on
I am using phpBB Single Sign-On module on my site, and I made a new account on my forum. When I try to login to the forum account on my Drupal site, I get this error:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'fastfred_drupal'@'localhost' for table 'phpbb__users': SELECT user_id, user_password, user_type FROM fastfred_phpbb.phpbb__users WHERE username_clean = :username; Array ( [:username] => iNickster ) in _phpbb_sso_check_user() (line 11 of /home4/fastfred/public_html/sites/all/modules/phpbb_sso/phpbb_sso.auth.inc).
How do I fix this?
Comments
=-=
It's a beta module. You should check the issue queue of the module in question for similar reports. If none exist file one.
SELECT command denied to user
Your database user fastfred_drupal does not have the correct database permissions to SELECT from the database. You will need to give this user SELECT permissions. This is outside Drupal.
Contact me to contract me for D7 -> D10/11 migrations.
Do my phpbb forum, and my
Do my phpbb forum, and my drupal site have to be in the same database on MySQL? Right now I have 2 separate databases for the drupal site, and the phpbb forum.
=-=
documentation within the module would explain that if it were the case. I don't see why that would be necessary.
I just have the user fastfred
I just have the user fastfred_drupal all permissions to the drupal database and its still not working.
The phpbb database was the
The phpbb database was the one that fastfred couldn't access (see the original error).
Contact me to contract me for D7 -> D10/11 migrations.
All permissions are selected
All permissions are selected for fastfred_drupal user and fastfred_phpbb user in the phpbb database.
If you've given all
If you've given all permissions to fastfred_drupal, and you are still seeing that error, then you should contact them directly, showing them that error and telling them what you've just told us.
Contact me to contract me for D7 -> D10/11 migrations.