WebSite X5Help Center

 
Martin P.
Martin P.
User

Database connection test  en

Autore: Martin P.
Visite 2668, Followers 1, Condiviso 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

Postato il
4 RISPOSTE - 1 UTILE - 1 CORRETTO
Andre E
Andre E
Moderator
Utente del mese EN

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.

Leggi di più
Postato il da Andre E
Dieter D.
Dieter D.
User

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.

Leggi di più
Postato il da Dieter D.
Martin P.
Martin P.
User
Autore
Andre E
no, not realy The database is always on your host server.

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:

  • Open an SSH connection to the MySQL server using the IP address (above)
  • Login using your username and password (above)
  • Once you have logged in, connect to your database using the command: use ishop;

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?

Leggi di più
Postato il da Martin P.
Andre E
Andre E
Moderator
Utente del mese EN

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)

Leggi di più
Postato il da Andre E