PDNS 4.2 (beta) compatibility

[Tatsu-Kishi]

Describe the bug
PowerDNS 4.2 removed the Autoserial feature and with that changed the schema, removing the change_date, currently requiring manual change of the schema to make it compatible with phpipam.

phpIPAM version
1.3.2

Versions of phpIPAM known to contain the issue.

• not tested: (Latest git master development branch.)
• Latest production release 1.3.2.

Your Environment (please supply the following information):

• phpIPAM version: 1.3.2
• OS: Ubuntu 64bit 16.04 (phpipam), 18.04 (pdns)
• PHP version php 7.0
• Webserver Apache
• Database MariaDB 10.2
• PDNS 4.2 (beta)

Steps To Reproduce
Please include steps to reproduce the issue:

1. Set up fresh PDNS install
2. Connect phpipam to PDNS database
3. Get "missing field change_date"
4. After fix of schema, Autoserial: On will yield Serial of 0 when querying PDNS for SOA record

A compatibility option in config.php or some autodetection magic would be great which disables the Autoserial option and expected database schema (or adjusts schema after confirmation).

[SpaceJelly]

It'd be great if this was corrected, we're on pdns 4.2.1 which is a release now.

Just tried playing with the module as it will speed things up, but the above error means it's now disabled again :(

[Tatsu-Kishi]

@SpaceJelly you can work around this by adding the field "change_date" to the "records" table in the pdns database and setting "Autoserial" to "off" in the phpipam pdns database settings.
MySQL query:
ALTER TABLE records ADD change_date int;

[SpaceJelly]

Thanks, but this other bug: #2947 is rather more problematic for us so am leaving it disabled for now!

[teadur]

In Meantime PDNS 4.2 has turned stable and released versions 4.3 and 4.4.
https://doc.powerdns.com/authoritative/changelog/

As of 4.1 is EOL and 4.2 will follow it next month out of box support for 4.3+ is desperately needed.
https://doc.powerdns.com/authoritative/appendices/EOL.html