[Pdns-users] Help with mydns backend

[Otto Moerbeek]

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