Coppermine 1.3.3 and phpBB 2.0.16 Login Problem

[CopperBlue]

Hi,

I've trawled the message boards searching for an answer to my login problem and have yet to find a solution. When I try to log in to Coppermine I am taken to the phpBB login page. On inserting my details I am then redirected back to the Coppermine index page however I remain logged out.

If however I log into phpbb and then type in the address to the config page in Coppermine I am miraculously signed in and can do all the administrative duties. I haven't a clue what the problem is, both systems are fresh fantastico installs and I followed the directions in the Coppermine user manual to the letter. As far as I am aware I am using the same database and the cookie names are different.

Here are my files:

phpbb.inc.php

Code Select Expand

// database configuration
define('PHPBB_DB_NAME', 'pootsy_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', 'pootsy_phpb1'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', 'ylKd6BF8Hy5w'); // 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', '/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', TRUE);

init.inc.php

Code Select Expand

define('COPPERMINE_VERSION', '1.3.3');
// 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...');

cpg_redir.php

Code Select Expand

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

I put it into debug mode and got this after trying the login:

Code Select Expand

USER:
------------------
Array
(
    [ID] => 2631b5b8914b253e8a73606853b3d6de
    [am] => 1
    [liv] => Array
        (
            [0] => 1
            [1] => 5
            [2] => 6
            [3] => 7
        )

)

==========================
USER DATA:
------------------
Array
(
    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 0
    [ufc_max] => 0
    [ufc_min] => 0
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [has_admin_access] => 0
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 1
    [group_name] => Anonymous
    [upload_form_config] => 0
    [group_quota] => 0
    [can_see_all_albums] => 0
    [group_id] => 3
    [groups] => Array
        (
            [0] => 3
        )

)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content FROM cpg_filetypes;
    [1] => SELECT user_id, username as user_name, user_level FROM `pootsy_phpb1`.phpbb_users WHERE user_id='2' AND user_password='' AND user_active='1'
    [2] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg_usergroups WHERE group_id in (3)
    [3] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 3
    [4] => DELETE FROM cpg_banned WHERE expiry < '2005-08-09 12:17:11'
    [5] => SELECT * FROM cpg_banned WHERE ip_addr='62.254.32.22' OR ip_addr='81.99.18.33' OR user_id=0
    [6] => SELECT aid FROM cpg_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3)
    [7] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = ''  ORDER BY pos
    [8] => SELECT aid FROM cpg_albums as a WHERE category>=10000
    [9] => SELECT count(*) FROM cpg_pictures as p, cpg_albums as a WHERE p.aid = a.aid AND category >= 10000
    [10] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '1'  ORDER BY pos
    [11] => SELECT aid FROM cpg_albums as a WHERE category = '0'
    [12] => SELECT count(*) FROM cpg_albums as a WHERE 1
    [13] => SELECT count(*) FROM cpg_pictures as p LEFT JOIN cpg_albums as a ON a.aid=p.aid WHERE 1
    [14] => SELECT count(*) FROM cpg_comments as c LEFT JOIN cpg_pictures as p ON c.pid=p.pid LEFT JOIN cpg_albums as a ON a.aid=p.aid WHERE 1
    [15] => SELECT count(*) FROM cpg_categories WHERE 1
    [16] => SELECT sum(hits) FROM cpg_pictures as p LEFT JOIN cpg_albums as a ON p.aid=a.aid WHERE 1
    [17] => SELECT count(*) FROM cpg_albums as a WHERE category = '0'
    [18] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg_albums as a LEFT JOIN cpg_pictures as p ON a.thumb=p.pid WHERE category=0 ORDER BY a.pos LIMIT 0,1
    [19] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg_pictures WHERE aid IN (1) AND approved = 'YES' GROUP BY aid
    [20] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='7'
    [21] => SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES'
    [22] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, aid FROM cpg_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8
    [23] => SELECT COUNT(*) from cpg_pictures WHERE approved = 'YES'
    [24] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM cpg_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
Page generated in 0.05 seconds - 25 queries in 0.005 seconds - Album set :

Any help on the matter would be greatly appreciated.

Thanks

Philip

[Nibbler]

Please post a link to your gallery and provide a test user account.

[CopperBlue]

Man, that was a speedy reply!!

you can go right in and use my admin account theres nothing on the boards at the moment. I've done a little investigating, perhaps I do have two databases after all. How do I check that and if thats the case how would I have them operating from the same database?

Login details

http://www.saintsrfc.com/forum/
http://www.saintsrfc.com/gallery/

Code Select Expand

login: admin
pass: saints

thanks

[Nibbler]

The databases are no problem.

use this as your cpg_redir.php:

Code Select Expand

<?php
header("Location: http://www.saintsrfc.com/gallery/");
exit;
?>


[CopperBlue]

Thats so amazing!!! Thank you so much!! It works.

What exactly was the problem if you don't mind me asking. I'm thinking about getting more into the technical side of all this stuff.

Cheers

[Nibbler]

The code you had before was sending you to here - http://saintsrfc.apstamps.com/gallery/index.php under which the forum's cookie was not accessible.

[joejoe123]

I'm having the exact same problem, however, this solution is not working for me.  can someone help me out?

[Nibbler]

You've read the thread - Please post a link to your gallery and provide a test user account. Start a new thread for your issue.