sqlrelay-discussion Mailing List for SQL Relay (Page 6)

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi Jan,

It looks like I introduced a bug in the last release.  Here is a quick fix:

Edit src/util/sqlrconfigfile.cpp and look for the following code, near 
line 558:

         // Filter section, nested (runquery*)
         case FILTER_TAG:
             currentname="filter";
             if (!charstring::compare(name,"runquery")) {
                 thistag=RUNQUERY_TAG;
             } else {
                 ok=false;
             }
             break;

         // Filter section, nested (runquery*)
         case ROUTE_TAG:
             currentname="route";
             if (!charstring::compare(name,"runquery")) {
                 thistag=RUNQUERY_TAG;
             } else {
                 ok=false;
             }
             break;

Change instances of "runquery" to "query" and RUNQUERY_TAG to QUERY_TAG, 
as follows:

         // Filter section, nested (query*)
         case FILTER_TAG:
             currentname="filter";
             if (!charstring::compare(name,"query")) {
                 thistag=QUERY_TAG;
             } else {
                 ok=false;
             }
             break;

         // Filter section, nested (query*)
         case ROUTE_TAG:
             currentname="route";
             if (!charstring::compare(name,"query")) {
                 thistag=QUERY_TAG;
             } else {
                 ok=false;
             }
             break;

I guess I got a little too aggressive with search and replace.  With 
those modifications, it should work as expected.

Sorry for the confusion.

David Muse
dav...@fi...

On 03/08/2012 06:31 AM, jan...@id... wrote:
> ok sorry.
> If I omit the query statements (which is senseless) I am able to start the router instance.
>
> # sqlr-start -id test -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
> Starting listener:
>    sqlr-listener -id test -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
>
> Starting 1 connections to defaultid :
>    sqlr-connection-router -id test -connectionid defaultid -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
>
> Starting scaler:
>    sqlr-scaler -id test -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
>
> cache manager already running.
> [...]
>
> But how can I use the query patterns sucessfully ?
>
> kind regards,
>
> ---
>
> Jan
> ________________________________________
> Von: Zeller, Jan (ID)
> Gesendet: Donnerstag, 8. März 2012 12:14
> An: sql...@li...
> Betreff: r/w splitting configuration question
>
> dear sqlrelay list,
>
> i try to configure r/w splitting.
>
> i am able to start the following instances "master"&  "slave" but not the router instance called "test".
>
> The error message is :
>
> unexpected tag<query>  within<route>
> Couldn't parse config file /opt/sqlrelay-0.44/etc/sqlrelay.conf.
> Couldn't find id test.
>
>
> By the way what is the purpose of "sqlr-connection-router" ?
> Should "sqlr-connection-router" or "sqlr-start" be used to start the router instance ?
> Anyway it fails with both programs.
>
> The config file used is nearly the same as stated on http://sqlrelay.sourceforge.net/sqlrelay/router.html
>
>
> # sqlr-start -id master -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
> [...]
> # sqlr-start -id slave -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
> [...]
>
> # pgrep -lf sql
> 27998 sqlr-listener -id master -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
> 28028 sqlr-connection-mysql -id master -connectionid db1 -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
> 28060 sqlr-scaler -id master -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
> 28067 sqlr-cachemanager
> 29266 sqlr-listener -id slave -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
> 29271 sqlr-connection-mysql -id slave -connectionid db1 -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
> 29288 sqlr-scaler -id slave -config /opt/sqlrelay-0.44/etc/sqlrelay.conf
>
> What am I doing wrong ?
> Any hints ?
>
> kind regards,
>
> Jan
>
> ------------------------------------------------------------------------------
> Virtualization&  Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com

2005	Jan	Feb (20)	Mar (27)	Apr (17)	May (32)	Jun (45)	Jul (49)	Aug (68)	Sep (44)	Oct (29)	Nov (64)	Dec (25)
2006	Jan (61)	Feb (22)	Mar (25)	Apr (31)	May (18)	Jun (28)	Jul (19)	Aug (16)	Sep (8)	Oct (17)	Nov (32)	Dec (4)
2007	Jan (20)	Feb (25)	Mar (5)	Apr (12)	May (11)	Jun (18)	Jul (16)	Aug (22)	Sep (37)	Oct (20)	Nov (11)	Dec (2)
2008	Jan (11)	Feb (33)	Mar (12)	Apr (18)	May (22)	Jun (31)	Jul (23)	Aug (6)	Sep	Oct (10)	Nov (22)	Dec
2009	Jan (12)	Feb (8)	Mar (11)	Apr (20)	May (18)	Jun (7)	Jul (27)	Aug (2)	Sep (10)	Oct (5)	Nov (2)	Dec (1)
2010	Jan (11)	Feb (18)	Mar (10)	Apr (28)	May (28)	Jun	Jul (27)	Aug (9)	Sep (21)	Oct (2)	Nov (2)	Dec (11)
2011	Jan	Feb (2)	Mar (4)	Apr (2)	May (2)	Jun (44)	Jul (9)	Aug (2)	Sep (12)	Oct (7)	Nov (11)	Dec (7)
2012	Jan (5)	Feb	Mar (9)	Apr (9)	May (12)	Jun	Jul (13)	Aug (3)	Sep (3)	Oct (1)	Nov (1)	Dec (10)
2013	Jan (21)	Feb (3)	Mar (4)	Apr	May (3)	Jun (2)	Jul (3)	Aug (3)	Sep (3)	Oct	Nov	Dec (4)
2014	Jan (7)	Feb	Mar (1)	Apr	May (2)	Jun	Jul (4)	Aug (2)	Sep	Oct (1)	Nov	Dec
2016	Jan	Feb	Mar (1)	Apr	May (1)	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2017	Jan	Feb (1)	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2018	Jan	Feb	Mar	Apr	May	Jun (1)	Jul	Aug	Sep	Oct	Nov	Dec
2021	Jan	Feb	Mar	Apr (3)	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2022	Jan	Feb	Mar	Apr	May	Jun (1)	Jul	Aug	Sep	Oct	Nov	Dec

sqlrelay-discussion Mailing List for SQL Relay (Page 6)

sqlrelay-discussion — Discussion of topics related to SQL Relay