Easy DB question

[univac]

I cant seem to find the answer in the documentation so here goes. The last time I installed coppermine I beleive it used the same DB as phpbb, at least thats how I remember it working. If in fact id did before is this still true? I need a coppemine gallery on a website but the host only allows 1 DB and phpbb is already installed.

Thanks,

-Uni

[hyperion]

Yes, Coppermine can coexist with phpBB in the same database.

[Joachim Müller]

it's even recommended to have them in the same db (see documentation that comes with coppermine).

GauGau

[hyperion]

Should be:

// database configuration
define('PHPBB_DB_NAME', 'db93629582'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'db71.perfora.net'); // The name of the database server
define('PHPBB_DB_USERNAME', 'name_of_my_DB'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', 'my_passwrd'); // The password to use to connect to the database

// The web path to your phpBB directory
// In this example http://yoursite_name.com/phpBB2/
define('PHPBB_WEB_PATH', '/phpBB2/');

[univac]

Man I don't know how I missed that, Ty for the help.

I am getting 1 more error:

Notice: Undefined index: debug_mode in /homepages/7/d93380453/htdocs/coppermine/include/functions.inc.php on line 96
Fatal error :
There was an error while processing a database query

I think PHPBB2 may have gave it's own DB name, but the host doesnt allow PHPMyAdmin on the server so I cant actually see the DB. Because the actual DB resides on a different Server I cant SSH either to it. Do you know what I did wrong to cause the error or do I have a wrong DB name possibly?

[hyperion]

This error is usually the result of a misconfiguration.  Check your spelling and capitalization for each item.

Next, I would ask if you have actually installed Coppermine yet by running the install script? If you have simply edited the files, the database tables Coppermine needs have not been created yet. This could also generate the error.

You seem a little confused, so I will try to clarify the integration process.

You only have one database with your host. Within that database, each application owns different tables.  phpBB and Coppermine will have different tables within the same database.

The best way to go about integrating Coppermine and phpBB is to set both up independently of each other.  Then you verify that each one is working properly.  After that you bridge the two, which essentially tells Coppermine to phpBB's user information table instead of it's own.

Setting up independent installations before integration alllows you to verify that problems are arising from the bridge, not something else.

In this case, db93629582 is the name of your only database on the server known as db71.perfora.net. name_of_my_DB should be your username, and 'my_passwrd' is the password you were given to access the database. db93629582 contains all the tables that your phpBB install created.  When you put the Coppermine files on your server, you should have run the install.php program that would have created all the tables Coppermine needed.  At this point, you would have two independent programs operating from the same database.  

Now to integrate the two programs, you would define the constants as stated in the integration documentation.  This makes Coppermine stop using it's user table within the database.  Instead, it will use phpBB's user table.  It will allow people to log into your BB and then interact directly with Coppermine without having to log in again.

[univac]

No I am getting the error when trying to open the install script through the web browser.
I think at this point I will do a full reinstall and do as you recomend. I don't know why I am having such issues, I have installed this MOD three times before with no issues.

Thank you very much for your help.

[Joachim Müller]

I remeber that there has been an issue with debug_mode, but I can't remember the actual thread. Do you try to install the most recent stable version of coppermine (currently cpg1.2.1)? If not, you should definitely go for it, especially since you're setting up a fresh install. As hyperion has pointed out, you should set it up as standalone in the first place - if you have modified inlcude/init.inc.php already (uncommenting the bridge file stuff) you should undo this (if you're not sure, get a fresh copy of init.in.php from the coppermine package you downloaded).

GauGau

[univac]

Yes I do have that build and I did reinstall per the readme. I have CHMOD'd the correct directorys and the files in them. I now get this error when trying to use the start up script:

Fatal error: Failed opening required 'include/config.inc.php' (include_path='.:/usr/local/lib/php') in /homepages/7/d93380453/htdocs/coppermine/include/init.inc.php on line 135

Per the readme I have done nothing else except CHMOD.

[univac]

Ok I think I got it, I reinstalled a 3rd time and it appears to be function at the startup script. I will let you know guys, and by the way thank you much for the help!!!