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

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

Hi David!

David Muse wrote:

> Did the MacPorts version of mysql come with a mysql_config script?  If
> so, you should just have to provide the configure script with it's
> prefix.  For example, if it's in /opt/local/bin/mysql_config, then you
> could use:
>
> ./configure --with-mysql-prefix=/opt/local
>
> And it will find the mysql_config script and use it to get the paths  
> for
> libs and include files.  And everything should go well.

Yes, there is an mysql_config5 in /opt/local/bin which prints

Usage: /opt/local/bin/mysql_config5 [OPTIONS]
Options:
         --cflags         [-I/opt/local/include/mysql5/mysql]
         --include        [-I/opt/local/include/mysql5/mysql]
         --libs           [-L/opt/local/lib -L/opt/local/lib/mysql5/ 
mysql -lmysqlclient -L/opt/local/lib -lz -lm  -L/opt/local/lib -lssl - 
lcrypto]
         --libs_r         [-L/opt/local/lib -L/opt/local/lib/mysql5/ 
mysql -lmysqlclient_r -L/opt/local/lib -lz -lm   -L/opt/local/lib - 
lssl -lcrypto]
         --socket         [/opt/local/var/run/mysql5/mysqld.sock]
         --port           [3306]
         --version        [5.0.51]
         --libmysqld-libs [-L/opt/local/lib -L/opt/local/lib/mysql5/ 
mysql -lmysqld -L/opt/local/lib -lz -lm     -L/opt/local/lib -lssl - 
lcrypto]

but running  ./configure --with-mysql-prefix=/opt/local without tweaks  
disables mysql support.


> Otherwise, you're on the right track. It looks like the tweaks to the
> configure script just didn't do the job.  Try adding them around line
> 23992 which is right before the tests are run.  You'll know it  
> worked if
> the various "checking for XXX" lines output by the configure script  
> say
> "yes" sometimes.

23992? Are you sure?

23991   (exit $ac_status); } &&
23992          { ac_try='test -z "$ac_cxx_werror_flag"
23993                          || test ! -s conftest.err'
23994   { (eval echo "$as_me:$LINENO: \"$ac_try\"") >&5

Line 23644 seems better to me and I added lines according to  
mysql_config5

23644 #eval "MYSQLINCLUDES=\"$INCLUDESTRING\""
23645 #eval "MYSQLLIBS=\"$LIBSTRING\""
23646 eval "MYSQLINCLUDES=\"-I/opt/local/include/mysql5/mysql\""
23647 eval "MYSQLLIBS=\"-L/opt/local/lib -L/opt/local/lib/mysql5/mysql  
-lmysqlclient -L/opt/local/lib -lz -lm  -L/opt/local/lib -lssl -lcrypto 
\""

and now I get

***** MySQL ******************
checking if MySQL requires -lz... no
checking for gzopen in -lz... yes
checking for mysql_real_connect... yes
checking for mysql_select_db... yes
checking for mysql_ping... yes
checking for mysql_change_user... yes
checking for mysql_commit... yes
checking for mysql_rollback... yes
checking for mysql_autocommit... yes
checking for mysql_prepare... yes
checking for mysql_next_result... yes
checking for CR_SERVER_GONE_ERROR... yes
checking for CR_SERVER_LOST... yes
checking for FIELD_TYPE_YEAR... yes
checking for FIELD_TYPE_NEWDATE... yes
checking for FIELD_TYPE_ENUM... yes
checking for FIELD_TYPE_SET... yes
checking for FIELD_TYPE_NEWDECIMAL... yes
checking for MYSQL_OPT_RECONNECT... yes
checking for MYSQL_GET_SERVER_VERSION... yes
mysql includes... -I/opt/local/include/mysql5/mysql
mysql libs... -L/opt/local/lib -L/opt/local/lib/mysql5/mysql - 
lmysqlclient -L/opt/local/lib -lz -lm  -L/opt/local/lib -lssl -lcrypto

and sql relay compiles without problems. Thank you very much! :)