Three days searching, still nothing.

[Stan]

Hey all, I am new to this board and to coppermine and phpbb. I have spent the last three days searching this board and the last week searching the phpbb boards. My problem is this, on a clean install of cpg, through my webservers cpanel, fantistico, everything works find. When I try to bridge them, I get in all kinds of trouble. The one I am heaving now is that when I click on the Login part in Coppermine, I get redirected to my main forum page. When I log in there and go back to the forum, I am still not logged in there. I don't have the gallery open for posting yet, I am trying to get the bugs worked out first, I will post the codes I edited so you all can tell me what I have done wrong.

phpbb.inc.php
// database configuration
define('PHPBB_DB_NAME', 'atvansc_newforum'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server
define('PHPBB_DB_USERNAME', 'xxxxxx'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', 'xxxxxx'); // The password to use to connect to the database

// The web path to your phpBB directory
// 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', '/newforum/');

init.inc.php
define('COPPERMINE_VERSION', '1.3.2');
// 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');
// define('UDB_INTEGRATION', 'punbb');

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

If you require any further info, please remember that I am new, I will try my best to get the info for you.

Thanksfor the help,
Stan

[Powerbob]

Hi there, have you had both installed and working on there own before you did the bridging?


Powerbob

[Stan]

Yes, both were working fine. The reason for the bridging is because of the password encryption. I manage a web page of a provincial association and the passwords have to be protected. The former webmaster from the page pointed out the plain text passwords in the db tome,so that is why the changes.

[Nibbler]

I can't see anything wrong with what you have posted, so it probably a problem with your cookie settings. Post a test account and link to your gallery if possible.

[Stan]

Thats the problem, I can't get in to set up any accounts. The main page will display, but as soon as I click on the Login, it takes me right back to the main forum page.

[Nibbler]

A test account would be created in your forum, which you say is working fine.

[Stan]

OK, I can now go to the gallery and click on the login button and be able to log in without being redirected to the main forum page. So now, I want to know why the gallery is not logging me in automatically? When I create an account in the gallery, I can still see the passwords in the database.

The forum is http://www.atvans.com, the gallery in not on line yet, but the url is just http://www.atvans.com/gallery. The username for both is test, password test2. Should I have a link on the page so you can try the link to see what is happening or not?

Thanks for your help.

Stan

[Stan]

Something else I found out, when I go from

define('COPPERMINE_VERSION', '1.3.2');
// 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');
// define('UDB_INTEGRATION', 'punbb');
if (!defined('IN_COPPERMINE')) die('Not in Coppermine...');
// Start output buffering
ob_start();

to this

define('COPPERMINE_VERSION', '1.3.2');
// 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');
// define('UDB_INTEGRATION', 'punbb');
if (!defined('IN_COPPERMINE')) die('Not in Coppermine...');
// Start output buffering
ob_start();

I lost the gallery and get this error

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

MySQL said: Access denied for user: 'test@localhost' (Using password: YES)

Why?

[Nibbler]

Lets review.

When you bridge coppermine to a forum, you click login in coppermine, are redirected to the board, you login to the board, you return to coppermine, and you are recognised by coppermine. If you register an account you do so on the forum. The coppermine users table is no longer used, and the forum takes over user management.

Currently your gallery is not working so i cannot test anything. Make sure you have the correct data in the bridge file.

[Stan]

Sorry, the gallery is working now.When I log in as test, i stay in the gallery, it does not send me to the forum.

[Nibbler]

Uncomment your

Code Select Expand

define('UDB_INTEGRATION', 'phpbb'); line in init.inc.php as stated in the docs.

[Stan]

Read my post up above, ^^^^^. When I do that, i lose the gallery. Can you tell me what the error message means, like I dais,I am new to this. And thanks for all the help.

[Nibbler]

Make sure you have the correct data in the bridge file.

It should be the same info you use for the forum.

[Stan]

Is there anything in here that needs to be changed?

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

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

// Prefix and names for the database tables
define('PHPBB_TABLE_PREFIX', 'phpbb_'); // The prefix used for the DB tables
define('PHPBB_USER_TABLE', 'users'); // The members table
define('PHPBB_SESSION_TABLE', 'sessions'); // The session table
define('PHPBB_GROUP_TABLE', 'groups'); // The groups table
define('PHPBB_UGROUP_TABLE', 'user_group'); // The group/user table

[Nibbler]

The username and/or password and/or db name are wrong. We can't tell you what they are supposed to be, you need to find that out yourself.

[Stan]

Ok, now I am starting to get frustrated. Not with you guys, you guys are great. I just can't seem to figure this sh&$ out. Here are some stupid questions, should the database be the same name as the one the forum uses, because that is what I am using. As fro the name and password, which name and password, the one I used when I installed cpg, or a different one?

Again, thanks for your patients in helping me.

Stan

[Nibbler]

Needs to be exactly the same as you entered when you installed your forum. There should be some config file in your forum's folder that holds the info.

[Nibbler]

If you are happy to PM me an FTP or cpanel login for your site I can take a look for you.

[Stan]

there in lies another problem, i didn't install the forum. it was given to me to look after after the last webmaster left. would it be the user name and password to log into the forum as the admin, or to log into the control panel to admin the database. Sorry for all the stupid questions.

[Stan]

are you on MSN now?