QSqlQuery::prepare: database not open

[Taz742]

@RekTek249

    QSqlQuery query(db);
    query.prepare("INSERT INTO person (Username, Password, summ, Email) "  
                      "VALUES (:user, :pass, :summ, :mail)");
    query.bindValue(":user", Username);          // I do have variables set earlier
    query.bindValue(":pass", Password);
    query.bindValue(":summ", summ);
    query.bindValue(":mail", Email);
    query.exec();

The mistake is not giving you anything error?

please #include "QSqlError" and

 if (db.open())                                             
    {                                                                        
        QMessageBox msgBox;                         
        msgBox.setText("DB OPENED");          
        msgBox.exec();

    }
else{
       qDebug() << db.lastError()
 }

By doing so we can understand what the problem is about anyway...

[RekTek249]

@Taz742 QSqlError("2003", "QMYSQL: Unable to connect", "Can't connect to MySQL server on 'adress.here' (10060)")
Is the error...

[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.