Changing Database from 'localhost' to a IP Address.

[Jump Network]

G'day Everyone,

I am moving a Zen Cart Shop from a Server where the database resides on the same server as the website, and the site is setup for localhost to access the database, to a datacentre, that uses a different server to handle database requests.

I have been given the IP of the Database Server, but need to know what I have to edit in Zen Cart to make the site access the Database via an IP rather than localhost?

Does any one know how to do this?

[DrByte]

You have 2 configure.php files:
/includes/configure.php
/admin/includes/configure.php

In both files you have a setting like this, which needs to be changed:

  define('DB_SERVER', 'localhost');

You may need to change the other DB_***** settings as well if your username/password/database-name are changing in the process.

[Jump Network]

Thanks for that.

Ok here is the issue so far.

My Old Server has the Database on the Same server, where as the new Host has the Database on a different Server.

To test this new Host, I need to test to make sure everything works on the new host before I change the Name Servers for the actual domain over. So I have registered a NEW Domain for this testing.

My Host uses cPanel, and I have added the new domain as a Parked domain so it will use the same files as normal.

The Domain where I am testing the Zen Cart on the New Server is www.jn1.com.au/shop

When you go here it says there is problems connecting to the database, below is what i edited in the php files

/includes/configure.php

((( This is where I changed for the Domain Name Change)))

define('HTTP_SERVER', 'http://jn1.com.au/shop');
define('HTTPS_SERVER', 'https://seure.jumpnetwork.com.au/~becs1/shop/');


(((Below is what I changed for the Local Host to IP Change)))

define('DB_SERVER', '192.168.2.7'); // eg, localhost - should not be empty

And in /admin/includes/configure.php

((( This is where I changed for the Domain Name Change)))

define('HTTP_SERVER', 'http://jn1.com.au/shop');
define('HTTPS_SERVER', 'https://secure.jumpnetwork.com.au/~becs1/shop');
define('HTTP_CATALOG_SERVER', 'https://jn1.com.au/shop');
define('HTTPS_CATALOG_SERVER', 'https://secure.jumpnetwork.com.au/~becs1/shop');

(((Below is what I changed for the Local Host to IP Change)))

define('DB_SERVER', '192.168.2.7'); // eg, localhost - should not be empty


I have checked the Database in cPanel and made sure the user is correctly setup.

Any help would be great.

Thanks

Chris.

[Jump Network]

OK Guys, with some stuffing around in MySQL, I added a new user, and set permissions for that user, and now everything works.

Thanks for you help guys.

[Jump Network]

Post Deleted. Sorry.

[Jump Network]

Sorry for all these posts. The post above this one, had an issue, but i thought I fixed it, so i edited the posts and put post deleted.

But the proplem still exists, and I can't edit that post any more

please go to

www.jn1.com.au/shop/index.php

At the top of the screen you will see;

[SCR]http://jn1.com.au/shop/includes/templates/template_default/images/icons/warning.gif[/SCR] Warning: I am able to write to the configuration file: /home/becs1/public_html/shop/includes/configure.php. This is a potential security risk - please set the right user permissions on this file (read-only, CHMOD 644 or 444 are typical).

Now I have changed the permissions to 644 and the message is still there, and then changed them to 444 and the message is still there.

I have also changed it for /admin/includes/configure.php

What could be wrong now?