WebSite X5Help Center

 
Martin P.
Martin P.
User

Database connection test  en

Autor: Martin P.
Visitado 2669, Followers 1, Compartido 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

Publicado en
4 RESPUESTAS - 1 ÚTIL - 1 CORRECTO
Andre E
Andre E
Moderator
Usuario del mes 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.

Leer más
Publicado en de 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.

Leer más
Publicado en de Dieter D.
Martin P.
Martin P.
User
Autor
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?

Leer más
Publicado en de Martin P.
Andre E
Andre E
Moderator
Usuario del mes 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)

Leer más
Publicado en de Andre E