I want to use QMYSQL

[gt.beta2]

Hi.

I tried a tipical:

bool MainWindow::connecToDB(){
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("http://localhost");
    db.setDatabaseName("name");
    db.setUserName("user");
    db.setPassword("password");
    if(!db.open()){
        QMessageBox msgBox;
        msgBox.setModal(true);
        msgBox.setText("Error ...");
        msgBox.exec();
        return false;
    }
    return true;
}

bool MainWindow::connecToDB(){
    QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
    db.setHostName("http://localhost");
    db.setDatabaseName("name");
    db.setUserName("user");
    db.setPassword("password");
    if(!db.open()){
        QMessageBox msgBox;
        msgBox.setModal(true);
        msgBox.setText("Error ...");
        msgBox.exec();
        return false;
    }
    return true;
}

To copy to clipboard, switch view to plain text mode 

I came to the error:

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE2 QPSQL7 QPSQL

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QSQLITE2 QPSQL7 QPSQL

To copy to clipboard, switch view to plain text mode 

I suppose this has something to do with the license restrictions for driver included in Qt?

I am using Debian/GNU LInux and i installed Qt with this Source Package: qt4-x11 (4.4.3-1).

How do i install the driver?

Thanks

[spirit]

you have to build mysql plugin or rebuild Qt with support of mysql.
read this for more info.

[gt.beta2]

Thanks for the info ... but now i realise my system is in a big mess!
I install something with apt, others with custom scrips (Qt Creator) and others by compiling the source code .... a big mess!
I will delete everything and install it all from source starting by this.
Wish me luck

[spirit]

it's not to hard. but good luck

[gt.beta2]

Hello!

Compiled Qt with:

./configure -qt-sql-mysql -dbus-linked -xshape
make
make install

./configure -qt-sql-mysql -dbus-linked -xshape
make
make install

To copy to clipboard, switch view to plain text mode 

Aparently it is working because i compiled some programs that i created before.

About the initial issue, the MySql connection ...

The initial example now gives me this message:

mainwindow.h:5:24: error: QSqlDatabase: No such file or directory

mainwindow.h:5:24: error: QSqlDatabase: No such file or directory

To copy to clipboard, switch view to plain text mode 

Whant include files will i need?

Thanks

[spirit]

did you add

CONFIG += sql

line in your pro-file?
did you include #include <QSqlDatabase> or #include <QtSql> in sources?
last include, includes all sql module into your sources.

[gt.beta2]

you were right about the

Quote:
CONFIG += sql

I had #include <QtSqlDatabse> an now changed to QtSql but get the same:

mainwindow.h:5:17: error: QtSql: No such file or directory

mainwindow.h:5:17: error: QtSql: No such file or directory

To copy to clipboard, switch view to plain text mode 

What am i missing here?!

[gt.beta2]

got it ...
QT += sql

[spirit]

oop, yes QT += sql, sorry for my mistake. just mistyped.

[gt.beta2]

And now for the final question ... i hope.

I installed a tipical LAMP for testing the connection:

apt-get install apache2 mysql-server php5 phpmyadmin

apt-get install apache2 mysql-server php5 phpmyadmin

To copy to clipboard, switch view to plain text mode 

When using http://localhost for the HostName i get:

Unknown MySQL server host 'http://localhost' (1) QMYSQL: Unable to connect

Unknown MySQL server host 'http://localhost' (1) QMYSQL: Unable to connect

To copy to clipboard, switch view to plain text mode 

Now what

[JhonJames]

MySQL is running??

$ sudo /etc/init.d/mysql start

[gt.beta2]

I can access to phpmyadmin ... so i supose yes.

[JhonJames]

Try with:

db.setHostName("localhost");

db.setHostName("localhost");

To copy to clipboard, switch view to plain text mode 

Without "http://".

[gt.beta2]

uff ... you were right

Thanks

[graciano]

Hello!
And if the database is in a server with ip 192.168.1.100?
I tried:

db.setHostName("192.168.1.100");

db.setHostName("192.168.1.100");

To copy to clipboard, switch view to plain text mode 

and it is not connecting.

Why is that? Must i give the port address or something?!

Thanks

[spirit]

try to set port. check you firewall.
can you connect to this address using Qt's example which is located in QTDIR/demos/sqlbrowser?