[Sqlrelay-discussion] help running
Brought to you by:
mused
|
From: Felipe C. - P. <fel...@gm...> - 2009-02-10 12:57:14
|
Hello,
I upgraded from 39 to 40, when I try to start it, it says listener is
not ok.
If I run listener by hand, it starts ok.
any help is appreciated.
Thanks
-----------------------------------------------------------------------------------------------------------------------------------
sqlr-start -id clx_db -config /etc/sqlrelay.conf
Starting listener:
sqlr-listener -id clx_db -config /etc/sqlrelay.conf
Starting 15 connections to clx_db :
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
sqlr-connection-postgresql -id clx_db -connectionid clx_db -config
/etc/sqlrelay.conf
Starting scaler:
sqlr-scaler -id clx_db -config /etc/sqlrelay.conf
sqlr-scaler error:
The file
/usr/local/firstworks/var/sqlrelay/tmp/pids/sqlr-listener-clx_db was not
found.
This usually means that the sqlr-listener is not running.
The sqlr-listener must be running for the sqlr-scaler to start.
sqlr-scaler failed to start.
----------------------------------------------------------------------
My config file:
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
<instance id="clx_db" port="9000" socket="/tmp/clx_db.socket"
dbase="postgresql" connections="15" maxconnections="50"
maxqueuelength="0" growby="1" ttl="60" endofsession="commit"
sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5"
authtier="listener" handoff="pass">
<users>
<user user="postgres" password="password"/>
<user user="postgres" password="passwd"/>
<user user="postgres" password="pass"/>
<user user="postgres" password=""/>
</users>
<connections>
<!connection connectionid="clx_db"
string="host=localhost;db=clx_db;user=postgres;password=password"
metric="1"/>
<connection connectionid="clx_db"
string="host=/tmp;port=5432;db=clx_db;user=postgres;password=password"
metric="1"/>
</connections>
</instance>
</instances>
--
Felipe Ceglia - PY1NB
PR1T team member - Rio DX Group
http://www.dxwatch.com
http://skimmer.dxwatch.com
http://riodxgroup.dxwatch.com
|