Thread: [Sqlrelay-discussion] connect to sqlrelay (via mysql)

Brought to you by: mused

sqlrelay-discussion

[Sqlrelay-discussion] connect to sqlrelay (via mysql)

From: Thomas S. <t....@sy...> - 2011-12-02 15:34:19

Hello.

First of all. Interesting piece of software!

And now my first question.

I am able to use:

app1 etc # query 127.0.0.1 9000 /tmp/mysqltest.socket user1 password1
"show databases;"
"information_schema"
"oxid45"
"oxidsample"
app1 etc #

But is it also possible to connect via regular mysql command to
sqlrelay? Something like:

app1 etc # mysql -h 127.0.0.1 -P 9000 -uuser1 -ppasswrd1

Is that possible at all? I think i didn't understand that part. Any help
appreciated.

best regards
thomas


Thomas Stein
Systems Engineer

-- 
SysEleven GmbH
Umspannwerk - Aufgang C
Ohlauer Straße 43
10999 Berlin

Tel +49 30 233 2012 0
Fax +49 30 616 7555 0

http://www.syseleven.de
http://www.facebook.com/SysEleven

Aktueller System-Status immer unter:
http://www.twitter.com/syseleven

Firmensitz: Berlin
Registergericht: AG Berlin Charlottenburg, HRB 108571 B
Geschäftsführer: Marc Korthaus

Re: [Sqlrelay-discussion] connect to sqlrelay (via mysql)

From: Thomas S. <t....@sy...> - 2011-12-02 15:35:36

Am 02.12.11 16:03, schrieb Thomas Stein:
> Hello.
> 
> First of all. Interesting piece of software!
> 
> And now my first question.
> 
> I am able to use:
> 
> app1 etc # query 127.0.0.1 9000 /tmp/mysqltest.socket user1 password1
> "show databases;"
> "information_schema"
> "oxid45"
> "oxidsample"
> app1 etc #
> 
> But is it also possible to connect via regular mysql command to
> sqlrelay? Something like:
> 
> app1 etc # mysql -h 127.0.0.1 -P 9000 -uuser1 -ppasswrd1
> 
> Is that possible at all? I think i didn't understand that part. Any help
> appreciated.

Answering my question. Yes it is possible. But now i have another problem:

LD_PRELOAD=/usr/local/firstworks/lib/libmysql51sqlrelay.so
export LD_PRELOAD

app1 / # mysql -h localhost -P 9000 --user=user1 --password=password1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.3484
(pid=3469) Abnormal termination: signal 11 received
Your MySQL connection id is 0
Server version: 5.1.22

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql>

The connection seems immediately broken.
/usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.3484 shows no
errors but the client connection seem to remain:

app1 / # sqlr-status -id oxidtest
Warning: using default connectionid.
  Open   Server Connections:  3
  Opened Server Connections:  3

  Open   Client Connections:  1
  Opened Client Connections:  1

  Open   Server Cursors:      15
  Opened Server Cursors:      15

  Times  New Cursor Used:     1
  Times  Cursor Reused:       0

  Total  Queries:             0
  Total  Errors:              0

  Forked Listeners:           0

Scaler's view:
  Connections:                2
  Sessions:                   1

Semaphores:
  +---------------------------------------------+
  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  10 |
  +---+---+---+---+---+---+---+---+---+---+-----+
  | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 |   0 |
  +---------------------------------------------+

app1 / #

Hm.


> best regards
> thomas
> 
> 
> Thomas Stein
> Systems Engineer
> 


Thomas Stein
Systems Engineer

-- 
SysEleven GmbH
Umspannwerk - Aufgang C
Ohlauer Straße 43
10999 Berlin

Tel +49 30 233 2012 0
Fax +49 30 616 7555 0

http://www.syseleven.de
http://www.facebook.com/SysEleven

Aktueller System-Status immer unter:
http://www.twitter.com/syseleven

Firmensitz: Berlin
Registergericht: AG Berlin Charlottenburg, HRB 108571 B
Geschäftsführer: Marc Korthaus

Re: [Sqlrelay-discussion] connect to sqlrelay (via mysql)

From: David M. <dav...@fi...> - 2011-12-02 18:31:10

Hi Thomas,

I have recently done a LOT of work on the MySQL drop-in replacement 
library.  MySQL recently made a bunch of changes under-the-hood and I 
had to make changes to keep up with them.  It's possible that the 
problem you are encountering is a result of all that.  Try the code in 
CVS and see if it works better.

Here are the instructions for checking out the code from CVS:

export 
CVSROOT=:pserver:ano...@sq...:/cvsroot/sqlrelay
cvs login
cvs checkout sqlrelay

First though,  try explicitly using the socket parameter with the mysql 
program:

app1 / # mysql -h localhost -P 9000 --socket=/tmp/mysqltest.socket 
--user=user1 --password=password1

