coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: mahiraminc on August 22, 2004, 07:26:23 PM

Title: VB3 & CPG 1.3 integration problem with logging in.
Post by: mahiraminc on August 22, 2004, 07:26:23 PM
I'm having a problem integrating VB3 and CPG 1.3.

I have an existing account in Vb3 and I am trying to log into the CPG and CPG doesn't recognize the username/password?


My config files are as follows:

Links:
CPG: http://www.mahiram.com/photos/index.php
VB3: http://www.mahiram.com/gossip/index.php

init.inc.php
define('UDB_INTEGRATION', 'vbulletin30');

vbulletin30.inc.php

//NOTE : Your vBulletin license number is provided at the top of every php file in your vBulletin installation!
define('VB_CUST_NO', 'xxxxxxxx'); // Your vBulletin license number (NOT your customer number)
define('VB_DB_NAME', 'dbname'); // The name of the database used by the board
define('VB_BD_HOST', 'localhost'); // The name of the database server
define('VB_DB_USERNAME', 'username'); // The username to use to connect to the database
define('VB_DB_PASSWORD', 'password'); // The password to use to connect to the database

// The web path to your vBulletin Board directory
// In this example http://yoursite_name.com/vbulletin3/
define('VB_WEB_PATH', '/gossip/');
// ------------------------------------------------------------------------- //
// Nothing to edit below this line
// ------------------------------------------------------------------------- //
// Prefix and names for the database tables
define('VB_TABLE_PREFIX', ''); // Leave empty, not supported by vBulletin 2.3
define('VB_USER_TABLE', 'user'); // The members table
define('VB_SESSION_TABLE', 'session'); // The sessions table
define('VB_GROUP_TABLE', 'usergroup'); // The groups table
define('VB_COOKIE_PREFIX', 'vb301');  // Cookie Prefix, not supported by vBulletin 2


Test Account (member registered in vb3)
User: cpg
Pass: cpg
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: Joachim Müller on August 22, 2004, 11:55:33 PM
are the two apps installed on the same database? Please post your cookie name and cookie path of both apps.

GauGau
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: mahiraminc on August 23, 2004, 01:30:07 AM
Yes, both applications are running of the same database: vb3b

Cookie path of both apps: /

Cookie name of vb3: vb301
Cookie name of CPG: cpg132 (not sure about but I copied and pasted everything in the cookie so you can see for yourself)

cpg132_dataYToyOntzOjI6IklEIjtzOjMyOiI3NGQyOTNhYWU5MzUyYjY0MzVmMjE5MWMzMGJjZjhjOCI7czoyOiJhbSI7aToxO30%3D
mahiram.com/1024399248396829663267118372803229657233*vb301lastvisit1093210973mahiram.com/1536193143923229730658126803229657233*vb301userid1mahiram.com/1536200143923229730658135122803229657233*vb301password45d5177c8599c257280c6989efc1758mahiram.com/1536200143923229730658135138803229657233*
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: Joachim Müller on August 23, 2004, 07:53:12 AM
no need to post the text inside the cookie, looking the cookie name up in coppermine config usually helps ;-)
Did you actually edit the bridge file, so that it matches your site's settings, especially
Quotedefine('VB_CUST_NO', 'xxxxxxxx'); // Your vBulletin license number (NOT your customer number)
define('VB_DB_NAME', 'dbname'); // The name of the database used by the board
define('VB_BD_HOST', 'localhost'); // The name of the database server
define('VB_DB_USERNAME', 'username'); // The username to use to connect to the database
define('VB_DB_PASSWORD', 'password'); // The password to use to connect to the database
The code you posted is from an untouched bridge file from the package - you will have to edit the highlighted bits. Make sure to replace the password with asterisks when posting your bridge file settings here.

GauGau
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: mahiraminc on August 23, 2004, 08:09:44 AM
define('VB_CUST_NO', '00000000'); // Your vBulletin license number (NOT your customer number)
define('VB_DB_NAME', 'vb3b'); // The name of the database used by the board
define('VB_BD_HOST', 'localhost'); // The name of the database server
define('VB_DB_USERNAME', 'vb3b'); // The username to use to connect to the database
define('VB_DB_PASSWORD', '***'); // The password to use to connect to the database

// The web path to your vBulletin Board directory
// My website is http://www.mahiram.com/gossip/
define('VB_WEB_PATH', '/gossip/');
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: mahiraminc on August 27, 2004, 11:51:24 AM
Is anybody gonna help me with this?
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: Joachim Müller on August 27, 2004, 09:19:03 PM
I'm not sure if this matters - is your 'VB_CUST_NO' really '00000000'?

Joachim
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: ryan on August 31, 2004, 10:24:19 PM
I don't think he'd want to give out his customer number.  I'm having the same problem myself.
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: Joachim Müller on August 31, 2004, 11:30:37 PM
sure, no need to post the number here, just confirm that you actually entered the correct number.

Joachim
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: Nibbler on September 01, 2004, 03:13:20 AM
If someone can email/pm me an FTP login for a VB3/CPG bridged install I can take a look.
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: mahiraminc on September 13, 2004, 05:01:02 PM
Can somebody post a sample license number? I have so much garbage here and dunno which number is what? Otherwise, I can post my license number (the one I think it is) and will anybody confirm if it is one?

Thanks!
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: Nibbler on September 13, 2004, 05:15:47 PM
It's at the top of all the vb php files


