Yet another, Moving Servers problem, please help.

[eliasp]

Ok, here is what I've done. I'd like to get my forums up and running asap.

Server1 is where I'm currently on and will be cancelled tuesday so I've moved everything to Server2. Here is what I did.

I created a Full Site Backup using Cpanel. I uploaded it to Sever2 and had it restored. Everything is back up except for the forums.

Server1 is still runing our forums (www.anglernet.net/forums) until I can make sure I get the forums running on Server 2.

The error I'm getting is the

"There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience."

What could be causing this?
Do I need to install Vbulletin on the new server?

Any help is greatly appreciated. Thanks.

[Andy Huang]

cPanel tend to prefix database with usernames (IE: alfarin_VBDatabase, Alfarin_WebsiteDatabase), please double check that your database user information matches your vB's configuration file's (/include/config.php) settings. Then, go into admin CP to see if anything needs to be updated. Additionally, you may also wish to check the dbmaster email address set in your configuration file to see what VB is emailing you, it'll let you know more info about what's going wrong.

Cheers.

[eliasp]

Thank you. It's good to know I was on the right track. The new server uses plesk7 so I just found my database information. I'm checking to see if the database names, etc match what's in the config.php

[eliasp]

Still having trouble. This is the error I'm getting via e-mail. What seems to be the problem?

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0

[Andy Huang]

I think that means it cannot connect to the database server (or login incorrect); please double check that your MySQL database was included in the tarball as well as loaded into your new server's MySQL. After which, make sure you give it the correct permission (personally, I prefer full access) to the database and its associated tables. And finally, reflect config.php with the changes made by changing the username and password as well as the database and table prefix of the new server.

Cheers.

[eliasp]

Thanks Alfarin. The dumps were in the tarball because the datbases had to be created by tech support to do the dump. This is where I think something got screwed. Here is what I'm proposing and would it work:

1. I have deleted the databases restored from the full backup so there are no databases. (there was a phpchat database in the backup which is not needed)

2. Create a new database labeled exactly how it was on our old server including the usernames to access the database then do a dump. I do not have ssh so tech support offered to do it. I do have other means to do the dump via plesk7 control panel.

Am I missing anything?

Thanks again.

[eliasp]

I plan on staying up all night if I have to. If anyone can help, I'd appreciate it. Thank you. Getting up to work is not going to be fun tomorrow

[Andy Huang]

Sorry about the late reply, I accidentally dozed off (and its now 4AM here...)

The above method should work well as it'll give you the matching information; make sure your config file uses an IP adress (or a resolvable domain) for the MySQL location. If you used the old domain which is currently still active, your installation may be trying to login to the MySQL on your old server.

Other than that, if you've got everything set the way exactly as is on the server, and you are still experiencing the error, you may wish to get in touch with Jelsoft through the support ticket system and they may be able to further support you with this.

Cheers.
PS: hope you're getting a better night of sleep than me

[eliasp]

Thanks. Waiting for tech support to do the dump. I think the problem lies within the config settings. I've confirmed servername is 'localhost'

This is where something is amiss. I've changed the names and passwords for examples:

// ****** DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$dbusername = 'database_databa';
$dbpassword = 'ABCdefg';

My question is, does the username/password have to be the ones created under the database OR the ones used to access the server, control panel, etc? I swear I've tried everyone with no luck but today is a new day. Thanks.

[Steve Machol]

The $dbusername and $dbpassword are the database username and password. This is not necessarily the same as your server CPanel info.

[eliasp]

Thanks Steve. I'm really pulling my hairs out on this one because I know it's something very simple. Our forums have been down since yesterday in order to avoid any lost data. I have an sql dump and tech support is dumping it right now.

I've created a fresh database with database name, usernames/passwords just the way they were on the old server.

The backup was dowloaded and uploaded in ascii. Can someone confirm that is correct?