v2.1.7

Sebastian Sellmeier edited this page Apr 7, 2016 · 3 revisions

Features implemented

  • Updated SQLlite database support (added to installer)
  • Authentication against LDAP or Active Directory (experimental)
  • Add language selection box on the logon screen.

Improvements

  • DNSSEC support (experimental, requires proper testing)
  • Dynamic DNS script
  • Listing of PTR records

Bug-fixes

  • Incorrect records pagination in zone view
  • Update zone template flushes all zones where template is used
  • Wrong zone list order
  • Other fixes

Added new configuration settings

  • 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


Upgrading

Updating instructions for 2.1.6:

  1. Download latest tarball from GitHub
  2. Backup old files, replace everything with content from downloaded file
  3. From backup restore only inc/config.inc.php
  4. Backup your database
  5. Update database structure
  6. 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
);