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

Username:
Password:

Lost Password? Register now!

Who's Online

67 user(s) are online (35 user(s) are browsing Support Forums)


Members: 0


Guests: 67


more...

Donat-O-Meter

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

Latest GitHub Commits