[Solved]: Unable to connect to phpBB Board database! [Solved]: Unable to connect to phpBB Board database!
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

[Solved]: Unable to connect to phpBB Board database!

Started by iCoty, August 13, 2004, 11:00:25 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

iCoty

I am trying to integrate coppermine gallery and phpbb2. I have tested both out separately and they both work fine. However, when I try and perform the intregration I recieve the following error:

"Coppermine critical error:
Unable to connect to phpBB Board database !

MySQL said: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"

Both my phpbb and coppermine gallery are located on the same server and share the same mysql database.

My edited "init.inc.php" file:

define('COPPERMINE_VERSION', '1.3.1');
// User database integration
// Uncomment the applicable line if you want to use it
define('UDB_INTEGRATION', 'phpbb');
// define('UDB_INTEGRATION', 'invisionboard');
// define('UDB_INTEGRATION', 'vbulletin23');
// define('UDB_INTEGRATION', 'vbulletin30');
// define('UDB_INTEGRATION', 'yabbse');
// define('UDB_INTEGRATION', 'smf');
// define('UDB_INTEGRATION', 'woltlab21');

My edited "phpbb.inc.php" file:

// database configuration
define('PHPBB_DB_NAME', 'phpBB'); // mydatabase
define('PHPBB_BD_HOST', 'localhost'); // mysql06.powweb.com
define('PHPBB_DB_USERNAME', 'root'); // ***
define('PHPBB_DB_PASSWORD', ''); // ***

// http://virtualaftershock.com/forum/
// If your URL to your board is for example 'http://yoursite_name.com/phpBB2/',
// you'll have to set the below var to '/phpBB2/'.
define('PHPBB_WEB_PATH', '/forum/');
// Logout Flag
// the value of this boolean constant depends on your phpBB version:
// If your version of phpBB is 2.0.4 or lower - change the value to FALSE;
// if your version of phpBB is 2.0.5 or newer - leave it as TRUE
define('PHPBB_LOGOUT_GET', FALSE);

Nibbler

// database configuration
define('PHPBB_DB_NAME', 'database_name_goes_in_here'); // this is just a comment - it does nothing
define('PHPBB_BD_HOST', 'mysql_server_name_goes_in_here'); // this is just a comment - it does nothing
define('PHPBB_DB_USERNAME', 'your_username'); // this is just a comment - it does nothing
define('PHPBB_DB_PASSWORD', 'your_password'); // this is just a comment - it does nothing


You be changing the wrong bits ;)

iCoty

Thanks for the quick reply! Okay, I can once again see my gallery okay...but I have encountered a new problem! When i try to logout from the gallery i get this response:

"Could not open the page "http://www.virtualaftershock.comvirtualaftershock.com/gallery/" because the server "www.virtualaftershock.comvirtualaftershock.com" could not be found."

I'm assuming that i once again screwed up the code since my url appears twice, but can't figure out where.

I think it has soemthing to do with the "cpg_redir.php" file:

<?php
if (!$_SERVER['HTTP_HOST']) {
  $cpg_host=$HTTP_SERVER_VARS['HTTP_HOST'];
} else {
  $cpg_host=$_SERVER['HTTP_HOST'];
}
$cpg_path='virtualaftershock.com/gallery/';
header("Location: http://".$cpg_host.$cpg_path);
exit;
?>

Nibbler


iCoty

Yup, I just figured that out! Sorry...I'm a newbie at this!

Thanks again!

iCoty

So, by simply clicking "groups" under the admin control in the coppermine gallery, all users on my forum will be synchronized with the gallery? Do I need to do this everytime there is a new user?

Nibbler

That synchronizes the user groups, and you only need to do it if you change the groups you have defined in phpbb.