I think recent versions of mysql fall back to a default socket of 
/tmp/mysql.sock (or something like that) and ignore the specified port 
if the file exists.  So, in effect, without specifying the port, the 
mysql program ends up trying to talk to the mysql server rather than SQL 
Relay, but using the SQL Relay protocol.

Let me know if you run into any issues.

David Muse
dav...@fi...

On 12/02/2011 10:35 AM, Thomas Stein wrote:
> Am 02.12.11 16:03, schrieb Thomas Stein:
>> Hello.
>>
>> First of all. Interesting piece of software!
>>
>> And now my first question.
>>
>> I am able to use:
>>
>> app1 etc # query 127.0.0.1 9000 /tmp/mysqltest.socket user1 password1
>> "show databases;"
>> "information_schema"
>> "oxid45"
>> "oxidsample"
>> app1 etc #
>>
>> But is it also possible to connect via regular mysql command to
>> sqlrelay? Something like:
>>
>> app1 etc # mysql -h 127.0.0.1 -P 9000 -uuser1 -ppasswrd1
>>
>> Is that possible at all? I think i didn't understand that part. Any help
>> appreciated.
> Answering my question. Yes it is possible. But now i have another problem:
>
> LD_PRELOAD=/usr/local/firstworks/lib/libmysql51sqlrelay.so
> export LD_PRELOAD
>
> app1 / # mysql -h localhost -P 9000 --user=user1 --password=password1
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.3484
> (pid=3469) Abnormal termination: signal 11 received
> Your MySQL connection id is 0
> Server version: 5.1.22
>
> Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL v2 license
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> mysql>
>
> The connection seems immediately broken.
> /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.3484 shows no
> errors but the client connection seem to remain:
>
> app1 / # sqlr-status -id oxidtest
> Warning: using default connectionid.
>    Open   Server Connections:  3
>    Opened Server Connections:  3
>
>    Open   Client Connections:  1
>    Opened Client Connections:  1
>
>    Open   Server Cursors:      15
>    Opened Server Cursors:      15
>
>    Times  New Cursor Used:     1
>    Times  Cursor Reused:       0
>
>    Total  Queries:             0
>    Total  Errors:              0
>
>    Forked Listeners:           0
>
> Scaler's view:
>    Connections:                2
>    Sessions:                   1
>
> Semaphores:
>    +---------------------------------------------+
>    | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  10 |
>    +---+---+---+---+---+---+---+---+---+---+-----+
>    | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 |   0 |
>    +---------------------------------------------+
>
> app1 / #
>
> Hm.
>
>
>> best regards
>> thomas
>>
>>
>> Thomas Stein
>> Systems Engineer
>>
>
> Thomas Stein
> Systems Engineer
>



_______________________________________________________
Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
              http://www.doteasy.com

Re: [Sqlrelay-discussion] connect to sqlrelay (via mysql)

From: Thomas S. <t....@sy...> - 2011-12-05 08:19:45

Am 02.12.11 19:29, schrieb David Muse:
> Hi Thomas,

Hi David.

> I have recently done a LOT of work on the MySQL drop-in replacement 
> library.  MySQL recently made a bunch of changes under-the-hood and I 
> had to make changes to keep up with them.  It's possible that the 
> problem you are encountering is a result of all that.  Try the code in 
> CVS and see if it works better.
> 
> Here are the instructions for checking out the code from CVS:
> 
> export 
> CVSROOT=:pserver:ano...@sq...:/cvsroot/sqlrelay
> cvs login
> cvs checkout sqlrelay
> 
> First though,  try explicitly using the socket parameter with the mysql 
> program:
> 
> app1 / # mysql -h localhost -P 9000 --socket=/tmp/mysqltest.socket 
> --user=user1 --password=password1

Hm. Tried the cvs version but still the same:

app1 etc # mysql -h localhost -P 9000 --socket=/tmp/mysqltest.socket
--user=user1 --password=password1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.7369
(pid=7303) Abnormal termination: signal 11 received
Your MySQL connection id is 0
Server version: 5.1.22

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> show databases;
app1 etc #

By the way. What exactly ist the sqlrelay.dtd for? I really didn't
figured that out.

cheers
t.

