Uncaught 500 error from API for malformed SOA record about terraform-provider-powerdns HOT 2 OPEN

hi @m33x-7 thanks for reporting issue. I'll try to reproduce, but I need one clarification first. Is it possible to create malformed SOA using PowerDNS API, or do I have to use PowerAdmin (and is this it: https://github.com/poweradmin/poweradmin) or can I use pdnsutil or manually enter record into database?

Just a side note. In API curl section you left API key value in -H "X-API-Key: header, but removed it later on. If this is just some random key then OK, but if it is a production key, then you might want to consider changing it just in case.

from terraform-provider-powerdns.

Hi @mbag thanks for catching that, luckily not a production box but still not something I wanted to escape.

pdnsutil and the api enforce creation of the SOA with all the attributes that are supposed to be there. It looks like we've run into this because PowerAdmin is doing SQL writes directly, and SQL is how we've traditionally managed PowerDNS in production. However in production we're not using PowerAdmin, but a stored proc which is setting everything up correctly.

So at this point it's a pretty contrived failure, if you still want to try replicating it the following should do it:

INSERT INTO domains (name,type) VALUES ('example.com','MASTER');
SELECT id INTO @domain_id FROM domains WHERE name = 'example.com';
INSERT INTO records (domain_id,name,type,content,ttl) VALUES (@domain_id,'example.com','SOA',' 2020072902 10800 3600 604800 86400',86400);

from terraform-provider-powerdns.