Re: [Sqlrelay-discussion] Problem compiling SQL Relay 0.50

[Ville S. <vil...@gm...>]

Hi,

I've now managed to compile sqlrelay-0.50 on RedHat 6.1. Here's what I had
to do:

1. To solve the "cc1plus: error: unrecognized command line option
"-Wno-long-double"" issue, I modified the configure to set it to empty
string (I know this isn't a real fix, sorry):

# diff configure configure.original
15168,15169c15168
<   #WNOLONGDOUBLE="-Wno-long-double"
<   WNOLONGDOUBLE=""
---
>   WNOLONGDOUBLE="-Wno-long-double"

2. sql_pwdenc should be spelled sqlr_pwdend in the spec file (missing "r"
character). It was also missing from the %files section:

# diff sqlrelay.spec sqlrelay.spec.original
422d421
< %{_bindir}/sqlr-pwdenc
432c431
< %{_libexecdir}/sqlrelay/sqlrpwdenc_*
---
> %{_libexecdir}/sqlrelay/sqlpwdenc_*

3. sqlrsh doesn't compile, because filename variable is not initialized
(g++ treats warnings as errors). I also initialized filenamelen, probably
not necessary:

# diff src/cmdline/sqlrsh.cpp src/cmdline/sqlrsh.cpp.original
1571,1572c1571,1572
<         size_t        filenamelen = 0;
<         char        *filename = NULL;
---
>         size_t        filenamelen;
>         char        *filename;

4. I had to modify the Makefiles for postgresql and mysql. When I tried to
build with rpmbuild, the install failed because the $(RM) commands in the
Makefiles remove the *.a and *.la files. This took me quite a long time to
figure out. I compared the Makefiles between 0.46 and 0.50 releases and
managed to fix them:

# diff src/api/postgresql/Makefile src/api/postgresql/Makefile.original
38c38,39
<     $(LIBTOOL) --mode=finish $(libdir)
---
>     $(RM) $(libdir)/libpqsqlrelay.a
>     $(RM) $(libdir)/libpqsqlrelay.la

# diff src/api/mysql/Makefile src/api/mysql/Makefile.original
64a65,66
>     $(RM) $(libdir)/libmysql3sqlrelay.a
>     $(RM) $(libdir)/libmysql3sqlrelay.la
65a68,69
>     $(RM) $(libdir)/libmysql40sqlrelay.a
>     $(RM) $(libdir)/libmysql40sqlrelay.la
66a71,72
>     $(RM) $(libdir)/libmysql41sqlrelay.a
>     $(RM) $(libdir)/libmysql41sqlrelay.la
67a74,75
>     $(RM) $(libdir)/libmysql50sqlrelay.a
>     $(RM) $(libdir)/libmysql50sqlrelay.la
69c77,78
<     $(LIBTOOL) --mode=finish $(libdir)
---
>     $(RM) $(libdir)/libmysql51sqlrelay.a
>     $(RM) $(libdir)/libmysql51sqlrelay.la

After this the rpmbuild command works for me.

# uname -a
Linux vsi-oy-test1.ebi.ac.uk 2.6.32-279.9.1.el6.x86_64 #1 SMP Fri Aug 31
09:04:24 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux

# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.1 (Santiago)

If you need any further details, please don't hesitate to ask.

Cheers,
Ville

On 1 March 2013 17:37, Ville Silventoinen <vil...@gm...>wrote:

> Hi,
>
> I just tried to compile sqlrelay-0.50 on RedHat 6.1 (I installed rudiments
> 0.41-1 first successfully):
>
> ...
> libtool: compile:  g++ -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2
> -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64
> -mtune=generic -Wall -pipe -Wno-long-double -Werror
> -DDEFAULT_CONFIG_FILE=\"/etc/sqlrelay.conf\"
> -DSYSTEM_SQLRSHRC=\"/etc/sqlrsh\" -I./ -I../../ -I../../src/common
> -I../../src/util -I../../src/server -I../../src/api/c++/include -c
> sqlrsh.cpp  -fPIC -DPIC -o .libs/sqlrsh.o
> cc1plus: warnings being treated as errors
> sqlrsh.cpp: In member function 'void sqlrsh::execute(int, const char**)':
> sqlrsh.cpp:1572: error: 'filename' may be used uninitialized in this
> function
> At global scope:
> cc1plus: error: unrecognized command line option "-Wno-long-double"
> make[2]: *** [sqlrsh.lo] Error 1
> make[2]: Leaving directory `/root/rpmbuild/BUILD/sqlrelay-0.50/src/cmdline'
> make[1]: *** [all] Error 2
> make[1]: Leaving directory `/root/rpmbuild/BUILD/sqlrelay-0.50/src'
> make: *** [all] Error 2
> error: Bad exit status from /var/tmp/rpm-tmp.DBkPfW (%build)
>
> I'm using a shell script like this to build the RPMs:
>
> #!/bin/sh
> rpmbuild -ta \
>            -without db2 \
>            -without erlang \
>            -without freetds \
>            -without firebird \
>            -without odbc \
>            -without ruby \
>            -without sqlite \
>            -without sybase \
>            -without mdbtools \
>            -without tcl \
>            -without zope \
>            -without gtk \
>            -with oracle-instant-client-prefix=/usr \
>            sqlrelay-0.50.tar.gz
>
> Any ideas? Apologies if this has already been reported, I haven't been
> able to keep up with the mailing list recently.
>
> Thanks,
> Ville
>
>