QMYSQL Driver (undefined symbol: mysql_server_init)

[miroslavgojic]

yes, I was install Qt from synaptic install manager

I install all package but mysql.pro is not present

and I have qt4 and qt3, can this make problems

[saa7_go]

I install all package but mysql.pro is not present.
and I have qt4 and qt3, can this make problems.

I'm not sure. But, have you search Qt4 MySQL plugin using synaptic?

[miroslavgojic]

I have look in synaptic and I have Qt mysql driver, it is installed at my Ubuntu

Qt4 Mysql database driver - this is name of synaptic package

[saa7_go]

So, you don't need to rebuilt Qt MySQL driver. Try to create simple application using MySQL driver.

[miroslavgojic]

I try to create simply application Qt and Mysql
and there I find some unexpected problems.

I make one project on C not C++, and it work, but this is not from QT, simply C code from gedit and gcc

I have one project in QT

one file is

connector.h

#ifndef CONNECTOR_H
#define CONNECTOR_H
#include <QSqlDatabase>
#include <QMessageBox>
 
bool createConnection()
{
    if (QSqlDatabase::isDriverAvailable("QMYSQL"))
    {
         QSqlDatabase db = QSqlDatabase.addDatabase("QMYSQL");
        db.setHostName("localhost");
        db.setDatabaseName("test");
        db.setUserName("user");
        db.setPassword("pass");
 
            if (!db.open())
            {
                QMessageBox m;
                m.setText("Greska I");
                m.exec();
                return false;
            }
        else
            {
                return true;
            }
    }
    else
    {
        QMessageBox m;
        m.setText("Nema drajver za DB");
        m.exec();
        return false;
    }
 
}
 
#endif // CONNECTOR_H

#ifndef CONNECTOR_H
#define CONNECTOR_H
#include <QSqlDatabase>
#include <QMessageBox>

bool createConnection()
{
    if (QSqlDatabase::isDriverAvailable("QMYSQL"))
    {
         QSqlDatabase db = QSqlDatabase.addDatabase("QMYSQL");
        db.setHostName("localhost");
        db.setDatabaseName("test");
        db.setUserName("user");
        db.setPassword("pass");

            if (!db.open())
            {
                QMessageBox m;
                m.setText("Greska I");
                m.exec();
                return false;
            }
        else
            {
                return true;
            }
    }
    else
    {
        QMessageBox m;
        m.setText("Nema drajver za DB");
        m.exec();
        return false;
    }

}

#endif // CONNECTOR_H

To copy to clipboard, switch view to plain text mode 

and main.cpp

#include <QtGui/QApplication>
#include "mainwindow.h"
#include "connector.h"
 
int main(int argc, char *argv[])
{
    QApplication a(argc, argv);
 
    if(!createConnection())
        return 1;
 
    MainWindow w;
    w.show();
    return a.exec();
}

#include <QtGui/QApplication>
#include "mainwindow.h"
#include "connector.h"

int main(int argc, char *argv[])
{
    QApplication a(argc, argv);

    if(!createConnection())
        return 1;

    MainWindow w;
    w.show();
    return a.exec();
}

To copy to clipboard, switch view to plain text mode 

and this project not work at QT

[saa7_go]

Are there any error/warning messages from your application?

[miroslavgojic]

I have this errors:

/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:3: error: QSqlDatabase: No such file or directory
/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:9: error: ‘QSqlDatabase’ has not been declared
/home/miroslav/dekis/Dekis/connector.h:11: error: ‘QSqlDatabase’ was not declared in this scope
/home/miroslav/dekis/Dekis/connector.h:11: error: expected ‘;’ before ‘db’
/home/miroslav/dekis/Dekis/connector.h:12: error: ‘db’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’
/home/miroslav/dekis/Dekis/main.cpp:13: error: ‘w’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: ‘MainWindow’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’

/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:3: error: QSqlDatabase: No such file or directory
/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:9: error: ‘QSqlDatabase’ has not been declared
/home/miroslav/dekis/Dekis/connector.h:11: error: ‘QSqlDatabase’ was not declared in this scope
/home/miroslav/dekis/Dekis/connector.h:11: error: expected ‘;’ before ‘db’
/home/miroslav/dekis/Dekis/connector.h:12: error: ‘db’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’
/home/miroslav/dekis/Dekis/main.cpp:13: error: ‘w’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: ‘MainWindow’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’

To copy to clipboard, switch view to plain text mode 

[saa7_go]

Can you post/attach your mainwindow.h and project file (*.pro)?

It looks like you don't add sql module in your project file.

[miroslavgojic]

mainwindow.h