/*======================================================================*\
|| #################################################################### ||
|| # vBulletin 3.0.3 - Licence Number 1111a01a
|| # ---------------------------------------------------------------- # ||
|| # Copyright (c)2000-2004 Jelsoft Enterprises Ltd. All Rights Reserved. ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||
|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||
|| #################################################################### ||
\*======================================================================*/
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: m0nty on September 22, 2004, 07:36:28 AM
i just installed this last night and integrated it into a vbulletin 3 board..

ran into the exact same problems as every1 else..

Here's the solution tho to fix it..


as before make sure the cookie domain is the same.. also make sure both paths are '/'

now to get it to login.. you need to edit file: vbulletin30.inc.php in your coppermine bridge folder

find:

define('VB_TABLE_PREFIX', '');

put the prefix of ur vbulletin board table in here..

ie.

define('VB_TABLE_PREFIX', 'vb3_');


find:

define('VB_COOKIE_PREFIX', '');

make sure this matches ur vbulletin cookie prefix..  the default is 'bb'

ie.

define('VB_COOKIE_PREFIX', 'bb');


now you should be able to login in both..


not sure y the member list goes to vbb admincp tho.. not figured it out yet..  but in the meantime, goto coppermine config section, and disable users viewin memberlist..

Allow logged in users to view memberlist:  Yes    (no)

Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: Fking on October 12, 2004, 04:52:29 PM
this solution does not work for me...
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: ipas on October 20, 2004, 02:31:58 PM
I think people who has problems with the integration between Coppermine and Vbulletin should ask themself the question... do I have a valid license or do I use the WDYL non-spy version of Vbulletin3 ;)

Otherwise I think most cookie related problems between Coppermine and Vb3 are license related.

I noticed because I ran this version before I actually bought the license, and updated the scripts never since.
Then again for those people ( like me ) who dont like build-in spy ware but do have a valid license ( or not ) check your actual license strings which are located in numerous files in the include directory.

for example

check out your actual license nummer in for exaple the file ./include/functions_login.php at at the top of at line 151

                        if ($_REQUEST['cookieuser'])M
                        {M
                                vbsetcookie('userid', $bbuserinfo['userid']);M
                                vbsetcookie('password', md5($bbuserinfo['password'] . '<your serial number>'));M
                        }M
                        else if ($_COOKIE[COOKIE_PREFIX . 'userid'] AND $_COOKIE[COOKIE_PREFIX . 'userid'] != $b
                        {M


Check out what is inbetween of the brackets < your serial number > and file this in in your license number in your vbulletin30.inc.php

Then again.. dont use this to avoid the actual license...  Vbulletin3 is one nice piece of software and deserves the be bought.
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: mahiraminc on October 29, 2004, 10:14:15 PM
It's working for me now. I wasn't using a licensed version of vBulletin.
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: rs25.com on November 29, 2004, 03:47:10 PM
I am also having the same problem.  I am using Coppermine 1.3.2 and vBulletin 3.03. 

I have tried the steps listed above and have not gotten any results.  In fact, when I change the cookie setting to "bb" I get a database error. 

Fatal error :
There was an error while processing a database query


Funny thing is that when I change it to "bb_" there is no error, but the integration does not work, either.

My settings:

define('VB_CUST_NO', '4090----'); // Your vBulletin license number (NOT your customer number)
define('VB_DB_NAME', 'rs25com_vbulletin'); // The name of the database used by the board
define('VB_BD_HOST', 'localhost'); // The name of the database server
define('VB_DB_USERNAME', 'rs25com'); // The username to use to connect to the database
define('VB_DB_PASSWORD', '--------'); // The password to use to connect to the database

// The web path to your vBulletin Board directory
// In this example http://yoursite_name.com/vbulletin3/
define('VB_WEB_PATH', '/forums/');
// ------------------------------------------------------------------------- //
// Nothing to edit below this line
// ------------------------------------------------------------------------- //
// Prefix and names for the database tables
define('VB_TABLE_PREFIX', 'vb3_'); // Leave empty, not supported by vBulletin 2.3
define('VB_USER_TABLE', 'user'); // The members table
define('VB_SESSION_TABLE', 'session'); // The sessions table
define('VB_GROUP_TABLE', 'usergroup'); // The groups table
define('VB_COOKIE_PREFIX', '');  // Cookie Prefix, not supported by vBulletin 2


Any ideas?  I have tried various settings, and even edited the "gamma" version of the .inc file (and now removed it.)

http://www.rs25.com/forums for vBulletin.
http://www.rs25.com/uploads for Coppermine.

Want to try it out?  Login with this vBulletin user:

username: copper
password: mine

Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: Nibbler on November 29, 2004, 04:04:45 PM
Enable debug mode, set cookie prefix to bb and post the error message.
Title: Re: VB3 & CPG 1.3 integration problem with logging in.
Post by: rs25.com on November 29, 2004, 04:11:54 PM
Aha, solved the problem!

Found this:

http://forum.coppermine-gallery.net/index.php?topic=10613.msg48137#msg48137

So I checked my vBulletin config.php (forums/includes/config.php) file.  I did *NOT* have the "vb3_" table prefix set on my board, so I removed that and then set the "bb" for the cookie and now it works.  I just had it backwards for my install.

This is probably because I upgraded from vBulletin 2.0 from a long time ago, so it was never set that way.  I bet the default vBulletin 3.0 setup has that prefix, but upgraded versions do not.  ;)