sqlrelay-discussion — Discussion of topics related to SQL Relay

[Sqlrelay-discussion] compiling rudiments 0.30 on OS X...

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

Hi all,

I'm having problems compiling rudiments 0.30 on OS X v. 10.3.9:

g++: unrecognized option `-pthread'
environment.C:155:26: #error no way to clear environment
environment.C: In static member function `static bool
    rudiments::environment::clear()':
environment.C:158: warning: control reaches end of non-void function
make[1]: *** [environment.lo] Error 1
make: *** [all] Error 2

Any ideas?

Thanks!

Rob

Re: [Sqlrelay-discussion] SQLRelay and Pear MDB2...

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

Hi Dave,

> SQL Relay has gotten both featureful
> and stable lately, so maybe that's why traffic is low

So no news is good news.  Glad to hear it...

I will also experiment with MDB2 and let you know what I find out.

Thanks for contributing this module to the general community!

Rob

Re: [Sqlrelay-discussion] SQLRelay and Pear MDB2...

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

I haven't done any specific work to make SQL Relay work with MDB2.  It
might :)

I'll look into it.

Yeah, it seems like I don't get as many emails as I used to.  Looking
through my email, it looks like I get a question about once every 2
days.  Though it also looks like a lot of folks have been emailing me
directly for the past few months.  SQL Relay has gotten both featureful
and stable lately, so maybe that's why traffic is low.  I should check
the sourceforge download stats :)

Dave
dav...@fi...

On Fri, 2006-11-10 at 11:46 +0800, Robert Locke wrote:
> Greetings everyone,
> 
> Will SQLRelay work with the PHP Pear MDB2 package?  MDB2 supersedes the 
> old DB package.
> 
> 	http://pear.php.net/package/MDB2
> 
> Also, on an unrelated note, is the mailing list archive out of date?  
> I'm only seeing 1 post to this list for the entire month of October and 
> none for November.
> 
> Thanks!
> 
> Rob
> 
> 
> 
> 
> -------------------------------------------------------------------------
> 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] SQLRelay and Pear MDB2...

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

Greetings everyone,

Will SQLRelay work with the PHP Pear MDB2 package?  MDB2 supersedes the 
old DB package.

	http://pear.php.net/package/MDB2

Also, on an unrelated note, is the mailing list archive out of date?  
I'm only seeing 1 post to this list for the entire month of October and 
none for November.

Thanks!

Rob

Re: [Sqlrelay-discussion] TTL not working?

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

It's implemented.  Those connections must be getting used.  Once they
start up, they will only die off if the level of traffic is low enough
that they don't get used.

You can test it though.  Set connections="1" and maxconnections="3",
start 3 sqlrsh sessions and run a query in each.  You'll see it scale up
to 3 connections, 2 of which have a ttl.  Then exit the second and third
sqlrsh session and 60 seconds later the connections should die off.

David Muse
dav...@fi...

On Wed, 2006-11-08 at 13:37 +0100, m.r...@fr... wrote:
> Hello,
> 
> I am wondering if the TTL-Feature works as described. I have set the TTL-Value to 60 Seconds. PS shows  up
> 12  sqlr-connections. I started the deamon with 6 processes. The listener startet 6 other connections but
> they don't seem to be terminated in any way anymore. 
> 
> Is the TTL-Feature not implemented yet?
> 
> Thanks in advance!
> 
> 
> 
> 
> 
> 
> -------------------------------------------------------------------------
> 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] TTL not working?

[<m.r...@fr...>]

Hello,=0A=0AI am wondering if the TTL-Feature works as described. I have se=
t the TTL-Value to 60 Seconds. PS shows  up=0A12  sqlr-connections. I start=
ed the deamon with 6 processes. The listener startet 6 other connections bu=
t=0Athey don't seem to be terminated in any way anymore. =0A=0AIs the TTL-F=
eature not implemented yet?=0A=0AThanks in advance!=0A=0A=0A=0A=0A=0A=0A

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

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

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

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

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

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

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

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

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
> 

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

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

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>

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

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

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

[Sqlrelay-discussion] sqlrelay 0.38

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

Hello Group,

SQL Relay 0.38 is out!