/****************************************************************************
** Form interface generated from reading ui file 'mainwindow.ui'
**
** Created: Sat Jul 24 19:27:05 2010
**
** WARNING! All changes made in this file will be lost!
****************************************************************************/

/****************************************************************************
** Form interface generated from reading ui file 'mainwindow.ui'
**
** Created: Sat Jul 24 19:27:05 2010
**
** WARNING! All changes made in this file will be lost!
****************************************************************************/

To copy to clipboard, switch view to plain text mode 

Dekis.pro

######################################################################
# Automatically generated by qmake (2.01a) Tue Jul 20 19:42:45 2010
######################################################################
 
TEMPLATE = app
TARGET = 
DEPENDPATH += .
INCLUDEPATH += .
 
# Input
HEADERS += connector.h mainwindow.h
FORMS += mainwindow.ui
SOURCES += main.cpp mainwindow.cpp

######################################################################
# Automatically generated by qmake (2.01a) Tue Jul 20 19:42:45 2010
######################################################################

TEMPLATE = app
TARGET = 
DEPENDPATH += .
INCLUDEPATH += .

# Input
HEADERS += connector.h mainwindow.h
FORMS += mainwindow.ui
SOURCES += main.cpp mainwindow.cpp

To copy to clipboard, switch view to plain text mode 

[saa7_go]

mainwindow.h

/****************************************************************************
** Form interface generated from reading ui file 'mainwindow.ui'
**
** Created: Sat Jul 24 19:27:05 2010
**
** WARNING! All changes made in this file will be lost!
****************************************************************************/

/****************************************************************************
** Form interface generated from reading ui file 'mainwindow.ui'
**
** Created: Sat Jul 24 19:27:05 2010
**
** WARNING! All changes made in this file will be lost!
****************************************************************************/

To copy to clipboard, switch view to plain text mode 

Where is your MainWindow class declaration?

Dekis.pro

######################################################################
# Automatically generated by qmake (2.01a) Tue Jul 20 19:42:45 2010
######################################################################
 
TEMPLATE = app
TARGET = 
DEPENDPATH += .
INCLUDEPATH += .
 
# Input
HEADERS += connector.h mainwindow.h
FORMS += mainwindow.ui
SOURCES += main.cpp mainwindow.cpp

######################################################################
# Automatically generated by qmake (2.01a) Tue Jul 20 19:42:45 2010
######################################################################

TEMPLATE = app
TARGET = 
DEPENDPATH += .
INCLUDEPATH += .

# Input
HEADERS += connector.h mainwindow.h
FORMS += mainwindow.ui
SOURCES += main.cpp mainwindow.cpp

To copy to clipboard, switch view to plain text mode 

Add the the following line in Dekis.pro

QT += sql

QT += sql

To copy to clipboard, switch view to plain text mode 

[miroslavgojic]

I was not make changes in MainWindow class declaration.

[miroslavgojic]

after I add

QT += sql

QT += sql

To copy to clipboard, switch view to plain text mode 

to Dekis.pro

I have next errors (it is less then before)

/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:11: error: expected primary-expression before ‘.’ token
/home/miroslav/dekis/Dekis/main.cpp:12: error: ‘MainWindow’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’
/home/miroslav/dekis/Dekis/main.cpp:13: error: ‘w’ was not declared in this scope

/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:11: error: expected primary-expression before ‘.’ token
/home/miroslav/dekis/Dekis/main.cpp:12: error: ‘MainWindow’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’
/home/miroslav/dekis/Dekis/main.cpp:13: error: ‘w’ was not declared in this scope

To copy to clipboard, switch view to plain text mode 

[saa7_go]

I was not make changes in MainWindow class declaration.

Stay to the same question, where is the MainWindow class declaration?

after I add

QT += sql

QT += sql

To copy to clipboard, switch view to plain text mode 

to Dekis.pro

I have next errors (it is less then before)

/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:11: error: expected primary-expression before ‘.’ token
/home/miroslav/dekis/Dekis/main.cpp:12: error: ‘MainWindow’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’
/home/miroslav/dekis/Dekis/main.cpp:13: error: ‘w’ was not declared in this scope

/home/miroslav/dekis/Dekis/main.cpp:3: In file included from main.cpp:3:
/home/miroslav/dekis/Dekis/connector.h:11: error: expected primary-expression before ‘.’ token
/home/miroslav/dekis/Dekis/main.cpp:12: error: ‘MainWindow’ was not declared in this scope
/home/miroslav/dekis/Dekis/main.cpp:12: error: expected ‘;’ before ‘w’
/home/miroslav/dekis/Dekis/main.cpp:13: error: ‘w’ was not declared in this scope

To copy to clipboard, switch view to plain text mode 

Just try to create new project based on your old project. Your mainwindow.h is empty (except the comments).