[Sqlrelay-discussion] r/w splitting configuration question

[<jan...@id...>]

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