Why 2 databases ?

[laubert]

Hi,

I want to use Coppermine bridged with phpBB and I can read in Coppermine's documentation

It 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.

[fm-2]

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

[Tranz]

@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.

[Nibbler]

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.

[laubert]

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...