Qy 4.4.3 MySQL driver failed

Hi,

I have tried installing the Qt 4.4.3 framework on Mac OS X 10.5.6 Leopard with no success. I tried both normal driver and plugin. It just will not compile.

The configure:

> ./configure -qt-sql-mysql -I/usr/local/mysql/include -L/usr/local/mysql/lib -universal
> sudo make

And I get this after some compilations later:

Code:

---

ld: warning in /usr/local/mysql/lib/libmysqlclient_r.dylib, file is not of required architecture
ld: warning in /usr/local/mysql/lib/libmygcc.a, file is not of required architecture
Undefined symbols:
  "_mysql_query", referenced from:
      QMYSQLDriver::beginTransaction()       in qsql_mysql.o
      QMYSQLDriver::commitTransaction()       in qsql_mysql.o
      QMYSQLDriver::rollbackTransaction()       in qsql_mysql.o
  "_mysql_num_rows", referenced from:
      QMYSQLResult::fetchLast()      in qsql_mysql.o
      QMYSQLResult::size()      in qsql_mysql.o
  "_mysql_stmt_param_count", referenced from:
      QMYSQLResult::prepare(QString const&) in qsql_mysql.o
      QMYSQLResult::prepare(QString const&) in qsql_mysql.o
      QMYSQLResult::exec()      in qsql_mysql.o
      QMYSQLResult::exec()      in qsql_mysql.o
  "_mysql_fetch_lengths", referenced from:
      QMYSQLResult::data(int)   in qsql_mysql.o
  "_mysql_stmt_bind_param", referenced from:
      QMYSQLResult::exec()      in qsql_mysql.o
  "_mysql_stmt_data_seek", referenced from:
      QMYSQLResult::fetch(int)   in qsql_mysql.o
  "_mysql_select_db", referenced from:
      QMYSQLDriver::open(QString const&, QString const&, QString const&, QString const&, int, QString const&)in qsql_mysql.o
  "_mysql_stmt_insert_id", referenced from:
      QMYSQLResult::lastInsertId() const  in qsql_mysql.o
  "_mysql_stmt_close", referenced from:
      QMYSQLResult::cleanup()      in qsql_mysql.o
  "_mysql_set_character_set", referenced from:
      QMYSQLDriver::open(QString const&, QString const&, QString const&, QString const&, int, QString const&)in qsql_mysql.o
  "_mysql_stmt_init", referenced from:
      QMYSQLResult::prepare(QString const&) in qsql_mysql.o
  "_mysql_get_client_version", referenced from:
      QMYSQLDriver::open(QString const&, QString const&, QString const&, QString const&, int, QString const&)in qsql_mysql.o
  "_mysql_get_server_version", referenced from:
      QMYSQLDriver::open(QString const&, QString const&, QString const&, QString const&, int, QString const&)in qsql_mysql.o
  "_mysql_list_fields", referenced from:
      QMYSQLDriver::record(QString const&) constin qsql_mysql.o
  "_mysql_stmt_num_rows", referenced from:
      QMYSQLResult::fetchLast()      in qsql_mysql.o
      QMYSQLResult::size()      in qsql_mysql.o
  "_mysql_stmt_fetch", referenced from:
      QMYSQLResult::fetch(int)   in qsql_mysql.o
      QMYSQLResult::fetchNext()      in qsql_mysql.o
  "_mysql_stmt_result_metadata", referenced from:
      QMYSQLResultPrivate::bindInValues()       in qsql_mysql.o
  "_mysql_server_end", referenced from:
      qLibraryEnd()     in qsql_mysql.o
  "_mysql_init", referenced from:
      QMYSQLDriver::open(QString const&, QString const&, QString const&, QString const&, int, QString const&)in qsql_mysql.o
  "_mysql_close", referenced from:
      QMYSQLDriver::close()      in qsql_mysql.o
      QMYSQLDriver::open(QString const&, QString const&, QString const&, QString const&, int, QString const&)in qsql_mysql.o
      QMYSQLDriver::open(QString const&, QString const&, QString const&, QString const&, int, QString const&)in qsql_mysql.o
  "_mysql_field_count", referenced from:
      QMYSQLResult::nextResult()       in qsql_mysql.o
      QMYSQLResult::reset(QString const&) in qsql_mysql.o
      QMYSQLResult::reset(QString const&) in qsql_mysql.o
  "_mysql_stmt_execute", referenced from:
      QMYSQLResult::exec()      in qsql_mysql.o
  "_mysql_stmt_errno", referenced from:
      qMakeStmtError(QString const&, QSqlError::ErrorType, st_mysql_stmt*)in qsql_mysql.o
  "_mysql_stmt_error", referenced from:
      qMakeStmtError(QString const&, QSqlError::ErrorType, st_mysql_stmt*)in qsql_mysql.o
  "_mysql_stmt_affected_rows", referenced from:
      QMYSQLResult::exec()      in qsql_mysql.o
  "_mysql_list_tables", referenced from:
      QMYSQLDriver::tables(QSql::TableType) const  in qsql_mysql.o
  "_mysql_real_connect", referenced from:
      QMYSQLDriver::open(QString const&, QString const&, QString const&, QString const&, int, QString const&)in qsql_mysql.o
  "_mysql_real_escape_string", referenced from:
      QMYSQLDriver::formatValue(QSqlField const&, bool) constin qsql_mysql.o
  "_mysql_stmt_reset", referenced from:
      QMYSQLResult::exec()      in qsql_mysql.o
  "_mysql_stmt_prepare", referenced from:
      QMYSQLResult::prepare(QString const&) in qsql_mysql.o
  "_mysql_free_result", referenced from:
      QMYSQLDriver::record(QString const&) constin qsql_mysql.o
      QMYSQLDriver::tables(QSql::TableType) const  in qsql_mysql.o
      QMYSQLResult::cleanup()      in qsql_mysql.o
      QMYSQLResult::cleanup()      in qsql_mysql.o
      QMYSQLResult::cleanup()      in qsql_mysql.o
      QMYSQLResult::nextResult()       in qsql_mysql.o
  "_mysql_data_seek", referenced from:
      QMYSQLResult::fetch(int)   in qsql_mysql.o
      QMYSQLDriver::tables(QSql::TableType) const  in qsql_mysql.o
  "_mysql_stmt_bind_result", referenced from:
      QMYSQLResult::exec()      in qsql_mysql.o
      QMYSQLResult::exec()      in qsql_mysql.o
  "_mysql_num_fields", referenced from:
      QMYSQLResultPrivate::bindInValues()       in qsql_mysql.o
  "_mysql_insert_id", referenced from:
      QMYSQLResult::lastInsertId() const  in qsql_mysql.o
  "_mysql_stmt_store_result", referenced from:
      QMYSQLResult::exec()      in qsql_mysql.o
  "_mysql_stmt_attr_set", referenced from:
      QMYSQLResult::exec()      in qsql_mysql.o
  "_mysql_store_result", referenced from:
      QMYSQLResult::cleanup()      in qsql_mysql.o
      QMYSQLResult::nextResult()       in qsql_mysql.o
      QMYSQLResult::reset(QString const&) in qsql_mysql.o
  "_mysql_errno", referenced from:
      qMakeError(QString const&, QSqlError::ErrorType, QMYSQLDriverPrivate const*)in qsql_mysql.o
      QMYSQLResult::record() const in qsql_mysql.o
  "_mysql_error", referenced from:
      qMakeError(QString const&, QSqlError::ErrorType, QMYSQLDriverPrivate const*)in qsql_mysql.o
  "_mysql_affected_rows", referenced from:
      QMYSQLResult::nextResult()       in qsql_mysql.o
      QMYSQLResult::reset(QString const&) in qsql_mysql.o
  "_mysql_real_query", referenced from:
      QMYSQLResult::reset(QString const&) in qsql_mysql.o
  "_mysql_fetch_field", referenced from:
      QMYSQLResult::record() const in qsql_mysql.o
      QMYSQLResult::record() const in qsql_mysql.o
      QMYSQLDriver::record(QString const&) constin qsql_mysql.o
      QMYSQLResultPrivate::bindInValues()       in qsql_mysql.o
  "_mysql_fetch_field_direct", referenced from:
      QMYSQLResult::nextResult()       in qsql_mysql.o
      QMYSQLResult::reset(QString const&) in qsql_mysql.o
  "_mysql_character_set_name", referenced from:
      codec(st_mysql*)    in qsql_mysql.o
  "_mysql_field_seek", referenced from:
      QMYSQLResult::record() const in qsql_mysql.o
      QMYSQLResult::record() const in qsql_mysql.o
  "_mysql_next_result", referenced from:
      QMYSQLResult::cleanup()      in qsql_mysql.o
      QMYSQLResult::nextResult()       in qsql_mysql.o
  "_mysql_server_init", referenced from:
      qLibraryInit()     in qsql_mysql.o
  "_mysql_fetch_row", referenced from:
      QMYSQLResult::fetch(int)   in qsql_mysql.o
      QMYSQLResult::fetchNext()      in qsql_mysql.o
      QMYSQLDriver::tables(QSql::TableType) const  in qsql_mysql.o
