sqlrelay-discussion — Discussion of topics related to SQL Relay

Re: [Sqlrelay-discussion] ruby binding problems

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

Actually, now that I look at it, there are several places in that file
where the same problem occurs.  And there is a slight error in the
command from the last email.  And, now that I try it, it appears that
the --no-print-directory option doesn't work anyway :)

So, try the attached file instead.

Dave

On Thu, 2006-12-21 at 16:34 +0100, Fr=C3=A9d=C3=A9ric Logier wrote:
> Hi,
>=20
> I try to compile sqlrelay 0.38 with the ruby binding, but I obtain
> these errors :
>=20
> make -C ruby all
> make[3]: entrant dans le r=C3=A9pertoire
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB
> cp rubyincludes1.h rubyincludes.h; \
>         /bin/sh ../../../libtool --mode=3Dcompile g++ -Wall -pipe
> -DHAVE_CONFIG -pthread  make[3]: entrant dans le r=C3=A9pertoire
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB -Wall -g
> -fno-strict-aliasing -O2 -fPIC -I. -I/usr/lib/ruby/1.8/i486-linux
> -I/usr/lib/ruby/1.8/i486-linux -I. make[3]: quittant le r=C3=A9pertoire
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB -I./
> -I../../../src/api/c++/include -I/usr/local/firstworks/include
> -pthread -c sqlrelay.C -o sqlrelay.lo 2> errors1; \
>         if ( test ! -r sqlrelay.lo ); then \
>                 cp rubyincludes2.h rubyincludes.h; \
>                 /bin/sh ../../../libtool --mode=3Dcompile g++ -Wall
> -pipe  -DHAVE_CONFIG -pthread  make[3]: entrant dans le r=C3=A9pertoire
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB -Wall -g
> -fno-strict-aliasing -O2 -fPIC -I. -I/usr/lib/ruby/1.8/i486-linux
> -I/usr/lib/ruby/1.8/i486-linux -I. make[3]: quittant le r=C3=A9pertoire
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB -I./
> -I../../../src/api/c++/include -I/usr/local/firstworks/include
> -pthread -c sqlrelay.C -o sqlrelay.lo 2> errors2; \
>                 if ( test ! -r sqlrelay.lo ); then \
>                         if ( test -s errors1 ); then \
>                                 echo "first try errors : "; cat
> errors1; echo; \=20
>                         fi; \
>                         if ( test -s errors2 ); then \
>                                 echo "second try errors : "; cat
> errors2; echo; \
>                         fi; \
>                         exit 1; \
>                 else \
>                         cat errors2; \
>                 fi; \
>         else \
>                 cat errors1; \
>         fi; \
>         rm -f errors1 errors2 rubyincludes.h
> mkdir .libs
>  g++ -Wall -pipe -DHAVE_CONFIG -pthread "make[3]:" entrant dans le
> r=C3=A9pertoire =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=
=BB -Wall -g
> -fno-strict-aliasing -O2 -fPIC -I. -I/usr/lib/ruby/1.8/i486-linux
> -I/usr/lib/ruby/1.8/i486-linux -I. "make[3]:" quittant le r=C3=A9pertoi=
re
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB -I./
> -I../../../src/api/c++/include -I/usr/local/firstworks/include
> -pthread -c sqlrelay.C  -fPIC -DPIC -o .libs/sqlrelay.o
>  g++ -Wall -pipe -DHAVE_CONFIG -pthread "make[3]:" entrant dans le
> r=C3=A9pertoire =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=
=BB -Wall -g
> -fno-strict-aliasing -O2 -fPIC -I. -I/usr/lib/ruby/1.8/i486-linux
> -I/usr/lib/ruby/1.8/i486-linux -I. "make[3]:" quittant le r=C3=A9pertoi=
re
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB -I./
> -I../../../src/api/c++/include -I/usr/local/firstworks/include
> -pthread -c sqlrelay.C  -fPIC -DPIC -o .libs/sqlrelay.o
> first try errors :=20
> g++: make[3]:: No such file or directory
> g++: entrant: No such file or directory
> g++: dans: No such file or directory
> g++: le: No such file or directory=20
> g++: r=C3=A9pertoire: No such file or directory
> g++: =C2=AB: No such file or directory
> g++: =C2=BB: No such file or directory
> g++: make[3]:: No such file or directory
> g++: quittant: No such file or directory
> g++: le: No such file or directory=20
> g++: r=C3=A9pertoire: No such file or directory
> g++: =C2=AB: No such file or directory
> g++: =C2=BB: No such file or directory
> sqlrelay.C: In function 'void Init_SQLRConnection()':
> sqlrelay.C:141: error: invalid conversion from 'VALUE (*)()' to 'VALUE
> (*)(...)'=20
> sqlrelay.C:141: error:   initializing argument 3 of 'void
> rb_define_singleton_method(VALUE, const char*, VALUE (*)(...), i
> sqlrelay.C:141: error:   initializing argument 3 of 'void
> rb_define_singleton_method(VALUE, const char*, VALUE (*)(...), int)'=20
> sqlrelay.C:143: error: invalid conversion from 'VALUE (*)()' to 'VALUE
> (*)(...)'
> .............
>=20
>=20
> What about the Ruby binding, is it too old ?
> And it seems that there is a problem with the makefile because of 'No
> such file or directory'=20
>=20
> Ubuntu edgy
> g++ (GCC) 4.1.2 20060928 (prerelease) (Ubuntu 4.1.1-13ubuntu5)
> ruby 1.8.4 (2005-12-24) [i486-linux]
> -----------------------------------------------------------------------=
--
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share=
 your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________ Sqlrelay-discussion mai=
ling list Sql...@li... https://lists.sourcef=
orge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] ruby binding problems

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

I see the problem.  One of my scripts assumes that you're using an
english locale :/

Try modifying src/api/ruby/Makefile and change the line:

