Bug 144383

Comment 1 Edwin Groothuis 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 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 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 2010-03-01 09:18:46 UTC

Responsible Changed
From-To: freebsd-ports-bugs->wen

I'll take it.

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>

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 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 2010-04-09 11:59:33 UTC

State Changed
From-To: feedback->closed

Committed. Thanks!