Bug 144383 - [Update] port dns/poweradmin 2.1.3 to 2.1.4
Summary: [Update] port dns/poweradmin 2.1.3 to 2.1.4
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: Normal Affects Only Me
Assignee: Wen Heping
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-03-01 08:50 UTC by Pavel Chudakov
Modified: 2010-04-09 17:10 UTC (History)
0 users

See Also:


Attachments
file.diff (2.06 KB, patch)
2010-03-01 08:50 UTC, Pavel Chudakov
no flags Details | Diff
poweradmin.diff.txt (7.75 KB, text/plain)
2010-03-14 16:16 UTC, Edmondas Girkantas
no flags Details
poweradmin214.patch (8.31 KB, patch)
2010-03-24 12:55 UTC, Edmondas Girkantas
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Pavel Chudakov 2010-03-01 08:50:02 UTC
2.1.4:
- Record, zone sorting by column.
- Updated error messages. 
- Display version in footer. 
- Fix headers already sent errors on some pages.
- Add link to edit zone success message.
- Integrate add record form into zone display.
- Add German translation. 
- Update German language translation.
- Allow dynamic DNS updates for DHCPd users.
- SPF Validation.
- Update serial when deleting records.
- Fix PHP warning about file not found, check if file exists.

- fix chmod 644 file config

Fix: Patch attached with submission follows:
Comment 1 Edwin Groothuis freebsd_committer freebsd_triage 2010-03-01 08:50:11 UTC
Class Changed
From-To: maintainer-update->change-request

Fix category (submitter is not maintainer) (via the GNATS Auto Assign 
Tool)
Comment 2 Edwin Groothuis freebsd_committer freebsd_triage 2010-03-01 08:50:14 UTC
Maintainer of dns/poweradmin,

Please note that PR ports/144383 has just been submitted.

If it contains a patch for an upgrade, an enhancement or a bug fix
you agree on, reply to this email stating that you approve the patch
and a committer will take care of it.

The full text of the PR can be found at:
    http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/144383

-- 
Edwin Groothuis via the GNATS Auto Assign Tool
edwin@FreeBSD.org
Comment 3 Edwin Groothuis freebsd_committer freebsd_triage 2010-03-01 08:50:15 UTC
State Changed
From-To: open->feedback

Awaiting maintainers feedback (via the GNATS Auto Assign Tool)
Comment 4 Wen Heping freebsd_committer freebsd_triage 2010-03-01 09:18:46 UTC
Responsible Changed
From-To: freebsd-ports-bugs->wen

I'll take it.
Comment 5 Edmondas Girkantas 2010-03-14 16:16:32 UTC
Hi,

Thank you Pavel for your PR.

Sorry for long response, but new poweradmin 2.1.4 has different
problems:

- poweradmin-*-db-structure.sql are missing the new tables
(https://www.poweradmin.org/trac/ticket/347)

- Template records added to database but not displayed nor inserted in
new zone (https://www.poweradmin.org/trac/ticket/346)

Therefore I created better patch to resolve these issues. See attached file.

Another thing - UPDATING file needs this info:

Upgrading from 2.1.x

Two tables were added to the database between 2.1.3 and 2.1.4, those need to be created manually when upgrading. An example in MySQL is:

CREATE TABLE zone_templ (
id int(11) NOT NULL auto_increment,
name varchar(128) NOT NULL,
descr varchar(1024) NOT NULL,
owner int(11) NOT NULL,
PRIMARY KEY (id)
);

CREATE TABLE zone_templ_records (
id int(11) NOT NULL auto_increment,
zone_templ_id int(11) NOT NULL,
name varchar(255) NOT NULL,
type varchar(6) NOT NULL,
content varchar(255) NOT NULL,
ttl int(11) NOT NULL,
prio int(11) NOT NULL,
PRIMARY KEY (id)
);

You can read about it here:
https://www.poweradmin.org/trac/wiki/ReleaseNotes/2.1.4

-- 
Edmondas Girkantas <eg@fbsd.lt>
Comment 6 Edmondas Girkantas 2010-03-24 12:55:26 UTC
A little bit updated patch.

How to apply;
cp -r /usr/ports/dns/poweradmin poweradmin
cd poweradmin
cat ../poweradmin214.patch | patch -p1
find ./ -name "*.orig" -delete

-- 
Edmondas Girkantas <eg@fbsd.lt>
Comment 7 dfilter service freebsd_committer freebsd_triage 2010-04-09 11:58:27 UTC
wen         2010-04-09 10:58:14 UTC

  FreeBSD ports repository

  Modified files:
    dns/poweradmin       Makefile distinfo 
  Added files:
    dns/poweradmin/files patch-poweradmin-mysql-db-structure.sql 
                         patch-poweradmin-pqsql-db-structure.sql 
                         patch-templates.inc.php 
  Log:
  - Update to 2.1.4
  
  PR:             ports/144383
  Submitted by:   Pavel Chudakov <sonic@4rm.ru>
  Approved by:    maintainer
  
  Revision  Changes    Path
  1.7       +10 -8     ports/dns/poweradmin/Makefile
  1.5       +3 -3      ports/dns/poweradmin/distinfo
  1.1       +62 -0     ports/dns/poweradmin/files/patch-poweradmin-mysql-db-structure.sql (new)
  1.1       +23 -0     ports/dns/poweradmin/files/patch-poweradmin-pqsql-db-structure.sql (new)
  1.1       +11 -0     ports/dns/poweradmin/files/patch-templates.inc.php (new)
_______________________________________________
cvs-all@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/cvs-all
To unsubscribe, send any mail to "cvs-all-unsubscribe@freebsd.org"
Comment 8 Wen Heping freebsd_committer freebsd_triage 2010-04-09 11:59:33 UTC
State Changed
From-To: feedback->closed

Committed. Thanks!