[Sqlrelay-discussion] Fwd: problem config sqlrelay router
Brought to you by:
mused
|
From: Heiko L. <he...@fh...> - 2007-11-18 17:20:35
|
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
|