Re: [Sqlrelay-discussion] [SPAM] - sqlr-scaler error - Email found in subject
Brought to you by:
mused
|
From: Carlos V. <cve...@em...> - 2010-04-06 03:14:08
|
Search forums for setting up dummy instance in config file before your real instance. There is a bug with the XML parser. So you must create a dummy instance in the config.
Sent from CJ's iPhone
On Apr 5, 2010, at 9:50 PM, "Jason Lee" <dz...@ho...<mailto:dz...@ho...>> wrote:
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<http://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.
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...<mailto:Sql...@li...>
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
|