problem bridging vBulletin 3.6.4 and 1.4.10

[Soliloquy]

I have the following issue when trying to bridge coppermine and vBulletin:
Unable to connect to UDB database!
MySQL says ...
The config file is in /includes, but when I try to enter that the bridging wizard says includesincludes/ is not valid.  I then tried using ../ and it was accepted.  When I enabled the bridge that's when I got the error message.  I then tried using phpMyAdmin to change it to ../includes/ and ../include but still no luck.

Coppermine install: http://www.clown-forum.com/clown_gallery/
Forum install: http://www.clown-forum.com/
Coppermine version: cpg1.4.10
Forum version: vBulletin 3.6.4
Test user account: test / pass

BridgeManager settings:
Forum URL:  http://www.clown-forum.com/
Relative path to your BBS's config file:  ../
Use post-based groups?:  0
Cookie name/preifx (if applicable)

[Joachim Müller]

Enable bridging if you want help.

[Soliloquy]

Ok... try again please.

[Nibbler]

Check your forum's includes/config.php for blank spaces at the start or end of your servername, password etc. I think vb3 trims them but Coppermine doesn't.

[Soliloquy]

No stray spaces in any of the variables.  Anything else it could be?  (What should I do about the path?)

[Nibbler]

../ is the correct path.

You can try to get more information about the problem with a code change, look in bridge/vbulletin30.inc.php, find

Code Select Expand


// Connect to db
$this->connect();


and before it, add

Code Select Expand


var_dump($this->db);


See if that gives you the data you are expecting. Reverse the change immediately though.

[Soliloquy]

Code Select Expand

array(5) { ["name"]=> NULL ["host"]=> string(9) "localhost" ["user"]=> NULL ["password"]=> NULL ["prefix"]=> NULL } Coppermine critical error:
Unable to connect to UDB database !

MySQL said:
I don't think it's reading the config file, though the path is correct (../).  I tried it with config.php's permissions at both 755 and 777, no change.

[Nibbler]

Hmm, I don't know why that is. Maybe the format of the file has changed in 3.6 or something. You can hardcode the db details into the bridge file for now, just remove the autodetection code here

Code Select Expand


if (isset($config['Database']['dbname']))
{
  // Running on vBulletin 3.5.x
    $this->db = array(
        'name' => $config['Database']['dbname'],
        'host' => $config['MasterServer']['servername'] ? $config['MasterServer']['servername'] : 'localhost',
        'user' => $config['MasterServer']['username'],
        'password' => $config['MasterServer']['password'],
        'prefix' => $config['Database']['tableprefix']
);
} else {
  // Running on vBulletin 3.0.x
    $this->db = array(
    'name' => $dbname,
    'host' => $servername ? $servername : 'localhost',
    'user' => $dbusername,
    'password' => $dbpassword,
    'prefix' =>$tableprefix
);
}


and type the details straight in

Code Select Expand


    $this->db = array(
    'name' => 'your database name here',
    'host' => 'localhost',
    'user' => 'db user name',
    'password' => 'db password',
    'prefix' => 'table prefix',
);


Similar thing for the cookie prefix further down.

[Soliloquy]

Still the same   Only the forum URL, path, and post-based groups variable are getting written to the database.  May I PM you my vbulletin30.inc.php file to make sure I didn't screw it up?

[Nibbler]

OK.

[Soliloquy]

Hard-coding the database information and cookie prefix solved the problem; Coppermine is successfully bridged.