[Sqlrelay-discussion] Fwd: problem config sqlrelay router

[Heiko L. <he...@fh...>]

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