Qt Remote Database connection
-
Hi,
To add to my fellow, did you also configure your remote database to accept connection from the outside ?
IIRC, accounts like root are only available for local connection.
-
@Tonny said in Qt Remote Database connection:
112.17.98.18
Is connectivity to remote server(112.17.98.18) exist ? Can you ping the 112.17.98.18 ? If yes, can you do 'telnet 112.17.98.18 111' from command to check it works. Can you check with some third party tools like DataBase Explorer to connect and query your remote DB ?
@dheerendra Sir when i type the command telnet it shows the error that 'telnet: Unable to connect to remote host: Connection refused'.I don't know what is the problem.Please help me sir
-
Are you able to do ping to remote server ping 112.17.98.18 ?
-
Are you able to do ping to remote server ping 112.17.98.18 ?
@dheerendra ping command is successfully run,But Telnet is not worked
-
112.17.98.18 is this in LAN ? Hope there is no firewall etc between your box and 112.17.98.18.
Since telnet is not able to connect to port 111 are you sure that SQL is running at the port 111 ? -
@Tonny said in Qt Remote Database connection:
But when i connecting the localhost it does not show any error
And does it connect then?
Did you try to connect using MySQL client? -
112.17.98.18 is this in LAN ? Hope there is no firewall etc between your box and 112.17.98.18.
Since telnet is not able to connect to port 111 are you sure that SQL is running at the port 111 ?@dheerendra
Sir SQL is not running in the port 111.Sql port is 3306 .. -
OK can you check telnet 112.17.98.18 3306 ? Does it work ? If it work, atleast DB is up at that port.
-
OK can you check telnet 112.17.98.18 3306 ? Does it work ? If it work, atleast DB is up at that port.
@dheerendra sir it shows telnet: Unable to connect to remote host: Connection refused
-
If you have access to the DB Server box, can you login to the system. In same system can you try to do telnet <IP> Port#. Just check the configuration of the remote sql server. Is it configured to listen for network connections also ?
-
@Tonny said in Qt Remote Database connection:
mysql client?Please give the procedure to connect it.
-
If you have access to the DB Server box, can you login to the system. In same system can you try to do telnet <IP> Port#. Just check the configuration of the remote sql server. Is it configured to listen for network connections also ?
-
What was the issue ? Please provide the details here. It helps others. You can move the issue to SOLVED state.
-
What was the issue ? Please provide the details here. It helps others. You can move the issue to SOLVED state.
@dheerendra bind address commented. it was 127.0.0.1 (/etc/mysql/mysql.cnf);
-
Your server was configured to listen only for local IP address. You tried to connect to server remotely. This was the issue.
-
@dheerendra Sir error solved.
Sir can you please tell me how to sent values through http protocol using qt creator in the REST API
please?Is there any solution for that sir@Tonny said in Qt Remote Database connection:
Sir can you please tell me how to sent values through http protocol using qt creator in the REST API
It's Qt not QtCreator. QtCreator is an IDE.
See https://doc.qt.io/qt-5.11/qtnetwork-programming.html -
Mysql or mariadb listen by default to the loopback address 127.0.0.1
you can change this values to the real local networkaddress in
/etc/mysql/ mysqld.cnfbind-address = 192.178.xx.xx
mysqlx-bind-address = 192.178.xx.xxrestart the sql.
that's it
