coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 (BBS) Integration / Bridging => Topic started by: laubert on June 26, 2005, 10:23:07 AM

Title: Why 2 databases ?
Post by: laubert on June 26, 2005, 10:23:07 AM
Hi,

I want to use Coppermine bridged with phpBB and I can read in Coppermine's documentation
QuoteIt is recommended that you use the same database for your board and Coppermine (in fact it is even mandatory!).

Is it actually mandatory to use only one database ?

I have tested on a local server with two distinct databases and it seems to work without problem...
Could there be any problems that I haven't seen ?

Thank you.
Title: Re: Why 2 databases ?
Post by: fm-2 on June 27, 2005, 04:21:46 AM
Hi,

I believe the reason for this is, because on a host you don't run under root, so you can't use dbname.dbtable like you can on localhost.

CPG needs to be able to access the session/user tables from phpBB in order to integrate into it... There is no security risk in putting them in one database.

Sincerely,
Christian
Title: Re: Why 2 databases ?
Post by: Tranz on June 27, 2005, 04:26:45 AM
@laubert, if you were able to do it, it would help others who want to do the same if you could please post how you did it.
Title: Re: Why 2 databases ?
Post by: Nibbler on June 27, 2005, 02:03:23 PM
The issue isn't actually the 2 databases, it's the 2 database connections usually required for 2 different databases. They are not handled properly in cpg 1.3.x (but now are in 1.4.x). If you have the forum and cpg in 2 different databases then it can work if you use the same db user for both databases (eg root + no pass). Stating they must share the same database just makes things easier.
Title: Re: Why 2 databases ?
Post by: laubert on July 10, 2005, 05:54:28 PM
Thank you all.

After a pause with my tests, I have now tried to my host.
I'm not root.

I use CPG 1.3.3 and PHPBB 2.0.16.

2 distinct databases.
2 distinct dbusers.

And ...
... it works.

It's now in test with a couple of friend users and we don't get problems...