ld: symbol(s) not found
collect2: ld returned 1 exit status
lipo: can't open input file: /var/tmp//cckcrMCB.out (No such file or directory)
make[2]: *** [../../lib/QtSql.framework/QtSql_debug] Error 1
make[1]: *** [debug-all] Error 2
make: *** [sub-sql-make_default-ordered] Error 2

---

I also tried installing using -plugin-sql-mysql, it does not work. I also tried just use the normal "./configure" without any flags, also fails at the same spot.

I have MySQL installed using the pre-compiled package, which it stores all the headers and libraries in /usr/local/mysql which is a symbolic link to /usr/local/mysql-5.1.30-osx10.5-x86_64.

Perhaps can anyone point out what am I doing wrong? I need help.

I found the problem and solved it.

It turns out that Qt 4.4.3 uses only 32-bit while the MySQL I am using is using 64-bit.

The problem became obvious when I tried to compile Qt as a framework with the flag -arch x86_64 turned on. The compile just stops at qcursor. I turned on the flag because I was double-checking my MySQL version and found I am using the x86_64:

/usr/local/mysql -> mysql-5.1.30-osx10.5-x86_64

So, I downloaded the normal x86 version from MySQL.com, compile Qt using

-I/usr/local/mysql/include and -L/usr/local/mysql/lib flags

