problems moving 1.3.2 integrated with phpBB 2.0.6 problems moving 1.3.2 integrated with phpBB 2.0.6
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

problems moving 1.3.2 integrated with phpBB 2.0.6

Started by n2ueg, June 12, 2006, 06:34:56 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

n2ueg

I am moving to a new host. YAY!

I have backups of my phpbb 2.0.6 and cpg 1.3.2 data via
mysqldump -u oldhostadmin -p oldhost_com >oldhost_com.sql
mysqldump -u oldhostadmin-p oldhost_comphpbb >oldhost_comphpbb.sql
tar -cvzfp cpg.tgz cpg/
tar -cvzfp phpbb.tgz phpbb/

I ftp'd the .sql and .tgz to the new host.  When the old host was setup, phpbb was already running on it.  CPG was integrated to it.  phpbb uses oldhost_comphpbb as the db and cpg uses oldhost_com as the db name.  The user/pass info is the same for both.  The DB is running on localhost.

So the new host, 1and1, has a slightly different setup so I upload the .sql and .tgz files and do some of this...
>mysql -u db40 -p dbo40 -h 172.31.5.140< geneseorxe_comphpbb.sql
>mysql -u db54 -p dbo54 -h 172.31.5.194< geneseorxe_com.sql
tar -xvzf cpg.tgz
tar -xvzf phpbb.tgz
nano cpg/include/config.inc.php
nano phpbb/config.php
chmod 755 cpg/albums/

and update the db hostname, username, password, and dbname in both configs for the new databases.  Which now have two different usernames, passwords and hosts.  phpBB now works correctly but not CPG.  I assume that it needs to connect to the other DB but how do I get it to connect to the other DB using a different user/pass/server/dbname to get the phpbb info than I have for the cpg info?  At least that is what I think is wrong...

Nibbler

What error messages do you get ? The phpbb db info neds to be specified in the phpbb bridge file. You really should update your gallery once this is resolved.

n2ueg

oh...and now all that is done, this is the error:
Quote
Coppermine critical error:
Unable to connect to phpBB Board database !

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

n2ueg

updating phpbb and cpg is next...unless it is easier to put new phpbb and cpg on the server...bridge file...looking fer it now

n2ueg

looks like I was forgetting the bridge file.  YAY it is working!   I can move tonight!  Thank you so much for your help.  After banging my head I figured it was something easy I was missing.