Can't login to phpbb forums

Posted by n00bie on June 28, 2008 at 12:03am

I installed drupal 5.7 w/phpbb 3.0.1 and integrated the database using the phpbb drupal module.
I'm having problems logging in to the phpbb forums (i.e. to http://mysite/phpbb or in my case http://mysite/forum). It doesn't matter whether I try to login as admin or regular user to phpbb, I'm redirected to "Access forbidden. Error 403" by the browser. I know that whenever I add a new user to drupal that user is also being added to phpbb because the username of the newest drupal user shows up at the bottom of the phpbb login page as the "Our newest member: newest drupal member".

Also, the following two things happen:
1) When I login to drupal everything looks normal but after browsing around the site if I return to the homepage a message appears at the top saying "(The phpBB superuser is never logged into Drupal). You should create a new user and give this user admin rights in both Drupal and phpBB."

2) Whenever I add a new user to drupal an error message appears stating

• Attempt to insert user with id 4, but this user already exists in the phpBB database.
• user warning: Duplicate entry '4' for key 1 query: INSERT INTO phpbb_users (user_id,group_id,username,username_clean,user_password,user_regdate,user_email,
user_options,user_lang,user_timezone,user_sig,user_lastpage,user_permissions,
user_from,user_aim,user_yim,user_msnm,user_jabber,user_website,user_occ,
user_interests,user_form_salt,user_email_hash) VALUES( 4,2,'kn','kn','$H$9WtpINAx/NwSFLkZNTSfXcgj0WhygO1',1214602290,'xxxxx@mail.com','853','en',0,
'','','','','','','','','','','','d6ff0c9e3ce5965e','173567522615') in C:\xampp\htdocs\drupal\sites\druphpbb\includes\database.mysql.inc on line 172.

After that when I login to the last created drupal member's account the following appears

    * user warning: Unknown column 'active' in 'field list' query: UPDATE drupal_users SET active = 0 WHERE uid = 4 in C:\xampp\htdocs\drupal\sites\druphpbb\includes\database.mysql.inc on line 172.
    * There is a problem with the system. Ask the administrator to check the watchdog log.
    * user warning: Unknown column 'active' in 'field list' query: UPDATE drupal_users SET active = 0 WHERE uid = 4 in C:\xampp\htdocs\drupal\sites\druphpbb\includes\database.mysql.inc on line 172.
    * There is a problem with the system. Ask the administrator to check the watchdog log.

I'm new to drupal and phpbb. And my php knowledge is limited. I can't really understand why is this occurring. How do I fix it?

Comments

Not sure about the 403. May

Posted by arkepp on June 29, 2008 at 4:52am

Not sure about the 403. May be due to lack of access to user profiles. I'd install Firebug in Firefox and figure out exactly at what location you get the 403.

1) That's normal, explained in a number of places

2) You skipped tweaking the user sequence, so your tables (user, group) may be foobar. See http://drupal.i1media.no/drupal+phpbb/install_module

Ok, the sequence issues is

Posted by n00bie on June 29, 2008 at 10:04am

Ok, the sequence issues is solved but now a number of new issues have cropped up. The 403 was occurring due to the absolute path. I no longer get an error after I changed the absolute path to '/forum/'. But here are the set of new problems:

1) cannot login to http://site/forum. After filling in the credentials and clicking submit I'm redirected back to the http://site/forum login page. The same behavior occurs when an user clicks on the Private Messages link on the drupal page, he/she is redirected to http://site/forum/inbox asking to provide authentication credentials. Once that is done and you click submit, you are redirected to http://site/forum/ucp.php?i=pm&folder=inbox which is displaying exactly the same thing as http://site/forum/inbox and asking for credentials again.

2) http://site/forum/bypass takes me to the Drupal login page. The bypass does work if I rename the .htaccess file but the url must be http://site/forum/ucp.php?bypass=true&mode=login because http://site/forum/bypass takes me to the Drupal login page. If I don't rename .htaccess and try to authenticate through http://site/forum/ucp.php?bypass=true&mode=login I'm not being logged in and am redirected to http://site/forum/index.php

3) http://site/forum/diagnostic takes me to the Drupal login page.... ALWAYS!

What do I do?

about 3)

Posted by manojn on June 29, 2008 at 3:56pm

I dont think i can help you with 1 & 2 but for 3, try using > http://site/phpbb/diagnostic even though you have setup phpbb in a directory called "forum"

Yes,

Posted by n00bie on June 29, 2008 at 7:42pm

Yes, http://site/phpbb/diagnostic works thanks. But still I've the vital issue of 1) and 2). The whole system is useless without a solution to those problems. Please help if possible.

Ok, 2) also works like 3)

Posted by n00bie on June 29, 2008 at 9:26pm

Ok, 2) also works like 3) http://site/phpbb/bypass but 1) still remains.

Debugging

Posted by manojn on June 30, 2008 at 3:31am

To resolve 1) try to debug using the following steps: http://groups.drupal.org/node/5912
I hope it helps.

Cookie domain

Posted by n00bie on June 30, 2008 at 11:03am

Thanks Manny. I didn't get to debugging but I did the bypass and set the cookie domain to blank. 1) seems to be solved now. So, finally things seem to work now. :) How do I put a link to the "phpbb-user control panel" on the block of the drupal site. Currently when an user logs on to the drupal site there is a link to "Private Messages" of the phpbb forum but not one to the "user control panel".

Congrats

Posted by manojn on June 30, 2008 at 11:49am

Hey! im glad things worked out for you.
For the link thing, login as admin in drupal. click on administer. Click on Menus.
Under Navigation, click on add item. Put in some description and title. For the path, enter > "http://yoursite.com/forum/ucp.php"

P.S: Make sure your authenticated users can see the menu item.

Thanks, again Manny. :) Is

Posted by n00bie on June 30, 2008 at 1:39pm

Thanks, again Manny. :) Is there a way for the users to come back to the drupal site from the phpbb forums without modifying the link on the addressbar of the browser manually? Basically can we place a permanent link to the "drupal site" in the header of the phpbb forums site (around the place where we have the link to the User Control Panel -top left- in the phpbb forums?

Sure

Posted by manojn on July 1, 2008 at 4:37am

Sure, you can.
All you need to do is edit this file > /forum/styles/prosilver/template/overall_header.html
search for > {L_PROFILE}
Add your link just before that.

However, a better place to add it would be the navigation bar in phpbb.
To add your link there, in the same file, search for >

Just after add >
<a href="http://www.mysite.com">Portal</a> <strong>‹</strong>