The highest profile feature of this release is support for query routing
and filtering.  You can, for example, send all insert/update/delete's to
a master and distribute selects over a pool of slaves.  There are some
caveats, but it can now be done.

There are other important features in this release too, here's the
changelog:

0.38 - implemented mysql_stmt function support in mysql connection
	fixed mysql_autocommit detection
	fixed missing self before __getRow and __getRowRange in
		python db driver
	implemented query filtering and routing
	interbase/firebird dead-db/relogin works now
	added test for 0 length result set to PySQLRDB's
		fetchmany method
	added mysql_config sanity test to configure script
	NULL's are escaped in fake input BLOB binds now
	query router works pretty well now
	applied Sharpinskiy Dmitry's odbc unicode patch
	integrated Devananda's statistics gathering code
	added support for mysql stored procedures
	integrated Devananda's mysql result set updates
	sqlrelay.conf.example installed as
		$datadir/examples/sqlrelay.conf now
	integrated Andreas Behr's listener crash patch
	removed erroneous reference to sqlrcon_errormessage
		in php pear db
	another multibyte clob fix
	added "delimiter" command to sqlrsh to change
		delimiter from ; to whatever
	removed msql support
	added db2 9.1 installation doc
	added firebird 2.0 installation docs
	router connection overrides authtier=database
	fixed a bug where clients would hang if they requested a cursor
		when none were available
	added some additional mdb 5 checks to configure script
	added iconv const char parameter check to configure script
	the main listener doesn't listen for clients until all of the
		connections have started now
	added notes about tcp_tw_recycle/tcp_tw_reuse in tuning doc
	ping causes the connection to relogin if it returns false now
	added iconv include/library find to configure script
	fixed sqlrlistener so forked listeners don't remove the pid file
	switched oracle 8 column size variable type from sb4 to ub2
	if maxqueuelength>maxlisteners then scaling isn't used

Give it a run, report any bugs.

Have fun!

David Muse
dav...@fi...

Re: [Sqlrelay-discussion] Problem with Courier-IMAP using LD_PRELOAD

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

Does Courier-IMAP call it many times to switch between different db's or
just once?  If not, then setting up the SQL Relay instance to point to
the db it needs to use and making mysql_select_db return true is
probably the best solution.  If so, then there probably isn't a good
solution at present.

Dave Muse
dav...@fi...

On Tue, 2006-10-31 at 17:21 +0000, Rodrigo Borges Pereira wrote:
> Hello,
> 
> First of all, i'd like to express my appreciation for this nice open-source software, which already proved usefull and efficient, so
> thank you for it. Now to the matter at hands.
> 
> I'm trying to integrate Courier-iMAP with Mysql backend and SQLRelay. I detected that Courier-IMAP's authlib, which is the daemon
> responsible for communicating with MySQL for auth, exits when calling mysql_select_db(). SQLRelay docs say that this function will
> always return false, so the problem is found.
> 
> My question is.. pretty much almost every application talking to MySQL calls mysql_select_db(), no? So, doesn't this break them all?
> What are my options? Change SQLRelay's code to always return true? What could be the implications of that? Changing courier's code
> seems overkill, and the point of using LD_PRELOAD tactic is exactly to avoid the need of chaning the app's code.
> 
> Any ideas?
> 
> Thank you,
> rodrigo
> 
> 
> -------------------------------------------------------------------------
> 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] erro compiling sqlrelay with Intel EM64T

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

Is it possible that you have an older version of SQL Relay currently
installed under /usr/local/firstworks?  That would cause the error
you're seeing.

Dave
dav...@fi...

