sqlrelay-discussion — Discussion of topics related to SQL Relay

[Sqlrelay-discussion] SQL Relay 0.39 is out

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

Hello Everyone,

I just made releases of SQL Relay 0.39 and Rudiments 0.31.

This release mainly improves stability under heavy load, but there are
several new features as well.  Here's the changelog:

* removed oracle7 support
* added OCI_OBJECT to oracle environment init
* added some more error codes to oracle's dead connection test
* connections don't decrement connection count when they fail to log in
	now :)
* added -silent option to connections that scaler uses so they don't
	spew login errors if the db is down
* fixed a bug that disabled scaling if maxlisteners
	was -1 (the default, which means no maximum)
* freetds, db2 connection don't detach before logging in any more
* added reloginatstart config parameter
* fixed sendLob for oracle<8i
* applied Johnny Luong's postgresql drop-in lib patch
* applied Jason McClellen's perl dbi raise-error patch
* sybase/freetds use CS_SEVERITY instead of msgp->severity now
* added 64 bit sybase tests
* postgresql only uses PQexecPrepared if PQprepare also exists
* set LANG=POSIX before running ruby/make so sed's would work on non-us
	locales
* documented how to use mysql stored procedure output parameters
* applied ja...@th...'s perl null bind patch
* applied Tim Bunce's perl dbi driver patch
* suppress error message of cat $ORACLE_HOME/lib/sysliblist in configure
	script
* added support for stored procedures which return result sets to sybase
	connection
* added support for stored procedures which return result sets to 
	freetds connection but it doesn't actually return anything
* documented how to use sybase stored procedure result sets
* fixed a bug that caused zope to get an exception when result sets are
	empty
* configure looks for instantclient if it can't find anything in
	ORACLE_HOME, added --with-oracle-instantclient-prefix option
* added sybase ASE 15 install doc
* fixed a bug that caused the router connection to return a max of
	10 rows
* applied Chris Coyle's mysql auto-reconnect patch
* modified countBindVariables to exclude :'s and @'s
	if it finds $'s or ?'s
* applied some of Tim Bunce's DBI patches
* added pid cleanup to init script similar to patch supplied by
	Ragnar Rova
* added validBind() method which will return whether a bind
	variable is in the query or not
* fixed Yeb Havinga's db-tier authentication bug
* added timequeries option
* added support for Oracle OS-authentication
* added some new FAQ's
* mysql connection calls commit() before running the first query after
	each new client connection
* fixed a crash in the router involving "fake begin's"
* documented msql transaction weirdness and db2 relogin issues
* added /opt/csw to configure script search path
* improved filtering out of -x arguments in perl/ruby make commands
* added -lruby, -lperl, -lpython, etc for OS X

Give it a try, report any bugs you find.

David Muse
dav...@fi...

Re: [Sqlrelay-discussion] compiling for oracle support in ubuntu

[Joshua S. <yat...@gm...>]

Thanks everyone for your helpful replies.

Oracle's instant client "packages" don't indicate where they should
go, but by examining sqlrelay's configure script I was able to get by.
After compiling, I only copied the specific oracle connection binaries
because I had installed Ubuntu's main sqlrelay package.

The following commands got it done... prepend sudo where appropriate:

