issues compiling Qt4.1 with mysql

This is the output I get from configure though I do have all my libmysqlclient-dev install, I use kubuntu, anyone?

Code:

---

g++ -c -pipe -O2 -Wall -W  -I../../../mkspecs/linux-g++ -I. -I. -o mysql.o mysql.cpp
mysql.cpp:1:19: error: mysql.h: No such file or directory
make: *** [mysql.o] Error 1
MySQL (thread-unsafe) disabled.
MySQL support cannot be enabled due to functionality tests!

---

and "locate mysql.h" does return "/usr/include/mysql/mysql.h".

Thanx in advance

Patcito

How did you configure it?
Can you show us your ./configure options?

./configure -v -qt-sql-mysql -qt-sql-sqlite

Quote:

---

Originally Posted by patcito

./configure -v -qt-sql-mysql -qt-sql-sqlite

---

Try this:

Code:

---

./configure -v -qt-sql-mysql -I/usr/include/mysql -qt-sql-sqlite

---

Maybe you can modify your CFLAGS env var to include /usr/include/mysql too.

I've got the same problem with 4.1.1 - did anyone else get around this?

When I add -I/usr/include/mysql, I get the following output:

MySQL (thread-safe) auto-detection... (-I/usr/include/mysql)
g++ -o mysql_r mysql.o -lmysqlclient_r
/usr/bin/ld: cannot find -lmysqlclient_r
collect2: ld returned 1 exit status
make: *** [mysql_r] Error 1
MySQL (thread-safe) disabled.
MySQL (thread-unsafe) auto-detection... (-I/usr/include/mysql)
g++ -o mysql mysql.o -lmysqlclient
/usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make: *** [mysql] Error 1
MySQL (thread-unsafe) disabled.
MySQL support cannot be enabled due to functionality tests!
Turn on verbose messaging (-v) to ./configure to see the final report.
If you believe this message is in error you may use the continue
switch (-continue) to ./configure to continue.

(oops - the FAQ mentions to use the -L option - thanks for pointing it out below).

Look in the FAQ.