Re: [Sqlrelay-discussion] Building sqlrelay on CentOS 5.2 x86_64

[David M. <dav...@fi...>]

Could you send me the config.log file that got generated when you ran
configure.  It appears that the little test programs that it builds to
test the different mysql functions aren't building for some reason.  The
log should say why.

Dave Muse
dav...@fi...

On Mon, 2008-11-03 at 20:13 -0500, Joseph Hardeman wrote:
> Hi Everyone,
> 
> I am having a little problem building the sqlrelay package on our 
> server.  I am wanting to use this as a proxy between our web servers and 
> our production databases, in a read/write scenario.  With all writes 
> going to the Master DB and all reads going to a slave. 
> 
> The problem I am having is that when building sqlrelay it does not see 
> entries for mysql:
> 
> ***** MySQL ******************
> checking for valid mysql_config output... no
> 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... -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 
> -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 
> -mtune=generic -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE 
> -fno-strict-aliasing -fwrapv
> mysql libs... -L/usr/lib64/mysql -lmysqlclient -lz -lcrypt -lnsl -lm 
> -L/usr/lib64 -lssl -lcrypto
> ******************************
> 
> 
> 
> It completes the configuration, and it says that mysql is dynamic.  But 
> when I go to make, I get the following: 
> 
> make -C mysql all
> make[3]: Entering directory 
> `/usr/local/src/sqlrelay-0.39.4/src/connections/mysql'
> /bin/sh ../../../libtool --mode=compile g++ -Wall -pipe  -pthread  -I./ 
> -I../../../ -I../../../src/common -I../../../src/util 
> -I../../../src/connection -I/usr/local/firstworks/include -pthread 
> -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions 
> -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic 
> -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE 
> -fno-strict-aliasing -fwrapv -I../../../src/api/c++/include -c 
> mysqlconnection.C -o mysqlconnection.lo
> mkdir .libs
>  g++ -Wall -pipe -pthread -I./ -I../../../ -I../../../src/common 
> -I../../../src/util -I../../../src/connection 
> -I/usr/local/firstworks/include -pthread -I/usr/include/mysql -g -pipe 
> -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector 
> --param=ssp-buffer-size=4 -m64 -mtune=generic -D_GNU_SOURCE 
> -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv 
> -I../../../src/api/c++/include -c mysqlconnection.C  -fPIC -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[3]: Leaving directory 
> `/usr/local/src/sqlrelay-0.39.4/src/connections/mysql'
> make[2]: *** [all] Error 2
> make[2]: Leaving directory `/usr/local/src/sqlrelay-0.39.4/src/connections'
> make[1]: *** [all] Error 2
> make[1]: Leaving directory `/usr/local/src/sqlrelay-0.39.4/src'
> make: *** [all] Error 2
> 
> 
> I am at a loss as to what I need to do, I installed mysql, mysql-server, 
> and mysql-devel on this server to see if it needed those added.
> 
> Can someone advise me on what I am missing?
> 
> Thanks
> 
> Joe
> 
> -- 
> This message has been scanned for viruses by Colocube's AV Scanner
> 
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>              http://www.doteasy.com


_____________________________________________________________
Veteran's Day Domain Sales: Hosting + Domain = US$5.95/year
Offer Ends: Nov 12, 2008.       http://www.doteasy.com