[Sqlrelay-discussion] help running

[Felipe C. - P. <fel...@gm...>]

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