[Pdns-users] Oracle backend connection string.

[Margus Kiting]

Hi!

Thank You all for your help. I got Oracle backend working. Now I have one
minor problem.
I'm using Oracle 11G and I'm not able to change SOA record content cell.
I'm trying to create trigger which updates SOA serial after every INSERT
and UPDATE in records table, but trigger get's error saying there are
problem with mutating table.

Could someone please explain how to solve SOA serial change in oracle
backend?

Thank You in advance.
Margus Kiting


On 28 March 2013 13:12, Aki Tuomi <cmouse at youzen.ext.b2.fi> wrote:

> The oraclebackend has dnssec turned on by default, the schema seems to
> support
> it. AXFR seems to implemented as well.
>
> To get all configuration options for oracle backend, you can run
>
> pdns_server --config --launch=oracle
>
> I am working with getting oracle xe instance to work on my devkit ubuntu
> and then with mr. van Dijk to get the same setup replicated on pdns jenkins
> for continuous testing for both goracle and oracle backend.
>
> Aki
>
> On Thu, Mar 28, 2013 at 10:06:07AM +0200, Margus Kiting wrote:
> > Hi,
> >
> > Thanks all for infromation. I'll try this patch today. I have two more
> > questions. Have someone tried AXFR ACL's with oracle backend? is DNSSEC
> > enabled by default using oracle backend or it need some kind of
> > configuration flag? I cound not find any information from documentation.
> >
> > Best Regards,
> > Margus Kiting
> >
> > On 27 March 2013 22:44, a b <tripivceta at hotmail.com> wrote:
> >
> > > > Actually you can fix this with /etc/ld.so.conf, just make sure the
> lib
> > > dir(s)
> > > > are in, say, /etc/ld.so.conf.d/oracle or /etc/ld.so.conf and run
> > > ldconfig.
> > > >
> > > > no need to use LD_LIBRARY_PATH
> > >
> > > That only works on GNU/Linux; if the libraries and binaries are linked
> > > with -R, it is not necessary to set either LD_LIBRARY_PATH nor
> > > /etc/ld.so.conf, and that technique works on both GNU/Linux and all the
> > > System V UNIXes.
> > >
> > > As an additional measure, using the $ORIGIN link editor keyword will
> > > encode RUNPATH and RPATH into the ELF header,
> > >
> > > [9]     RUNPATH
> $ORIGIN:$ORIGIN/../lib:$ORIGIN/../../lib:/opt/lib
> > > [10]    RPATH
> $ORIGIN:$ORIGIN/../lib:$ORIGIN/../../lib:/opt/lib
> > >
> > > ...causing the runtime linker to look in the current directory of the
> > > binary/library first ($ORIGIN), then in the other paths relative to the
> > > directory where the binary/library are
> > > ($ORIGIN:$ORIGIN/../lib:$ORIGIN/../../lib). This feature is supported
> by
> > > GNU ld, and ld's in Solaris, IRIX and HP-UX, and possibly other UNIX
> > > operating systems.
> > >
> > > After this, binary executables and libraries can be relocated
> anywhere, so
> > > long as the relative filesystem structure is preserved.
> > >
> > > The neat thing about the $ORIGIN keyword is that it causes the linker
> to
> > > always correctly find symbols in libraries and binaries, without
> having to
> > > depend on LD_LIBRARY_PATH or /etc/ld.so.conf.
> > >
> > > I would pay good money to find out why Oracle does not do this with
> their
> > > instant client libraries.
> > > _______________________________________________
> > > Pdns-users mailing list
> > > Pdns-users at mailman.powerdns.com
> > > http://mailman.powerdns.com/mailman/listinfo/pdns-users
> > >
>
> > _______________________________________________
> > Pdns-users mailing list
> > Pdns-users at mailman.powerdns.com
> > http://mailman.powerdns.com/mailman/listinfo/pdns-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20130416/d4db9f26/attachment.html>