> I think recent versions of mysql fall back to a default socket of 
> /tmp/mysql.sock (or something like that) and ignore the specified port 
> if the file exists.  So, in effect, without specifying the port, the 
> mysql program ends up trying to talk to the mysql server rather than SQL 
> Relay, but using the SQL Relay protocol.
> 
> Let me know if you run into any issues.
> 
> David Muse
> dav...@fi...
> 
> On 12/02/2011 10:35 AM, Thomas Stein wrote:
>> Am 02.12.11 16:03, schrieb Thomas Stein:
>>> Hello.
>>>
>>> First of all. Interesting piece of software!
>>>
>>> And now my first question.
>>>
>>> I am able to use:
>>>
>>> app1 etc # query 127.0.0.1 9000 /tmp/mysqltest.socket user1 password1
>>> "show databases;"
>>> "information_schema"
>>> "oxid45"
>>> "oxidsample"
>>> app1 etc #
>>>
>>> But is it also possible to connect via regular mysql command to
>>> sqlrelay? Something like:
>>>
>>> app1 etc # mysql -h 127.0.0.1 -P 9000 -uuser1 -ppasswrd1
>>>
>>> Is that possible at all? I think i didn't understand that part. Any help
>>> appreciated.
>> Answering my question. Yes it is possible. But now i have another problem:
>>
>> LD_PRELOAD=/usr/local/firstworks/lib/libmysql51sqlrelay.so
>> export LD_PRELOAD
>>
>> app1 / # mysql -h localhost -P 9000 --user=user1 --password=password1
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.3484
>> (pid=3469) Abnormal termination: signal 11 received
>> Your MySQL connection id is 0
>> Server version: 5.1.22
>>
>> Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
>> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
>> and you are welcome to modify and redistribute it under the GPL v2 license
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>> statement.
>>
>> mysql>
>>
>> The connection seems immediately broken.
>> /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.3484 shows no
>> errors but the client connection seem to remain:
>>
>> app1 / # sqlr-status -id oxidtest
>> Warning: using default connectionid.
>>    Open   Server Connections:  3
>>    Opened Server Connections:  3
>>
>>    Open   Client Connections:  1
>>    Opened Client Connections:  1
>>
>>    Open   Server Cursors:      15
>>    Opened Server Cursors:      15
>>
>>    Times  New Cursor Used:     1
>>    Times  Cursor Reused:       0
>>
>>    Total  Queries:             0
>>    Total  Errors:              0
>>
>>    Forked Listeners:           0
>>
>> Scaler's view:
>>    Connections:                2
>>    Sessions:                   1
>>
>> Semaphores:
>>    +---------------------------------------------+
>>    | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  10 |
>>    +---+---+---+---+---+---+---+---+---+---+-----+
>>    | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 |   0 |
>>    +---------------------------------------------+
>>
>> app1 / #
>>
>> Hm.
>>
>>
>>> best regards
>>> thomas
>>>
>>>
>>> Thomas Stein
>>> Systems Engineer
>>>
>>
>> Thomas Stein
>> Systems Engineer
>>
> 
> 
> 
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>               http://www.doteasy.com 
> 
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure 
> contains a definitive record of customers, application performance, 
> security threats, fraudulent activity, and more. Splunk takes this 
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion


Thomas Stein
Systems Engineer

-- 
SysEleven GmbH
Umspannwerk - Aufgang C
Ohlauer Straße 43
10999 Berlin

Tel +49 30 233 2012 0
Fax +49 30 616 7555 0

http://www.syseleven.de
http://www.facebook.com/SysEleven

Aktueller System-Status immer unter:
http://www.twitter.com/syseleven

Firmensitz: Berlin
Registergericht: AG Berlin Charlottenburg, HRB 108571 B
Geschäftsführer: Marc Korthaus

Re: [Sqlrelay-discussion] connect to sqlrelay (via mysql)

From: David M. <dav...@fi...> - 2011-12-29 08:08:35

Thomas,

I see that you have debugging turned on...

I recently fixed a bug that could cause this behavior if debugging of 
the connection is enabled.  The fix is in CVS.  A workaround is to 
disable debugging of the connection in the sqlrelay.conf file.  Set 
debug="none" or debug="listener" but not debug="listener_and_connection" 
or debug="connection".

You can also apply this fix directly.  Edit 
src/connection/sqlrconnection/returnresultsetdata.C and around line 67 
you should see code like:

         cursor->returnRow();

         if (dbgfile.debugEnabled()) {
             debugstr=new stringbuffer();
             dbgfile.debugPrint("connection",3,
                         debugstr->getString());
             delete debugstr;
         }

change it to:

         if (dbgfile.debugEnabled()) {
             debugstr=new stringbuffer();
         }

         cursor->returnRow();

         if (dbgfile.debugEnabled()) {
             dbgfile.debugPrint("connection",3,
                         debugstr->getString());
             delete debugstr;
         }

Let me know if that takes care of the problem or not.

Dave
dav...@fi...

