Print

[dvlee]

I'm not sure, but I believe there is a redirect issue somewhere in my site.  I had CPG and PHPBB working perfectly together about a week ago, until a server crash lost everything.  I've re-installed both and they work just fine alone.  After 3 days of trying everything I can think of, I'm asking for help here. (Which is VERY much appreciated)

It's probably a very simple fix I'm just not seeing.

Web Site Name:  www.cartoongypsy.com
Cpg Path: www.cartoongypsy.com/gallery/
PHPBB Path: www.cartoongypsy.com/phpbb/

PHPBB Settings:
Cookie domain: cartoongypsy.com
Cookie name: phpbb2mysql
Cookie path: /

Test Account:
username: test_user
password: test

CPG Settings:
Gallery name: cartoongypsy.com
Name of the cookie used by the script: cpg11d
Path of the cookie used by the script: /

init.inc.php

// User database integration
// Uncomment the applicable line if you want to use it
define('UDB_INTEGRATION', 'phpbb');
// define('UDB_INTEGRATION', 'invisionboard');
// define('UDB_INTEGRATION', 'vbulletin');
// define('UDB_INTEGRATION', 'yabbse');

phpbb.inc.php

// database configuration
define('PHPBB_DB_NAME', 'cartoon_phpb1'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server
define('PHPBB_DB_USERNAME', 'cartoon_phpb1'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', '********'); // The password to use to connect to the database

// The web path to your phpBB directory
// In this example http://yoursite_name.com/phpBB2/
define('PHPBB_WEB_PATH', '/phpbb/');
// ------------------------------------------------------------------------- //
// You can keep the default values below if your instalation is standard
// ------------------------------------------------------------------------- //
// The prefix for the phpBB cookies
define('PHPBB_COOKIE_PREFIX', 'phpbb2mysql'); // The prefix used for board cookies

cpg_redir.php

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

Thank you very much,
Dave Lee

[Joachim Müller]

after logging in to phpbb and going to your coppermine page, I get

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

You probably have a typo in your mySQL settings in phpbb.inc.php - review them. If you can't find out what's wrong with it, temporarily disable integration (by re-inserting the // in init.inc.php), log in as admin to coppermine standalone (using the admin username and password you set up during install), go to coppermine config, enable debug_mode (at the very bottom of the screen) for everyone, re-enable integration (remove the // in initc.inc.php again), try to log in and go to coppermine then. Post the additional debug_info, especially what query failed.

GauGau

[dvlee]

Thanks for the help GauGau.  I've done all that you mentioned and got the following:

Fatal error :

There was an error while processing a database query.

While executing query "SELECT (ug.group_id + 5) as group_id FROM `cartoon_phpb1`.phpbb_user_group as ug LEFT JOIN `cartoon_phpb1`.phpbb_groups as g ON ug.group_id = g.group_id WHERE user_id = 2 AND user_pending = 0 AND group_single_user = 0" on 0

mySQL error: Access denied for user: 'cartoon_copp1@localhost' to database 'cartoon_phpb1'

[Joachim Müller]

well, you got "Access denied" for the mySQL user. Do you use different mySQL users for the bbs and coppermine?

GauGau