VB3 & CPG 1.3 integration problem with logging in.

[mahiraminc]

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

Code Select Expand

define('UDB_INTEGRATION', 'vbulletin30');

vbulletin30.inc.php

Code Select Expand


//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

[Joachim Müller]

are the two apps installed on the same database? Please post your cookie name and cookie path of both apps.

GauGau

[mahiraminc]

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)

Code Select Expand

cpg132_dataYToyOntzOjI6IklEIjtzOjMyOiI3NGQyOTNhYWU5MzUyYjY0MzVmMjE5MWMzMGJjZjhjOCI7czoyOiJhbSI7aToxO30%3D
mahiram.com/1024399248396829663267118372803229657233*vb301lastvisit1093210973mahiram.com/1536193143923229730658126803229657233*vb301userid1mahiram.com/1536200143923229730658135122803229657233*vb301password45d5177c8599c257280c6989efc1758mahiram.com/1536200143923229730658135138803229657233*

[Joachim Müller]

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

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 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

[mahiraminc]

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/');

[mahiraminc]

Is anybody gonna help me with this?

[Joachim Müller]

I'm not sure if this matters - is your 'VB_CUST_NO' really '00000000'?

Joachim

[ryan]

I don't think he'd want to give out his customer number.  I'm having the same problem myself.

[Joachim Müller]

sure, no need to post the number here, just confirm that you actually entered the correct number.

Joachim

[Nibbler]

If someone can email/pm me an FTP login for a VB3/CPG bridged install I can take a look.

[mahiraminc]

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!

[Nibbler]

It's at the top of all the vb php files

Code Select Expand


/*======================================================================*\
|| #################################################################### ||
|| # 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 # ||
|| #################################################################### ||
\*======================================================================*/


[m0nty]

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)

[Fking]

this solution does not work for me...

[ipas]

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

Code Select Expand

                        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.

[mahiraminc]

It's working for me now. I wasn't using a licensed version of vBulletin.

[rs25.com]

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:

Code Select Expand

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

[Nibbler]

Enable debug mode, set cookie prefix to bb and post the error message.

[rs25.com]

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.