Re: [Sqlrelay-discussion] [SPAM] - sqlr-scaler error - Email found in subject

[Carlos V. <cve...@em...>]

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&#174; 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