On 2015-11-22 12:19, a b wrote:
Good idea!

pdnssec check-zone dmz
Error: Received NULL where a value was expected

SQL> delete from records where (id = 16 or id = 66);

2 rows deleted.

SQL>  update zones set serial = 2015112209 where name = 'dmz';

1 row updated.

SQL> commit;

Commit complete.

# pdnssec check-zone dmz
Checked 18 records of 'dmz', 0 errors, 0 warnings.

...So my A record INSERT's are wrong?

Ahh, so it's Oracle, yeah I should have known from the SQL> prompt.

I didn't know the Oracle backend uses other table names, an euh.. interesting choice.

Never really looked at the Oracle backend code, so I had a quick look.

Maybe you don't have any TTLs (you didn't have them in the insert query) ?

It seems that would trigger an error:
https://github.com/PowerDNS/pdns/blob/master/modules/oraclebackend/oraclebackend.cc#L999

Maybe add a check like the example ?:
https://github.com/PowerDNS/pdns/blob/master/modules/oraclebackend/schema.oracle.sql#L121



_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users

Reply via email to