[Sqlrelay-discussion] Building sqlrelay on CentOS 5.2 x86_64

[Joseph H. <jha...@co...>]

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