QSqlQuery::prepare: database not open

[RekTek249]

@mawh1960 I didn't know you had to set port... where to you know the port ? is 3306 the default one ?

[RekTek249]

@jsulm It works with phpmyadmin... It doesn't respond for like 30sec and then if I wait it sends the "database not open"message in the output

[SGaist]

Hi,

Are you running phpmyadmin on the same machine as the MySQL server ?

Are you running your application on the same machine as the server ?

If no to the second question, then did you correctly configure your MySQL server to accept external connections ? And also don't forget to secure them.

[RekTek249]

@SGaist I'm hosting the sql server on a website. It's a hosting website so I guess it's a linux server ? I'm running phpmyadmin on my windows 10 computer.

[SGaist]

Then check that you are correctly using the same user name, password as you are using in PHPMyAdmin.

[RekTek249]

@SGaist It is the correct one i checked that before asking it here...

[SGaist]

What exact error message do you get from your QSqlDatabase object ?

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