Re: [Sqlrelay-discussion] [sqlrelay] new instance won't start :-(

[David M. <dav...@fi...>]

This kind of problem is usually caused when the xml file has a problem,
like a missing double-quote or missing end-tag or something similar.

Try running xmllint on the sqlrelay.conf file and see if it turns up any
errors.

Dave
dav...@fi...

Roger wrote:
> 	My 'sqlrelay.conf' file had 3 instances defined. The first one is
> dummy on port 9000. Next two are separate MySQL databases that are
> functioning, on ports 9001 and 9002.
>
> 	I have (tried to) set up a development database for one of the two
> that are now running, but duplicating the production indstance and
> changing the port to 2003, the instance id to something unique, and the
> database name to the development database. (I also reduced the number of
> connections and cursors.)
>
> 	However, when I restart sqlrelay - I still only get the other two,
> and not the new one defined. I have tried moving the relative positions of
> the instance definitions, to no avail.
>
> 	Note: Excluding the dummy instance, there are 100 maxconnections
> for the other two instances, and 10 maxconnections for the newly defined
> (but not working) instance. The my.cnf file has 200 connections to MySQL,
> maximum.
>
> 	Anyone have ideas for tracking down and correcting the problem?
> Would this issue be getting logged somewhere that I'm not aware of?
>
> 	Thanks.
>
>