[Pdns-users] Help with mydns backend

[Rob Campbell]

Hi,

apologies, I've only just seen this. We've got a unique constraint on the
origin field of the soa table so we don't have any duplicates. We have
given up on the mydns backend though and will be moving to the generic one
when we've got time.

Thanks,

Rob.

On Mon, 18 Feb 2019 at 10:22, Otto Moerbeek <otto at drijf.net> wrote:

> On Mon, Feb 11, 2019 at 08:29:09AM +0100, Otto Moerbeek wrote:
>
> > On Fri, Feb 08, 2019 at 10:17:01AM +0000, Rob Campbell wrote:
> >
> > > Hi,
> > >
> > > max_connections is set to 500 and we're not hitting it.
> > >
> > > Thanks,
> > > Rob.
> >
> > I have looked at the mydns backend and spotted at least one potential
> > problem that would pop up if there are duplicate record in the soa
> > table (duplicate with respect to the "origin" column).
> >
> > Can you check if that's the case? A query like
> >
> > SELECT origin, COUNT(*) FROM soa-table GROUP by origin HAVING COUNT(*) >
> 1
> >
> > should do it (untested).
> >
> > That said, the mydns backend code contains warning to not use it for
> > anything more than very simple setups. So moving away from it to a
> > proper backend should be done.
> >
> >       -Otto
>
> No answer to this in a week.
>
> I've spent time on this, and I think it is common courtesy to answer.
> There is an explicit requests for information you can reply to, even
> if only with: we moved to the gmysql backend and the issue is no
> longer relevant to us.
>
>         -Otto
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20190219/ace0eb5e/attachment.html>