[Sqlrelay-discussion] Please help

[Henrik HJ <tes...@li...>]

Can you please help me. I can't connect to SQLRelay, when I try to connect. The client freeze and stop working.
 
I have 4 server:
Serv1: 10.131.50.191 Database #1
Serv2: 10.131.50.192 Database #2
Serv3: 10.131.50.193 SQLRelay
Serv4: 10.131.50.190 This is the server who have the client install.
 
Thanks in advance
 
Henrik
　
　
Startup shell script
#!/bin/sh
/usr/local/firstworks/bin/sqlr-start -id master
/usr/local/firstworks/bin/sqlr-start -id slave
/usr/local/firstworks/bin/sqlr-start -id router
　
SQLRELAY.CONF
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
<!-- This instance maintains connections to the "master" Postgresql database
on the masterdb machine. This instance only listens on the
unix socket /tmp/master.socket and thus cannot be connected to
by clients from another machine. -->
<instance id="master" port="" socket="/tmp/master.socket" dbase="postgresql" connections="3" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="4000" maxlobbindvaluelength="71680" idleclienttimeout="-1">
<users>
<user user="postgres" password="xxx"/>
</users>
<connections>
<connection connectionid="db" string="user=postgres;password=xxx;host=10.131.50.191;db=duc;" metric="1" behindloadbalancer="no"/>
</connections>
</instance>
　
<!-- This instance maintains connections to 1 "slave" Postgresql databases
on 1 slave machines. This instance only listens on the unix
socket /tmp/slave.socket and thus cannot be connected to by
clients from another machine. -->
<instance id="slave" port="" socket="/tmp/slave.socket" dbase="postgresql" connections="3" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="4000" maxlobbindvaluelength="71680" idleclienttimeout="-1">
<users>
<user user="postgres" password="xxx"/>
</users>
<connections>
<connection connectionid="db1" string="user=postgres;password=xxx;host=10.131.50.192;db=duc;" metric="1" behindloadbalancer="no"/>
</connections>
</instance>
　
<!-- This instance sends DML (insert,update,delete) and
DDL (create/delete) queries to the "master" SQL Relay instance
which, in turn, sends them to the "master" database.
This instance sends any other queries to the "slave" SQL Relay
instance which, in turn, distributes them over the "slave"
databases. -->
<instance id="router" port="9000" socket="/tmp/router.socket" dbase="router" connections="3" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass" deniedips="" allowedips="" debug="none" maxquerysize="65536" maxstringbindvaluelength="4000" maxlobbindvaluelength="71680" idleclienttimeout="-1">
<users>
<user user="postgres" password="xxx"/>
</users>
<router>
<!-- send all DML/DDL queries to "master" -->
<route host="" port="" socket="/tmp/master.socket" user="masteruser" password="masterpassword">
<query pattern="^\s*select\s+.*\s+from\s+"/>
<query pattern="^\s*insert\s+into\s+"/>
<query pattern="^\s*update\s+"/>
<query pattern="^\s*delete\s+from\s+"/>
<query pattern="^\s*drop\s+table\s+"/>
<query pattern="^\s*create\s+table\s+"/>
</route>
<!-- send all other queries to "slave" -->
<route host="" port="" socket="/tmp/slave.socket" user="slaveuser" password="slavepassword">
<query pattern=".*"/>
</route>
</router>
</instance>
</instances>
　
Output
Warning: using default id.
Starting listener:
sqlr-listener -id master -config /usr/local/firstworks/etc/sqlrelay.conf
Starting 3 connections to db :
sqlr-connection-postgresql -id master -connectionid db -config /usr/local/firstworks/etc/sqlrelay.conf
sqlr-connection-postgresql -id master -connectionid db -config /usr/local/firstworks/etc/sqlrelay.conf
sqlr-connection-postgresql -id master -connectionid db -config /usr/local/firstworks/etc/sqlrelay.conf
Starting scaler:
sqlr-scaler -id master -config /usr/local/firstworks/etc/sqlrelay.conf
Starting cache manager:
sqlr-cachemanager
　
Thanks to MP3.com for sponsoring: 
Clustered/Replicated database support.
Perl API.
Thanks to FeedLounge for sponsoring: 
Query routing and filtering.
Starting listener:
sqlr-listener -id slave -config /usr/local/firstworks/etc/sqlrelay.conf
Starting 3 connections to db1 :
sqlr-connection-postgresql -id slave -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
sqlr-connection-postgresql -id slave -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
sqlr-connection-postgresql -id slave -connectionid db1 -config /usr/local/firstworks/etc/sqlrelay.conf
Starting scaler:
sqlr-scaler -id slave -config /usr/local/firstworks/etc/sqlrelay.conf
cache manager already running.
　
Thanks to MP3.com for sponsoring: 
Clustered/Replicated database support.
Perl API.
Thanks to FeedLounge for sponsoring: 
Query routing and filtering.
Couldn't set autocommit off.
Couldn't set autocommit off.
Starting listener:
sqlr-listener -id router -config /usr/local/firstworks/etc/sqlrelay.conf
Starting 3 connections to defaultid :
sqlr-connection-router -id router -connectionid defaultid -config /usr/local/firstworks/etc/sqlrelay.conf
sqlr-connection-router -id router -connectionid defaultid -config /usr/local/firstworks/etc/sqlrelay.conf
sqlr-connection-router -id router -connectionid defaultid -config /usr/local/firstworks/etc/sqlrelay.conf
Starting scaler:
sqlr-scaler -id router -config /usr/local/firstworks/etc/sqlrelay.conf
cache manager already running.
　
Thanks to MP3.com for sponsoring: 
Clustered/Replicated database support.
Perl API.
Thanks to FeedLounge for sponsoring: 
Query routing and filtering.
Couldn't set autocommit off.
　
_________________________________________________________________
Få 25 GB lagerplads på nettet!
http://www.microsoft.com/danmark/windows/windowslive/products/skydrive.aspx