The most recent change I made to a site was installing the PostNode module. I recompiled PHP5 with curl/curlwrappers support, restarted Apache, and enabled the module. PostNode continued to report errors with submitting topics to phpBB. Then users started filing reports that they were receiving Access Denied messages when trying to post or reply to topics. Now, all users, including Admins, cannot use the forum. Enabling PostNode was the last change I made to the site & server, so I'm wondering if you can help me figure out what happened that has caused all users to be denied access to using the forums. Only viewing the forums is possible now.

Thank you very much,

Bob

Comments

ymmatt’s picture

ymmatt commented
Assigned: Unassigned » ymmatt

Bob,

I currently have this working on a machine using PHP Version 4.3.9 I will have to test this on a php5 server.

Can you send me the specific errors you were receiving?

What version of Drupal are you using, What version of mysql, what version of phpbb?

bobwaycott’s picture

bobwaycott commented

mysql-5.0.40
phpBB-2.0.22
php-5.2.2-r1
drupal-5.1

I had to rebuild php with curl support to enable PostNode. I think the issue with PostNode not posting to the forum is that it appears it is looking for a phpbb_posts table in my drupal db. I have the two separated. phpBB is in its own db, Drupal has its own. Everything has worked fine until all of a sudden user logins are not persisting between Drupal and phpBB. Enabling PostNode and recompiling PHP with CURL are the only changes I've made. I may have to just disable CURL and PostNode and see what happens.

user warning: Table 'drupal.phpbb_posts' doesn't exist query: SELECT `topic_id` FROM `phpbb_posts` WHERE post_id =0 in /path/to/site.com/htdocs/includes/database.mysql.inc on line 172.

What would I need to clean out of the Drupal db to erase PostNode's existence after disabling?

ymmatt’s picture

ymmatt commented

PhpBBPostNode installs a phpbb_posts table in your drupal mysql database, regardless of the location of your phpbb database. This is where the variables that are important to the drupal nodes are stored.

What other phpbb modules do you have installed? It sounds like you may have another module that coordinates the logins between phpbb and drupal.

bobwaycott’s picture

bobwaycott commented

I have the phpbb module enabled for users to login thru drupal and have the login carry to phpBB. Since enabling PostNode, the logins are not carried over and all users, including Admins, are now receiving 'Access Denied' pages when attempting to post and reply.

Any idea why this has happened after enabling PostNode?

ymmatt’s picture

ymmatt commented

Currently this module posts from one user, specified in the configuration settings, no matter who is logged into Drupal.

It seems that this would be a good opportunity for me to make it possible for both modules to "play well together" I know exactly what the issue is, but keep an eye on this thread to see when it has been resolved.

Can you disable the module, if so does everything start working as it should?

bobwaycott’s picture

bobwaycott commented

I have disabled PostNode, deleted the phpbbPostNode table from my Drupal db, and removed phpbbPostNode from the /modules directory.

Still, no users or admins can use phpBB now.

I've checked with arkepp, maintainer of the phpbb module that handles logins, and he says all data being inserted in tables looks correct. But phpBB is not recognizing any logins.

ymmatt’s picture

ymmatt commented

I took a look at your support request at the phpbb module, have you tried restoring the phpBB database to the day before you enabled phpbbPostNode? Is there a way to re-sync the user-login tables?

I will setup a test site and work on solving this issue for the next release of phpbbPostNode.

bobwaycott’s picture

bobwaycott commented

I'm not sure how to resync the user login tables. And I did not create a backup before enabling PostNode. I had no idea there would be a conflict between the two modules.

ymmatt’s picture

ymmatt commented

You may have tried this, but it may be worth attempting to disable the phpbb module, and re-enable it.

phpbbPostNode uses curl, so it is an http request. It does not edit the phpbb tables directly. It behaves as if the user, specified in the phpbbPostNode configuration settings (not the one currently logged in), had actually gone to the page, entered in the required fields and clicked submit.

Before you do anything more I would suggest backing up all of your databases.

I recommend making daily backups of all of your databases, I use this to automate the process on my machines:
http://sourceforge.net/projects/automysqlbackup/

bobwaycott’s picture

bobwaycott commented

I have tried disabling the phpbb module, deleting all cookies and authenticated sessions from my browser, and then re-enabling phpbb. Nothing changed.

For the future version of phpbbPostNode, is there a way for these two modules to work together by basing it on permissions and user roles? So, if I have a Dev role for people who can post content that can also be cross-posted to phpBB, only they will see those options and the posting will take place with their user login?

In the meantime, I'm starting to fear having to completely reinstall this site from scratch. The big problem is that I have done such heavy customization to the interface and theme, I don't want to lose any of that.

bobwaycott’s picture

bobwaycott commented

I am still receiving the error after re-enabling phpbbPostNode about the table phpbb_posts.

I have looked through your code in phpbbPostNode.install and PostNode.module. I don't see anything creating that table. It seems to assume it is there. I see the mysql code that is creating the phpbbPostNode table, but not phpbb_posts.

Can you either point out where that table creation takes place or let me know what fields and in what order they should appear so I can create the table myself?

Thanks again for your overwhelming support. Peace.

ymmatt’s picture

ymmatt commented
Title: After enabling PostNode, Access Denied » phpbbPostNode does not work with phpbb module
Category: support » feature
Priority: Critical » Normal
Status: Active » Postponed
ymmatt’s picture

ymmatt commented
Status: Postponed » Closed (won't fix)

I'm not sure I'll have time to work on this, especially for all of the different versions of the module/phpbb.

That is unless enough people are intersted

jwhitakr’s picture

jwhitakr commented

I am having a similar issue with this module, though not exactly the same. Any help that anyone could provide to fix it would be greatly appreciated!

jwhitakr’s picture

jwhitakr commented

From what I can tell after doing some more R&D, is that this module is not compatible with phpBB 3.0.4 (what I am running).