configure problem with mysql on redhat 9 and more

Hello, 

This keeps on coming up on the users list :-7
It seems it is also a problem for fedora users (not sure all or some).
I wonder could we commit this patch to cvs?
It's a very silly teeny patch.
It would save traffic on the users list.

What would happen if I run 
  cvs ci -m"configure problem with mysql on redhat 9 and mac os/x" 
 on kannel cvs head ? :) 

I'm not using kannel now :(. Have discovered yet another xml interface, 
 http post this time (o2 ireland http://www.xiam.com) 
 Not much time to do kannel things. :-7

In theory automake things should solve this but I tried a while
 ago with patches and results were not good. 

The problem:

 ./configure --disable-ssl --with-mysql --with-mysql-dlr=/usr
 mysql-config returns libs in quotes ''
 parsed incorrectly on some systems
 configure script fails to configure with mysql
 
The change:

-        MYSQL_LIBS="$($MYSQL_CONFIG --libs  |sed s/\'//g)"
+        MYSQL_LIBS="$($MYSQL_CONFIG --libs)"

patch attached ... ,

 ~/src/kannel/gateway-1.4.0/$ patch -p0 <mysql-redhat-configure.patch 

Tested both with latest cvs head and gateway-1.4.0

Thanks,

James.



p.s. on applying the patch to cvs head or gateway-1.4.0 I get:
Reversed (or previously applied) patch detected!  Assume -R? [n] y
And I reply yes.
Don't know why exactly.
The patch does make the one line change.


[jamesc@betty] ~/src/kannel/gateway-cvshead/$ patch -p0 <mysql-redhat-configure.patch
patching file configure
Reversed (or previously applied) patch detected!  Assume -R? [n] y
[jamesc@betty] ~/src/kannel/gateway-cvshead/$ cvs diff -u configure
Index: configure
===================================================================
RCS file: /home/cvs/gateway/configure,v
retrieving revision 1.143
diff -u -r1.143 configure
--- configure   6 Oct 2004 15:55:59 -0000       1.143
+++ configure   30 Nov 2004 16:33:42 -0000
@@ -4542,7 +4542,7 @@
 
     fi
     if test -z "$MYSQL_LIBS" ; then
-        MYSQL_LIBS="$($MYSQL_CONFIG --libs)"
+        MYSQL_LIBS="$($MYSQL_CONFIG --libs  |sed s/\'//g)"
         echo $ac_n "checking mysql libs""... $ac_c" 1>&6
 echo "configure:4548: checking mysql libs" >&5
         echo "$ac_t"" $MYSQL_LIBS " 1>&6


----- Forwarded message from Rene Kluwen <[email protected]> -----

Date: Tue, 30 Nov 2004 14:55:07 +0100
From: Rene Kluwen <[email protected]>
To: James Coleman <[email protected]>
Subject: Re: MySQL problem with gateway-1.4.0

Can somebody please commit this patch to CVS?
I keep having to change this again whenever I check out Kannel on a 
remote site.

Rene Kluwen
Chimit

James Coleman wrote:
>On Mon, Nov 29, 2004 at 04:16:30PM +0000, João Correia wrote:
>
>>Anyone was able to compile gateway with DLR MySQL with Red Hat Fedora Core 
>>1
>>??
>>
>>Regards
>>Joao Correia
>>
>>
>
>
>okay
>
>redhat 9.1
>
>gateway-1.4.0 yes still same mysql configure error :-(
>
>./configure --disable-ssl --with-mysql --with-mysql-dlr=/usr
>
> .....
>
>Configuring DB support ...
>checking whether to compile with MySQL support... searching
>checking for mysql_config... /usr/bin/mysql_config
>checking mysql version... 3.23.58
>checking mysql libs...  -L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl 
>-lm checking for mysql_init in -lmysqlclient... no
>configure: error: Unable to find MySQL client libraries
>
>
>
>$ cp configure configure.orig
>$ patch -p0 <mysql-redhat-configure.patch 
>patching file configure
>Reversed (or previously applied) patch detected!  Assume -R? [n] 
>
> (say Y )
>
>$ diff -u configure configure.orig
>
>
>onfiguring DB support ...
>checking whether to compile with MySQL support... searching
>checking for mysql_config... /usr/bin/mysql_config
>checking mysql version... 3.23.58
>checking mysql libs...  -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl 
>-lm checking for mysql_init in -lmysqlclient... yes
>checking mysql includes... -I'/usr/include/mysql'
>checking for mysql/mysql.h... yes
>checking for mysql/mysql_version.h... yes
>checking whether to compile with MySQL support... yes
>checking whether to compile with LibSDB support... disabled
>checking whether to compile with SQLite support... disabled
>checking whether to compile with Oracle support... disabled
>checking whether to compile with PostgresSQL support... disabled
>
>
>so just apply the attached patch
>
>
>one line change, same one line change/patch as previous on mail list
>
>
>James.
>
>
>
>------------------------------------------------------------------------
>
>--- configure	2004-11-09 14:15:18.000000000 +0000
>+++ ../gateway-1.4.0/configure	2004-10-06 16:55:59.000000000 +0100
>@@ -4542,7 +4542,7 @@
> 
>     fi
>     if test -z "$MYSQL_LIBS" ; then
>-        MYSQL_LIBS="$($MYSQL_CONFIG --libs  |sed s/\'//g)"
>+        MYSQL_LIBS="$($MYSQL_CONFIG --libs)"
>         echo $ac_n "checking mysql libs""... $ac_c" 1>&6
> echo "configure:4548: checking mysql libs" >&5
>         echo "$ac_t"" $MYSQL_LIBS " 1>&6


----- End forwarded message -----