[Bug]: Signing zones with DNSSEC is not possible #819
Description
Describe the problem
When clicking on "Sing zone" on a zone that is not signed, Poweradmin says: An error occurred while processing the request.
When I trace it via podman logs the following message is shown:
{"level":"info","ts":1761681000.2560663,"msg":"SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: boolean = integer\nLINE 5: AND disabled = 0\n ^\nHINT: No operator matches the given name and argument types. You might need to add explicit type casts.","syslog_level":"notice"}
{"level":"info","ts":1761681000.2564683,"msg":"#0 /app/lib/Domain/Service/ZoneValidationService.php(118): PDOStatement->execute(Array)\n#1 /app/lib/Domain/Service/ZoneValidationService.php(80): Poweradmin\\Domain\\Service\\ZoneValidationService->checkSoaRecord(4, 'example.org')\n#2 /app/lib/Application/Controller/EditController.php(338): Poweradmin\\Domain\\Service\\ZoneValidationService->validateZoneForDnssec(4, 'example.org')\n#3 /app/lib/Application/Routing/SymfonyRouter.php(166): Poweradmin\\Application\\Controller\\EditController->run()\n#4 /app/index.php(43): Poweradmin\\Application\\Routing\\SymfonyRouter->process()\n#5 {main}","syslog_level":"notice"}
Signing zones on the PowerDNS with pdnsutil works like a charm.
Steps to reproduce
- Add a new native zone (example.org)
- Click on "Sing zone"
- The error appears
Poweradmin version
Poweradmin v4.1.0 via docker.io
Database
PostgreSQL
Additional information (optional)
No response