Could not obtain integration config settings

DickNervous · Beginner Joined: Apr 19, 2005 Posts: 18

Start off with fresh installs of G2 and phpBB3.
Go through the core integration.
Do the prosilver theme integration

The issue is that when I try to use the "Synchronize Users" button in the ACP, it just takes me to a blank screen. The URL looks like this:

Quote: › http://gruntville.com/gvlwp/phpBB3/adm/index.php?i=gallery2&sid=1351288f29b273fc9921ce02e742e5bb&mode=options&action=sync

G2 has 1 user in it, admin.
phpBB has 2 users (other than the bot users), admin and one other.

AdBot

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1047

Have you done the automatic configuration or the manual configuration first to setup the path settings?

DickNervous · Beginner Joined: Apr 19, 2005 Posts: 18

Did the automatic config and all the path settings are correct.

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1047

The title of your post says "Could not obtain integration config settings". Is it giving you that error message or just a blank screen?

Blank screen probably means you have done the mods wrong somewhere (especially in the acp areas).

The error message means the settings are not being stored in the db...

DickNervous · Beginner Joined: Apr 19, 2005 Posts: 18

Oh duh.

When I started writing this post I was getting two errors, but I fixes one (the one in the title) and not the other between the time I started the post and finished it. The pitfalls of multitasking.

I will double check the ACP integration points and see if I messed something up.

Thanks.

DickNervous · Beginner Joined: Apr 19, 2005 Posts: 18

I went thought the entire integration again and did find 1 line I missed. So I fixed it and went through the Automatic Configruation and all goes fine.

When I try to Synchronize the users I get the dreaded "Internet Explorer cannot display the webpage".

The back end of the URL is "phpBB3/adm/index.php?i=gallery2&sid=759beaa7f18e8c2a96e888ae800f37a7&mode=options&action=sync"

Also, at this point if I click the g2img button in a reply, I get the "Could not obtain integration config settings from phpbb3_config". When I look in that table I see that out of all the g2i entries the allLinksAlbums, allLinks, link, adctiveAdminID, and allLinksLimit are blank. The g2Uri, fullPath, and enbedUri have what seems to be the correct information in them.

I also get that error when clicking the Gallery2 link at the top of a forum page.

I am guessing that these are related.

I am so close to getting this all working I can taste it... so any help is appreciated!

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1047

Hmm...I don't understand why it says it can't display the page. All the 'Gallery2 Settings' options run from the same php file and use the same template file. Do all the other option buttons work in the Gallery2 Settings menu?

Until you run the Synchronize Users function, the rest of the error messages are irrelevant at this point. You have to run the snyc users code to set some crucial settings and setup admin mappings.

The blank page problem is gone, right? Try clearing the phpbb cache and the browser cache.

DickNervous · Beginner Joined: Apr 19, 2005 Posts: 18

Okay, I am starting to get frustrated.

I have done a complete clean re-install of Gallery2.
I have double checked all the file edits for the integration.
I have done all the SQL modifications.

At the end of the Automatic Configuration when it tries to sync I get a blank screen with the URL mentioned earler (just a different sessionID as you might expect).

The only user in the Gallery is the admin.
The forums have 2 users, the admin and 1 other.

Is there some other permissions or something in the forums that I need to set?

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1047

Do all the other option buttons work in the Gallery2 Settings menu?

DickNervous · Beginner Joined: Apr 19, 2005 Posts: 18

The Automatic Config does.
The Manual Config does, though the ActiveAdminID is blank.
Link Settings appears to work.
Synch does not.
Unsynch, I didn't actually do it, but I can get to the final "Are you sure" button
Export results works, but shows all 0 for everything
Cache purge claims to have pruges the cache.

So, yeah, it seems like they all work excpet for the Sync.

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1047

Hmm...ok so it's not the php file itself or the template file. Seems to be the export form. Not sure why since you only have a few users and nobody else has ever had this problem, but try swapping this code from the next version. It was mostly to eliminate a sql query in a loop and some redundant language settings, but maybe it will help...
In includes/acp/acp_gallery2.php, Find:

