Re: [Sqlrelay-discussion] include config files using XML entities?

[Cal H. <ca...@fb...>]

Okay thanks for the info David.  It's not that important, just a nicety, as
you said.  I've got about 40 different database instances to manage, and it
would make it a little more convenient for puppet to manage.


---------------------------------------------------------------
Cal Heldenbrand
   Web Operations at FBS
   Creators of flexmls <http://flexmls.com>® and Spark
Platform<http://sparkplatform.com>
   ca...@fb...


On Wed, Jan 8, 2014 at 11:36 AM, David Muse <dav...@fi...>wrote:

> Hi Cal,
>
> Unfortunately, the ENTITY tag isn't currently supported.  SQL Relay uses
> a fairly simple XML parser from the Rudiments library that doesn't
> support a few things, including entity tags.  It does support "built-in"
> entities like &quot; and &apos; and &#110; and so forth, but not
> entities defined with the entity tag.
>
> It is on my to-do list.  It's funny, it's is actually one of the older
> tasks in my PM system but it's always been in the "nice-to-have"
> category and I just haven't gotten around to it yet.
>
> If it's is important to you guys, then I'd be happy to implement it for
> you on a contract basis.  Let me know if you're interested.
>
> Dave
> dav...@fi...
>
> On 1/7/2014 2:44 PM, Cal Heldenbrand wrote:
> > Hi everyone,
> >
> > Is it possible to create a file hierarchy for the config file using the
> > ENTITY tag in DOCTYPE?  Here's what I tried in sqlrelay.conf:
> >
> > --------------------------------------------------------
> > <?xml version="1.0"?>
> > <!DOCTYPE instances SYSTEM "sqlrelay.dtd" [
> >    <!ENTITY server1 SYSTEM "/opt/sqlrelay/etc/db2/server1.xml">
> > ]>
> > <instances>
> >    &server1;
> > </instances>
> > --------------------------------------------------------
> >
> > ----------------  server1.xml  --------------------
> > <instance id="server1"
> >     ...
> >>
> >     <connections> ...
> > </instance>
> > --------------------------------------------------------
> >
> > But, it seems that on startup, sql relay does not find my "server1"
> > instance and it fails, with no error logs or anything useful.
> >
> > # ./sqlr-start -id server1
> > Couldn't find id server1.
> >
> > Does the XML parser just plain not support doing include files?  Or can
> > you spot anything wrong with my syntax?  I'm certainly no XML expert.
> >
> > Thanks!
> >
> > --Cal
> >
> >
> >
> ------------------------------------------------------------------------------
> > Rapidly troubleshoot problems before they affect your business. Most IT
> > organizations don't have a clear picture of how application performance
> > affects their revenue. With AppDynamics, you get 100% visibility into
> your
> > Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
> AppDynamics Pro!
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> >
> > _______________________________________________________
> > Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
> >                http://www.doteasy.com
> >
> >
> >
> > _______________________________________________
> > 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
> >
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>