Database connection test 
Author: Martin P.
Visited 2667,
Followers 1,
Shared 0
I think I already know the answer, but only to be sure a short question.
For testing a database connection, is it absolutely required to bring
the website "live" up front e.g. upload the pages to the webserver before,
even if the mySQL database is located and online on a different server?
Thank in advance
Posted on the
no, not realy
The database is always on your host server.
You can querie it from your pc or from another pc that connects to your webstite, and your website connects to your database.
I hope this helps.
Unfortunately only few hosters allow DB connections from externally. Many will only allow "localhost" as the DB server address.
If your hoster allows external DB connection you can work with a development setup like XAMPP and still already connect to your live DB.
Author
I think that is not correct in my case. My hoster is networksolutions.com in the US and they bought another company with server cluster farms, called mysqlcluster21.registeredsite.com. Under my hosting packet are 50 databases, but I am happy, if I can get at least one working with X5 :-)
From the host panel everything is set up fine (see attachment). I can access the database from a webbroser via a SSH link like:
https://mysqlcluster21.registeredsite.com/sso/sso_auth.php?token=username_pwdtoken
From the instructions on how to use the database I got:
I assume that X5 is doing that in the same way?
I set up a complete shop on my development PC and would like to test it locally, befor I upload the pages to the server. If I hit the update button inside the shop product list or inside user management panel I got an database connection error. My question is now, is the error related due to the fact, that I have no real webserver working (only the preview mode or environment of X5) or is something wrong with the connection itselfs?
The update button works also offline because it only collects data from the database.
If you have an error then some items, dbname, server path, passwrd, are probably not setup (correct)