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

[Thomas S. <t....@sy...>]

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