coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: Lady18wheels on November 27, 2005, 08:05:25 PM

Title: Database - "If you already have a database...."
Post by: Lady18wheels on November 27, 2005, 08:05:25 PM
If this has already been covered, I apologize.  I can't find it.  I'm confused about the database installation and configuration.

I have a phpBB test board - it's database is named ********_phpb3(I also have a phpb1 and phpb2)
The username for phpb3's database is ********_*****
The password for this username is *********

The readme file that came with the cpg1.4 download says:
QuoteYou need to create a MySQL database. Using your website Control Panel or a tool like phpMyAdmin, create a MySQL database. Write down the database name, the username and password – you'll need it to successfully install Coppermine. If you already have a database you're using for a BBS or something else, that'll work just as well. You can use that database for Coppermine, too. If you have a BBS and plan to connect it to Coppermine install, you'll need to share the database anyway.

After uploading all the files, and changing the permissions on the appropriate files, I tried to run cpg140/install.php using the phpBB database values for the "Your MySQL configuration".  It didn't work.  Should it have?

I appreciate your time. 

Title: Re: Database - "If you already have a database...."
Post by: Nibbler on November 27, 2005, 08:06:38 PM
What do you mean by "It didn't work" ?
Title: Re: Database - "If you already have a database...."
Post by: Tranz on November 27, 2005, 08:08:57 PM
It should have worked if you used the same mysql values, as long as the prefix is different. However, you would need to say what went wrong and any error messages you see.
Title: Re: Database - "If you already have a database...."
Post by: Lady18wheels on November 27, 2005, 08:10:33 PM
This is the error msg:
QuoteCould not create a mySQL connection, please check the SQL values entered
MySQL error was : Access denied for user: '********_***** @localhost' (Using password: YES)
Title: Re: Database - "If you already have a database...."
Post by: Lady18wheels on November 27, 2005, 08:50:22 PM
Quote from: TranzNDance on November 27, 2005, 08:08:57 PM
... as long as the prefix is different. ....
The prefixes for my phpBB tables are phpbb_
and I assumed that the "MySQL table prefix" default (which is cpg140_) on the cpg140/install.php meant that the installer would do whatever it does to create the table in the phpb3 database using the prefix cpg_140.  Is this, in fact, how it's supposed to work?

Maybe I should say that I also have a copp1 database - fantasico install of v1.3.4, but it isn't bridged.
Title: Re: Database - "If you already have a database...."
Post by: Lady18wheels on November 29, 2005, 08:26:39 AM
Since there were no other replies to this, I created a seperate database and will try to bridge later.
Title: Re: Database - "If you already have a database...."
Post by: Joachim Müller on November 29, 2005, 09:15:04 AM
coppermine doesn't create a database. Use the same database you use for your bbs. Keep the default prefix. Details: http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#install_screen_start
Title: Re: Database - "If you already have a database...."
Post by: Satyr on December 01, 2005, 10:02:07 AM
It's much better to install the tables in the same database as the forum where you want coppermine have beeing bridged.
Depending on serverconfiguration it is possible that you can only access the database via localhost.
That's why it's necessary that both programs have the same database/same mysqlserver.
Title: Re: Database - "If you already have a database...."
Post by: Lady18wheels on December 02, 2005, 08:08:24 AM
Thanks.

I was able to install on my test board this time - no error messages  :)  Not sure why I got
Could not create a MySQL connection, please check the SQL values entered
MySQL error was : Access denied for user: '********_***** @localhost' (Using password: YES)

on the first go 'round.  Maybe something just hadn't had time to update in MySQL?  I guess it doesn't matter now, because the coppermine tables are, in fact, in the same database as my test phpb3. :D 

In general, if the tables aren't installed in the same database as a phpbb, is a bridge even possible between two seperate databases?
I think this is what Satyr is saying?  I'm so new at all this ....