===============================
cd /tmp
unzip <PATH>/instantclient-basic*.zip
mkdir -p /usr/lib/oracle/<VERSION>/client/lib
cd /usr/lib/oracle/<VERSION>/client/lib
cp /tmp/instantclient_10_2/* .
ln -s libclntsh.so.10.1 libclntsh.so
ln -s libocci.so.10.1 libocci.so

cd /tmp
unzip <PATH>/instantclient-sdk*.zip
mkdir -p /usr/include/oracle/<VERSION>/client
cp instantclient_10_2/sdk/include/* /usr/include/oracle/<VERSION>/client

cd ~/sqlrelay-0.38
ORACLE_HOME="" ./configure --disable-python
make
cp src/connections/oracle8/.libs/sqlr* /usr/local/bin
===============================

On 7/24/07, David Muse <dav...@fi...> wrote:
> Try unsetting your ORACLE_HOME and running ./configure again.  The
> current version of SQL Relay doesn't properly detect the instantclient
> installation if ORACLE_HOME is set.  This is fixed in CVS.
>
> Make sure you installed the oracle "instantclient" package too, and not
> a different oracle package.
>
> David Muse
> dav...@fi...
>
> On Mon, 2007-07-23 at 16:42 -0700, Joshua Swink wrote:
> > I would like to use sqlrelay in Ubuntu 7.04. Unfortunately, Ubuntu
> > does not supply a package for sqlrelay and Oracle. Evidently I will
> > need to compile sqlrelay myself in order to connect with an Oracle
> > database. (The RPM is compiled against a different version of libc so
> > I cannot use that.)
> >
> > I have installed Oracle's sqlplus client, but nothing else, so
> > sqlrelay's configure script says the following:
> >
> > ***** Oracle *****************
> > checking for oracle includes and libraries... cat:
> > /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/sysliblist: No
> > such file or directory
> > no
> > configure: WARNING: Oracle support will not be built.
> > ******************************
> >
> > Where can I get the required files to compile this?

Re: [Sqlrelay-discussion] compiling for oracle support in ubuntu

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

Try unsetting your ORACLE_HOME and running ./configure again.  The
current version of SQL Relay doesn't properly detect the instantclient
installation if ORACLE_HOME is set.  This is fixed in CVS.

Make sure you installed the oracle "instantclient" package too, and not
a different oracle package.

David Muse
dav...@fi...

On Mon, 2007-07-23 at 16:42 -0700, Joshua Swink wrote:
> I would like to use sqlrelay in Ubuntu 7.04. Unfortunately, Ubuntu
> does not supply a package for sqlrelay and Oracle. Evidently I will
> need to compile sqlrelay myself in order to connect with an Oracle
> database. (The RPM is compiled against a different version of libc so
> I cannot use that.)
> 
> I have installed Oracle's sqlplus client, but nothing else, so
> sqlrelay's configure script says the following:
> 
> ***** Oracle *****************
> checking for oracle includes and libraries... cat:
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/sysliblist: No
> such file or directory
> no
> configure: WARNING: Oracle support will not be built.
> ******************************
> 
> Where can I get the required files to compile this?
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> 
> _________________________________________________________________
> Need personalized email and website? Look no further. It's easy
> with Doteasy $0 Web Hosting! Learn more at www.doteasy.com

Re: [Sqlrelay-discussion] SQL Relay on OSX

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

In the past, I've gotten it working on various versions of OSX, but I
always had to tweak the config.mk file after running the configure
script.

Recently, I inherited my wife's old powerbook and have been using it to
bring OSX compatibility up to the same level as Linux/Solaris/*BSD.

Currently, it's possible to get it working on OSX if you modify the
config.mk file after running configure and add in some stub libraries.

For example, perl needs:

-L...path to libperl.dylib... -lperl

and simiarly python needs -lpython, ruby needs -lruby, etc.

Do that and you should be able to build and use those api's.

David Muse
dav...@fi...

On Fri, 2007-07-20 at 01:43 -0700, Rizwan Kassim wrote:
> Has anyone built SQL Relay on BSD/OSX?
> 

Re: [Sqlrelay-discussion] compiling for oracle support in ubuntu

[BlacKarma <bla...@gm...>]

Hi,

I think you need to install Oracle Instant Client to compile the oracle
support.
http://www.oracle.com/technology/tech/oci/instantclient/index.html

SDK : "Additional header files and an example makefile for developing Oracle
applications with Instant Client".

Regards.

2007/7/24, Joshua Swink <yat...@gm...>:
>
> I would like to use sqlrelay in Ubuntu 7.04. Unfortunately, Ubuntu
> does not supply a package for sqlrelay and Oracle. Evidently I will
> need to compile sqlrelay myself in order to connect with an Oracle
> database. (The RPM is compiled against a different version of libc so
> I cannot use that.)
>
> I have installed Oracle's sqlplus client, but nothing else, so
> sqlrelay's configure script says the following:
>
> ***** Oracle *****************
> checking for oracle includes and libraries... cat:
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/sysliblist: No
> such file or directory
> no
> configure: WARNING: Oracle support will not be built.
> ******************************
>
> Where can I get the required files to compile this?
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] compiling for oracle support in ubuntu

[Simon M. <sm...@mi...>]

Try this link

http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html

> I would like to use sqlrelay in Ubuntu 7.04. Unfortunately, Ubuntu
> does not supply a package for sqlrelay and Oracle. Evidently I will
> need to compile sqlrelay myself in order to connect with an Oracle
> database. (The RPM is compiled against a different version of libc so
> I cannot use that.)
>
> I have installed Oracle's sqlplus client, but nothing else, so
> sqlrelay's configure script says the following:
>
> ***** Oracle *****************
> checking for oracle includes and libraries... cat:
> /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/sysliblist: No
> such file or directory
> no
> configure: WARNING: Oracle support will not be built.
> ******************************
>
> Where can I get the required files to compile this?
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

[Sqlrelay-discussion] compiling for oracle support in ubuntu

[Joshua S. <yat...@gm...>]

I would like to use sqlrelay in Ubuntu 7.04. Unfortunately, Ubuntu
does not supply a package for sqlrelay and Oracle. Evidently I will
need to compile sqlrelay myself in order to connect with an Oracle
database. (The RPM is compiled against a different version of libc so
I cannot use that.)

I have installed Oracle's sqlplus client, but nothing else, so
sqlrelay's configure script says the following:

***** Oracle *****************
checking for oracle includes and libraries... cat:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/sysliblist: No
such file or directory
no
configure: WARNING: Oracle support will not be built.
******************************

Where can I get the required files to compile this?

[Sqlrelay-discussion] SQL Relay on OSX

[Rizwan K. <ri...@ge...>]

Has anyone built SQL Relay on BSD/OSX?

-- 
Rizwan Kassim
Software and Systems Engineer, uWink Interactive Bistro
http://www.geekymedia.com

"I may not have gone where I intended to go, but I think I have ended
up where I needed to be." -Douglas Adams

Re: [Sqlrelay-discussion] ORA Error : ORA-04030

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

On Mon, 2007-07-16 at 11:42 +0200, Huve Loic wrote:
> Hi David,
> 
> I have check my "ulimit -m" and all are unlimited and when errors
> appear I have no memory leaks (ram used and process don't use memory
> more than usually). 
> On oracle alert log I never see these error (in general ORA-XXX are
> log in).
> I have check a little more and It's only errors on "SELECT DISTINCT".
> Is it possible, at one time, to many "SELECT DISTINCT" use all the
> "sort memory" of sqlrelay ?

All of the sorting is done in Oracle, SQL Relay doesn't do any
processing of the result set.  So, maybe Oracle is running out of
"sort-memory".  I know Oracle uses the global shared pool for that, but
I'm not exactly sure how.  It could be that certain queries are trying
to use more shared pool memory than Oracle is configured to allow them
to use.

Dave

> 
> I let run sqlrelay all the week and ratio is good but on the total
> errors 95% are SELECT-DISTINCT.
>   Total  Queries:             79484886
>   Total  Errors:                677
> 
> I Try to do something, I just put a new sqlrelay server and a
> keepalived so with more connections open that maybe limit the numbers
> of errors.
> 
> Thank's 
> Loic
> 
> 
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

[Sqlrelay-discussion] ORA Error : ORA-04030

[Huve L. <l....@fo...>]

Hi David,

I have check my "ulimit -m" and all are unlimited and when errors appear
I have no memory leaks (ram used and process don't use memory 
more than usually). 
On oracle alert log I never see these error (in general ORA-XXX are log
in).
I have check a little more and It's only errors on "SELECT DISTINCT".
Is it possible, at one time, to many "SELECT DISTINCT" use all the "sort
memory" of sqlrelay ?

I let run sqlrelay all the week and ratio is good but on the total
errors 95% are SELECT-DISTINCT.
  Total  Queries:             79484886
  Total  Errors:                677

I Try to do something, I just put a new sqlrelay server and a keepalived
so with more connections open that maybe limit the numbers of errors.

Thank's 
Loic

Re: [Sqlrelay-discussion] maxlisteners=-1, sqlr-scaler will not start

[Stephen B. <sql...@st...>]

David,

  I reported this a while back and you had referenced getting me a patch...

> Oooh, no, that's not the desired behavior.  Thanks for finding that.
> I'll fix it and get you a patch.
>
> Dave
> dav...@fi...
>
> On Sun, 2006-11-26 at 17:59 -0600, Stephen Barclay [Call-Em-All.com]
> wrote:
>   
>> > David,
>> > 
>> > I dug into the code and found the following..
>> > 
>> > bool sqlrconfigfile::getDynamicScaling() {
>> >         return (maxconnections>connections && growby>0 && ttl>0 &&
>> >                                         maxqueuelength<=maxlisteners);
>> > 
>> > Maxlistener if not set is defaulted to -1, so the scaler would not
>> > run if a value is not explicitly set.. Is this desired behavior?
>> > 
>> > I set my maxlisteners to 10 (not sure of what value is appropriate,
>> > and it is working now)
>> > 
>> > Sorry to waste your time if this is something I should have
>> > found online..
>> > 
>> > Respectfully,
>> > 
>> > Stephen Barclay
>> > st...@ca...
>> > Telecom/Software Engineer
>> > Call-Em-All
>> > 
>> > 
>>     
>
>   


keith wrote:
> Hi,
>
> May I know the rational behind when maxlisteners is set to -1, which is 
> the default, sqlr-scaler will not start. 
>
> I was trying to figure out why sqlr-scaler did not start initially until 
> i read this from sqlrconfigfile.C
>
> bool sqlrconfigfile::getDynamicScaling() {
>         return (maxconnections>connections && growby>0 && ttl>0 &&
>                                         maxqueuelength<=maxlisteners);
>
> Thanks.
>
> Keith
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>   

[Sqlrelay-discussion] maxlisteners=-1, sqlr-scaler will not start

[keith <ke...@sc...>]

Hi,

May I know the rational behind when maxlisteners is set to -1, which is 
the default, sqlr-scaler will not start. 

I was trying to figure out why sqlr-scaler did not start initially until 
i read this from sqlrconfigfile.C

bool sqlrconfigfile::getDynamicScaling() {
        return (maxconnections>connections && growby>0 && ttl>0 &&
                                        maxqueuelength<=maxlisteners);

Thanks.

Keith

Re: [Sqlrelay-discussion] ORA Error : ORA-04030

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

I believe that error means that either all of the system's memory has
been used, or the "max memory size" of a process has gotten too large.
This could be on the database server or the server running sqlrelay.

Run "ulimit -m" on the sqlrelay server and check to see if there are any
sqlr-connection-oracle8 processes that are close to consuming that
amount of memory.  If so, that could be the problem; there could be a
memory leak.  If not, then check on the database server and see if there
are any processes which are getting close to whatever "ulimit -m"
returns on that server.

sqlrelay 0.38 doesn't have any known memory leaks, but I've encountered
a few leaks in Oracle's client libraries.  There is one leak, for sure
on the client-side in 10g that occurs when a client logs in.  It causes
problems if the database is unavailable for a while and sqlrelay has to
attempt to log in over and over until it becomes available again.

Take a look and let me know what you find.

David Muse
dav...@fi...

On Thu, 2007-07-12 at 11:00 +0200, Huve Loic wrote:
> Hello,
> 
> We use since a short time sqlrelay with oracle RAC 10 g on a debian
> etch and sqlrelay 0.38.
> We use it for php pooling.
> We have a strange probleme, all work fine during 15-16 hours and at
> one moment we received  this type of errors :
> 
> ORA Error : ORA-04030: mémoire de traitement manquante lors
> d'affectation de 123404 octets (QERGH hash-agg,kllcqas:kllsltba) 
> 
> In the same time sqlr-status detect errors :
> 
> root@sqlrelay:/usr/local/sqlrelay/bin# sqlr-status -id USER_BRAIN_A
> Warning: using default connectionid.
>   Open   Server Connections:  20
>   Opened Server Connections:  20
>   Open   Client Connections:  1
>   Opened Client Connections:  23324
>   Open   Server Cursors:      300
>   Opened Server Cursors:      23623
>   Times  New Cursor Used:     0
>   Times  Cursor Reused:       4469369
>   Total  Queries:             2463745
> 
>   Total  Errors:              66
> 
>   Forked Listeners:           0
> 
> 
> We just restart instance and all work fine again (errors stop until 15
> or 16 hours). Do you have an idea of what it occurs.
> 
> Thanks a lot.
> Loic 
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

[Sqlrelay-discussion] ORA Error : ORA-04030

[Huve L. <l....@fo...>]

Hello,

We use since a short time sqlrelay with oracle RAC 10 g on a debian etch
and sqlrelay 0.38.
We use it for php pooling.
We have a strange probleme, all work fine during 15-16 hours and at one
moment we received  this type of errors :

ORA Error : ORA-04030: m=C3=A9moire de traitement manquante lors
d'affectation de 123404 octets (QERGH hash-agg,kllcqas:kllsltba)=20

In the same time sqlr-status detect errors :

root@sqlrelay:/usr/local/sqlrelay/bin# sqlr-status -id USER_BRAIN_A
Warning: using default connectionid.
  Open   Server Connections:  20
  Opened Server Connections:  20
  Open   Client Connections:  1
  Opened Client Connections:  23324
  Open   Server Cursors:      300
  Opened Server Cursors:      23623
  Times  New Cursor Used:     0
  Times  Cursor Reused:       4469369
  Total  Queries:             2463745

  Total  Errors:              66

  Forked Listeners:           0


We just restart instance and all work fine again (errors stop until 15
or 16 hours).=20
Do you have an idea of what it occurs.

Thanks a lot.
Loic

Re: [Sqlrelay-discussion] Oracle error (ORA-01036)

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

On Tue, 2007-07-10 at 14:19 -0500, Jason McClellen wrote:
> I figured this out. The prepared statement only works on the same
> connection daemon that it was initially prepared on.
> 
> That lead me to think that I could create a prepared statement per
> connection cache and try to get the prepared statement from there if
> it existed. In order to do that, I would need some way to uniquely
> identify each connection. 
> 
> I looked at sqlrcon_getConnectionPort and sqlrcon_getConnectionSocket,
> but the documentation suggests that they are only valid after a
> sqlrcon_suspendSession. It would seem wasteful to suspend a connection
> just to resume it again. 

The suspend/resume session is really only there so you can make a single
transaction span multiple invocations of a program or get passed around
between clients on multiple machines.  It's mainly used to allow
transactions to span more than one web-page.

> 
> Has anyone else implemented a prepared statement cache, or does anyone
> know how to uniquely identify a connection?

Sorry, otehr than suspend/resume session, there's no way to guarantee
which connection daemon a client will end up using.  Many DBs have an
implicit prepared statement cache though.  If you prepare a statement,
then prepare it again, as long as it's still in the cache, no work is
done the second time (other than to look up and see if it's in the cache
or not).  I think with postgres, you can get a handle to a statement and
explicitly reuse it across db connections, but SQL Relay doesn't
currently offer that functionality.

Dave
dav...@fi...

> 
> Thanks,
> Jason
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] Oracle error (ORA-01036)

[Jason M. <jmc...@gm...>]

I figured this out. The prepared statement only works on the same connection
daemon that it was initially prepared on.

That lead me to think that I could create a prepared statement per
connection cache and try to get the prepared statement from there if it
existed. In order to do that, I would need some way to uniquely identify
each connection.

I looked at sqlrcon_getConnectionPort and sqlrcon_getConnectionSocket, but
the documentation suggests that they are only valid after a
sqlrcon_suspendSession. It would seem wasteful to suspend a connection just
to resume it again.

Has anyone else implemented a prepared statement cache, or does anyone know
how to uniquely identify a connection?

Thanks,
Jason

[Sqlrelay-discussion] Oracle error (ORA-01036)

[Jason M. <jmc...@gm...>]

I have recently started playing with sqlrelay, and I am getting this error
occasionally.

>From the server side, I am using sqlrelay to connect to an Oracle (10g)
database in a RAC environment. There are two nodes in this cluster. From the
client side, I am using the C API. Just to get a feel for how things work, I
whipped up a quick client program that essentially does the following:

1 establish a connection
2 get a cursor
3 prepare an update query (with bind variables)
4 bind strings to the cursor
5 execute the query
6 commit the transaction
7 clear the bind variables
8 end the session

steps 4 through 8 are repeated a bunch of times with the bind variables
changed on each iteration.

I am running 30 of these clients at a time to get a feel for what each of
the configuration values does.

Occasionally, and unpredictably, the execute fails with an error (ORA-01036:
illegal variable name/number). At this point, I am clearing the bind
variables, ending the session, re-binding, and re-executing until it
succeeds, but that may take several iterations to accomplish.

I am wondering if the prepared statement must be run on a connection to the
same node in the cluster, but I do not know how to confirm that.

Any idea what is causing this, and how to get around it?

Thanks,
Jason

Re: [Sqlrelay-discussion] Problems with MySQL 5.0.37

[Michael R. <mr...@ma...>]

With MySQL 3.23 as client connecting to MySQL 5.0.37 it works well.

Client Configuration:

MySQL 3.23.58
Red Hat Enterprise Linux AS release 3 (Taroon Update 9)
rudiments 0.30
sqlrelay 0.38

I think there is an incompatibility between "/usr/bin/mysql" from MySQL 
5.0.37 and the sqlrelay library "/usr/local/lib/libmysql50sqlrelay.so".
I will do some more tests.


Michael Roth schrieb:
> I tried:
>
> # /usr/bin/mysql -h test1 -P 9000 --user=mysqltest --password=mysqltest
>
> The command still hangs and do nothing.
>
> When I try:
>
> # /usr/bin/mysql -h test5 --user=xxx --user=xxx
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 159
> Server version: 5.0.26-standard-log MySQL Community Edition - Standard 
> (GPL)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql>
>
> Everything works , the connection is ok !
>
> I would really need sqlrelay for a project, and I don't like to do it 
> with "sequoia" because of its complexity.
>
> Thanks
> Michael
>
>
>> Try using:
>>
>>  
>>
>>  # /usr/bin/mysql -h test1 -P 9000 --user=mysqltest --password=mysqltest
>>
>>  
>>
>>  the user/password need to be the ones defined in the sqlrelay.conf 
>> file,
>>
>>  not the database's user/password.
>>
>>  
>>
>>  Alternatively, you could set authtier="database" and use the db
>>
>>  user/pass.
>>
>>  
>>
>>  David Muse
>>
>>  david.muse@fi...I cannot connect to sqlrelay using the mysql client.
>> I have the following configuration:
>>
>> MySQL 5.0.37
>> rudiments 0.30
>> sqlrelay 0.38
>> Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
>>
>> sqlrelay.conf
>>
>> <?xml version="1.0"?>
>> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
>> <instances>
>>
>>         <instance id="mysqltest" port="9000" socket="/tmp/mysql.sock" 
>> dbase="mysql" connections="3" maxconnections="5" maxqueuelength="0" 
>> growby="1" ttl="60" endofsession="commit" sessiontimeout="600" 
>> runauser="nobody" runasgroup="nobody" cursors="5" authtier="listener" 
>> handoff="pass">
>>                 <users>
>>                         <user user="mysqltest" password="mysqltest"/>
>>                 </users>
>>                 <connections>
>>                         <connection connectionid="mysqltest" 
>> string="user=xxx;password=xxx;db=testdb;host=test5" metric="1"/>
>>                 </connections>
>>         </instance>
>>
>> </instances>
>>
>> I'have started the instance using sqlr-start, then I've check the 
>> connection using sqlrsh, everything looks allright.
>>
>> # sqlrsh  -id mysqltest
>> SQLRShell - Version 0.22
>>         Connected to: localhost:9000 as mysqltest
>>
>>         type help; for a help.
>>
>> 0> ping;
>>         The database is up.
>> 0> quit;
>> #
>>
>> I tried to connect to sqlrelay using the following commands:
>>
>> # LD_PRELOAD=/usr/local/lib/libmysql50sqlrelay.so
>> # export LD_PRELOAD
>> # ldd /usr/bin/mysql
>>         /usr/local/lib/libmysql50sqlrelay.so (0x00804000)
>>         libncurses.so.5 => /usr/lib/libncurses.so.5 (0x049af000)
>>         libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00499000)
>>         libcrypt.so.1 => /lib/libcrypt.so.1 (0x00d93000)
>>         libnsl.so.1 => /lib/libnsl.so.1 (0x00d7b000)
>>         libm.so.6 => /lib/tls/libm.so.6 (0x0037b000)
>>         libc.so.6 => /lib/tls/libc.so.6 (0x0024d000)
>>         libsqlrclient-0.38.so.1 => 
>> /usr/local/lib/libsqlrclient-0.38.so.1 (0x006ec000)
>>         librudiments-0.30.so.1 => 
>> /usr/local/lib/librudiments-0.30.so.1 (0x00595000)
>>         libssl.so.4 => /lib/libssl.so.4 (0x00d45000)
>>         libcrypto.so.4 => /lib/libcrypto.so.4 (0x00881000)
>>         libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x0086b000)
>>         libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00111000)
>>         libcom_err.so.2 => /lib/libcom_err.so.2 (0x006cc000)
>>         libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x007ca000)
>>         libresolv.so.2 => /lib/libresolv.so.2 (0x004e2000)
>>         libz.so.1 => /usr/lib/libz.so.1 (0x003a6000)
>>         libpcre.so.0 => /lib/libpcre.so.0 (0x00176000)
>>         librt.so.1 => /lib/tls/librt.so.1 (0x00dea000)
>>         libdl.so.2 => /lib/libdl.so.2 (0x003a0000)
>>         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x003b6000)
>>         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00186000)
>>         /lib/ld-linux.so.2 (0x00233000)
>> # /usr/bin/mysql -h test1 -P 9000 --user=xxx --password=xxx
>>
>> The Command seems to do nothing. I've to press CTRL-C to stop it.
>>
>> What I'm doing wrong ?
>>
>> Thanks,
>> Michael
>>
>>   
>
>


-- 
--------------------------------------------------------------------------
Michael Roth                           email ro...@zi...
Certified Project Management Associate http://www.zid.tuwien.ac.at/michael_roth/
Zentraler Informatikdienst (ZID)       Tel. (++43-1) 588 01 - 42091
Technische Universitaet Wien           Fax. (++43-1) 588 01 - 42099
Wiedner Hauptstr. 8-10, A-1040 Wien

Re: [Sqlrelay-discussion] Problems with MySQL 5.0.37

[Michael R. <mr...@ma...>]

I tried:

# /usr/bin/mysql -h test1 -P 9000 --user=mysqltest --password=mysqltest

The command still hangs and do nothing.

When I try:

# /usr/bin/mysql -h test5 --user=xxx --user=xxx
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 159
Server version: 5.0.26-standard-log MySQL Community Edition - Standard (GPL)

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

mysql>

Everything works , the connection is ok !

I would really need sqlrelay for a project, and I don't like to do it with "sequoia" because of its complexity.

Thanks
Michael


> Try using:
>
>  
>
>  # /usr/bin/mysql -h test1 -P 9000 --user=mysqltest --password=mysqltest
>
>  
>
>  the user/password need to be the ones defined in the sqlrelay.conf file,
>
>  not the database's user/password.
>
>  
>
>  Alternatively, you could set authtier="database" and use the db
>
>  user/pass.
>
>  
>
>  David Muse
>
>  david.muse@fi...I cannot connect to sqlrelay using the mysql client.
> I have the following configuration:
>
> MySQL 5.0.37
> rudiments 0.30
> sqlrelay 0.38
> Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
>
> sqlrelay.conf
>
> <?xml version="1.0"?>
> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
> <instances>
>
>         <instance id="mysqltest" port="9000" socket="/tmp/mysql.sock" 
> dbase="mysql" connections="3" maxconnections="5" maxqueuelength="0" 
> growby="1" ttl="60" endofsession="commit" sessiontimeout="600" 
> runauser="nobody" runasgroup="nobody" cursors="5" authtier="listener" 
> handoff="pass">
>                 <users>
>                         <user user="mysqltest" password="mysqltest"/>
>                 </users>
>                 <connections>
>                         <connection connectionid="mysqltest" 
> string="user=xxx;password=xxx;db=testdb;host=test5" metric="1"/>
>                 </connections>
>         </instance>
>
> </instances>
>
> I'have started the instance using sqlr-start, then I've check the 
> connection using sqlrsh, everything looks allright.
>
> # sqlrsh  -id mysqltest
> SQLRShell - Version 0.22
>         Connected to: localhost:9000 as mysqltest
>
>         type help; for a help.
>
> 0> ping;
>         The database is up.
> 0> quit;
> #
>
> I tried to connect to sqlrelay using the following commands:
>
> # LD_PRELOAD=/usr/local/lib/libmysql50sqlrelay.so
> # export LD_PRELOAD
> # ldd /usr/bin/mysql
>         /usr/local/lib/libmysql50sqlrelay.so (0x00804000)
>         libncurses.so.5 => /usr/lib/libncurses.so.5 (0x049af000)
>         libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00499000)
>         libcrypt.so.1 => /lib/libcrypt.so.1 (0x00d93000)
>         libnsl.so.1 => /lib/libnsl.so.1 (0x00d7b000)
>         libm.so.6 => /lib/tls/libm.so.6 (0x0037b000)
>         libc.so.6 => /lib/tls/libc.so.6 (0x0024d000)
>         libsqlrclient-0.38.so.1 => 
> /usr/local/lib/libsqlrclient-0.38.so.1 (0x006ec000)
>         librudiments-0.30.so.1 => /usr/local/lib/librudiments-0.30.so.1 
> (0x00595000)
>         libssl.so.4 => /lib/libssl.so.4 (0x00d45000)
>         libcrypto.so.4 => /lib/libcrypto.so.4 (0x00881000)
>         libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x0086b000)
>         libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00111000)
>         libcom_err.so.2 => /lib/libcom_err.so.2 (0x006cc000)
>         libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x007ca000)
>         libresolv.so.2 => /lib/libresolv.so.2 (0x004e2000)
>         libz.so.1 => /usr/lib/libz.so.1 (0x003a6000)
>         libpcre.so.0 => /lib/libpcre.so.0 (0x00176000)
>         librt.so.1 => /lib/tls/librt.so.1 (0x00dea000)
>         libdl.so.2 => /lib/libdl.so.2 (0x003a0000)
>         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x003b6000)
>         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00186000)
>         /lib/ld-linux.so.2 (0x00233000)
> # /usr/bin/mysql -h test1 -P 9000 --user=xxx --password=xxx
>
> The Command seems to do nothing. I've to press CTRL-C to stop it.
>
> What I'm doing wrong ?
>
> Thanks,
> Michael
>
>   


-- 
Michael Roth                           email ro...@zi...
Certified Project Management Associate http://www.zserv.tuwien.ac.at/mroth/
Zentraler Informatikdienst (ZID)       Tel. (++43-1) 588 01 - 42091
Technische Universitaet Wien           Fax. (++43-1) 588 01 - 42099
Wiedner Hauptstr. 8-10, A-1040 Wien

Re: [Sqlrelay-discussion] Connecting to sql relay from mysql client

[CyberGod <cyb...@li...>]

David Muse wrote:
> Hello,
>
> Sorry for taking a while to respond.
>
> Make sure you're using the user/pass defined in your sqlrelay.conf file:
>
> mysql --port=9000 --host=10.0.0.1 --user=root --password=pass
>
> Other than that, and assuming you're using the LD_PRELOAD, it should
> work.
>
> Dave
> dav...@fi...
>
> On Fri, 2007-06-08 at 07:53 -0500, CyberGod wrote:
>   
>> Hi,
>> I successfully installed, configured and run the software. The only 
>> problem I have now is how to connect to it form a mysql client. Port 
>> 9000 is open (defined in the config file), the daemons are connected to 
>> the remote MySQL server based on host ip, user, pass and table and all 
>> services are running. I can remotely connect directly to the MySQL 
>> server using the same settings with the mysql command so its not a 
>> connectivity or mysql issue. Any suggestions where I can find log files 
>> if any?
>> Please advice how to test this setup with mysql client (I tried 
>> something like this: mysql --port=9000 --host=10.0.0.1 -pc@password, 
>> where the host ip is the ip of the server that sql-relay is running on).
>>
>> Here's my config file:
>>
>> <?xml version="1.0"?>
>> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
>>
>> <instances>
>>         <!-- Regular SQL Relay Instance -->
>>         <instance id="example" port="9000" socket="/tmp/example.socket" 
>> dbase="mysql" connections="3" maxconnections="15" maxqueuelength="5" 
>> growby="1" ttl="60" endofsession="commit" sessiontimeout="600" 
>> runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" 
>> handoff="pass" deniedips="" allowedips="" debug="none" 
>> maxquerysize="65536" maxstringbindvaluelength="4000" 
>> maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1" 
>> listenertimeout="0">
>>                 <users>
>>                         <user user="root" password="pass"/>
>>                 </users>
>>                 <connections>
>>                         <connection connectionid="db1" 
>> string="user=root;password=croot;db=test;host=10.0.0.10;port=3306;" 
>> metric="1" behindloadbalancer="no"/>
>>                 </connections>
>>         </instance>
>> </instances>
>>
>> Running processes:
>>
>> 11490 ?        Ss     0:00 sqlr-listener -id example -config 
>> /usr/local/firstworks/etc/sqlrelay.conf
>> 11492 ?        Ss     0:00 sqlr-connection-mysql -id example 
>> -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
>> 11494 ?        Ss     0:00 sqlr-connection-mysql -id example 
>> -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
>> 11496 ?        Ss     0:00 sqlr-connection-mysql -id example 
>> -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
>> 11502 ?        Ss     0:00 sqlr-cachemanager
>>
>>
>> Thanks.
>> Konstantin
>>
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by DB2 Express
>> Download DB2 Express C - the FREE version of DB2 express and take
>> control of your XML. No limits. Just data. Click to get it now.
>> http://sourceforge.net/powerbar/db2/
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>>
>>     
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> It just sits there doing nothing when I try to connect. I have no idea why, but everything else is exactly as specified. I wonder if it may be the library and my current mysql version.
>   

Re: [Sqlrelay-discussion] Connecting to sql relay from mysql client

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

Hello,

Sorry for taking a while to respond.

Make sure you're using the user/pass defined in your sqlrelay.conf file:

mysql --port=9000 --host=10.0.0.1 --user=root --password=pass

Other than that, and assuming you're using the LD_PRELOAD, it should
work.

Dave
dav...@fi...

On Fri, 2007-06-08 at 07:53 -0500, CyberGod wrote:
> Hi,
> I successfully installed, configured and run the software. The only 
> problem I have now is how to connect to it form a mysql client. Port 
> 9000 is open (defined in the config file), the daemons are connected to 
> the remote MySQL server based on host ip, user, pass and table and all 
> services are running. I can remotely connect directly to the MySQL 
> server using the same settings with the mysql command so its not a 
> connectivity or mysql issue. Any suggestions where I can find log files 
> if any?
> Please advice how to test this setup with mysql client (I tried 
> something like this: mysql --port=9000 --host=10.0.0.1 -pc@password, 
> where the host ip is the ip of the server that sql-relay is running on).
> 
> Here's my config file:
> 
> <?xml version="1.0"?>
> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
> 
> <instances>
>         <!-- Regular SQL Relay Instance -->
>         <instance id="example" port="9000" socket="/tmp/example.socket" 
> dbase="mysql" connections="3" maxconnections="15" maxqueuelength="5" 
> growby="1" ttl="60" endofsession="commit" sessiontimeout="600" 
> runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" 
> handoff="pass" deniedips="" allowedips="" debug="none" 
> maxquerysize="65536" maxstringbindvaluelength="4000" 
> maxlobbindvaluelength="71680" idleclienttimeout="-1" maxlisteners="-1" 
> listenertimeout="0">
>                 <users>
>                         <user user="root" password="pass"/>
>                 </users>
>                 <connections>
>                         <connection connectionid="db1" 
> string="user=root;password=croot;db=test;host=10.0.0.10;port=3306;" 
> metric="1" behindloadbalancer="no"/>
>                 </connections>
>         </instance>
> </instances>
> 
> Running processes:
> 
> 11490 ?        Ss     0:00 sqlr-listener -id example -config 
> /usr/local/firstworks/etc/sqlrelay.conf
> 11492 ?        Ss     0:00 sqlr-connection-mysql -id example 
> -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
> 11494 ?        Ss     0:00 sqlr-connection-mysql -id example 
> -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
> 11496 ?        Ss     0:00 sqlr-connection-mysql -id example 
> -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
> 11502 ?        Ss     0:00 sqlr-cachemanager
> 
> 
> Thanks.
> Konstantin
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

Re: [Sqlrelay-discussion] oracle 10

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

Yes.  Oracle 8,8i,9i and 10g are all supported.  When sqlrelay is built
against oracle 7, it uses an older api.  When built against 8,8i,9i or
10g, it uses the OCI8 api.

Dave
dav...@fi...

On Fri, 2007-06-15 at 11:17 -0400, Cosio, Dan wrote:
> Is there any support for oracle10.. I only see scripts for oracle7/8 .
> 
>  
> 
> Thanks
> 
>  
> 
>  
> 
> 
> 
> 
>  GenuNet
>   Online
>    Brand
>      and
>  Channel
> Protection
> 
> 
> 
>  
> 
> 
> Dan
> Cosio
> Software
> Engineer 
> 
> 
> Genuone,
>    Inc.,
> division
> of OpSec
> Security
>    Group
> 
>      320
> Congress
>      St,
> 7thFloor
>  Boston,
>       MA
>   02210 
> 
> 
> dc...@op... 
> 
> 
> tel: 
> mobile: 
> 
> 
> 617-226-3026 
> 617-283-0088 
> 
> 
> 
> 
> 
>  
> 
> 
> 
> Add me to your address book...
> 
> 
>         Want a signature like this?
> 
> 
> 
> 
>  
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

Re: [Sqlrelay-discussion] Problems with MySQL 5.0.37

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

Try using:

# /usr/bin/mysql -h test1 -P 9000 --user=mysqltest --password=mysqltest

the user/password need to be the ones defined in the sqlrelay.conf file,
not the database's user/password.

Alternatively, you could set authtier="database" and use the db
user/pass.

David Muse
dav...@fi...

On Mon, 2007-06-18 at 16:02 +0200, Michael Roth wrote:
> I cannot connect to sqlrelay using the mysql client.
> I have the following configuration:
> 
> MySQL 5.0.37
> rudiments 0.30
> sqlrelay 0.38
> Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
> 
> sqlrelay.conf
> 
> <?xml version="1.0"?>
> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
> <instances>
> 
>         <instance id="mysqltest" port="9000" socket="/tmp/mysql.sock" 
> dbase="mysql" connections="3" maxconnections="5" maxqueuelength="0" 
> growby="1" ttl="60" endofsession="commit" sessiontimeout="600" 
> runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" 
> handoff="pass">
>                 <users>
>                         <user user="mysqltest" password="mysqltest"/>
>                 </users>
>                 <connections>
>                         <connection connectionid="mysqltest" 
> string="user=xxx;password=xxx;db=testdb;host=test5" metric="1"/>
>                 </connections>
>         </instance>
> 
> </instances>
> 
> I'have started the instance using sqlr-start, then I've check the 
> connection using sqlrsh, everything looks allright.
> 
> # sqlrsh  -id mysqltest
> SQLRShell - Version 0.22
>         Connected to: localhost:9000 as mysqltest
> 
>         type help; for a help.
> 
> 0> ping;
>         The database is up.
> 0> quit;
> #
> 
> I tried to connect to sqlrelay using the following commands:
> 
> # LD_PRELOAD=/usr/local/lib/libmysql50sqlrelay.so
> # export LD_PRELOAD
> # ldd /usr/bin/mysql
>         /usr/local/lib/libmysql50sqlrelay.so (0x00804000)
>         libncurses.so.5 => /usr/lib/libncurses.so.5 (0x049af000)
>         libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00499000)
>         libcrypt.so.1 => /lib/libcrypt.so.1 (0x00d93000)
>         libnsl.so.1 => /lib/libnsl.so.1 (0x00d7b000)
>         libm.so.6 => /lib/tls/libm.so.6 (0x0037b000)
>         libc.so.6 => /lib/tls/libc.so.6 (0x0024d000)
>         libsqlrclient-0.38.so.1 => 
> /usr/local/lib/libsqlrclient-0.38.so.1 (0x006ec000)
>         librudiments-0.30.so.1 => /usr/local/lib/librudiments-0.30.so.1 
> (0x00595000)
>         libssl.so.4 => /lib/libssl.so.4 (0x00d45000)
>         libcrypto.so.4 => /lib/libcrypto.so.4 (0x00881000)
>         libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x0086b000)
>         libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00111000)
>         libcom_err.so.2 => /lib/libcom_err.so.2 (0x006cc000)
>         libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x007ca000)
>         libresolv.so.2 => /lib/libresolv.so.2 (0x004e2000)
>         libz.so.1 => /usr/lib/libz.so.1 (0x003a6000)
>         libpcre.so.0 => /lib/libpcre.so.0 (0x00176000)
>         librt.so.1 => /lib/tls/librt.so.1 (0x00dea000)
>         libdl.so.2 => /lib/libdl.so.2 (0x003a0000)
>         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x003b6000)
>         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00186000)
>         /lib/ld-linux.so.2 (0x00233000)
> # /usr/bin/mysql -h test1 -P 9000 --user=xxx --password=xxx
> 
> The Command seems to do nothing. I've to press CTRL-C to stop it.
> 
> What I'm doing wrong ?
> 
> Thanks,
> Michael
> 

[Sqlrelay-discussion] Problems with MySQL 5.0.37

[Michael R. <mr...@ma...>]

I cannot connect to sqlrelay using the mysql client.
I have the following configuration:

MySQL 5.0.37
rudiments 0.30
sqlrelay 0.38
Red Hat Enterprise Linux AS release 4 (Nahant Update 5)

sqlrelay.conf

<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>

        <instance id="mysqltest" port="9000" socket="/tmp/mysql.sock" 
dbase="mysql" connections="3" maxconnections="5" maxqueuelength="0" 
growby="1" ttl="60" endofsession="commit" sessiontimeout="600" 
runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" 
handoff="pass">
                <users>
                        <user user="mysqltest" password="mysqltest"/>
                </users>
                <connections>
                        <connection connectionid="mysqltest" 
string="user=xxx;password=xxx;db=testdb;host=test5" metric="1"/>
                </connections>
        </instance>

</instances>

I'have started the instance using sqlr-start, then I've check the 
connection using sqlrsh, everything looks allright.

# sqlrsh  -id mysqltest
SQLRShell - Version 0.22
        Connected to: localhost:9000 as mysqltest

        type help; for a help.

0> ping;
        The database is up.
0> quit;
#

I tried to connect to sqlrelay using the following commands:

# LD_PRELOAD=/usr/local/lib/libmysql50sqlrelay.so
# export LD_PRELOAD
# ldd /usr/bin/mysql
        /usr/local/lib/libmysql50sqlrelay.so (0x00804000)
        libncurses.so.5 => /usr/lib/libncurses.so.5 (0x049af000)
        libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00499000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x00d93000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x00d7b000)
        libm.so.6 => /lib/tls/libm.so.6 (0x0037b000)
        libc.so.6 => /lib/tls/libc.so.6 (0x0024d000)
        libsqlrclient-0.38.so.1 => 
/usr/local/lib/libsqlrclient-0.38.so.1 (0x006ec000)
        librudiments-0.30.so.1 => /usr/local/lib/librudiments-0.30.so.1 
(0x00595000)
        libssl.so.4 => /lib/libssl.so.4 (0x00d45000)
        libcrypto.so.4 => /lib/libcrypto.so.4 (0x00881000)
        libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x0086b000)
        libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00111000)
        libcom_err.so.2 => /lib/libcom_err.so.2 (0x006cc000)
        libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x007ca000)
        libresolv.so.2 => /lib/libresolv.so.2 (0x004e2000)
        libz.so.1 => /usr/lib/libz.so.1 (0x003a6000)
        libpcre.so.0 => /lib/libpcre.so.0 (0x00176000)
        librt.so.1 => /lib/tls/librt.so.1 (0x00dea000)
        libdl.so.2 => /lib/libdl.so.2 (0x003a0000)
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x003b6000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00186000)
        /lib/ld-linux.so.2 (0x00233000)
# /usr/bin/mysql -h test1 -P 9000 --user=xxx --password=xxx

The Command seems to do nothing. I've to press CTRL-C to stop it.

What I'm doing wrong ?

Thanks,
Michael

-- 
--------------------------------------------------------------------------
Michael Roth                           email ro...@zi...
Certified Project Management Associate http://www.zid.tuwien.ac.at/michael_roth/
Zentraler Informatikdienst (ZID)       Tel. (++43-1) 588 01 - 42091
Technische Universitaet Wien           Fax. (++43-1) 588 01 - 42099
Wiedner Hauptstr. 8-10, A-1040 Wien

[Sqlrelay-discussion] Connecting to sql relay from mysql client - addition

[CyberGod <cyb...@li...>]

I forgot to mention that my mysql client is version 5.0.41 and the 
drop-off library I use is
export LD_PRELOAD=/usr/local/firstworks/lib/libmysql50sqlrelay.so .
Still cannot connect though.