RUBYCFLAGS =3D $(shell $(RUBY) getcflags.rb | sed -e "s|-mtune=3Dpentium4=
||
g" | $(MAKE) -s -f - | grep -v Entering | grep -v Leaving )

to

RUBYCFLAGS =3D $(shell $(RUBY) getcflags.rb | sed -e "s|-mtune=3Dpentium4=
||
g" | $(MAKE) -s -f --no-print-directory )

And let me know if that works or not.

Dave

On Thu, 2006-12-21 at 16:34 +0100, Fr=C3=A9d=C3=A9ric Logier wrote:
> Hi,
>=20
> I try to compile sqlrelay 0.38 with the ruby binding, but I obtain
> these errors :
>=20
> make -C ruby all
> make[3]: entrant dans le r=C3=A9pertoire
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB
> cp rubyincludes1.h rubyincludes.h; \
>         /bin/sh ../../../libtool --mode=3Dcompile g++ -Wall -pipe
> -DHAVE_CONFIG -pthread  make[3]: entrant dans le r=C3=A9pertoire
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB -Wall -g
> -fno-strict-aliasing -O2 -fPIC -I. -I/usr/lib/ruby/1.8/i486-linux
> -I/usr/lib/ruby/1.8/i486-linux -I. make[3]: quittant le r=C3=A9pertoire
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB -I./
> -I../../../src/api/c++/include -I/usr/local/firstworks/include
> -pthread -c sqlrelay.C -o sqlrelay.lo 2> errors1; \
>         if ( test ! -r sqlrelay.lo ); then \
>                 cp rubyincludes2.h rubyincludes.h; \
>                 /bin/sh ../../../libtool --mode=3Dcompile g++ -Wall
> -pipe  -DHAVE_CONFIG -pthread  make[3]: entrant dans le r=C3=A9pertoire
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB -Wall -g
> -fno-strict-aliasing -O2 -fPIC -I. -I/usr/lib/ruby/1.8/i486-linux
> -I/usr/lib/ruby/1.8/i486-linux -I. make[3]: quittant le r=C3=A9pertoire
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB -I./
> -I../../../src/api/c++/include -I/usr/local/firstworks/include
> -pthread -c sqlrelay.C -o sqlrelay.lo 2> errors2; \
>                 if ( test ! -r sqlrelay.lo ); then \
>                         if ( test -s errors1 ); then \
>                                 echo "first try errors : "; cat
> errors1; echo; \=20
>                         fi; \
>                         if ( test -s errors2 ); then \
>                                 echo "second try errors : "; cat
> errors2; echo; \
>                         fi; \
>                         exit 1; \
>                 else \
>                         cat errors2; \
>                 fi; \
>         else \
>                 cat errors1; \
>         fi; \
>         rm -f errors1 errors2 rubyincludes.h
> mkdir .libs
>  g++ -Wall -pipe -DHAVE_CONFIG -pthread "make[3]:" entrant dans le
> r=C3=A9pertoire =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=
=BB -Wall -g
> -fno-strict-aliasing -O2 -fPIC -I. -I/usr/lib/ruby/1.8/i486-linux
> -I/usr/lib/ruby/1.8/i486-linux -I. "make[3]:" quittant le r=C3=A9pertoi=
re
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB -I./
> -I../../../src/api/c++/include -I/usr/local/firstworks/include
> -pthread -c sqlrelay.C  -fPIC -DPIC -o .libs/sqlrelay.o
>  g++ -Wall -pipe -DHAVE_CONFIG -pthread "make[3]:" entrant dans le
> r=C3=A9pertoire =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=
=BB -Wall -g
> -fno-strict-aliasing -O2 -fPIC -I. -I/usr/lib/ruby/1.8/i486-linux
> -I/usr/lib/ruby/1.8/i486-linux -I. "make[3]:" quittant le r=C3=A9pertoi=
re
> =C2=AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =C2=BB -I./
> -I../../../src/api/c++/include -I/usr/local/firstworks/include
> -pthread -c sqlrelay.C  -fPIC -DPIC -o .libs/sqlrelay.o
> first try errors :=20
> g++: make[3]:: No such file or directory
> g++: entrant: No such file or directory
> g++: dans: No such file or directory
> g++: le: No such file or directory=20
> g++: r=C3=A9pertoire: No such file or directory
> g++: =C2=AB: No such file or directory
> g++: =C2=BB: No such file or directory
> g++: make[3]:: No such file or directory
> g++: quittant: No such file or directory
> g++: le: No such file or directory=20
> g++: r=C3=A9pertoire: No such file or directory
> g++: =C2=AB: No such file or directory
> g++: =C2=BB: No such file or directory
> sqlrelay.C: In function 'void Init_SQLRConnection()':
> sqlrelay.C:141: error: invalid conversion from 'VALUE (*)()' to 'VALUE
> (*)(...)'=20
> sqlrelay.C:141: error:   initializing argument 3 of 'void
> rb_define_singleton_method(VALUE, const char*, VALUE (*)(...), i
> sqlrelay.C:141: error:   initializing argument 3 of 'void
> rb_define_singleton_method(VALUE, const char*, VALUE (*)(...), int)'=20
> sqlrelay.C:143: error: invalid conversion from 'VALUE (*)()' to 'VALUE
> (*)(...)'
> .............
>=20
>=20
> What about the Ruby binding, is it too old ?
> And it seems that there is a problem with the makefile because of 'No
> such file or directory'=20
>=20
> Ubuntu edgy
> g++ (GCC) 4.1.2 20060928 (prerelease) (Ubuntu 4.1.1-13ubuntu5)
> ruby 1.8.4 (2005-12-24) [i486-linux]
> -----------------------------------------------------------------------=
--
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share=
 your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________ Sqlrelay-discussion mai=
ling list Sql...@li... https://lists.sourcef=
orge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] sqlrelay 0.38 compile error on Centos 4.4

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

It looks like in postgresql 7.4, the PQprepare function didn't exist,
rather you had to manually PQexecute a "PREPARE ..." query and then you
could call PQexecPrepared on it.

I'll update the code to support that.

In the mean time, you can fix the problem by editing the config.h file
which is generated by the configure script and change the line:

#define HAVE_POSTGRESQL_PQEXECPREPARED 1

to

#undef HAVE_POSTGRESQL_PQEXECPREPARED

and run the make again.

This will remove support for prepared queries in postgres.  The only
other option is to upgrade to postgresql 8.

Dave

On Fri, 2006-12-29 at 16:48 +0700, Nguyen Thai Ha wrote:
> I compiled sqlrelay 0.38 with rudiments 0.30, at stage of linking
> postgresql libraries, g++ thrown this error:
> 
> make -C postgresql all
> make[3]: Entering directory
> `/root/sqlrelay-0.38/src/connections/postgresql' 
> /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../../../src/api/c++/include -c postgresqlconnection.C -o
> postgresqlconnection.lo
>  g++ -Wall -pipe -pthread -I./ -I../../../ -I../../../src/common
> -I../../../src/util -I../../../src/connection
> -I/usr/local/firstworks/include -pthread -I../../../src/api/c
> ++/include -c postgresqlconnection.C  -fPIC -DPIC
> -o .libs/postgresqlconnection.o
> postgresqlconnection.C: In member function `virtual bool
> postgresqlcursor::prepareQuery(const char*, uint32_t)':
> postgresqlconnection.C:233: error: `PQprepare' was not declared in
> this scope 
> postgresqlconnection.C:233: warning: unused variable 'PQprepare'
> make[3]: *** [postgresqlconnection.lo] Error 1
> make[3]: Leaving directory
> `/root/sqlrelay-0.38/src/connections/postgresql'
> make[2]: *** [all] Error 2 
> make[2]: Leaving directory `/root/sqlrelay-0.38/src/connections'
> make[1]: *** [all] Error 2
> make[1]: Leaving directory `/root/sqlrelay-0.38/src'
> make: *** [all] Error 2
> 
> I used Centos 4.4 version of  postgresql (that is 7.4.13) 
> 
> Please help ! Thanks
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

[Sqlrelay-discussion] sqlrelay 0.38 compile error on Centos 4.4

[Nguyen T. H. <th...@gm...>]

I compiled sqlrelay 0.38 with rudiments 0.30, at stage of linking postgresql
libraries, g++ thrown this error:

make -C postgresql all
make[3]: Entering directory `/root/sqlrelay-0.38/src/connections/postgresql'
/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../../../src/api/c++/include -c postgresqlconnection.C -o
postgresqlconnection.lo
 g++ -Wall -pipe -pthread -I./ -I../../../ -I../../../src/common
-I../../../src/util -I../../../src/connection
-I/usr/local/firstworks/include -pthread -I../../../src/api/c++/include -c
postgresqlconnection.C  -fPIC -DPIC -o .libs/postgresqlconnection.o
postgresqlconnection.C: In member function `virtual bool
postgresqlcursor::prepareQuery(const char*, uint32_t)':
postgresqlconnection.C:233: error: `PQprepare' was not declared in this
scope
postgresqlconnection.C:233: warning: unused variable 'PQprepare'
make[3]: *** [postgresqlconnection.lo] Error 1
make[3]: Leaving directory `/root/sqlrelay-0.38/src/connections/postgresql'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/root/sqlrelay-0.38/src/connections'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/root/sqlrelay-0.38/src'
make: *** [all] Error 2

I used Centos 4.4 version of  postgresql (that is 7.4.13)

Please help ! Thanks

[Sqlrelay-discussion] ruby binding problems

[<fr...@gm...>]

Hi,

I try to compile sqlrelay 0.38 with the ruby binding, but I obtain these
errors :

make -C ruby all
make[3]: entrant dans le r=E9pertoire =AB
/home/fred/sources/cvs/sqlrelay/src/api/ruby =BB
cp rubyincludes1.h rubyincludes.h; \
        /bin/sh ../../../libtool --mode=3Dcompile g++ -Wall -pipe
-DHAVE_CONFIG -pthread  make[3]: entrant dans le r=E9pertoire =AB
/home/fred/sources/cvs/sqlrelay/src/api/ruby =BB -Wall -g -fno-strict-alias=
ing
-O2 -fPIC -I. -I/usr/lib/ruby/1.8/i486-linux -I/usr/lib/ruby/1.8/i486-linux
-I. make[3]: quittant le r=E9pertoire =AB
/home/fred/sources/cvs/sqlrelay/src/api/ruby =BB -I./
-I../../../src/api/c++/include -I/usr/local/firstworks/include -pthread -c
sqlrelay.C -o sqlrelay.lo 2> errors1; \
        if ( test ! -r sqlrelay.lo ); then \
                cp rubyincludes2.h rubyincludes.h; \
                /bin/sh ../../../libtool --mode=3Dcompile g++ -Wall -pipe
-DHAVE_CONFIG -pthread  make[3]: entrant dans le r=E9pertoire =AB
/home/fred/sources/cvs/sqlrelay/src/api/ruby =BB -Wall -g -fno-strict-alias=
ing
-O2 -fPIC -I. -I/usr/lib/ruby/1.8/i486-linux -I/usr/lib/ruby/1.8/i486-linux
-I. make[3]: quittant le r=E9pertoire =AB
/home/fred/sources/cvs/sqlrelay/src/api/ruby =BB -I./
-I../../../src/api/c++/include -I/usr/local/firstworks/include -pthread -c
sqlrelay.C -o sqlrelay.lo 2> errors2; \
                if ( test ! -r sqlrelay.lo ); then \
                        if ( test -s errors1 ); then \
                                echo "first try errors : "; cat errors1;
echo; \
                        fi; \
                        if ( test -s errors2 ); then \
                                echo "second try errors : "; cat errors2;
echo; \
                        fi; \
                        exit 1; \
                else \
                        cat errors2; \
                fi; \
        else \
                cat errors1; \
        fi; \
        rm -f errors1 errors2 rubyincludes.h
mkdir .libs
 g++ -Wall -pipe -DHAVE_CONFIG -pthread "make[3]:" entrant dans le
r=E9pertoire =AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =BB -Wall -g
-fno-strict-aliasing -O2 -fPIC -I. -I/usr/lib/ruby/1.8/i486-linux
-I/usr/lib/ruby/1.8/i486-linux -I. "make[3]:" quittant le r=E9pertoire =AB
/home/fred/sources/cvs/sqlrelay/src/api/ruby =BB -I./
-I../../../src/api/c++/include -I/usr/local/firstworks/include -pthread -c
sqlrelay.C  -fPIC -DPIC -o .libs/sqlrelay.o
 g++ -Wall -pipe -DHAVE_CONFIG -pthread "make[3]:" entrant dans le
r=E9pertoire =AB /home/fred/sources/cvs/sqlrelay/src/api/ruby =BB -Wall -g
-fno-strict-aliasing -O2 -fPIC -I. -I/usr/lib/ruby/1.8/i486-linux
-I/usr/lib/ruby/1.8/i486-linux -I. "make[3]:" quittant le r=E9pertoire =AB
/home/fred/sources/cvs/sqlrelay/src/api/ruby =BB -I./
-I../../../src/api/c++/include -I/usr/local/firstworks/include -pthread -c
sqlrelay.C  -fPIC -DPIC -o .libs/sqlrelay.o
first try errors :
g++: make[3]:: No such file or directory
g++: entrant: No such file or directory
g++: dans: No such file or directory
g++: le: No such file or directory
g++: r=E9pertoire: No such file or directory
g++: =AB: No such file or directory
g++: =BB: No such file or directory
g++: make[3]:: No such file or directory
g++: quittant: No such file or directory
g++: le: No such file or directory
g++: r=E9pertoire: No such file or directory
g++: =AB: No such file or directory
g++: =BB: No such file or directory
sqlrelay.C: In function 'void Init_SQLRConnection()':
sqlrelay.C:141: error: invalid conversion from 'VALUE (*)()' to 'VALUE
(*)(...)'
sqlrelay.C:141: error:   initializing argument 3 of 'void
rb_define_singleton_method(VALUE, const char*, VALUE (*)(...), i
sqlrelay.C:141: error:   initializing argument 3 of 'void
rb_define_singleton_method(VALUE, const char*, VALUE (*)(...), int)'
sqlrelay.C:143: error: invalid conversion from 'VALUE (*)()' to 'VALUE
(*)(...)'
.............


What about the Ruby binding, is it too old ?
And it seems that there is a problem with the makefile because of 'No such
file or directory'

Ubuntu edgy
g++ (GCC) 4.1.2 20060928 (prerelease) (Ubuntu 4.1.1-13ubuntu5)
ruby 1.8.4 (2005-12-24) [i486-linux]

Re: [Sqlrelay-discussion] CVS head seems to be broken / need a version that works with MySQL 4.1.x

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

After starting the sqlrelay daemons, you need to use the sqlrelay client
program sqlrsh rather than the mysql client program.  It works similarly
to the mysql client program but speaks sqlrelay protocol rather than
mysql protocol.

You could also use the mysql client program and sqlrelay's
drop-in-replacement library for mysql:
http://sqlrelay.sourceforge.net/sqlrelay/dropin/mysql.html

There was a bug in sqlrelay CVS though that would cause it not to log in
to the database.  I fixed that last night.

Dave
dav...@fi...

On Mon, 2006-12-11 at 12:05 -1000, Joshua Hoblitt wrote:
> I've just updated rudiments & sqlrelay from CVS head and switch to MySQL
> 5.0.27. The good news is that SQLRelay is no longer segfaulting.  The bad
> news is that it will not connect to the MySQL server.
> 
> --
> mysql -u ipp -p ipp -P9000  --protocol=TCP
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 0 to server version: 5.0.0
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql> show tables;
> ERROR:
> Couldn't connect to the databaseconnection daemon.
> Tried unix port /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/tmp/sockets/6Tried inet port -1795
> --
> 
> Is the that the right socket?  Shouldn't it be connecting to port 9000?
> Why isn't it looking at /tmp/sqlrelay.socket?  How do you pass
> configuration information to the client lib?  Is there a type converion
> issue in in the way the port # is handled? "-1795" seems to imply that
> the port setting is being corrupted somewhere.
> 
> sqlrelay.conf
> --
> <?xml version="1.0"?>
> <instances>
>     <instance id="ipp" port="9000" unixport="/tmp/sqlrelay.socket" dbase="mysql" connections="1" maxconnections="1" maxqueuelength="1" growby="1" ttl="60" endofsession="rollback" sessiontimeout="60" runasuser="jhoblitt" runasgroup="users" cursors="5" authtier="listener" handoff="reconnect" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="32768" maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0">
>         <users>
>             <user user="ipp" password="X"/>
>         </users>
>         <connections>
>             <connection connectionid="localmysql" string="user=ipp;password=X;db=ipp" metric="1" behindloadbalancer="1"/>
>         </connections>
>     </instance>
> </instances>
> --
> 
> Thanks,
> 
> -J
> 
> --
> On Tue, Oct 17, 2006 at 03:11:06PM -1000, Joshua Hoblitt wrote:
> > Hello,
> > 
> > I just discovered SQL Relay and have been trying to get it work for the
> > first time.  It seems that the latest stable release, 0.37.1, is
> > completely incompatible with MySQL 4.1.20.  Eg.,
> > 
> >     mysql -u X -p X -P9000
> >     Enter password:
> >     Debugging to:
> >     /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/debug/sqlr-listener.15087
> >     Segmentation fault
> > 
> > I dug through this list's archives and found a thread here:
> > 
> >     http://sourceforge.net/mailarchive/message.php?msg_id=12572938
> > 
> > that suggests there are some known issues with 0.37.1 & Mysql 4.1.x,
> > even if of a slightly different nature.  So I tried to build from CVS
> > and got this compilation error:
> > 
> >  g++ -Wall -pipe -pthread
> > -DTMP_DIR=\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/tmp\"
> > -DDEBUG_DIR=\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/debug\"
> > -DDEFAULT_CONFIG_FILE=\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//etc/sqlrelay.conf\"
> > -I./ -I../../ -I../../src/common -pthread -c cmdline.C  -fPIC -DPIC -o
> > .libs/cmdline.o
> > cmdline.C: In member function 'void cmdline::setId()':
> > cmdline.C:20: error: 'getValue' was not declared in this scope
> > cmdline.C: In member function 'void cmdline::setConfig()':
> > cmdline.C:30: error: 'getValue' was not declared in this scope
> > cmdline.C: In member function 'void cmdline::setLocalStateDir()':
> > cmdline.C:39: error: 'getValue' was not declared in this scope
> > make[2]: *** [cmdline.lo] Error 1
> > make[2]: Leaving directory `/home/moanui/jhoblitt/tmp/sqlrelay/src/util'
> > make[1]: *** [all] Error 2
> > make[1]: Leaving directory `/home/moanui/jhoblitt/tmp/sqlrelay/src'
> > make: *** [all] Error 2
> > 
> > Does this error leap out and anyone or should I take stab at fixing it?
> > 
> > Cheers,
> > 
> > -J
> > 
> > --
> 
> 
> 
> > -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services, security?
> > Get stuff done quickly with pre-integrated technology to make your job easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] CVS head seems to be broken / need a version that works with MySQL 4.1.x

[Joshua H. <jho...@if...>]

I've just updated rudiments & sqlrelay from CVS head and switch to MySQL
5.0.27. The good news is that SQLRelay is no longer segfaulting.  The bad
news is that it will not connect to the MySQL server.

--
mysql -u ipp -p ipp -P9000  --protocol=3DTCP
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 0 to server version: 5.0.0

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show tables;
ERROR:
Couldn't connect to the databaseconnection daemon.
Tried unix port /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrela=
y/tmp/sockets/6Tried inet port -1795
--

Is the that the right socket?  Shouldn't it be connecting to port 9000?
Why isn't it looking at /tmp/sqlrelay.socket?  How do you pass
configuration information to the client lib?  Is there a type converion
issue in in the way the port # is handled? "-1795" seems to imply that
the port setting is being corrupted somewhere.

sqlrelay.conf
--
<?xml version=3D"1.0"?>
<instances>
    <instance id=3D"ipp" port=3D"9000" unixport=3D"/tmp/sqlrelay.socket" db=
ase=3D"mysql" connections=3D"1" maxconnections=3D"1" maxqueuelength=3D"1" g=
rowby=3D"1" ttl=3D"60" endofsession=3D"rollback" sessiontimeout=3D"60" runa=
suser=3D"jhoblitt" runasgroup=3D"users" cursors=3D"5" authtier=3D"listener"=
 handoff=3D"reconnect" deniedips=3D"" allowedips=3D"" debug=3D"none" maxque=
rysize=3D"65536" maxstringbindvaluelength=3D"32768" maxlobbindvaluelength=
=3D"71680" idleclienttimeout=3D"-1" maxlisteners=3D"-1" listenertimeout=3D"=
0">
        <users>
            <user user=3D"ipp" password=3D"X"/>
        </users>
        <connections>
            <connection connectionid=3D"localmysql" string=3D"user=3Dipp;pa=
ssword=3DX;db=3Dipp" metric=3D"1" behindloadbalancer=3D"1"/>
        </connections>
    </instance>
</instances>
--

Thanks,

-J

--
On Tue, Oct 17, 2006 at 03:11:06PM -1000, Joshua Hoblitt wrote:
> Hello,
>=20
> I just discovered SQL Relay and have been trying to get it work for the
> first time.  It seems that the latest stable release, 0.37.1, is
> completely incompatible with MySQL 4.1.20.  Eg.,
>=20
>     mysql -u X -p X -P9000
>     Enter password:
>     Debugging to:
>     /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/debug/sq=
lr-listener.15087
>     Segmentation fault
>=20
> I dug through this list's archives and found a thread here:
>=20
>     http://sourceforge.net/mailarchive/message.php?msg_id=3D12572938
>=20
> that suggests there are some known issues with 0.37.1 & Mysql 4.1.x,
> even if of a slightly different nature.  So I tried to build from CVS
> and got this compilation error:
>=20
>  g++ -Wall -pipe -pthread
> -DTMP_DIR=3D\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrela=
y/tmp\"
> -DDEBUG_DIR=3D\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlre=
lay/debug\"
> -DDEFAULT_CONFIG_FILE=3D\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu/=
/etc/sqlrelay.conf\"
> -I./ -I../../ -I../../src/common -pthread -c cmdline.C  -fPIC -DPIC -o
> .libs/cmdline.o
> cmdline.C: In member function 'void cmdline::setId()':
> cmdline.C:20: error: 'getValue' was not declared in this scope
> cmdline.C: In member function 'void cmdline::setConfig()':
> cmdline.C:30: error: 'getValue' was not declared in this scope
> cmdline.C: In member function 'void cmdline::setLocalStateDir()':
> cmdline.C:39: error: 'getValue' was not declared in this scope
> make[2]: *** [cmdline.lo] Error 1
> make[2]: Leaving directory `/home/moanui/jhoblitt/tmp/sqlrelay/src/util'
> make[1]: *** [all] Error 2
> make[1]: Leaving directory `/home/moanui/jhoblitt/tmp/sqlrelay/src'
> make: *** [all] Error 2
>=20
> Does this error leap out and anyone or should I take stab at fixing it?
>=20
> Cheers,
>=20
> -J
>=20
> --



> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job ea=
sier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

[Sqlrelay-discussion] routerconnections only return 10 rows

[<boc...@du...>]

Hi all

 

I updated to version 0.38 recently and found routing and filtering is a
great idea.

While, I found some problem with the route.

 

Using the sqlrelay.conf.example, 

I can only get first 10 rows when accessing the database with routed
sqlrconnection.

 

I found there is a FETCH_AT_ONCE=10 in
src/connections/route/routeconnections.h

Routeconnections connect to database (mysql) with ResultSetBufferSize = 10

It seems routeconnections not get more rows.

 

Is there something I missed?

 

I think nobody received my last mail, for I have sent it wrong address.

 

I found this today:

Routerconnection.C 

bool routercursor::fetchRow() {

        if (nextrow<cur->rowCount()) {

                nextrow++;

                return true;

        }

        return false;

}

 

BUT:

rowCount() only return count of the result set buffer.

This should be cur->endOfResultSet()

 

--- src/connections/router/routerconnection.C   2006-11-27
10:26:31.949039296 +0800

+++ src/connections/router/routerconnection.C  2006-11-27 10:26:24.277205592
+0800

@@ -708,7 +708,8 @@

 }

 

 bool routercursor::fetchRow() {

-       if (nextrow<cur->rowCount()) {

+       //if (nextrow<cur->rowCount()) {

+       if (!cur->endOfResultSet()) {

                nextrow++;

                return true;

        }

 

 

[Sqlrelay-discussion] mysql_options and ssl

[elijah <el...@ri...>]

Hello all,

We are using sqlrelay with mysql over ssl. In order to get this to work,
we needed to patch mysqlconnection.C so that it would read a [sqlrelay]
section of /etc/mysql/my.cnf.

Perhaps there is another way to do this? Is there a reason why
mysqlconnection.C currently does not call mysql_options?

Here is an example of what we did:

in /etc/mysql/my.cnf
--------------------------------------

[sqlrelay]
ssl-ca          = /etc/certs/roots/cacert-root.pem
ssl-cert        = /etc/certs/mx1.riseup.net/cert.pem
ssl-key         = /etc/certs/mx1.riseup.net/key.pem

the world's smallest patch:
-------------------------------------

--- sqlrelay-0.38/src/connections/mysql/mysqlconnection.C
+++ sqlrelay-0.38-mysql_options/src/connections/mysql/mysqlconnection.C
@@ -73,6 +73,7 @@
                fprintf(stderr,"mysql_init failed\n");
                return false;
        }
+       mysql_options(&mysql,MYSQL_READ_DEFAULT_GROUP,"sqlrelay");
        if (!mysql_real_connect(&mysql,hostval,user,password,dbval,
                                        portval,socketval,clientflag)) {
        #else


-elijah

p.s. thanks to David for sqlrelay!

Re: [Sqlrelay-discussion] Sqlrelay-discussion Digest, Vol 6, Issue 14

[armand\.bastien <arm...@la...>]

Hi,

Your computer memory should be exhausted.

By default, each oracle8 connection use 400 mB of ram. You
could tune memory usage by modifying 'cursors', 'fetchatonce',
'maxselectlistsize' and 'maxitembuffersize'.

For example, I use
<instance id=3D"1" port=3D"11000" dbase=3D"oracle8" connections=3D"0"
maxconnections=3D"10" maxqueuelength=3D"0" growby=3D"1" ttl=3D"60"
endofsession=3D"rollback" sessiontimeout=3D"60"
runasuser=3D"sqlrelay" runasgroup=3D"sqlrelay" cursors=3D"1"
authtier=3D"listener" handoff=3D"pass" fetchatonce=3D"10"
maxselectlistsize=3D"128" maxitembuffersize=3D"1024" >
With this, each connection use 20mB. Warning : Too low value
can harm performance or sqlrelay behaviour.

Regards.

> Send Sqlrelay-discussion mailing list submissions to
> 	sql...@li...
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> or, via email, send a message with subject or body 'help' to
> 	sql...@li...
> 
> You can reach the person managing the list at
> 	sql...@li...
> 
> When replying, please edit your Subject line so it is more
specific
> than "Re: Contents of Sqlrelay-discussion digest..."
> 
> 
> Today's Topics:
> 
>    1. sqlrelay & oracle & solaris (S?bastien BROCHET)
> 
> 
>
----------------------------------------------------------------------
> 
> Message: 1
> Date: Thu, 23 Nov 2006 13:37:33 +0100
> From: S?bastien BROCHET  <seb...@do...>
> Subject: [Sqlrelay-discussion] sqlrelay & oracle & solaris
> To: sql...@li...
> Message-ID: <456...@do...>
> Content-Type: text/plain; charset=3DISO-8859-1
> 
> I'm using sqlrelay on solaris 10.
> It's open 30 connexions pgsql on localhost.
> I can't open more than 5 oracle connexions ... a the 6th i
obtain the
> follow error :
> 
> # sqlr-connection-oracle8 -id M1DB1 -connectionid M1DB1 -config
> /usr/local/firstworks/etc/sqlrelay.conf
> # terminate called after throwing an instance of
'std::bad_alloc'
>   what():  St9bad_alloc
> 
> 
> is anybody can help me ?
> 
> sincerly yours,
> 
> S?b.
> 
> 
> 
> ------------------------------
> 
>
-------------------------------------------------------------------------=

> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the
chance to share your
> opinions on IT & business topics through brief surveys - and
earn cash
>
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> 
> ------------------------------
> 
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> End of Sqlrelay-discussion Digest, Vol 6, Issue 14
> **************************************************
> =0A=0AAcc=E9dez au courrier =E9lectronique de La Poste 
sur www.laposte.net ou sur 3615 LAPOSTENET (0,34=80 TTC /mn) 
1 Giga de stockage gratuit =96 Antispam et antivirus int=E9gr=E9s 
=0A

[Sqlrelay-discussion] sqlrelay & oracle & solaris

[<seb...@do...>]

I'm using sqlrelay on solaris 10.
It's open 30 connexions pgsql on localhost.
I can't open more than 5 oracle connexions ... a the 6th i obtain the
follow error :

# sqlr-connection-oracle8 -id M1DB1 -connectionid M1DB1 -config
/usr/local/firstworks/etc/sqlrelay.conf
# terminate called after throwing an instance of 'std::bad_alloc'
  what():  St9bad_alloc


is anybody can help me ?

sincerly yours,

S=E9b.

Re: [Sqlrelay-discussion] Problems getting SQLRelay to play nicewithDBIx::Class & Mysql on Solaris 5.9

[Tom H. <Tom...@bb...>]

Hmm.. after some playing it seems to be partly working using the
DBI:SQLRelay connection string and no loadable module.

However, I am still getting the "unknown database SQLRelay - using
GenericSubQ dialect" error.

Additionally I am finding the following errors:

 Can't set DBI::st=3DHASH(0x2a29320)->{PRECISION}: unrecognised attribute=

or invalid value at /home/tomh/Pips3/deps/perl5lib//DBD/SQLRelay.pm line
477.
Can't set DBI::st=3DHASH(0x2a29320)->{NULLABLE}: unrecognised attribute o=
r
invalid value at /home/tomh/Pips3/deps/perl5lib//DBD/SQLRelay.pm line
477.

And also some of my SQL is now failing syntax checks (although it works
perfectly when connecting directly via DBI.

any ideas?=20

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
Tom Howe
Sent: 22 November 2006 11:48
To: Discussion of topics related to SQL Relay
Subject: Re: [Sqlrelay-discussion] Problems getting SQLRelay to play
nicewithDBIx::Class & Mysql on Solaris 5.9

ps I'm running all this on solaris 9 (5.9)=20

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
Tom Howe
Sent: 22 November 2006 11:39
To: Discussion of topics related to SQL Relay
Subject: [Sqlrelay-discussion] Problems getting SQLRelay to play nice
withDBIx::Class & Mysql

Hi all, first post on this list.

I am looking to use SQLRelay as a db connection pooler for our
application server.=20

We use Perl/Catalyst/DBIx::Class for the application server and MySQL as
the backend database.

I have installed SQLRelay 0.38 with only Perl and Mysql support and it
has compiled and installed ok.

If I use sqlrsh I can connect to my database ok. I also successfully ran
a small test script using SQLRelay::Connection.

However when my application server tries to access the db via sqlrelay I
am having problems.

If I use the drop in replacement modules (for mysql v5.0) and leave my
DBI connection string as dbi:mysql.. I am getting the following errors.

"DBI Connection failed: DBD driver has not implemented the AutoCommit
attribute."
 and
"DBI Connection failed: Turning on AutoCommit failed"

If I change the connection string to DBI:SQLRelay.. I get the following
error:

"unknown database SQLRelay - using GenericSubQ dialect"

Can anyone advice what I am doing wrong?
Is DBIx::Class known to have problems with SQLRelay?



I also notice on the FAQ page a table showing why one should use SQL
Relay with different databases. For MySQL it says it does not overcome
Connection delays.

I plan to run SQLRelay on the server where my application holding a
number of connections with MySQL and then connect to SQLRelay via unix
sockets, which in my experience are much faster than TCPIP.

Will this work and will this also not give a performance improvement
over direct connections?


Many thanks, Tom

http://www.bbc.co.uk/
This e-mail (and any attachments) is confidential and may contain
personal views which are not the views of the BBC unless specifically
stated.
If you have received it in error, please delete it from your system.
Do not use, copy or disclose the information in any way nor act in
reliance on it and notify the sender immediately.
Please note that the BBC monitors e-mails sent or received.
Further communication will signify your consent to this.
				=09

------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT Join
SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

http://www.bbc.co.uk/
This e-mail (and any attachments) is confidential and may contain
personal views which are not the views of the BBC unless specifically
stated.
If you have received it in error, please delete it from your system.
Do not use, copy or disclose the information in any way nor act in
reliance on it and notify the sender immediately.
Please note that the BBC monitors e-mails sent or received.
Further communication will signify your consent to this.
				=09

------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT Join
SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

http://www.bbc.co.uk/
This e-mail (and any attachments) is confidential and may contain persona=
l views which are not the views of the BBC unless specifically stated.
If you have received it in error, please delete it from your system.
Do not use, copy or disclose the information in any way nor act in relian=
ce on it and notify the sender immediately.
Please note that the BBC monitors e-mails sent or received.
Further communication will signify your consent to this.
				=09

Re: [Sqlrelay-discussion] Problems getting SQLRelay to play nice withDBIx::Class & Mysql on Solaris 5.9

[Tom H. <Tom...@bb...>]

ps I'm running all this on solaris 9 (5.9)=20

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
Tom Howe
Sent: 22 November 2006 11:39
To: Discussion of topics related to SQL Relay
Subject: [Sqlrelay-discussion] Problems getting SQLRelay to play nice
withDBIx::Class & Mysql

Hi all, first post on this list.

I am looking to use SQLRelay as a db connection pooler for our
application server.=20

We use Perl/Catalyst/DBIx::Class for the application server and MySQL as
the backend database.

I have installed SQLRelay 0.38 with only Perl and Mysql support and it
has compiled and installed ok.

If I use sqlrsh I can connect to my database ok. I also successfully ran
a small test script using SQLRelay::Connection.

However when my application server tries to access the db via sqlrelay I
am having problems.

If I use the drop in replacement modules (for mysql v5.0) and leave my
DBI connection string as dbi:mysql.. I am getting the following errors.

"DBI Connection failed: DBD driver has not implemented the AutoCommit
attribute."
 and
"DBI Connection failed: Turning on AutoCommit failed"

If I change the connection string to DBI:SQLRelay.. I get the following
error:

"unknown database SQLRelay - using GenericSubQ dialect"

Can anyone advice what I am doing wrong?
Is DBIx::Class known to have problems with SQLRelay?



I also notice on the FAQ page a table showing why one should use SQL
Relay with different databases. For MySQL it says it does not overcome
Connection delays.

I plan to run SQLRelay on the server where my application holding a
number of connections with MySQL and then connect to SQLRelay via unix
sockets, which in my experience are much faster than TCPIP.

Will this work and will this also not give a performance improvement
over direct connections?


Many thanks, Tom

http://www.bbc.co.uk/
This e-mail (and any attachments) is confidential and may contain
personal views which are not the views of the BBC unless specifically
stated.
If you have received it in error, please delete it from your system.
Do not use, copy or disclose the information in any way nor act in
reliance on it and notify the sender immediately.
Please note that the BBC monitors e-mails sent or received.
Further communication will signify your consent to this.
				=09

------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT Join
SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

http://www.bbc.co.uk/
This e-mail (and any attachments) is confidential and may contain persona=
l views which are not the views of the BBC unless specifically stated.
If you have received it in error, please delete it from your system.
Do not use, copy or disclose the information in any way nor act in relian=
ce on it and notify the sender immediately.
Please note that the BBC monitors e-mails sent or received.
Further communication will signify your consent to this.
				=09

[Sqlrelay-discussion] Problems getting SQLRelay to play nice with DBIx::Class & Mysql

[Tom H. <Tom...@bb...>]

Hi all, first post on this list.

I am looking to use SQLRelay as a db connection pooler for our
application server.=20

We use Perl/Catalyst/DBIx::Class for the application server and MySQL as
the backend database.

I have installed SQLRelay 0.38 with only Perl and Mysql support and it
has compiled and installed ok.

If I use sqlrsh I can connect to my database ok. I also successfully ran
a small test script using SQLRelay::Connection.

However when my application server tries to access the db via sqlrelay I
am having problems.

If I use the drop in replacement modules (for mysql v5.0) and leave my
DBI connection string as dbi:mysql.. I am getting the following errors.

"DBI Connection failed: DBD driver has not implemented the AutoCommit
attribute."
 and=20
"DBI Connection failed: Turning on AutoCommit failed"

If I change the connection string to DBI:SQLRelay.. I get the following
error:

"unknown database SQLRelay - using GenericSubQ dialect"

Can anyone advice what I am doing wrong?
Is DBIx::Class known to have problems with SQLRelay?



I also notice on the FAQ page a table showing why one should use SQL
Relay with different databases. For MySQL it says it does not overcome
Connection delays.

I plan to run SQLRelay on the server where my application holding a
number of connections with MySQL and then connect to SQLRelay via unix
sockets, which in my experience are much faster than TCPIP.

Will this work and will this also not give a performance improvement
over direct connections?


Many thanks, Tom

http://www.bbc.co.uk/
This e-mail (and any attachments) is confidential and may contain persona=
l views which are not the views of the BBC unless specifically stated.
If you have received it in error, please delete it from your system.
Do not use, copy or disclose the information in any way nor act in relian=
ce on it and notify the sender immediately.
Please note that the BBC monitors e-mails sent or received.
Further communication will signify your consent to this.
				=09

[Sqlrelay-discussion] sqlrelay connection pooling and postgres

[blair b. <bla...@gm...>]

Hi,

I discovered SQLRelay a few weeks ago and thought it seemed like a
good option for connection pooling a grid middleware application
cluster that I am setting up.  The app is written in python using
postgres and will typically be running several instances for different
users (separate databases) at once.  When I was setting it up however
I noticed this hidden deep in the config info:

"When SQL Relay is used with any other database, it simply logs out
and logs back in as a different user. This is quite inefficient and
defeats the value of keeping persistent database connections."

Does this mean that sqlrelay is actually of no use as a connection
pool server to any DBMS other than oracle?  If so, I think that needs
to be made much clearer on the website.  Or will it try and reuse
connections to the same database when they are available and only
reconnect when there are none available (in which case there is still
some benefit, especially with a large pool)?

Regards,
-Blair

-- 
In science one tries to tell people, in such a way
as to be understood by everyone, something that
no one ever knew before. But in poetry, it's the
exact opposite.
 - Paul Dirac

Re: [Sqlrelay-discussion] 0.38 compile problems... all I need is the php5.so!

[Jon R. <jo...@gm...>]

Eh... nevermind. I figured it all out.

Seems to working pretty well, too... thanks!

I think I deserve a Linux merit badge now.

  -- jon

-- 
jon roig
web developer
tempe, az
http://jonroig.com

Re: [Sqlrelay-discussion] connections="0" gives errors, memory leaks when oracle not available

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

I'm not sure what the patch id was.  A client of mine just told me that
they had applied lots of patches and that the leak didn't occur on their
system.

Dave
dav...@fi...

On Tue, 2006-11-07 at 17:01 +0100, Ragnar Rova wrote:
> I hand-edited config.mk and the libtool wrappers in src/connections/oracle8
> .. sqlrelay needed ORACLE_HOME set although instant client is not a oracle home
> install..
> It seems to work now.
> Have to wait for leaks. What was the patch id?
> 
> On Tue, Nov 07, 2006 at 16:35 +0100 Ragnar Rova wrote:
> > How to build sqlrelay-0.38 on hp-ux 11.11 using oracle instant client 10.2.0.2?
> > 
> > On Tue, Nov 07, 2006 at 09:34 -0500 David Muse wrote:
> > > Oracle's OCIServerAttach method appears to leak 192 bytes (on x86_64
> > > linux, oracle version 10.2.0.1) whenever it's called if the db isn't
> > > available.  Since SQL Relay attempts to log every 5 seconds when the db
> > > is unavailable, it can lead to huge memory consumption if the db is
> > > down.
> > > 
> > > There is apparently a patch or set of patches which fix the problem.
> > > One of my customers is using 10.2.0.4 and doesn't have the problem.
> > > 
> > > What exactly happens when connections="0", other than the memory leak?
> > > 
> > > Also, give 0.38 a try.  I did recently make some fixes to the connection
> > > scaling code.
> > > 
> > > Dave
> > > dav...@fi...
> > > 
> > > On Tue, 2006-11-07 at 10:15 +0100, Ragnar Rova wrote:
> > > > Hello.
> > > 
> > > > If I configure an instance to have connections="0" and the
> > > > database is unavailable, sqlrelay seems to run amok for me
> > > > when trying to scale up connections when needed.
> > > > 
> > > > Also I noticed strange memory leaks when an oracle8 database
> > > > went away (sqlr-connection-oracle8 for an unavailable instance consuming
> > > > some 450M memory on hp-ux 11.11i)
> > > > 
> > > > This was using 0.37
> > > > 
> > > > 
> > > > 
> > > > -------------------------------------------------------------------------
> > > > Using Tomcat but need to do more? Need to support web services, security?
> > > > Get stuff done quickly with pre-integrated technology to make your job easier
> > > > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > > > _______________________________________________
> > > > Sqlrelay-discussion mailing list
> > > > Sql...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> > > > 
> > > 
> > > 
> > > -------------------------------------------------------------------------
> > > Using Tomcat but need to do more? Need to support web services, security?
> > > Get stuff done quickly with pre-integrated technology to make your job easier
> > > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > > _______________________________________________
> > > Sqlrelay-discussion mailing list
> > > Sql...@li...
> > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> > 
> > -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services, security?
> > Get stuff done quickly with pre-integrated technology to make your job easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

Re: [Sqlrelay-discussion] If oracle8 username invalid will sqlrelay attempt to reconnect until username valid?

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

Those are good ideas.  Currently, when SQL Relay starts up, if it can't
log in, then it just shuts down.  However, after it's successfully
logged in and started up, if any of those issues occur, then it will
attempt to re-log-in over and over until it's successful.  It could do
that at start-up too, that should definitely be an option.

Dave
dav...@fi...

On Tue, 2006-11-07 at 13:45 +0100, Ragnar Rova wrote:
> Hi.
> 
> I run sqlrelay against a oracle9 database.
> The reason is to avoid connection setup overhead and to
> avoid my client app using more than one oracle session to each
> database. Also it should provide fault recovery
> (Compared to a client which does not have reconnect
> logic when db goes down)
> 
> If an oracle8 username is invalid for the moment,
> will sqlrelay retry to connect until it is valid?
> 
> If the TNSNAMES.ORA does not list the supplied oracle_sid
> will sqlrelay retry to connect until it is valid?
> 
> SQLrelay should be able to recover from all types of
> situations where the database it is relaying to goes temporarily
> unavailable etc.
> 
> I had to set maxlisteners="10" to
> avoid sqlrelay from forcing my system to its knees when a database goes
> away. maxlisteners should not default to -1 in my opinion.
> (should have read the docs)
> 
> Example when user not available:
> 
> ----
> starting sqlrelay
> 
> Starting listener:
>   sqlr-listener -id E2FOO -config /usr/local/firstworks/etc/sqlrelay.conf
> 
> Starting 1 connections to E2FOO :
>   sqlr-connection-oracle8 -id E2FOO -connectionid E2FOO -config
> /usr/local/firstworks/etc/sqlrelay.conf
> OCISessionBegin() failed.
> 
> 
> error: ORA-01017: invalid username/password; logon denied
> 
> Couldn't log into database.
> 
> 
> Now it seems that the listener does not bind to its port (9001).
> Is this desired? Will the listener become available when the
> username does?
> 
> Config:
> 
>    <instance id="E2FOO" addresses="127.0.0.1" port="9001"
> unixport="/tmp/sqlrelay.e2FOO.socket" dbase="oracle8" connections="1"
> maxconnections="1" maxqueuelength="0" growby="1" maxlisteners="10"
> ttl="600" endofsession="rollback" sessiontimeout="60" runasuser="batch"
> runasgroup="nuucp" cursors="5" authtier="listener" handoff="reconnect"
> deniedips="" allowedips="" debug="none" maxquerysize="65536"
> maxstringbindvaluelength="4000" maxlobbindvaluelength="71680"
> idleclienttimeout="-1">
>       <users>
>                         <user user="foo" password="foo"/>
>                 </users>
>       <connections>
>          <connection connectionid="E2FOO"
> string="user=FOOtools;password=FOOtools;oracle_sid=E2FOO"
> metric="1" behindloadbalancer="no"/>
>       </connections>
>    </instance>
> 
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

[Sqlrelay-discussion] User on MySql - authtier

[SmallFries <sma...@gm...>]

Hello All

I have a setup where I would to use sqlrelay to seperate read/writes and
have a layer of redundancy by having a standby sqlrelay server.
I was able to install and get the software running with 5 connections to the
Master db. I'm still a bit puzzled at how the application username/password
get passed to the real db sitting behind the sqlrelay servers.  About 10
different users exist in the mysql database. With sqlrelay, would I have to
add these users to the config file ? What if a new user is added to the
database, then the file would have to be updated again. I was looking at "*
authtier*" attribute. I sent this attribute to database, but was unable to
connect locally,remotely and with slqrsh.


Any help appreciated.

Thank You

[Sqlrelay-discussion] Fwd: 0.38 compile problems... all I need is the php5.so!

[Jon R. <jo...@gm...>]

Ok... so I'm having the hardest time compiling this thing.

(I swear I'm not totally retarded, but I'm not having any luck.)

Ultimately, all I want is the php5-sqlrelay.so file since the debian
package doesn't seem to contain the actual file. (If someone wanted to
send me a version of the php api compiled for amd64, that'd be just as
cool.)

Anyway... got rudiments compiled/installed just fine.

But sqlrelay...? Any idea wassup? What am I missing?

-------------
make -C src all
make[1]: Entering directory `/usr/local/sqlrelay-0.38/src'
make -C util all
make[2]: Entering directory `/usr/local/sqlrelay-0.38/src/util'
/bin/sh ../../libtool --mode=compile g++ -Wall -pipe  -pthread
-DTMP_DIR=\"/usr/local/firstworks/var/sqlrelay/tmp\"
-DDEBUG_DIR=\"/usr/local/firstworks/var/sqlrelay/debug\"
-DDEFAULT_CONFIG_FILE=\"/usr/local/firstworks/etc/sqlrelay.conf\" -I./
-I../../ -I../../src/common -pthread -c cmdline.C -o cmdline.lo
 g++ -Wall -pipe -pthread
-DTMP_DIR=\"/usr/local/firstworks/var/sqlrelay/tmp\"
-DDEBUG_DIR=\"/usr/local/firstworks/var/sqlrelay/debug\"
-DDEFAULT_CONFIG_FILE=\"/usr/local/firstworks/etc/sqlrelay.conf\" -I./
-I../../ -I../../src/common -pthread -c cmdline.C  -fPIC -DPIC -o
.libs/cmdline.o
cmdline.C: In member function 'void cmdline::setId()':
cmdline.C:20: error: 'getValue' was not declared in this scope
cmdline.C: In member function 'void cmdline::setConfig()':
cmdline.C:30: error: 'getValue' was not declared in this scope
cmdline.C: In member function 'void cmdline::setLocalStateDir()':
cmdline.C:39: error: 'getValue' was not declared in this scope
make[2]: *** [cmdline.lo] Error 1
make[2]: Leaving directory `/usr/local/sqlrelay-0.38/src/util'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/usr/local/sqlrelay-0.38/src'
make: *** [all] Error 2

------------

Thank you so much...

 -- jon


--
jon roig
web developer
http://jonroig.com

[Sqlrelay-discussion] 0.38 compile problems... all I need is the php5.so!

[Jon R. <jo...@gm...>]

Ok... so I'm having the hardest time compiling this thing.

(I swear I'm not totally retarded, but I'm not having any luck.)

Ultimately, all I want is the php5-sqlrelay.so file since the debian
package doesn't seem to contain the actual file.

Anyway... get rudiments compiled/installed just fine.

But sqlrelay...? Any idea wassup?

-------------
make -C src all
make[1]: Entering directory `/usr/local/sqlrelay-0.38/src'
make -C util all
make[2]: Entering directory `/usr/local/sqlrelay-0.38/src/util'
/bin/sh ../../libtool --mode=compile g++ -Wall -pipe  -pthread
-DTMP_DIR=\"/usr/local/firstworks/var/sqlrelay/tmp\"
-DDEBUG_DIR=\"/usr/local/firstworks/var/sqlrelay/debug\"
-DDEFAULT_CONFIG_FILE=\"/usr/local/firstworks/etc/sqlrelay.conf\" -I./
-I../../ -I../../src/common -pthread -c cmdline.C -o cmdline.lo
 g++ -Wall -pipe -pthread
-DTMP_DIR=\"/usr/local/firstworks/var/sqlrelay/tmp\"
-DDEBUG_DIR=\"/usr/local/firstworks/var/sqlrelay/debug\"
-DDEFAULT_CONFIG_FILE=\"/usr/local/firstworks/etc/sqlrelay.conf\" -I./
-I../../ -I../../src/common -pthread -c cmdline.C  -fPIC -DPIC -o
.libs/cmdline.o
cmdline.C: In member function 'void cmdline::setId()':
cmdline.C:20: error: 'getValue' was not declared in this scope
cmdline.C: In member function 'void cmdline::setConfig()':
cmdline.C:30: error: 'getValue' was not declared in this scope
cmdline.C: In member function 'void cmdline::setLocalStateDir()':
cmdline.C:39: error: 'getValue' was not declared in this scope
make[2]: *** [cmdline.lo] Error 1
make[2]: Leaving directory `/usr/local/sqlrelay-0.38/src/util'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/usr/local/sqlrelay-0.38/src'
make: *** [all] Error 2

------------

Thank you so much...

 -- jon


-- 
jon roig
web developer
http://jonroig.com

[Sqlrelay-discussion] Oracle instantclient and configure script

[<la...@he...>]

Hi,

  Configure script does not detect oracle-instantclient library when
$ORACLE_HOME is set. Took some time to figure that out :) This check
should be moved outside if ( test -n "$ORACLE_HOME" ) not in the else
like it is now. Could this be fixed in configure script?

Lauris

Re: [Sqlrelay-discussion] need help with php4

[Robert L. <ro...@mo...>]

Hi Ankur,

I'm no expert, but try specifying the path to your sqlstart.conf file=20=20
using the "-config" flag.

Hope that helps...

Rob


On 11 16, 06, at 12:19 AM, Ankur Dave wrote:

> Hello all.
> =A0
> I have installed sqlrelay and I have written this sqlrelay.conf for=20=20
> that.
> =A0
> <?xml version=3D"1.0"?>
> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
> <instances>
> <instance id=3D"test" port=3D"9000" socket=3D"/tmp/mysqltest.socket"=20=
=20
> dbase=3D"mysql" connections=3D"3" maxconnections=3D"5" maxqueuelength=3D"=
0"=20=20
> growby=3D"1" ttl=3D"60" endofsession=3D"commit" sessiontimeout=3D"600"=20=
=20
> runasuser=3D"nobody" runasgroup=3D"nobody" cursors=3D"5" authtier=3D"list=
ener"=20=20
> handoff=3D"pass">
> =A0=A0 <users>
> =A0=A0=A0=A0 <user user=3D"root" password=3D""/>
> =A0=A0 </users>
> =A0=A0 <connections>
> =A0=A0=A0=A0 <connection connectionid=3D"test"=20=20
> string=3D"user=3Droot;password=3D;db=3Dmobango" host=3D"localhost" metric=
=3D"1"/>
> =A0=A0 </connections>
> </instance>
> </instances>
> =A0
> so when I am running like this =96
> this is giving something like this
> =A0
> mytestsrv:/usr/local/firstworks/etc# sqlr-start -id test
> Couldn't find id test.
> =A0
> I do not know, now what more is remaining.
> =A0
> Plz help me.
> =A0
> -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
> @nkur d@ve ||http://ullu.wordpress.com
> =A0
>
>  The information contained in, or attached to, this e-mail, contains=20=
=20
> confidential information and is intended solely for the use of the=20=20
> individual or entity to whom they are addressed and is subject to=20=20
> legal privilege. If you have received this e-mail in error you should=20=
=20
> notify the sender immediately by reply e-mail, delete the message from=20=
=20
> your system and notify your system manager. Please do not copy it for=20=
=20
> any purpose, or disclose its contents to any other person. The views=20=
=20
> or opinions presented in this e-mail are solely those of the author=20=20
> and do not necessarily represent those of the company. The recipient=20=
=20
> should check this e-mail and any attachments for the presence of=20=20
> viruses. The company accepts no liability for any damage caused,=20=20
> directly or indirectly, by any virus transmitted in this email.
>
>  www.aztecsoft.com
> -----------------------------------------------------------------------=
=20
> --
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to=20=20
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?=20
> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV_____________________________=
____=20
> ______________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

[Sqlrelay-discussion] need help with php4

[Ankur D. <an...@az...>]

Hello all.=0D

=0D

I have installed sqlrelay and I have written this sqlrelay.conf for
that.

=0D

<?xml version=3D"1.0"?>

<!DOCTYPE instances SYSTEM "sqlrelay.dtd">

<instances>

<instance id=3D"test" port=3D"9000" socket=3D"/tmp/mysqltest.socket"
dbase=3D"mysql" connections=3D"3" maxconnections=3D"5" maxqueuelength=3D"0"
growby=3D"1" ttl=3D"60" endofsession=3D"commit" sessiontimeout=3D"600"
runasuser=3D"nobody" runasgroup=3D"nobody" cursors=3D"5" authtier=
=3D"listener"
handoff=3D"pass">

   <users>

     <user user=3D"root" password=3D""/>

   </users>

   <connections>

     <connection connectionid=3D"test"
string=3D"user=3Droot;password=3D;db=3Dmobango" host=3D"localhost" metric=
=3D"1"/>

   </connections>

</instance>

</instances>

=0D

so when I am running like this -=0D

this is giving something like this=0D

=0D

mytestsrv:/usr/local/firstworks/etc# sqlr-start -id test

Couldn't find id test.

=0D

I do not know, now what more is remaining.=0D

=0D

Plz help me.=0D

=0D

-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-

@nkur d@ve ||http://ullu.wordpress.com

=0D




The information contained in, or attached to, this e-mail, contains=
 confidential information and is intended solely for the use of the=
 individual or entity to whom they are addressed and is subject to legal=
 privilege. If you have received this e-mail in error you should notify the=
 sender immediately by reply e-mail, delete the message from your system=
 and notify your system manager. Please do not copy it for any purpose, or=
 disclose its contents to any other person. The views or opinions presented=
 in this e-mail are solely those of the author and do not necessarily=
 represent those of the company. The recipient should check this e-mail and=
 any attachments for the presence of viruses. The company accepts no=
 liability for any damage caused, directly or indirectly, by any virus=
 transmitted in this email.

www.aztecsoft.com

Re: [Sqlrelay-discussion] connections='0' gives errors, memory leaks when oracle not available

[Ragnar R. <rr...@mi...>]

Hello.

Sorry, but I am unable to reproduce the error I described
previously.

Here are some notes on getting sqlrelay to work on HP-UX 11.11.

I switched to sqlrelay-0.38 and upgraded the oracle client to instant client
10.2.0.2

I have attached a patch for rudiments-0.30, it probably
breaks some functionality but it compiles and works for me.

For sqlrelay-0.38, I had to set ORACLE_HOME to a Oracle 9i
directory and replace all instances of $ORACLE_HOME/lib with
$ORACLE_HOME/lib32 in sqlrelay-0.38/configure

After running ./configure I had to edit config.mk
and replace the paths with references to an oracle instant client 10.2.0.2
installation because of the new directory structure.

changes to config.mk:
------
ORACLEVERSION = 10g
ORACLEINCLUDES = -I/usr/app/oracle/instantclient/10.2.0.2/sdk/include/
ORACLELIBS = -L/usr/app/oracle/instantclient/10.2.0.2/ -lclntsh
-l:libcl.sl -l:librt.sl -lpthread -l:libnss_dns.1 -l:libdld.sl
ORACLELIBSPATH = /usr/app/oracle/instantclient/10.2.0.2/
ORACLESTATIC =
ORACLEUSERPATH = yes
------

because of a missing shared libgcc I had to modify sqlrelay-0.38/libtool

--- libtool.orig        2006-11-15 11:03:33 +0100
+++ libtool     2006-11-14 19:01:33 +0100
@@ -7037,7 +7037,7 @@

 # Dependencies to place after the objects being linked to create a
 # shared library.
-postdeps="-lstdc++ -lm -lgcc -lgcc"
+postdeps="-lstdc++ -lm"

 # The library search path used internally by the compiler when linking
 # a shared library.


--
In src/api/perl/Connection/Makefile,
src/api/perl/Cursor/Makefile
and src/api/php/Makefile

I replaced all occurrences of ".so" with ".sl" to get it to build.

The php and perl interpreters crash when I try to use the respective
sqlrelay APIs. But the "query" and "sqlrsh" command line tools
work fine.

Also attached a sqlrelay rc script for init. sqlr-stop would not
always kill all processes (although this was only observed in 0.37)

On Tue, November 7, 2006 15:34, David Muse wrote:
> Oracle's OCIServerAttach method appears to leak 192 bytes (on x86_64
> linux, oracle version 10.2.0.1) whenever it's called if the db isn't
> available.  Since SQL Relay attempts to log every 5 seconds when the db is
> unavailable, it can lead to huge memory consumption if the db is down.
>
> There is apparently a patch or set of patches which fix the problem.
> One of my customers is using 10.2.0.4 and doesn't have the problem.
>
>
> What exactly happens when connections="0", other than the memory leak?
>
>
> Also, give 0.38 a try.  I did recently make some fixes to the connection
> scaling code.
>
> Dave
> dav...@fi...
>
> On Tue, 2006-11-07 at 10:15 +0100, Ragnar Rova wrote:
>
>> Hello.
>>
>
>> If I configure an instance to have connections="0" and the
>> database is unavailable, sqlrelay seems to run amok for me when trying to
>> scale up connections when needed.
>>
>> Also I noticed strange memory leaks when an oracle8 database
>> went away (sqlr-connection-oracle8 for an unavailable instance consuming
>>  some 450M memory on hp-ux 11.11i)
>>
>> This was using 0.37
>>
>>
>>
>>
>> -----------------------------------------------------------------------
>> --
>> Using Tomcat but need to do more? Need to support web services,
>> security? Get stuff done quickly with pre-integrated technology to make
>> your job easier Download IBM WebSphere Application Server v.1.0.1 based
>> on Apache Geronimo
>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=12164
>> 2
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>>
>>
>
>
> -------------------------------------------------------------------------
>  Using Tomcat but need to do more? Need to support web services,
> security? Get stuff done quickly with pre-integrated technology to make
> your job easier Download IBM WebSphere Application Server v.1.0.1 based on
> Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>