with MySQL driver as a plugin (default), everything went smoothly.

Right now, the link points to

/usr/local/mysql -> mysql-5.1.31-osx10.5-x86

Off-topic:

I hope all these 32 and 64 bit binaries to be solved in Snow Leopard, as I have read an article saying Leopard still has binaries mixed with 32 and 64 bits. One of the problems I am having is the default PHP not working with its image libraries, because of the same issue.

Thanks pamalite, I was doing the same mistake....its working now

Quote:

---

Originally Posted by pamalite

I found the problem and solved it.

It turns out that Qt 4.4.3 uses only 32-bit while the MySQL I am using is using 64-bit.

The problem became obvious when I tried to compile Qt as a framework with the flag -arch x86_64 turned on. The compile just stops at qcursor. I turned on the flag because I was double-checking my MySQL version and found I am using the x86_64:

/usr/local/mysql -> mysql-5.1.30-osx10.5-x86_64

So, I downloaded the normal x86 version from MySQL.com, compile Qt using

-I/usr/local/mysql/include and -L/usr/local/mysql/lib flags

with MySQL driver as a plugin (default), everything went smoothly.

Right now, the link points to

/usr/local/mysql -> mysql-5.1.31-osx10.5-x86

Off-topic:

I hope all these 32 and 64 bit binaries to be solved in Snow Leopard, as I have read an article saying Leopard still has binaries mixed with 32 and 64 bits. One of the problems I am having is the default PHP not working with its image libraries, because of the same issue.

---