[Pdns-users] errno - 128 with mysql

[Cliff Hayes]

I have to use 4.0.6 because authoritative + recursion was removed with 4.1.

I took your advice and ran the queries with the u/p used by pdns.
I can see that errno 128 means the field is blank.
In my pdns records table, the prio and auth fields are blank.
So to fix, should I put a 10 in all of the records for prio even though 
they are not MX records?  What should I put in the auth field?

To recap:
a) can I put 10 in all records for prio?
b) what should I put in auth for all records?


On 12/21/2018 2:49 AM, frank+pdns--- via Pdns-users wrote:
> 
> Hi Cliff,
> 
> Besides the question about 4.0 vs 4.1 that Remi brought up, MySQL errno 128 can mean a few things.
> 
> Could you try to issues those MySQL queries by hand, when connecting with the exact same user/password that PowerDNS uses to connect?
> 
> Frank Louwers
> Certified PowerDNS Consultant
> 
>> On 21 Dec 2018, at 09:26, Remi Gacogne <remi.gacogne at powerdns.com> wrote:
>>
>> Signed PGP part
>> Hi,
>>
>> On 12/20/18 7:25 PM, Cliff Hayes wrote:
>>> I have just successfully installed authoritative server 4.0.6 on Fedora
>>> 28.  It appears proper results are being returned on DNS queries but I
>>> and am now seeing the following errors which are new to me.  I tried
>>> putting in 2018122001 for all records as the change_date and nothing
>>> changed.  prio field is null.
>>
>>> Dec 20 12:14:32 Result field at row 0 column 2 has errno -128
>>
>> This sounds very similar to [1], which was fixed in 4.1.0 by [2]. Is
>> there any reason you are still using the 4.0.x branch instead of the
>> 4.1.x one?
>>
>> [1]: https://github.com/PowerDNS/pdns/issues/5675
>> [2]: https://github.com/PowerDNS/pdns/pull/5820
>>
>> Regards,
>> -- 
>> Remi Gacogne
>> PowerDNS.COM BV - https://www.powerdns.com/
>>
>>
>>
> 
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>