diff --git a/README.Fedora b/README.Fedora new file mode 100644 index 0000000..0541740 --- /dev/null +++ b/README.Fedora @@ -0,0 +1,71 @@ +# Upgrading poweradmin from 2.1.6 to 2.1.7 requires the following manual steps: + +## Updating instructions for 2.1.6: + + 1. dnf upgrade to 2.1.7 + 2. Backup your database + 3. Update database structure (see below) + 4. Execute migration script http://YOUR_HOSTNAME/migrations/201405302318_add_relations_to_zone_templates.php. + Later you can remove this file. + +## Database Update Instructions + +### MySQL + +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 +); + diff --git a/poweradmin.spec b/poweradmin.spec index bf2cb66..1ac4f40 100644 --- a/poweradmin.spec +++ b/poweradmin.spec @@ -1,6 +1,6 @@ Name: poweradmin -Version: 2.1.6 -Release: 8%{?dist} +Version: 2.1.7 +Release: 1%{?dist} Summary: A friendly web-based DNS administration tool for Bert Hubert's PowerDNS server Group: Applications/Internet @@ -9,6 +9,7 @@ URL: http://www.poweradmin.org Source0: https://www.poweradmin.org/download/%{name}-%{version}.tgz Source1: %{name}.conf Source2: %{name}-config.inc.php +Source3: README.Fedora BuildArch: noarch Requires: httpd @@ -24,15 +25,12 @@ PowerDNS. It has full support for all zone types (master, native and slave), for supermasters for automatic provisioning of slave zones, full support for IPv6 and comes with multi-language support. - %prep %setup -q -n %{name}-%{version} %build - %install -rm -rf %{buildroot} %{__mkdir} -pv %{buildroot}/%{_datadir}/%{name} %{__mkdir} -pv %{buildroot}/%{_sysconfdir}/httpd/conf.d/ %{__mkdir} -p %{buildroot}/%{_sysconfdir}/%{name} @@ -41,9 +39,12 @@ rm -rf %{buildroot} %{__cp} -pv %{SOURCE1} %{buildroot}/%{_sysconfdir}/httpd/conf.d/%{name}.conf %{__cp} %{SOURCE2} %{buildroot}/%{_sysconfdir}/%{name}/config.inc.php +%{__cp} %{SOURCE3} . ln -s %{_sysconfdir}/%{name}/config.inc.php %{buildroot}/%{_datadir}/%{name}/inc/config.inc.php %{__rm} -rfv %{buildroot}/%{_datadir}/%{name}/install +%{__rm} -rfv %{buildroot}/%{_datadir}/%{name}/README.md +%{__rm} -rfv %{buildroot}/%{_datadir}/%{name}/LICENSE %files %defattr(-,root,root,-) @@ -51,10 +52,13 @@ ln -s %{_sysconfdir}/%{name}/config.inc.php %{buildroot}/%{_datadir}/%{name}/inc %config(noreplace) %{_sysconfdir}/httpd/conf.d/%{name}.conf %dir %{_sysconfdir}/%{name} %config(noreplace) %{_sysconfdir}/%{name}/config.inc.php -%doc LICENSE README.markdown - +%doc LICENSE README.md README.Fedora %changelog +* Mon Feb 22 2016 Sven Lankes - 2.1.7-1 +- new upstream release +- Add README.Fedora listing manual steps required to upgrade from 2.1.6 + * Thu Feb 04 2016 Fedora Release Engineering - 2.1.6-8 - Rebuilt for https://fedoraproject.org/wiki/Fedora_24_Mass_Rebuild