Date: Mon, 19 Mar 2007 19:36:45 -0400 From: "Anish Mistry" <amistry@am-productions.biz> To: "FreeBSD gnats submit" <FreeBSD-gnats-submit@FreeBSD.org> Cc: tremere@cainites.net Subject: ports/110546: dns/powerdns Postgresql database init errors Message-ID: <1174347405.24445@bigguy.am-productions.biz> Resent-Message-ID: <200703192340.l2JNe2RS068467@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 110546
>Category: ports
>Synopsis: dns/powerdns Postgresql database init errors
>Confidential: no
>Severity: non-critical
>Priority: low
>Responsible: freebsd-ports-bugs
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: sw-bug
>Submitter-Id: current-users
>Arrival-Date: Mon Mar 19 23:40:01 GMT 2007
>Closed-Date:
>Last-Modified:
>Originator: Anish Mistry
>Release: FreeBSD 6.2-RELEASE i386
>Organization:
AM Productions
>Environment:
System: FreeBSD 6.2-RELEASE #0: Thu Feb 1 01:53:22 EST 2007
amistry@bigguy.am-productions.biz:/usr/home/amistry/storage/temp/usr/home/amistry/windows-share/build/src/sys/BIGGUY
>Description:
The postgresql database init script contains errors. Fixed attached.
>How-To-Repeat:
>Fix:
--- pdns_postgresql.sql.patch begins here ---
--- pdns_postgresql.sql.orig Mon Mar 19 19:14:57 2007
+++ pdns_postgresql.sql Mon Mar 19 19:22:32 2007
@@ -3,7 +3,7 @@
name VARCHAR(255) NOT NULL,
type VARCHAR(6) NOT NULL,
master VARCHAR(40) DEFAULT NULL,
- account VARCHAR(40) DEFAULT NULL
+ account VARCHAR(40) DEFAULT NULL,
notified_serial INT DEFAULT NULL,
last_check INT DEFAULT NULL,
CONSTRAINT pk_id
@@ -22,7 +22,7 @@
prio INT DEFAULT NULL,
content VARCHAR(255) DEFAULT NULL,
change_date INT DEFAULT NULL,
-CONSTRAINT pk_id
+CONSTRAINT pk_records_id
PRIMARY KEY (id),
CONSTRAINT fk_domainid
FOREIGN KEY (domain_id)
--- pdns_postgresql.sql.patch ends here ---
>Release-Note:
>Audit-Trail:
>Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1174347405.24445>