PostgreSQL pdnssec secure-zone error
Closed this issue · 3 comments
nimbus powerdns # pdnssec secure-zone dal-01.v6.for-no-reason.net
Securing zone with rsasha256 algorithm with default key size
DBD::Pg::db last_insert_id failed: last_insert_id needs at least a sequence or table name at /etc/powerdns/rev.pl line 482, <> line 5.
Use of uninitialized value $kid in int at /etc/powerdns/rev.pl line 485, <> line 5.
DBD::Pg::db last_insert_id failed: last_insert_id needs at least a sequence or table name at /etc/powerdns/rev.pl line 482, <> line 8.
Use of uninitialized value $kid in int at /etc/powerdns/rev.pl line 485, <> line 8.
Zone dal-01.v6.for-no-reason.net secured
Adding NSEC ordering information
Properly secures the zone, no idea why it's throwing this error though.
This is because Postgres handles last_insert_id in different way than mysql. I'll look into it.
Can you test?
Issue has been fixed, Thanks!
nimbus powerdns # pdnssec secure-zone example.com
Securing zone with rsasha256 algorithm with default key size
Zone example.com secured
Adding NSEC ordering information