Code: ›       // display synchronize users form
      case 'sync':
         $this->_g2Init();

         // search for Gallery users who do not exist in phpBB
         // in case we have to reverse synchronize first
         list ($ret, $userList) = GalleryCoreApi::fetchUsernames();
         if (isset($ret))
         {
            trigger_error($user->lang['G2_FETCHUSERNAMES_FAILED'] . $user->lang['G2_ERROR'] . $ret->getAsHtml(), E_USER_ERROR);
         }

         foreach ($userList as $id => $name)
         {
            if ($name != 'guest')
            {
               $sql = 'SELECT username
                  FROM ' . USERS_TABLE . "
                  WHERE username = '" . $db->sql_escape($name) . "'";
               if (!$row = $db->sql_fetchrow($db->sql_query_limit($sql, 1)))
               {
                  list ($ret, $groupsForUser) = GalleryCoreApi::fetchGroupsForUser($id);
                  if (isset($ret))
                  {
                     trigger_error(sprintf($user->lang['G2_FETCHGROUPSFORUSER_FAILED'], $id) . $user->lang['G2_ERROR'] . $ret->getAsHtml(), E_USER_ERROR);
                  }

                  $template->assign_block_vars('users', array(
                     'USER_ID' => $id,
                     'USER_NAME' => $name,
                     'USER_GROUPS' => implode(', ', array_values($groupsForUser))
                     )
                  );

                  $usersExist = true;
               }
            }
         }

         $this->_g2Done();

         $this->page_title = $user->lang['ACP_GALLERY2_INTEGRATION'] . ' :: ' . $user->lang['GALLERY2_SYNC_TITLE'];

         $template->assign_vars(array(
            'L_INTEGRATION_TITLE' => $user->lang['ACP_GALLERY2_INTEGRATION'],
            'L_SYNC_TITLE' => $user->lang['GALLERY2_SYNC_TITLE'],
            'L_SYNC_EXISTING' => $user->lang['GALLERY2_SYNC_EXISTING'],
            'L_SYNC_EXPLAIN1' => $user->lang['GALLERY2_SYNC_EXPLAIN1'],
            'L_SYNC_EXPLAIN2' => $user->lang['GALLERY2_SYNC_EXPLAIN2'],
            'L_SYNC_EXPLAIN3' => $user->lang['GALLERY2_SYNC_EXPLAIN3'],
            'L_SYNC_EXPLAIN4' => $user->lang['GALLERY2_SYNC_EXPLAIN4'],
            'L_SYNC_EXPLAIN5' => $user->lang['GALLERY2_SYNC_EXPLAIN5'],
            'L_SYNC_EXPLAIN6' => $user->lang['GALLERY2_SYNC_EXPLAIN6'],
            'L_SYNC_EXPLAIN7' => $user->lang['GALLERY2_SYNC_EXPLAIN7'],
            'L_SYNC_ACTION' => $user->lang['GALLERY2_SYNC_ACTION'],
            'L_SYNC_USER' => $user->lang['GALLERY2_SYNC_USER'],
            'L_SYNC_USERID' => $user->lang['GALLERY2_SYNC_USERID'],
            'L_SYNC_GROUPS' => $user->lang['GALLERY2_SYNC_GROUPS'],
            'L_SYNC_IMPORT' => $user->lang['GALLERY2_SYNC_IMPORT'],
            'L_SYNC_DELETEALL' => $user->lang['GALLERY2_SYNC_DELETEALL'],
            'L_SYNC_DELETE' => $user->lang['GALLERY2_SYNC_DELETE'],
            'L_SYNC_LEAVE' => $user->lang['GALLERY2_SYNC_LEAVE'],
            'L_SYNC_NOW' => $user->lang['GALLERY2_SYNC_NOW'],
            'L_SYNC_LATER' => $user->lang['GALLERY2_SYNC_LATER'],
            'L_SYNC_BUTTON' => $user->lang['GALLERY2_SYNC_BUTTON'],

            'S_SYNC' => true,
            'S_G2_EXPORT' => $this->u_action . '&action=export',
            'S_EXPLAIN' => (isset($usersExist)) ? $usersExist : false,
            'S_INTEGRATION_VERSION' => $this->_integrationVersion)
         );

   break;

