Re: [Sqlrelay-discussion] SQL Relay 0.41 Couldn't parse config file sqlrelay.conf
Brought to you by:
mused
Menu
▾
▴
Re: [Sqlrelay-discussion] SQL Relay 0.41 Couldn't parse config file sqlrelay.conf
|
From: Alex <al...@lb...> - 2009-05-21 21:46:18
|
Hi all!
Problem in file
src/util/sqlrconfigfile.C
--------------
sqlrconfigfile::sqlrconfigfile() : xmlsax() {
addresses=new char *[1];
addresses[0]=charstring::duplicate("0.0.0.0");
addresscount=1; // in original file addresscount=0;
port=0;
listenoninet=false;
unixport=charstring::duplicate("");
listenonunix=false;
----------
Try patch file...
or add in config file parameter: addresses="0.0.0.0" not sure about
this...
addresscount=0 it's small error in code
addreses array length = 1 and addresscount must have 1
O> Hi all,
O> I've installed SQL Relay 0.41. There is error when I try to run
O> it. Initially my sqlrelay.conf is like this:
O> ------START CONFIG---------------
O> <?xml version="1.0"?>
O> <!DOCTYPE instances SYSTEM "sqlrelay.dtd">
O> <instances>
O> <instance id="mysql1" port="9000" socket="/tmp/mysql1.socket"
O> dbase="mysql" connections="3" maxconnections="20"
O> maxqueuelength="2" growby="1" ttl="60" maxsessioncount="10"
O> endofsession="commit" sessiontimeout="600" runasuser="nobody"
O> runasgroup="nobody" cursors="5" authtier="listener" handoff="pass"
O> deniedips="" allowedips="" debug="none" maxquerysize="65536"
O> maxstringbindvaluelength="32768" maxlobbindvaluelength="71680"
O> idleclienttimeout="-1" maxlisteners="-1" listenertimeout="0"
O> reloginatstart="no" timequeriessec="-1" timequeriesusec="-1">
O> <users>
O> <user user="user" password="pw"/>
O> </users>
O> <connections>
O> <connection connectionid="mysql1"
O> string="user=me;password=pass;db=db1;socket=/var/lib/mysql/mysql.sock"
O> metric="1" behindloadbalancer="no"/>
O> </connections>
O> </instance>
O> </instances>
O> ------END CONFIG---------------
O> When I run "sqlr-start -id mysql1", I get this:
O> --------START ERR MSG--------
O> Starting listener:
O> sqlr-listener -id mysql1 -config /usr/local/etc/sqlrelay.conf
O> Starting 3 connections to mysql1 :
O> sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf
O> sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf
O> sqlr-connection-mysql -id mysql1 -connectionid mysql1 -config /usr/local/etc/sqlrelay.conf
O> Starting scaler:
O> sqlr-scaler -id mysql1 -config /usr/local/etc/sqlrelay.conf
O> sqlr-scaler error:
O> The file /usr/local/var/sqlrelay/tmp/pids/sqlr-listener-mysql1 was not found.
O> This usually means that the sqlr-listener is not running.
O> The sqlr-listener must be running for the sqlr-scaler to start.
O> sqlr-scaler failed to start.
O> Thanks to MP3.com for sponsoring:
O> Clustered/Replicated database support.
O> Perl API.
O> Thanks to FeedLounge for sponsoring:
O> Query routing and filtering.
O> --------END ERR MSG--------
O> I followed a solution found at:
O> http://sourceforge.net/mailarchive/forum.php?thread_name=59D43F9401ECAC43BD3FADCC97D850A9012643DB%40sysm0030.sysinf.local&forum_name=sqlrelay-discussion
O> and added a dummy instance as first entry. When I try to run again, I get this error:
O> Couldn't parse config file /usr/local/etc/sqlrelay.conf.
O> Couldn't find id mysql1.
O> I've checked and sqlrelay.conf is readable by all groups. So I
O> assume it must a problem with the XML parser. I'm using 0.41 while
O> the person giving the solution is using 0.40. Not sure is there is
O> any change in both versions that makes the solution not working.
O> Anyone knows of a solution? Or will this be fixed in the coming versions?
O> Thanks,
O> Olivia
O> ------------------------------------------------------------------------------
O> Crystal Reports - New Free Runtime and 30 Day Trial
O> Check out the new simplified licensing option that enables
O> unlimited royalty-free distribution of the report engine
O> for externally facing server and web deployment.
O> http://p.sf.net/sfu/businessobjects
O> _______________________________________________
O> Sqlrelay-discussion mailing list
O> Sql...@li...
O> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
O> __________ NOD32 4084 (20090518) Information __________
O> This message was checked by NOD32 antivirus system.
O> http://www.eset.com
--
Best Regards
Alexey Leontev mailto:al...@lb...
|
