🐛 Bug Fixes

🔐 Authentication & LDAP

• Auth: Fixed LDAP Authentication with MFA integration issues (#813)
• Auth: Resolved LDAP Authentication PHP compatibility problems (#812)

🌐 Core System & Database

• Core: Fixed record comment not being saved while adding records (#814)
• Database: Resolved SQL syntax error causing database access violations (#810)
• UI: Fixed page crashes when clearing search field (#815)

🔧 DNS Management

• DNS: Added support for automatic splitting of long TXT records (e.g., DKIM) into 255-byte strings with configurable length options (#809)

🔒 DNSSEC

• DNSSEC: Fixed DNSSEC zone signing functionality (#819)
• DNSSEC: Resolved errors when using "DS and DNS keys" operations (#818)

Full Changelog: v4.0.3...v4.0.4

🐛 Bug Fixes

🌐 DNS & API

• API: Update SOA serial on all record operations (#804)
• API: Make pagination optional for zones and users endpoints (#803)
• API: Resolve Basic Auth TypeError when LDAP authentication is enabled (#799)
• DNS: Exclude reverse zones from forward zone listings
• Zones: Allow slave zone creation with delegation NS records (#802)
• PowerDNS: Add Basic Auth support for PowerDNS metrics endpoint (#800)

🖥️ User Interface

• UI: Correct checkbox handling in multi-record add form (#807)
• UI: Remove color classes preventing dark mode visibility (#801)

📧 Mail System

• Mail: Prevent email rejection due to long lines (#798)

Full Changelog: v4.0.2...v4.0.3

✨ Features

📊 User Interface & Experience

• User-configurable rows per page with session persistence - Users can now customize the number of rows displayed per page (10, 20, 50, 100) on list zones, search results, and zone edit pages. Preferences are stored in the session for convenience.

⚡ Performance Improvements

🗄️ Database Optimization

• Optimize zone listing performance with database indexes - Added missing database indexes on the zones table (domain_id and owner columns) across all database types (MySQL, PostgreSQL, SQLite). This provides 10-100x faster query performance when managing large numbers of zones (tested with 10,000+ zones).

🔧 Refactoring

🌐 DNS & Validation

• Extract core DNS record validators into dedicated class - Improved code organization by separating DNS record validation logic into focused, reusable validator classes.

📦 Database Migrations

Migration to v3.9.7

This release includes database schema updates. Run the appropriate migration script for your database:

MySQL:
mysql -u username -p database_name < sql/poweradmin-mysql-update-to-3.9.7.sql

PostgreSQL:
psql -U username -d database_name -f sql/poweradmin-pgsql-update-to-3.9.7.sql

SQLite:
sqlite3 /path/to/pdns.db < sql/poweradmin-sqlite-update-to-3.9.7.sql

What the migration does:

• Adds zones_domain_id_idx index on zones.domain_id column
• Adds zones_owner_idx index on zones.owner column

Note: These indexes significantly improve performance for zone listing queries, especially with large datasets.

Full Changelog: v3.9.6...v3.9.7

🐛 Bug Fixes

🌐 DNS & Validation

• Validation: Add CAA record validation (#790)

✨ Features

🌐 DNS & Validation

• Validation: Enhance DNS record validation

Full Changelog: v3.9.5...v3.9.6

🐛 Bug Fixes

🗃️ Database & Records

• Records: Exclude invalid database entries from queries (#758)
• Database: Standardize boolean parameter binding for MySQL strict mode compatibility
• Records: Handle null ptrZoneId in RecordCommentSyncService PTR record updates (#760)
• Database: Add migration scripts to fix password_reset_tokens default value (run sql/poweradmin-{database}-update-to-4.0.2.sql for your database type)

🔐 Authentication & Security

• Auth: Correct recovery code input validation length (#784)
• Auth: Include used field in password reset token creation

🌐 DNS & Validation

• Validation: Improve IP address validation (#794)
• DNS: Allow multiple instances of SPF mechanisms
• Validation: Support record type prefixes in LUA validator (#770)
• DNS: Correct SRV record validation to match PowerDNS format requirements (#755)
• Error Handling: Improve error handling for validation failures (#764)

🖥️ User Interface

• UI: Enable sorting by owner, id, and disabled status (#781)
• UI: Disable browser autofill for user creation (#782)
• UI: Clear form data and errors when switching between zones (#769)

📧 Mail & SMTP

• SMTP: Resolve authentication and response parsing issues
• Mail: Remove invalid SMTP headers causing server rejections (#774)

🔌 API & Infrastructure

• API: Resolve routing and method validation issues (#767)
• Docker: Resolve container startup validation logic (#766)

Full Changelog: v4.0.1...v4.0.2

🐛 Bug Fixes

• Add MySQL separate PowerDNS database configuration support for Docker
• Resolve validation errors in configuration migration from v3.9.2 to v4.0.0 (#754)
• Resolve config summary display when using custom config files
• Resolve user preference persistence and loading issues
• Move reverse zone filtering from PHP to database level (#751)
• Correct pagination calculation when filters are applied (#748)
• Resolve missing LDAP section in Add User form (#750)
• Add missing XML extension to installer requirements check (#745)

Full Changelog: v4.0.0...v4.0.1

This major release modernizes the DNS management interface after months of community collaboration, bringing enhanced security, improved performance, and a refreshed user experience. The codebase has been refactored to provide a solid foundation for future development while maintaining the simplicity users expect. Thanks to all contributors who helped make this milestone possible, with special recognition to @michielvisser for testing new features, providing valuable insights, and being incredibly helpful throughout, and to @muckl for his various contributions.

🚀 New Features

DNS Management

• Bulk record operations - UI for adding multiple records in a zone (#106, #306)
• CSV export - Export zone data to CSV format (#431)
• Template zone management - Show all domains using specified template and list zones per template (#280, #110)

User Management & Security

• Configurable password reset - Enable/disable reset functionality (#90)
• User preferences - Database-backed preferences with configurable display settings (#84)
• Password policy enforcement - Secure password policies across user management
• User agreement system - Comprehensive system with audit trail (#640)
• reCAPTCHA integration - Google reCAPTCHA for enhanced login security (#548)

System Integration

• WHOIS/RDAP support - WHOIS lookup page and Registration Data Access Protocol (#101)
• Installation requirements - Installer with requirements validation (#163)
• Database consistency checks - Infrastructure for database validation (#81)
• API implementation - Fundamental endpoints with key authentication
• OpenAPI documentation - Comprehensive API docs through Swagger
• FrankenPHP upgrade - Modern Docker image with hybrid configuration system (#568)
• Configurable settings - Database and DNS configuration options

User Interface

• Modernized dashboard - Modern card design with responsive layout and dark theme support
• Enhanced installer - Progress bar and consistent styling (#659)
• Form improvements - Required field indicators and smart zone name tips (#732, #715)
• Email template previews - Preview functionality with dark mode and plain text options

🐛 Bug Fixes & Improvements

DNS Record Management

• PTR record deletion - Fixed deletion of PTR records along with A records (#58)
• Duplicate PTR records - Resolved issue with duplicate identical PTR records (#115)
• CNAME validation - Fixed CNAME validator to properly reject non-FQDN content (#722)
• Root record CNAME warning - Added proper validation for CNAME records (#189)

System Improvements

• RFC compliance - Record validation following RFC standards (#271)
• Input validation - Sanitization and permission checks across controllers
• Navigation fixes - Corrected menu highlighting and form structure
• Timezone handling - Global timezone initialization during startup
• Configuration system overhaul - Centralized configuration management replacing legacy systems
• Cross-database compatibility - Support across MySQL, PostgreSQL, and SQLite
• Framework upgrades - Adopted Symfony components for validation and request handling

🔄 Migration Guide

For detailed upgrade instructions from v3.x to v4.0.0, please refer to the official migration guide.

New Contributors

• @psych0d0g made their first contribution in #654
• @ENGINYRING made their first contribution in #686
• @muckl made their first contribution in #693
• @michielvisser made their first contribution in #694
• @jozefrebjak made their first contribution in #740
• @sriccio made their first contribution in #742

Full Changelog: v3.9.4...v4.0.0

🐛 Bug Fixes

• Resolve MySQL ONLY_FULL_GROUP_BY compatibility in zone queries (#737)

Full Changelog: v3.9.4...v3.9.5

✨ Features

• Add configurable pagination rows per page (#485)

🐛 Bug Fixes

• Add missing return statements for type compliance

Full Changelog: v3.9.3...v3.9.4

🐛 Bug Fixes

• Add PowerDNS database prefix support for has_similar_records method (#709)
• Make letter navigation case-insensitive for zone filtering (#707)
• Add PostgreSQL compatibility for domain pagination with complex sorting (#706)
• Resolve pagination issue with domains having multiple owners (#706)

Full Changelog: v3.9.2...v3.9.3