Replace with:

Code: ›       // display synchronize users form
      case 'sync':
         $this->_g2Init();

         // search for Gallery users that do not exist in phpBB
         // in case we have to reverse synchronize first
         list ($ret, $userList) = GalleryCoreApi::fetchUsernames();
         if (isset($ret))
         {
            trigger_error($user->lang['G2_FETCHUSERNAMES_FAILED'] . $user->lang['G2_ERROR'] . $ret->getAsHtml(), E_USER_ERROR);
         }

         $sql = 'SELECT username
            FROM ' . USERS_TABLE . '
            WHERE ' . $db->sql_in_set('username', array_values($userList));
         if (!$result = $db->sql_query($sql))
         {
            trigger_error($user->lang['FETCH_USERINFO_FAILED'], E_USER_ERROR);
         }

         $user_list = array();

         while ($row = $db->sql_fetchrow($result))
         {
            $user_list[] = $row['username'];
         }

         $userList = array_diff($userList, $user_list);

         if (sizeof($userList))
         {
            foreach ($userList as $id => $name)
            {
               if ($name != 'guest')
               {
                  list ($ret, $groupsForUser) = GalleryCoreApi::fetchGroupsForUser($id);
                  if (isset($ret))
                  {
                     trigger_error(sprintf($user->lang['G2_FETCHGROUPSFORUSER_FAILED'], $id) . $user->lang['G2_ERROR'] . $ret->getAsHtml(), E_USER_ERROR);
                  }

                  $template->assign_block_vars('users', array(
                     'USER_ID'    => $id,
                     'USER_NAME'    => $name,
                     'USER_GROUPS' => implode(', ', array_values($groupsForUser))
                  ));

                  $usersExist = true;
               }
            }
         }

         $this->_g2Done();

         $this->page_title = $user->lang['ACP_GALLERY2_INTEGRATION'] . ' :: ' . $user->lang['GALLERY2_SYNC_TITLE'];

         $template->assign_vars(array(
            'U_G2_EXPORT'    => $this->u_action . '&action=export',

            'S_SYNC'       => true,
            'S_EXPLAIN'       => (isset($usersExist)) ? $usersExist : false)
         );

   break;

DickNervous · Beginner Joined: Apr 19, 2005 Posts: 18

Still don't work.

Could it be that the phpBB3 admin ID and G2 admin ID are the same?
And what should the g2i_activeAdminId value be in the phpBB config table? Mine is blank right now (always has been).

jettyrat · Moderator Joined: Nov 28, 2005 Posts: 1047

Is this a local setup or somewhere online that I can access? I don't understand why it is hanging up there.

There is not much chance the two admin id's have the same id number and it wouldn't matter anyway.

The g2i_activeAdminId is normally 2 (the default initial phpbb admin id), but you can't just enter it in there because you will have other issues. The export function needs to run to make it all work properly.

I can probably walk you through the steps to do a manual export since you only have a couple users, but it would be better to figure out the problem. Nobody has ever had this problem before so I'm kinda stumped by it. Also 2 different sets of code do the same thing so that is a bit weird!

whodaman · Beginner Joined: Jul 18, 2008 Posts: 4 Location: Australia

Hey all,

was this ever resolved? I seem to be having the exact same issue, The install goes very smoothly until the point of synchronizing the users, Where I get a blank screen. I assumed it was the PHP Memory limit issue? I did the entire integration locally before i went live and it works a treat on my testing environment, the only difference I can see is that locally I have 128MB memory limit and live it is limited to 16MB. I have managed to go through the entire instillation and everything looks fine. Is the manual export a viable idea for a database of 120ish users?

have put a request into the host for more memory, but since I am on a shared environment that may not be possible.

Im so close I can smell it Smile

Thanks in advance
Pete

whodaman · Beginner Joined: Jul 18, 2008 Posts: 4 Location: Australia

just an update for anyone else having probs with this, this is definitely a script size issue, this is the message when errors turned on.

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 1966080 bytes) in /var/virtual/web/w0538/html/includes/utf/data/confusables.php on line 1

I have asked for an increase to 24mb so I am hoping that will do the trick.