[Sqlrelay-discussion] sqlr-scaler error
Brought to you by:
mused
|
From: Jason L. <dz...@ho...> - 2010-04-06 02:49:22
|
Hello!
I have Rudiments 0.32, Sqlrelay 0.41 installed on a CentOS 5.4 32bit system,
but i just can not start sqlrelay, the error message is:
[root@mail bin]# ./sqlr-start -id postgresqltest
Starting listener:
sqlr-listener -id postgresqltest -config /usr/local/firstworks/etc/sqlrelay.conf
Starting 3 connections to postgresqltest :
sqlr-connection-postgresql -id postgresqltest -connectionid postgresqltest -config /usr/local/firstworks/etc/sqlrelay.conf
sqlr-connection-postgresql -id postgresqltest -connectionid postgresqltest -config /usr/local/firstworks/etc/sqlrelay.conf
sqlr-connection-postgresql -id postgresqltest -connectionid postgresqltest -config /usr/local/firstworks/etc/sqlrelay.conf
Starting scaler:
sqlr-scaler -id postgresqltest -config /usr/local/firstworks/etc/sqlrelay.conf
sqlr-scaler error:
The file /usr/local/firstworks/var/sqlrelay/tmp/pids/sqlr-listener-postgresqltest 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.
Thanks to MP3.com for sponsoring:
Clustered/Replicated database support.
Perl API.
Thanks to FeedLounge for sponsoring:
Query routing and filtering.
However, There are 3 files in the pids dir:
[root@mail bin]# cd /usr/local/firstworks/var/sqlrelay/tmp/pids/
[root@mail pids]# ls
sqlr-connection-postgresqltest.3136 sqlr-connection-postgresqltest.3139 sqlr-connection-postgresqltest.3142
[root@mail pids]#
The sqlrelay.conf is:
<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">
<instances>
<!-- Regular SQL Relay Instance -->
<instance id="postgresqltest" port="9001" socket="/tmp/postgresqltest.socket" dbase="postgresql" connections="3" maxconnections="15" maxqueuelength="0" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="pass">
<users>
<user user="user1" password="password1"/>
<user user="user2" password="password2"/>
<user user="user3" password="password3"/>
</users>
<connections>
<connection connectionid="postgresqltest" string="host=localhost;db=xxxxxx;user=xxxxxx;password=xxxxxx;" metric="1"/>
</connections>
</instance>
</instances>
What's wrong with it?
Regards.
|