How to connect MAMP with QT under OS X 10.10 [SOLVED]

[Fer_Bo]

Hi everyone!.
I hope someone can help me, i'm a beginner; i installed MAMP and i try to connect a project in Qt with mySQL on my mac, when a i try to run a project i got this message: QSqlQuery::exec: database not open.

db.setHostName("localhost");
db.setPort(8889);
db.setDatabaseName("books");
db.setUserName("myUser");
db.setPassword("password");

I have checked the query and this right, but seems the connection never happens because the database is not open. Can be? that the name of the host is wrong?.

Thanks! and i'm sorry for mi bad English, i'm from Mexico!.

[SGaist]

Hi and welcome to devnet,

Did you call db.open ? If so is returning true ? If not, what's the error message ?

[Fer_Bo]

@SGaist Yes, i put the function open.db in a if statement, if this is true, then a do the query, but the query never happens, because the error i got is the following: QSqlQuery::exec: database not open.
The Query is also located in a if statement, for example:

QSqlQuery myQuery;

if (myQuery.exec("The SQL Query"))
{
Qdebug << "Success";
}
else
Qdebug << "Error";

Why the program sends me a message that the database is not open?

[SGaist]

Can you show your complete db setup code ?

[Fer_Bo]

@SGaist Yes, Here is:

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("localhost");
db.setPort(8889);
db.setDatabaseName("books");
db.setUserName("myUser");
db.setPassword("password");

if(db.open())
{

    QSqlQuery myQuery;

    if(myQuery.exec("SELECT AuthorID, LastName FROM Authors"))
    {
        while(myQuery.next())
        {
            qDebug() << myQuery.value(1).toString();
        }
    }
    else
    {
        qDebug() << "No se completó la consulta";
    }

    qDebug() << "Cerrando base de datos...";
    db.close();
}
else
{
    qDebug() << "Error = " << db.lastError().text();
}


return a.exec();

}

[SGaist]

Currently there's a nasty little bug that makes open return always true with the QMYSQL plugin.

See this bug and the related patch

[Fer_Bo]

@SGaist Thank you for you help!!!, i solved my problem, i just added one line of code.

db.setConnectOptions("UNIX_SOCKET=/Applications/MAMP/tmp/mysql/mysql.sock");

Now I can do my queries with my database.

Now, how can i mark this thread as SOLVED?, sorry i'm very new in this forum.

[SGaist]

You're welcome !

If you can't from the Topic Tools button, just edit the thread title and prepend [solved] and you're good

Happy coding !