On 12/05/2011 03:19 AM, Thomas Stein wrote:
> Am 02.12.11 19:29, schrieb David Muse:
>> Hi Thomas,
> Hi David.
>
>> I have recently done a LOT of work on the MySQL drop-in replacement
>> library.  MySQL recently made a bunch of changes under-the-hood and I
>> had to make changes to keep up with them.  It's possible that the
>> problem you are encountering is a result of all that.  Try the code in
>> CVS and see if it works better.
>>
>> Here are the instructions for checking out the code from CVS:
>>
>> export
>> CVSROOT=:pserver:ano...@sq...:/cvsroot/sqlrelay
>> cvs login
>> cvs checkout sqlrelay
>>
>> First though,  try explicitly using the socket parameter with the mysql
>> program:
>>
>> app1 / # mysql -h localhost -P 9000 --socket=/tmp/mysqltest.socket
>> --user=user1 --password=password1
> Hm. Tried the cvs version but still the same:
>
> app1 etc # mysql -h localhost -P 9000 --socket=/tmp/mysqltest.socket
> --user=user1 --password=password1
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.7369
> (pid=7303) Abnormal termination: signal 11 received
> Your MySQL connection id is 0
> Server version: 5.1.22
>
> Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL v2 license
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> mysql>  show databases;
> app1 etc #
>
> By the way. What exactly ist the sqlrelay.dtd for? I really didn't
> figured that out.
>
> cheers
> t.
>
>> I think recent versions of mysql fall back to a default socket of
>> /tmp/mysql.sock (or something like that) and ignore the specified port
>> if the file exists.  So, in effect, without specifying the port, the
>> mysql program ends up trying to talk to the mysql server rather than SQL
>> Relay, but using the SQL Relay protocol.
>>
>> Let me know if you run into any issues.
>>
>> David Muse
>> dav...@fi...
>>
>> On 12/02/2011 10:35 AM, Thomas Stein wrote:
>>> Am 02.12.11 16:03, schrieb Thomas Stein:
>>>> Hello.
>>>>
>>>> First of all. Interesting piece of software!
>>>>
>>>> And now my first question.
>>>>
>>>> I am able to use:
>>>>
>>>> app1 etc # query 127.0.0.1 9000 /tmp/mysqltest.socket user1 password1
>>>> "show databases;"
>>>> "information_schema"
>>>> "oxid45"
>>>> "oxidsample"
>>>> app1 etc #
>>>>
>>>> But is it also possible to connect via regular mysql command to
>>>> sqlrelay? Something like:
>>>>
>>>> app1 etc # mysql -h 127.0.0.1 -P 9000 -uuser1 -ppasswrd1
>>>>
>>>> Is that possible at all? I think i didn't understand that part. Any help
>>>> appreciated.
>>> Answering my question. Yes it is possible. But now i have another problem:
>>>
>>> LD_PRELOAD=/usr/local/firstworks/lib/libmysql51sqlrelay.so
>>> export LD_PRELOAD
>>>
>>> app1 / # mysql -h localhost -P 9000 --user=user1 --password=password1
>>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>>> Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.3484
>>> (pid=3469) Abnormal termination: signal 11 received
>>> Your MySQL connection id is 0
>>> Server version: 5.1.22
>>>
>>> Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
>>> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
>>> and you are welcome to modify and redistribute it under the GPL v2 license
>>>
>>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>>> statement.
>>>
>>> mysql>
>>>
>>> The connection seems immediately broken.
>>> /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.3484 shows no
>>> errors but the client connection seem to remain:
>>>
>>> app1 / # sqlr-status -id oxidtest
>>> Warning: using default connectionid.
>>>     Open   Server Connections:  3
>>>     Opened Server Connections:  3
>>>
>>>     Open   Client Connections:  1
>>>     Opened Client Connections:  1
>>>
>>>     Open   Server Cursors:      15
>>>     Opened Server Cursors:      15
>>>
>>>     Times  New Cursor Used:     1
>>>     Times  Cursor Reused:       0
>>>
>>>     Total  Queries:             0
>>>     Total  Errors:              0
>>>
>>>     Forked Listeners:           0
>>>
>>> Scaler's view:
>>>     Connections:                2
>>>     Sessions:                   1
>>>
>>> Semaphores:
>>>     +---------------------------------------------+
>>>     | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  10 |
>>>     +---+---+---+---+---+---+---+---+---+---+-----+
>>>     | 0 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 |   0 |
>>>     +---------------------------------------------+
>>>
>>> app1 / #
>>>
>>> Hm.
>>>
>>>
>>>> best regards
>>>> thomas
>>>>
>>>>
>>>> Thomas Stein
>>>> Systems Engineer
>>>>
>>> Thomas Stein
>>> Systems Engineer
>>>
>>
>>
>> _______________________________________________________
>> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>>                http://www.doteasy.com
>>
>> ------------------------------------------------------------------------------
>> All the data continuously generated in your IT infrastructure
>> contains a definitive record of customers, application performance,
>> security threats, fraudulent activity, and more. Splunk takes this
>> data and makes sense of it. IT sense. And common sense.
>> http://p.sf.net/sfu/splunk-novd2d
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
> Thomas Stein
> Systems Engineer
>



_______________________________________________________
Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
              http://www.doteasy.com