QSqlQuery::prepare: database not open

SGaist

Did you check that the user you are using to connect to the database can be used for remote connections ?

RekTek249

@SGaist It can.... What is the "2003" and 10060 meaning ? is 2003 the port ?

RekTek249

I tried it on another server and it gives the following error..

QSqlError("2005", "QMYSQL: Unable to connect", "Unknown MySQL server host 'mysql.hostinger.fr' (0)")
QSqlQuery::prepare: database not open

the_

@RekTek249
Again: are you sure you are allowed to establish a remote connection to the database?

check user permission
check if port is correct
check if port is reachable from remote

Taz742

@RekTek249 said in QSqlQuery::prepare: database not open:

It can.... What is the "2003" and 10060 meaning ? is 2003 the port ?

2003 is not a port name, so let's say the title of the problem.

the_

@Taz742
It's not a "title", just an qt internal error number. Same with the other code that is a mysql internal error code

SGaist

To add to @the_ : the error state that mysql.hostinger.fr is an unknown host. Looks like you are giving the wrong address.

RekTek249

@SGaist When I go to the "remote mysql" part of the site, it gives an access host... do i gotta use this as the hostname ?

RekTek249

@RekTek249 If that's what i do, it gives that error:

QSqlError("1045", "QMYSQL: Unable to connect", "Access denied for user 'rektek_write'@'*ip here*.' (using password: YES)")

If it's a permission problem, what do I need to do ? I have the insert one because that's the only thing I need to do...

SGaist

Is this user authorised to access the database from outside that machine ?

RekTek249

@SGaist Well it's a website host.... They wouldn't allow you to create hosts that can only connect on that machine i guess.

SGaist

That I don't know, you should ask them.

RekTek249

@SGaist Alright... I checked something and apparently for remote you need the user's ip. The control panel needs the ip so I guess I can't make this application public because they wont be able to access the database ?

SGaist

Then implement a REST service to expose what you need for your application.

What exactly are you trying to implement ? Because currently it seems you are trying to do server-side stuff from your application.

RekTek249

@SGaist I just need to store (INSERT) things in a database... And what is a REST ?

the_

@RekTek249
See https://www.tutorialspoint.com/restful/

jsulm

@RekTek249 Yes, you should implement a REST interface - exposing a SQL database to the public internet isn't a good idea.

SGaist

To add to @the_, the tutorial explains thing nicely but there are more lightweight options than a full Java + eclipse + tomcat setup to get started.

Python wise there's the Django REST framework or Flask RESTful

PHP wise there's PHP Slim

There are also other options but you'd have to first share what you have available on your server.