coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: m5zal88 on March 18, 2005, 07:17:55 AM

Title: NEED HELP - phpbb integration
Post by: m5zal88 on March 18, 2005, 07:17:55 AM
I'm trying to intergrate coppermine with phpbb forum. what i done now is edit the phpbb.inc.php in the "bridge" folder... i dont know how to set up the file


// database configuration

define('PHPBB_DB_NAME', 'faizal_phpbb1'); // The name of the database used by the board

define('PHPBB_BD_HOST', 'localhost'); // The name of the database server

define('PHPBB_DB_USERNAME', 'faizal_phpbb1'); // The username to use to connect to the database

define('PHPBB_DB_PASSWORD', 'xxxxxxxx'); // The password to use to connect to the database



i think this is the db setting for my phpbb... i dont know the password coz i had installed phpbb using fantastico... can i create a new user for that database so i can use the username in the setting above? actually i already create one, and i try with the new username [which is under 'faizal_phpbb1' database] ... but it failed.... nothing happen, when i log into the forum, it didn't logged into coppermine photo gallery yet. and when i try to log in into coppermine photo gallery using the username that created at the phpbb forum, it also failed....any other setting should i modified?

and yeah, i already edit the below setting also.


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



I'm so screwed right now.... hopefully someone can help me  :-[
Title: Re: NEED HELP - phpbb integration
Post by: Tranz on March 18, 2005, 07:36:29 AM
You can get the phpbb db password from phpbb's config.php, I think.

Just to clarify, did the board and gallery work before bridging? Could you log into either?
Title: Re: NEED HELP - phpbb integration
Post by: m5zal88 on March 18, 2005, 07:41:47 AM
yes, i can log in into coppermine and phpbb. no problem with those. but when i log in into coppermine, i didn't log in into phpbb yet [vice versa] ..... coz they're using different db .... right?

to do bridging, do i just have to edit the "phpbb.inc.php" file?
Title: Re: NEED HELP - phpbb integration
Post by: Tranz on March 18, 2005, 07:46:14 AM
The integration instructions specifically state that they must be in the same db.

You can export the cpg tables and import them into the phpbb db.
Title: Re: NEED HELP - phpbb integration
Post by: m5zal88 on March 18, 2005, 07:54:34 AM
err... export coppermine pg tables into phpbb database? thats it? no renaming needeD? i wish i know how to export the tables.... i will try..
Title: Re: NEED HELP - phpbb integration
Post by: Tranz on March 18, 2005, 07:59:15 AM
As long as they use different prefixes for the tables, they can exist in the same db
Title: Re: NEED HELP - phpbb integration
Post by: m5zal88 on March 18, 2005, 08:10:26 AM
sorry to bother u again, but do i need to export all the tables?

i'm using phpMyAdmin to export.... but i dont know how to export!!! please help me!!!! *screwed*...

what i did is go to cpg database, tick all the tables available, and then click "export" button.... then another page will appear... i select all the tables, and click go.... then another page appears with lots of text in it...  something started with :

-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 18, 2005 at 03:07 PM
-- Server version: 4.0.24
-- PHP Version: 4.3.10
--
-- Database: `faizal_copp1`
--

-- --------------------------------------------------------

what should i do next? sorry for asking lots of questions but i really dont know how to do this.
Title: Re: NEED HELP - phpbb integration
Post by: jefvhal on March 18, 2005, 11:10:28 PM
Export all the tables to the Phpbb DB?
I have also a bridge between Phpbb and Coppermine but i'm using 2 differents databases and everything is working fine... In my eyes all you need to do is check 2 files: on your board "config.php" and on your gallery "bridge/phpbb.inc.php"

The next values have to be exactly the same:
On config.php "$dbhost = 'XXX'" and on phpbb.inc.php "define('PHPBB_BD_HOST', 'XXX')"
On config.php "$dbname = 'XXX'" and on phpbb.inc.php "define('PHPBB_DB_NAME', 'XXX')"
On config.php "$dbuser = XXX'" and on phpbb.inc.php "define('PHPBB_DB_USERNAME', 'XXX')"
On config.php "$dbpasswd = 'XXX'" and on phpbb.inc.php "define('PHPBB_DB_PASSWORD', 'XXX')"
If something is different most of all the "config.php" file is leading.