[Pdns-users] API issue

[qutic development]

Hi Aki,

>> we are using PowerDNS version 4.2.2 and seeing errors creating subdomains via the api.
>> 
>> The following curl worked for years [1], but after an update to latest pdns version it is returning 500 http errors:
>> 
>> curl -i -s -XPATCH \
>> -H 'X-API-Key: $powerdns_api_key' \
>> https://$powerdns_host/api/v1/servers/localhost/zones/$domain -d '{
>> "rrsets": [
>> {
>> "name": "$subdomain.$domain.",
>> "type": "A",
>> "changetype": "REPLACE",
>> "ttl": 600,
>> "records": [
>> {
>> "content": "$ip",
>> "disabled": false
>> }
>> ]
>> }
>> ]
>> }'
>> 
>> HTTP ISE for "/api/v1/servers/localhost/zones/example.com": Exception: GSQLBackend unable to insert empty non-terminal rr '_domainkey.example.com' in domain_id 2: Could not execute mysql statement: insert into records (type,domain_id,disabled,name,ordername,auth,content,ttl,prio) values (null,?,0,?,?,?,NULL,NULL,NULL): Column 'type' cannot be null
> 
> Did you remember to update the schema as well?

Yes, I executed the documented schema changes.

- Stefan