coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: Colliope on February 05, 2005, 02:22:47 AM

Title: install - mySQL - 1 & 1
Post by: Colliope on February 05, 2005, 02:22:47 AM
I am kind of afraid to ask this after reading this thread

http://forum.coppermine-gallery.net/index.php?topic=13353.0

but I'm going to ask anyway.

I have a free trial account at 1 & 1 and  installed phpBB2 and had no troubles. Everything is going well and I'm having a ball customizing my own style. Now I am ready to set-up Coppermine, but am stuck on the install page re the mySQL info. (You can see a screenshot of the page in the first post of the thread at the above URL.)

I can't for the life of me rememeber how I got by this when installing the phpBB board, and I did call 1 & 1, but their recording says phone support is not offered for the trial accounts.   >:(  The trial account is my way of testing whether I can successfully run both phpBB and Coppermine before becoming a paying customer, so I find that really annoying. If they offered support for trial customers, more of them would probably become paying customers! Ugh.

Anyway, if anyone is familiar with 1 & 1 and could help me out, I would really appreciate it.

col

Title: Re: install - mySQL - 1 & 1
Post by: Colliope on February 05, 2005, 02:31:32 AM
I wanted to add - I was thinking that maybe the info I need is stored somewhere in one of my phpBB files, but don't know where to look for it, although i have been trying.

Col
Title: Re: almost got it - file question
Post by: Colliope on February 05, 2005, 02:43:00 AM
In the config.php file for phpBB2, I found this info
("x" substituted for actual characters):

dbhost: xxxx.net
dbname: xxxxxxxx
dbuser: xxxxxxxx
dbpassword: xxxxxxxx
table prefix: phpbb_

Can I use that same info (with differnt table prefix) for the Coppermine install or will that overwrite my phpBB2 data?

Thanks,

Col
Title: Re: install - mySQL - 1 & 1
Post by: kegobeer on February 05, 2005, 02:45:51 AM
Yes, you can use the same database information.  Coppermine uses a different table prefix (cpg132_), so you won't overwrite any tables.
Title: Re: install - mySQL - 1 & 1
Post by: Colliope on February 05, 2005, 03:19:23 AM
Bless you, Kegobeer, for your quick reply! Going to use that same info then and keep my fingers crossed.

Col
Title: Re: didn't work
Post by: Colliope on February 05, 2005, 03:38:16 AM
dbhost: xxxx.net
dbname: xxxxxxxx
dbuser: xxxxxxxx

As shown in my phpBB2 config file, all those start with "db".

If I enter the info with the db at the beginning as shown for name and user, and use the default "localhost", I get this error message:

MySQL error was : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

If I enter the info with the db at the begining and use the specified hostname, I get this error message:

MySQL error was : Unknown MySQL Server Host 'dbxxxxxx.net' (1)  

So then I tried going back to "locahost" and not including the "db" at the beginning of name & password, and get this error message again:

MySQL error was : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Is there another combination I am missing to try?

Col





Title: Re: Got it!
Post by: Colliope on February 05, 2005, 03:52:56 AM
 :)


I  used the db before the name & user, and used the specific host name rather than the the default "localhost" and it worked. Don't know why it didn't work the first few times i tried that combo, but oh well, I'm there now.

Col