1
XXeR_
Migrating xoops to new server - database connection prob
  • 2007/8/1 16:19

  • XXeR_

  • Just popping in

  • Posts: 2

  • Since: 2007/8/1 1


Hello, I am trying to migrate my XOOPS installation from one server to another. I have successfully copied all files, including the DB. All necessary services are set up on the new system, and via the cmd line I can get into my MySQL DB with no issues. When I try to go to XOOPS via HTTP, I get:

~~
This page cannot be displayed due to an internal error.

You can provide the following information to the administrators of this site to help them solve the problem:

Error: Unable to connect to database
~~

My MySQL log doesn't even log a failure, so it seems like XOOPS isn't even trying to access the DB (at least, not on this host). I have modified what I thought were the necessary settings in mainfile.php to be correct for this new host, anyone have any ideas?

Thanks!

2
spacejoee
Re: Migrating xoops to new server - database connection prob
  • 2007/8/1 18:14

  • spacejoee

  • Not too shy to talk

  • Posts: 106

  • Since: 2004/7/25


Hi,
Make sure you replace the XOOPS path, MySQL user , password and host by the new servers infos in your config file. It should work.

Good luck

3
XXeR_
Re: Migrating xoops to new server - database connection prob
  • 2007/8/1 19:55

  • XXeR_

  • Just popping in

  • Posts: 2

  • Since: 2007/8/1 1


I finally got it working. I had several issues to work out, including:

- setting the proper socket filename in my.cnf
- doing an actual mysqldump and restore instead of just copying the files
- ensuring all the proper rights were granted within mysql

The bottom line is it wasn't seamless going from Debian to RH like I hoped it would have been, because:

1) the MySQL versions were SLIGHTLY different
2) Debian uses several different defaults than RH does with regards to MySQL (like socket location).

Anyways, thanks for the reply!

Login

Who's Online

192 user(s) are online (113 user(s) are browsing Support Forums)


Members: 0


Guests: 192


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits