v2.1.7
Edmondas Girkantas edited this page Feb 24, 2022
·
4 revisions
- Updated SQLlite database support (added to installer)
- Authentication against LDAP or Active Directory (experimental)
- Add language selection box on the logon screen.
- DNSSEC support (experimental, requires proper testing)
- Dynamic DNS script
- Listing of PTR records
- Incorrect records pagination in zone view
- Update zone template flushes all zones where template is used
- Wrong zone list order
- Other fixes
- dns_top_level_tld_check
- dns_third_level_check
- pdnssec_use and pdnssec_command
- ldap_use and other ldap_*
List of changes in this release: https://github.com/poweradmin/poweradmin/issues?milestone=2&page=1&state=closed
- Download latest tarball from GitHub
- Backup old files, replace everything with content from downloaded file
- From backup restore only inc/config.inc.php
- Backup your database
- Update database structure
Note: There is a possibility that this script will not work correctly, so instead use migration script from version 2.2.1.
- Execute migration script http://YOUR_HOSTNAME/migrations/201405302318_add_relations_to_zone_templates.php. Later you can remove this file.
MySQL Read some notes on migration to Inno DB
ALTER TABLE users ADD use_ldap BOOLEAN NOT NULL;
ALTER TABLE users ENGINE=InnoDB;
ALTER TABLE perm_items ENGINE=InnoDB;
ALTER TABLE perm_templ ENGINE=InnoDB;
ALTER TABLE perm_templ_items ENGINE=InnoDB;
ALTER TABLE zones ENGINE=InnoDB;
ALTER TABLE zone_templ ENGINE=InnoDB;
ALTER TABLE zone_templ_records ENGINE=InnoDB;
ALTER TABLE domainmetadata ENGINE=InnoDB;
ALTER TABLE cryptokeys ENGINE=InnoDB;
ALTER TABLE tsigkeys ENGINE=InnoDB;
ALTER TABLE domains ENGINE=InnoDB;
ALTER TABLE records ENGINE=InnoDB;
ALTER TABLE supermasters ENGINE=InnoDB;
CREATE TABLE records_zone_templ (
domain_id INTEGER NOT NULL,
record_id INTEGER NOT NULL,
zone_templ_id INTEGER NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE migrations (
version VARCHAR(255) NOT NULL,
apply_time INTEGER NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PostgreSQL
ALTER TABLE users ADD COLUMN use_ldap smallint NOT NULL DEFAULT 0;
CREATE TABLE records_zone_templ (
domain_id integer NOT NULL,
record_id integer NOT NULL,
zone_templ_id integer NOT NULL
);
CREATE TABLE migrations (
version varchar(255) NOT NULL,
apply_time integer NOT NULL
);
SQLite
ALTER TABLE users ADD use_ldap BOOLEAN NOT NULL DEFAULT 0;
CREATE TABLE records_zone_templ (
domain_id int(11) NOT NULL,
record_id int(11) NOT NULL,
zone_templ_id int(11) NOT NULL
);
CREATE TABLE migrations (
version varchar(255) NOT NULL,
apply_time int(11) NOT NULL
);