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: David M. <dav...@fi...> - 2009-05-28 15:52:55
|
Wow, this is quite a bug. Basically, if you don't have an addresses
attribute, then it won't listen for inet connections at all.
The patch and workaround are both correct though. Either should take
care of the problem.
I'm rolling this patch into the next release now. Thanks for finding
that Alexey.
David Muse
dav...@fi...
On Fri, 2009-05-22 at 01:29 +0400, Alex wrote:
> 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
>
>
>
>
__________________________________________________
D O T E A S Y - "Join the web hosting revolution!"
http://www.doteasy.com
|
