CPG 1.4. bridge Bug? [eblah]

[frtaz]

the vars that are used when bridgemgr is enabled
CPG 1.4.1 will take you to the forum boards, but CPG Board will not remember it in the cookies. I have reinstalled both CPG 1.4.1 and E-Blah Forums P9 today. After the bridgemgr is enabled you get kicked off is admin of the board and you can not sign in. When I log out of the admin in CPG I get an *ERROR* when I am in the enable mode. No *ERROR* in the disable mode. is this a setting prob. or a bug?
E-Blah cookies are set up as eblah not as blah   

Here Is the new E-Blah.inc.php for E-blah P9 the code that you have is for P8 
Thank you for all of your help on the Bug.  CPG board still will not redirect back after login

Code Select Expand

<?php
/*************************
  Coppermine Photo Gallery
  ************************
  Copyright (c) 2003-2005 Coppermine Dev Team
  v1.1 originally written by Gregory DEMAR

  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License as published by
  the Free Software Foundation; either version 2 of the License, or
  (at your option) any later version.
  ********************************************
  Coppermine version: 1.4.1
  $Source: /cvsroot/coppermine/devel/bridge/eblah.inc.php,v $
  $Revision: 1.2 $
  $Author: donnoman $
  $Date: 2005/04/10 17:01:36 $
**********************************************/


if (!defined('IN_COPPERMINE')) die('Not in Coppermine...');

// Switch that allows overriding the bridge manager with hard-coded values
define('USE_BRIDGEMGR', 0);

require 'bridge/udb_base.inc.php';

class cpg_udb extends core_udb {

function cpg_udb()
{
global $BRIDGE, $CONFIG;

if (!USE_BRIDGEMGR) { // the vars that are used when bridgemgr is disabled

// URL of your punbb
$this->cookie_name = 'eblah';
$this->datapath = 'var/www/cgi-bin/blah/Members/';
$this->boardurl = 'http://homepage/cgi-bin/blah';
}

$this->multigroups = 0;
$this->group_overrride = 0;

// Database connection settings
$this->db = array(
'name' => $CONFIG['dbname'],
'host' => $CONFIG['dbserver'],
'user' => $CONFIG['dbuser'],
'password' => $CONFIG['dbpass'],
'prefix' =>$CONFIG['TABLE_PREFIX']
);

// Board table names
$this->table = array(
'users' => 'users',
'groups' => 'usergroups'
);

// Derived full table names
$this->usertable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['users'];
$this->groupstable =  '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['groups'];

// Table field names
$this->field = array(
'username' => 'user_name', // name of 'username' field in users table
'user_id' => 'user_id', // name of 'id' field in users table
'password' => 'user_password', // name of 'password' field in users table
'email' => 'user_email', // name of 'email' field in users table
'regdate' => 'user_regdate', // name of 'registered' field in users table
'location' => 'user_location', // name of 'location' field in users table
'website' => 'user_website', // name of 'website' field in users table
'usertbl_group_id' => 'user_group', // name of 'group id' field in users table
'grouptbl_group_id' => 'group_id'
);

// Pages to redirect to
$this->page = array(
'register' => '/Blah.pl?,v=register',
'editusers' => '/userlist.php',
'edituserprofile' => '/Blah.pl?b=,v=memberpanel,a=view,u='
);

// Group ids
$this->admingroups = array(1);
$this->guestgroup = 3;

// Connect to db
$this->connect($CONFIG['link_id']);

}

// definition of how to extract id, name, group from a session cookie
function session_extraction()
{
return false;
}

// definition of how to extract an id and password hash from a cookie
function cookie_extraction()
{
if (isset($_COOKIE['eblah_un']) && isset($_COOKIE['eblah_pw'])){
return array($this->get_user_id($_COOKIE['eblah_un']), $_COOKIE['eblah_pw']);
}

return false;
}

// View user profile
function view_profile($uid)
{
$this->redirect($this->page['edituserprofile'].$this->get_user_name($uid ? $uid : USER_ID));
}

// Edit user profile
function edit_profile($uid)
{
$this->redirect($this->page['edituserprofile'].$this->get_user_name($uid));
}

// definition of actions required to convert a password from user database form to cookie form
function udb_hash_db($password)
{
return crypt($password, $_COOKIE['eblah_pw']);
}

// Login
function login_page()
{
$this->redirect('/Blah.pl?,v=login');
}

// Logout
function logout_page()
{
$this->redirect('/Blah.pl?,v=login,p=3');
}

function get_user_id($username)
{
static $x = false;

$username = addslashes($username);

$sql = "SELECT {$this->field['user_id']} AS user_id FROM {$this->usertable} WHERE {$this->field['username']}  = '$username'";

$result = cpg_db_query($sql, $this->link_id);

if (mysql_num_rows($result)) {
$row = mysql_fetch_array($result);
mysql_free_result($result);
return $row['user_id'];
} else {
if (!$x){
$x =  true;
$this->sync_users();
$id = 0;
$id = $this->get_user_id($username);
return $id;
}
}
return 0;
}

function synchronize_groups()
{
parent::synchronize_groups();
$this->sync_users();
}

function sync_users()
{
$data = file($this->datapath . 'List.txt');

foreach ($data as $name){
$name = trim($name);
$info = file($this->datapath . "$name.dat");
$info = array_map('trim', $info);

list($password, $username, $email,,$rank) = $info;
$user_group = $rank === 'Administrator' ? 1 : 2;
cpg_db_query("INSERT IGNORE INTO {$this->usertable} (`user_name`, `user_password`, `user_email`, `user_active`, `user_group`) VALUES ( '$username', '$password', '$email', 'YES', $user_group)");
}
}
}

