Re: [Sqlrelay-discussion] Fwd: problem config sqlrelay router

[Mark V. De V. <mv...@gm...>]

hi heiko,
did you get any response to your post?
I've been considering this project but it appears it may be dormant or
worse dead?

Were you able to get the SQLrelay working?

Appreciate any response you can offer.
Regards
Mark

On Nov 19, 2007 3:44 AM, Heiko L. <he...@fh...> wrote:
>
>
> hallo *!
>
>
> I try one config with router, but it does not work.
>
> - config:
>
>   psql ----- :9000 sqlrelay ------ :5432 postmaster
>   x.x.x.87      x.x.x.73               x.x.x.74
>
>
> $ egrep "instance |user |route " /usr/local/firstworks/etc/sqlrelay.conf |
> cut -c  1-70
>         <instance id="inspg1" port="9000" unixport="/tmp/psql.socket"
>                         <user user="smuser" password="smpass"/>
>                         <user user="smuser" password="smpass"/>
>                         <route host="x.x.x.74" port="5432" socket
>
>
> - Test route sqlrelay-0.35-10 (debian sarge)
>
> sqlrelay $ sqlr-start -id inspg1 -config
> /usr/local/firstworks/etc/sqlrelay.conf
>
>  Starting listener:
>    sqlr-listener -id inspg1 -config
> /usr/local/firstworks/etc/sqlrelay.conf Could not listen on inet port:
> 5432
>    Make sure that no other processes are listening on that port.
>
>
>    sqlr-listener failed to start.
>
> - Test route sqlrelay-0.39
>
> sqlrelay $ /usr/local/firstworks/bin/sqlr-start -id inspg1 ; netstat -anep
> | grep sqlr ;
>
>
> Starting listener:
>   sqlr-listener -id inspg1 -config /usr/local/firstworks/etc/sqlrelay.conf
>
> Starting 1 connections to defaultid :
>   sqlr-connection-router -id inspg1 -connectionid defaultid -config
> /usr/local/f
> irstworks/etc/sqlrelay.conf
>
> Starting cache manager:
>   sqlr-cachemanager
> Warning: using default id.
>
>
> tcp        0      0 0.0.0.0:9000            0.0.0.0:*               LISTEN
>     6
> 5534      18502296   5338/sqlr-listener
> tcp        0      0 0.0.0.0:52403           0.0.0.0:*               LISTEN
>     6
> 5534      18502793   5343/sqlr-connectio
> tcp        0      0 x.x.x.73:9000      x.x.x.87:54624     ESTABLISHED6
> 5534      18503113   5338/sqlr-listener
> unix  2      [ ACC ]     STREAM     LISTENING     18502297
> 5338/sqlr-listener  /tmp/psql.socket
> unix  2      [ ACC ]     STREAM     LISTENING     18502791
> 5343/sqlr-connectio /
>
> usr/local/firstworks/var/sqlrelay/tmp/sockets/6
>
> $ tail /var/log/postgresql/postgres.log;
> 2007-11-16 15:54:31 [6098] LOG:  connection received: host=x.x.x.73
> port=55699
> 2007-11-16 15:54:31 [6098] LOG:  invalid length of startup packet
> 2007-11-16 15:54:31 [6099] LOG:  connection received: host=x.x.x.73
> port=55700
> 2007-11-16 15:54:31 [6099] LOG:  invalid length of startup packet
>
>
> - summary:
>   - 0.35-10
>     - sqlrelay listen on :5432 , should be :9000
>   - 0.39
>     - sqlrelay listen on :9000, but not forward connection to postmaster
>
> Whats going wrong?
>
> regards heiko
>
>
>
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>