On Tue, 2006-10-31 at 14:05 -0200, Luciano Antonio Borguetti Faustino
wrote:
> Hi,=20
>=20
> I have compiled rudiments-0.29
>=20
> Use config from sqlrelay:
>=20
> "./configure
> --disable-oracle=20
> --disable-msql=20
> --disable-postgresql=20
> --disable-sqlite=20
> --disable-lago=20
> --disable-freetds=20
> --disable-sybase=20
> --disable-odbc=20
> --disable-db2=20
> --disable-interbase=20
> --disable-python=20
> --disable-zope=20
> --disable-ruby=20
> --disable-tcl=20
> --disable-perl
> --with-mysql-prefix=3D/usr=20
> --sysconfdir=3D/etc=20
> --with-java-prefix=3D/usr/local/java"
>=20
> -------------------------------
>=20
> ***** Summary ***********************************************
>  Version      : 0.37.1
>  API's        : C++  C  Java =20
>  Connections  : Oracle7     no            Oracle8    no    =20
>                 MySQL       dynamic       mSQL       no    =20
>                 PostgreSQL  no            SQLite     no    =20
>                 FreeTDS     no            Sybase     no    =20
>                 ODBC        no            DB2        no    =20
>                 Interbase   no            MDB Tools  no    =20
> *************************************************************
>=20
> If you expected a Connection or API that doesn't show up in the Summary
> then the configure script probably couldn't find a package it needed to
> build it.  You can manually specify package locations using command lin=
e
> options.
>=20
> Type:  configure --help   for a list of options.
>=20
>=20
> Thanks to MP3.com for sponsoring:
>         Clustered/Replicated database support.
>         Perl API.
>=20
>=20
>=20
>=20
> Java version is j2sdk-1_4_2_11-linux-i586.bin
>=20
>=20
> sqlrelay-0.37.1 not compiling with Intel EM64T,=20
>=20
>=20
>=20
> make -C cmdline all
> make[2]: Entering directory `/usr/src/sqlrelay-0.37.1/src/cmdline'
> /bin/sh ../../libtool --mode=3Dlink g++  -Wall -pipe   -o query=20
> query.lo -L../../src/util -lsqlrutil -L../../src/api/c++/src -lsqlrclie=
nt -L/usr/local/firstworks/lib -lrudiments -lpthread -lssl -lcrypto -ldl =
-L/usr/lib64 -lpcre -lrt -lrt -lcrypt -ldl   =20
> g++ -Wall -pipe -o .libs/query .libs/query.o  -L/usr/src/sqlrelay-0.37.=
1/src/util /usr/src/sqlrelay-0.37.1/src/util/.libs/libsqlrutil.so -L/usr/=
local/firstworks/lib -L/usr/lib64 -L/usr/src/sqlrelay-0.37.1/src/api/c++/=
src /usr/local/firstworks/lib/libsqlrclient.so /usr/local/firstworks/lib/=
librudiments.so -lpthread -lssl -lcrypto /usr/lib64/libpcre.so -lrt -lcry=
pt -ldl  -Wl,--rpath -Wl,/usr/local/firstworks/lib -Wl,--rpath -Wl,/usr/l=
ib64
> .libs/query.o: In function `main':
> query.C:(.text+0x38e): undefined reference to=20
> `sqlrconnection::sqlrconnection(char const*, unsigned short, char const=
*,=20
> char const*, char const*, int, int)'
> query.C:(.text+0x3d0): undefined reference to=20
> `sqlrcursor::setResultSetBufferSize(unsigned long)'
> query.C:(.text+0x428): undefined reference to `sqlrcursor::getField(uns=
igned=20
> long, unsigned int)'
> collect2: ld returned 1 exit status
> make[2]: *** [query] Error 1
> make[2]: Leaving directory `/usr/src/sqlrelay-0.37.1/src/cmdline'
> make[1]: *** [all] Error 2
> make[1]: Leaving directory `/usr/src/sqlrelay-0.37.1/src'
> make: *** [all] Error 2
>=20
>=20
>=20
> have you heard about it?
>=20
>=20
>=20
> --=20
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>  Luciano Antonio Borguetti Faustino <lu...@de...>
>  Departamento de Network <su...@de...>
>  Devel-IT - http://www.devel-it.com.br - http://www.devel-it.org
>  Fones: S=C3=A3o Paulo +55 11 2124-7474 - Ourinhos: +55 14 3324-1200
>  Ivoz: #1029
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>=20
> -----------------------------------------------------------------------=
--
> Using Tomcat but need to do more? Need to support web services, securit=
y?
> 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 Geron=
imo
> 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
>=20

[Sqlrelay-discussion] Problem with Courier-IMAP using LD_PRELOAD

[Rodrigo B. P. <rbp...@in...>]

Hello,

First of all, i'd like to express my appreciation for this nice open-source software, which already proved usefull and efficient, so
thank you for it. Now to the matter at hands.

I'm trying to integrate Courier-iMAP with Mysql backend and SQLRelay. I detected that Courier-IMAP's authlib, which is the daemon
responsible for communicating with MySQL for auth, exits when calling mysql_select_db(). SQLRelay docs say that this function will
always return false, so the problem is found.

My question is.. pretty much almost every application talking to MySQL calls mysql_select_db(), no? So, doesn't this break them all?
What are my options? Change SQLRelay's code to always return true? What could be the implications of that? Changing courier's code
seems overkill, and the point of using LD_PRELOAD tactic is exactly to avoid the need of chaning the app's code.

Any ideas?

Thank you,
rodrigo

[Sqlrelay-discussion] erro compiling sqlrelay with Intel EM64T

[Luciano A. B. F. <lu...@de...>]

Hi,=20

I have compiled rudiments-0.29

Use config from sqlrelay:

"./configure
=2D-disable-oracle=20
=2D-disable-msql=20
=2D-disable-postgresql=20
=2D-disable-sqlite=20
=2D-disable-lago=20
=2D-disable-freetds=20
=2D-disable-sybase=20
=2D-disable-odbc=20
=2D-disable-db2=20
=2D-disable-interbase=20
=2D-disable-python=20
=2D-disable-zope=20
=2D-disable-ruby=20
=2D-disable-tcl=20
=2D-disable-perl
=2D-with-mysql-prefix=3D/usr=20
=2D-sysconfdir=3D/etc=20
=2D-with-java-prefix=3D/usr/local/java"

=2D------------------------------

***** Summary ***********************************************
 Version      : 0.37.1
 API's        : C++  C  Java =20
 Connections  : Oracle7     no            Oracle8    no    =20
                MySQL       dynamic       mSQL       no    =20
                PostgreSQL  no            SQLite     no    =20
                FreeTDS     no            Sybase     no    =20
                ODBC        no            DB2        no    =20
                Interbase   no            MDB Tools  no    =20
*************************************************************

If you expected a Connection or API that doesn't show up in the Summary
then the configure script probably couldn't find a package it needed to
build it.  You can manually specify package locations using command line
options.

Type:  configure --help   for a list of options.


Thanks to MP3.com for sponsoring:
        Clustered/Replicated database support.
        Perl API.




Java version is j2sdk-1_4_2_11-linux-i586.bin


sqlrelay-0.37.1 not compiling with Intel EM64T,=20



make -C cmdline all
make[2]: Entering directory `/usr/src/sqlrelay-0.37.1/src/cmdline'
/bin/sh ../../libtool --mode=3Dlink g++  -Wall -pipe   -o query=20
query.lo -L../../src/util -lsqlrutil -L../../src/api/c++/src -lsqlrclient -=
L/usr/local/firstworks/lib -lrudiments -lpthread -lssl -lcrypto -ldl -L/usr=
/lib64 -lpcre -lrt -lrt -lcrypt -ldl   =20
g++ -Wall -pipe -o .libs/query .libs/query.o  -L/usr/src/sqlrelay-0.37.1/sr=
c/util /usr/src/sqlrelay-0.37.1/src/util/.libs/libsqlrutil.so -L/usr/local/=
firstworks/lib -L/usr/lib64 -L/usr/src/sqlrelay-0.37.1/src/api/c++/src /usr=
/local/firstworks/lib/libsqlrclient.so /usr/local/firstworks/lib/librudimen=
ts.so -lpthread -lssl -lcrypto /usr/lib64/libpcre.so -lrt -lcrypt -ldl  -Wl=
,--rpath -Wl,/usr/local/firstworks/lib -Wl,--rpath -Wl,/usr/lib64
=2Elibs/query.o: In function `main':
query.C:(.text+0x38e): undefined reference to=20
`sqlrconnection::sqlrconnection(char const*, unsigned short, char const*,=20
char const*, char const*, int, int)'
query.C:(.text+0x3d0): undefined reference to=20
`sqlrcursor::setResultSetBufferSize(unsigned long)'
query.C:(.text+0x428): undefined reference to `sqlrcursor::getField(unsigne=
d=20
long, unsigned int)'
collect2: ld returned 1 exit status
make[2]: *** [query] Error 1
make[2]: Leaving directory `/usr/src/sqlrelay-0.37.1/src/cmdline'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/usr/src/sqlrelay-0.37.1/src'
make: *** [all] Error 2



have you heard about it?



=2D-=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
 Luciano Antonio Borguetti Faustino <lu...@de...>
 Departamento de Network <su...@de...>
 Devel-IT - http://www.devel-it.com.br - http://www.devel-it.org
 Fones: S=E3o Paulo +55 11 2124-7474 - Ourinhos: +55 14 3324-1200
 Ivoz: #1029
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Re: [Sqlrelay-discussion] Using a oracle identified externally user

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

Sorry for taking sooo looong to respond :/

That's a good question.  I don't think I've ever tried it before, so
there probably isn't a way to do it.  I think it would be easy to
implement though.  Is there a doc on the web that describes how to set
up an oracle instance to use OS authentication?

David Muse
dav...@fi...

On Thu, 2006-10-12 at 11:26 +0200, Ragnar Rova wrote:
> Hi.
> 
> 
> How do I configure sqlrelay to use a oracle8 login
> which is identified externally (OS authentication).
> 
> I get:
> 
> OCISessionBegin() failed.
> 
> 
> error: ORA-01017: invalid username/password; logon denied
> or
> error: ORA-01005: null password given; logon denied
> 
> My conf:
> 
>                 <connections>
>                       <connection connectionid="FOO" 
>                       string="user=/;password=;oracle_sid=FOOFOO"
>                       metric="1" behindloadbalancer="no"/>
>                 </connections>
> 
> -------------------------------------------------------------------------
> 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] SQLRelay + Oracle Client install problem

[Gerson S. <gsa...@gm...>]

Hi

I need some help to install SQLRelay in a server with oracleclient 10.1.0.4
The Oracle8i db is in another server.

When a run ./configure the final status display that the oracle=no.
Maybe I miss some libs needed to SQLRelay

If anyone knows what libs is necessary to SQLRelay found the oracleclient to
configure correctly please let me know

Thanks in advance
Gerson Sakurai

Re: [Sqlrelay-discussion] reads from one database and writes to another.

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

The code that's in CVS right now has this feature.  I've been working
hard to get it released, but I've been pretty busy taking care of
customer requests lately so it's been slow-going.  You could try the CVS
version though.  Make sure you check out the CVS version of rudiments as
well.  The feature is described as "query routing and filtering" in the
docs.  There are some limitations and they are discussed in the docs as
well, but it works in general.

David Muse
dav...@fi...

On Thu, 2006-10-26 at 00:40 -0700, elijah wrote:
> I see in the TODO that the feature 'reads from slave and writes to
> master' is under consideration for the future.
> 
> For what it is worth, I think this feature would be amazingly useful.
> Particularly in the case of mysql, a cluster has many drawbacks and it
> is often impractical or impossible to change an application to support a
> master/slave replication setup. This feature in sqlrelay would make it
> much easier to use a replicated database setup with existing open source
> applications.
> 
> Since I have started looking for something which could do this I have
> found dozens of posts from people asking the same question: can I send
> reads to one database and writes to another? The answer people give is
> always that you must rewrite your application to do this manually. It
> would be nice if sqlrelay could be the answer.
> 
> -elijah
> 
> 
> 
> -------------------------------------------------------------------------
> 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] reads from one database and writes to another.

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

I see in the TODO that the feature 'reads from slave and writes to
master' is under consideration for the future.

For what it is worth, I think this feature would be amazingly useful.
Particularly in the case of mysql, a cluster has many drawbacks and it
is often impractical or impossible to change an application to support a
master/slave replication setup. This feature in sqlrelay would make it
much easier to use a replicated database setup with existing open source
applications.

Since I have started looking for something which could do this I have
found dozens of posts from people asking the same question: can I send
reads to one database and writes to another? The answer people give is
always that you must rewrite your application to do this manually. It
would be nice if sqlrelay could be the answer.

-elijah

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

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

Switching to Rudiments CVS head got it building but there still seems to be
something amiss.  I get debugging statements printed with lags of several s=
econds between them and then an error about the database connection daemon =
(which is running).  The port number in the error message, -1303, looks a l=
ittle suspicious to me.  Is it possible that this is just my configuration?

$ mysql -u X -p X -P 9000
Enter password:
Debugging to: /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/=
debug/sqlr-listener.1536
Debugging to: /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/=
debug/sqlr-listener.1537
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 0 to server version: 4.1.1

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

mysql> select * from detRun;
Debugging to: /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/=
debug/sqlr-listener.1538
ERROR:
Couldn't connect to the databaseconnection daemon.
Tried unix port /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrela=
y/tmp/sockets/27Tried inet port -1303

mysql> status;
--------------
mysql  Ver 14.7 Distrib 4.1.20, for pc-linux-gnu (i686) using  EditLine wra=
pper

Connection id:          0
Debugging to: /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/=
debug/sqlr-listener.1546
SSL:                    Not in use
Current pager:          less -i
Using outfile:          ''
Using delimiter:        ;
Server version:         4.1.1
Protocol version:       14
Connection:
Debugging to: /home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sqlrelay/=
debug/sqlr-listener.1547
Client characterset:    latin1
Segmentation fault



-J

--
On Wed, Oct 18, 2006 at 09:45:59AM -0400, David Muse wrote:
> Try compiling it against the rudiments CVS head.  That should work.
>=20
> Dave
> dav...@fi...
>=20
> On Tue, 2006-10-17 at 15:11 -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/=
sqlr-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/sqlre=
lay/tmp\"
> > -DDEBUG_DIR=3D\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gnu//var/sql=
relay/debug\"
> > -DDEFAULT_CONFIG_FILE=3D\"/home/moanui/jhoblitt/jhroot/i686-pc-linux-gn=
u//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, securit=
y?
> > 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 Geron=
imo
> > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> > _______________________________________________ Sqlrelay-discussion mai=
ling list Sql...@li... https://lists.sourcefor=
ge.net/lists/listinfo/sqlrelay-discussion
>=20
>=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

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

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

Try compiling it against the rudiments CVS head.  That should work.

Dave
dav...@fi...

On Tue, 2006-10-17 at 15:11 -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

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

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

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

--

[Sqlrelay-discussion] Output Bind Curosr with stored procedures

[Sylvain G. <S.G...@fo...>]

Hi,

I am trying to use sored procedures with output bind cursor.

Here's my code.

$con=3Dsqlrcon_alloc("hosr,"","sqltest","relay",0,1);
$cur=3Dsqlrcur_alloc($con);
sqlrcur_prepareQuery($cur,"begin =
PROCEDURES_PCK.P_GET_ARTICLELIBELLE_BY_REF(:refcentrale, :curseur); =
end;");
sqlrcur_inputBind($cur,"refcentrale","P8297734");
sqlrcur_defineOutputBindCursor($cur,"curseur");
sqlrcur_executeQuery($cur);
$bindcur=3Dsqlrcur_getOutputBindCursor($cur,"curseur");
sqlrcur_fetchFromBindCursor($bindcur);
var_dump($bindcur);
var_export(sqlrcur_rowCount($bindcur));
var_export(sqlrcur_totalRows($bindcur));
var_export(sqlrcur_colCount($bindcur));
# print fields from table
for ($i=3D0; $i<sqlrcur_rowCount($bindcur); $i++) {
                for ($j=3D0; $j<sqlrcur_colCount($bindcur); $j++) {
                        echo sqlrcur_getField($bindcur,$i,$j);
                        echo ", ";
                }
                echo "\n";
}

My issue is that I receive a sqlRelay resources in bindCursor but there =
is no rows, no cols, etc...

I have tried the same thing with oci and it works so the procedure works =
well.

Can somebody helps me , PLEASEEE !! ;-)

Regards,

  _____ =20

Sylvain Gourvil
D=E9partement e-merchant
D=E9veloppeur Php/MySQL/Oracle

[Sqlrelay-discussion] Using a oracle identified externally user

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

Hi.


How do I configure sqlrelay to use a oracle8 login
which is identified externally (OS authentication).

I get:

OCISessionBegin() failed.


error: ORA-01017: invalid username/password; logon denied
or
error: ORA-01005: null password given; logon denied

My conf:

                <connections>
                      <connection connectionid="FOO" 
                      string="user=/;password=;oracle_sid=FOOFOO"
                      metric="1" behindloadbalancer="no"/>
                </connections>