// and go !
$cpg_udb = new cpg_udb;
?>


[frtaz]

If you would like to see what I am talking about here is a link the web site
http://www.icducks.com/Photo/  Bridge Wizard is enabled also

test
test

Thank you

[frtaz]

Is anyone looking at this?

[Nibbler]

I can't get eblah to install, if/when I do I will investigate.

[Nibbler]

Commited a bunch of fixes to cvs, still mainly lacking support for encrpyted passwords and group importing.

[frtaz]

Thanks

[Ozidave]

I can't get eblah to install, if/when I do I will investigate.

There's a MOD you may have to apply to E-Blah, and that's to edit Setup.pl and change all the text that refers to Chmod 777 & 0777 to 755 & 0755 else it will hang on a server that doesn't allow 777...

Prior to install.... only CHMOD Setup.pl and Blah.pl to 755 and Settings.pl to 666 the rest is set by the Setup routine. Hence the need to change the chmod values.


Looking forward to you solving this problem, as I came here to ask the same question..  :\'(

[Ozidave]

Commited a bunch of fixes to cvs, still mainly lacking support for encrpyted passwords and group importing.

You may like to be aware of some changes that E-Blah made to cookie-handling.... and didn't tell anyone.

The E-Blah cookie prefix has changed, it used to be blahname and blahpass, it is now eblah_un and eblah_pw

[frtaz]

Yes,
They did change them (cookie prefix) I have changed them in the code I posted for everyone in the
E-Blah.inc.php 

[Nibbler]

Feedback welcome on current verision.

http://cvs.sourceforge.net/viewcvs.py/*checkout*/coppermine/devel/bridge/eblah.inc.php

[frtaz]

It still does not work.  When You are logged in on the forum you can not log on to CPG.   BUT If you are logged out of the forum and then goto CPG it tells you that you are logged in as Mr. X.   :-\\

also it will not redirect back to CGP after login. 

[Nibbler]

Well it obviously works fine for me, so please post more details, link, test account, etc.

[frtaz]

http://www.icducks.com/Photo/ 

test
test

[Ozidave]

Well it obviously works fine for me, so please post more details, link, test account, etc.

Hi Nibbler,

I'll set up a whole new fresh install again with the latest eblah.inc.php, and if I still can't get it to work... I'll PM you the Password / Address for both the FTP address and Forum Admin.. if that's Ok with you ??

This is driving everyone nuts...

[Ozidave]

Hi again,

To put everyone's mind at rest, the bridge works.

Big THANKS to Nibbler.

BUT! it has a bug in it...

I made so many changes that I will have to re-install eblah and Coppermine to determine if the bug is a genuine one or just an oversight.

So hang in there people........ it works!. It just needs a bit of tweaking.

[Ozidave]

I'm not sure if this was / is a bug, or just a quirk from mixing Perl, php and MySQL ?

Whatever name is used to install Coppermine is lost to any type of access once the install and bridging is complete. ??

It doesn't stop Coppermine from recognising the Board once the install is completed, and actually hands over the Coppermine Admin privileges to the Admin of the E-blah board.

Quirky.... The name one uses to install Coppermine with, becomes unavailable after the 'bridging' install.


Off-Topic:

And Brother!, am I having some trouble accessing this board to post this message. I may as well be on 2400bps, that's when I can manage to hold onto your server ??

[Nibbler]

That's normal. It is the same for all bridges.

[Ozidave]

That's normal. It is the same for all bridges.

Hi Nibbler,

Not quite right... Here's some bridging instructions for MyBB RC-4 that I wrote, and it contradicts the install for E-Blah ??


Quote:

And like Coppermine who repeat their instructions in RED to emphasise them.

YOU SHOULD USE YOUR MyBB ADMIN NAME AND PASSWORD WITH COPPERMINE ALSO! (Am I Serious..?? YES)

Continued:...............


Fill in User Name / Password / Email etc. (Good idea to use the same ADMIN NAME & PASSWORD as your MyBB otherwise you WILL run into problems once it's bridged)

E O Quote.

The Mod for MyBB here.... >>

http://www.mybboard.com/community/showthread.php?tid=2922

And that's why it became a problem with E-Blah.... because it was opposite of what I found with MyBB

Doesn't matter......... You've done a great job, it's merely a technicality (Problem between Keyboard and back of chair), and it's solved.

Thanks for your help.


PS: Could you change the header on this thread to include 'eblah', as it was by chance that I came across it when I came to ask the same question...

[Nibbler]

You don't have to use the same admin username and password for the forum as for Coppermine, if the MyBB bridge requires this then please submit a bug report.

[Ozidave]

Will do,

But there's a software upgrade happening for a new release of MyBB... Will wait until that's released and see if there are any problems. 

Thanks for your response, as it's made it clearer of what is and what is not required.