Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Moving DBMan from one server to another

Quote Reply
Moving DBMan from one server to another
I'm in the process of moving my site from one server to another with my current webhost. I moved the files about a month ago from a different host to this one, and had no problems getting DBManSQL to work. This time, however, there's a problem and neither my webhost nor I can track it down. When trying to access the script, I get an internal server error. I turned debugging on, but still don't get anything more helpful. perl -w and perl -c say there's no syntax errors. There's nothing in the error log. The scripts have been uploaded in ASCII format. Permissions have been set properly. Oh, another interesting twist....changing permissions on the db.cgi file causes it to return a "file not found" error. My host tells me they have DBI installed on the server. I have other DBMan databases running and they're working fine on the new server, but they are all flatfile versions. I have checked the data in the MySQL tables and it all appears to be there and okay.

Does anyone have any ideas what we can do next or what to check for to get this working? In the meantime, I've restricted access to the database on my current server so there wouldn't be any loss of data in the transfer, so time is of the essence in getting this up and running again.

Thanks!

Melanie
http://www.somemoorecats.com/ww/
http://www.okhima.org/
Quote Reply
Re: Moving DBMan from one server to another In reply to
Check your server error log. You might find something useful.

Check the path in cfg file:

# URL of the directory dbman resides in. No Trailing Slash Please.
$db_script_url = "http://www.yourdomain.com/cgi-bin/db/db.cgi";

and db.cgi:

# Use relative script paths.
$db_script_path = "/home/yours/www/cgi-bin/db";


Regards

__________________________
http://anteromas.com
Trading Resources
Quote Reply
Re: Moving DBMan from one server to another In reply to
Thanks. I checked my error logs and my host checked the server wide logs for my IP. There's absolutely nothing there. Right now the site doesn't resolve to my domain as we're still trying to get things set up before making the DNS changes....we tried changing the $db_script_url to the IP address of the new site with no success.

The relative script path is unchanged as this is with the same host and the servers are set up the same.

This has definitely got us beating our heads against the wall.

Melanie
http://www.somemoorecats.com/ww/
http://www.okhima.org/
Quote Reply
Re: Moving DBMan from one server to another In reply to
Just a followup, in case anyone wondered what the problem was... Smile I have a debug switch set in the config file that I can turn on or off...for some reason, the script ignored it and failed to print an error message. I commented out the if statement in db.cgi and got an error to print finally. Turns out it was a problem with the DBD module which my host fixed. Things are working now. Smile



Melanie
http://www.somemoorecats.com/ww/
http://www.okhima.org/
Quote Reply
Re: Moving DBMan from one server to another In reply to
Glad to hear that....

__________________________
http://anteromas.com
Trading Resources