[Sqlrelay-discussion] Installing sql relay on Mac OS X with MySQL support

[Holger A. <ke...@fe...>]

Hi!

I'm trying to compile sql relay on OS X 10.5.2 with MySQL 5.0.51  
installed by MacPorts in /opt/local/libs/mysql5/mysql and /opt/local/ 
include/mysql5/mysql. Because configure didn't find the headers and  
libs, I played with configure.mk.in and set

MYSQLINCLUDES = -I/opt/local/include/mysql5/mysql
MYSQLLIBS = -L/opt/local/libs/mysql5/mysql

, and I modified configure with

MYSQLINCLUDES="/opt/local/include/mysql5/mysql"
MYSQLLIBS="/opt/local/libs/mysql5/mysql"

This results in

...
***** MySQL ******************
checking for mysql_real_connect... no
checking for mysql_select_db... no
checking for mysql_ping... no
checking for mysql_change_user... no
checking for mysql_commit... no
checking for mysql_rollback... no
checking for mysql_autocommit... no
checking for mysql_prepare... no
checking for mysql_next_result... no
checking for CR_SERVER_GONE_ERROR... no
checking for CR_SERVER_LOST... no
checking for FIELD_TYPE_YEAR... no
checking for FIELD_TYPE_NEWDATE... no
checking for FIELD_TYPE_ENUM... no
checking for FIELD_TYPE_SET... no
checking for FIELD_TYPE_NEWDECIMAL... no
checking for MYSQL_OPT_RECONNECT... no
checking for MYSQL_GET_SERVER_VERSION... no
mysql includes... /opt/local/include/mysql5/mysql
mysql libs... /opt/local/libs/mysql5/mysql
...

and make aborts with
...
make -C connection all
make[2]: Nothing to be done for `all'.
make -C connections all
make -C status all
make[3]: Nothing to be done for `all'.
make -C mysql all
/bin/sh ../../../libtool --mode=compile g++ -Wall -pipe -Wno-long- 
double -I/opt/local/include/mysql5/mysql -pthread  -I./ -I../../../ - 
I../../../src/common -I../../../src/util -I../../../src/connection -I/ 
usr/local/firstworks/include -pthread -I/opt/local/include -I/opt/ 
local/include/mysql5/mysql -I../../../src/api/c++/include -c  
mysqlconnection.C -o mysqlconnection.lo
  g++ -Wall -pipe -Wno-long-double -I/opt/local/include/mysql5/mysql - 
pthread -I./ -I../../../ -I../../../src/common -I../../../src/util - 
I../../../src/connection -I/usr/local/firstworks/include -pthread -I/ 
opt/local/include -I/opt/local/include/mysql5/mysql -I../../../src/api/ 
c++/include -c mysqlconnection.C  -fno-common -DPIC -o .libs/ 
mysqlconnection.o
mysqlconnection.C: In member function 'virtual bool  
mysqlconnection::logIn(bool)':
mysqlconnection.C:102: error: 'mysql_connect' was not declared in this  
scope
mysqlconnection.C:70: warning: unused variable 'dbval'
make[3]: *** [mysqlconnection.lo] Error 1
make[2]: *** [all] Error 2
make[1]: *** [all] Error 2
make: *** [all] Error 2
...

I want to write an application based on sql relay, but I have no idea  
how to resolve this.
Thanks for any hint or suggestion!

Holger