[Pkg-nagios-changes] [pkg-nagios] r1080 - in nagios/trunk/debian: .
patches
Sean Finney
seanius at alioth.debian.org
Sat Dec 9 21:53:36 CET 2006
Author: seanius
Date: 2006-12-09 21:53:36 +0100 (Sat, 09 Dec 2006)
New Revision: 1080
Added:
nagios/trunk/debian/patches/17_create_pgsql-oids.dpatch
Modified:
nagios/trunk/debian/NEWS
nagios/trunk/debian/changelog
nagios/trunk/debian/patches/00list
Log:
pgsql oid fix
Modified: nagios/trunk/debian/NEWS
===================================================================
--- nagios/trunk/debian/NEWS 2006-12-09 18:59:19 UTC (rev 1079)
+++ nagios/trunk/debian/NEWS 2006-12-09 20:53:36 UTC (rev 1080)
@@ -1,3 +1,15 @@
+nagios (2:1.4-4) unstable; urgency=low
+
+ nagios-pgsql users: if you've installed the package on a postgresql-8.1
+ or newer database, your tables might not be created with the WITH OIDS
+ option (this was previously a default but no longer). if you have trouble
+ with host/service commments/downtime, you will need to drop those tables
+ and re-create them from the relevant portions of
+ /usr/share/doc/nagios-common/create_pgsql
+ (look for the tables created WITH OIDS).
+
+ -- sean finney <seanius at debian.org> Sat, 09 Dec 2006 21:51:57 +0100
+
nagios (2:1.3-cvs.20050402-9) unstable; urgency=low
the nagios init script now dynamically determines the location of
Modified: nagios/trunk/debian/changelog
===================================================================
--- nagios/trunk/debian/changelog 2006-12-09 18:59:19 UTC (rev 1079)
+++ nagios/trunk/debian/changelog 2006-12-09 20:53:36 UTC (rev 1080)
@@ -7,8 +7,15 @@
add-on grouplist.cgi feature, as discovered by Kai Pastor. also
added a note just above the configuration line mentioning that it's
required (closes: #368956).
+ * postgresql now creates tables defaulting to WITHOUT OIDS instead of
+ WITH OIDS, causing trouble for some parts of nagios-pgsql.
+ The relevant tables are now created explicitly WITH OIDS. Thanks to
+ Sven Riedel for first noticing this, and to Steinar Gunderson for
+ the follow-up consultation. existing nagios-pgsql users: see NEWS.Debian.
+ (closes: #401155).
+ patch: 17_create_pgsql-oids.dpatch
- -- sean finney <seanius at debian.org> Sat, 09 Dec 2006 19:58:09 +0100
+ -- sean finney <seanius at debian.org> Sat, 09 Dec 2006 21:52:38 +0100
nagios (2:1.4-3) unstable; urgency=low
Modified: nagios/trunk/debian/patches/00list
===================================================================
--- nagios/trunk/debian/patches/00list 2006-12-09 18:59:19 UTC (rev 1079)
+++ nagios/trunk/debian/patches/00list 2006-12-09 20:53:36 UTC (rev 1080)
@@ -15,3 +15,4 @@
13_config.h.in-traceroute_hardcoded.dpatch
15_submit_check_result_via_nsca-nagioshost.dpatch
16_CVE-2006-2162_content-length.dpatch
+17_create_pgsql-oids.dpatch
Added: nagios/trunk/debian/patches/17_create_pgsql-oids.dpatch
===================================================================
--- nagios/trunk/debian/patches/17_create_pgsql-oids.dpatch 2006-12-09 18:59:19 UTC (rev 1079)
+++ nagios/trunk/debian/patches/17_create_pgsql-oids.dpatch 2006-12-09 20:53:36 UTC (rev 1080)
@@ -0,0 +1,46 @@
+#! /bin/sh /usr/share/dpatch/dpatch-run
+## 17_create_pgsql-oids.dpatch by <seanius at localhost.localdomain>
+##
+## All lines beginning with `## DP:' are a description of the patch.
+## DP: No description.
+
+ at DPATCH@
+diff -urNad nagios-1.4~/contrib/database/create_pgsql nagios-1.4/contrib/database/create_pgsql
+--- nagios-1.4~/contrib/database/create_pgsql 2002-02-26 05:03:37.000000000 +0100
++++ nagios-1.4/contrib/database/create_pgsql 2006-12-09 20:52:17.000000000 +0100
+@@ -16,7 +16,7 @@
+ "persistent" int2 DEFAULT 0 NOT NULL,
+ "author_name" varchar(75),
+ "comment_data" varchar(1024)
+-);
++) WITH OIDS;
+
+
+ /* --------------------------------------------------------
+@@ -32,7 +32,7 @@
+ "duration" int8 DEFAULT 0 NOT NULL,
+ "author_name" varchar(75),
+ "comment_data" varchar(1024)
+-);
++) WITH OIDS;
+
+
+ /* --------------------------------------------------------
+@@ -154,7 +154,7 @@
+ "entry_time" timestamp NOT NULL,
+ "author_name" varchar(75),
+ "comment_data" varchar(1024)
+-);
++) WITH OIDS;
+
+
+ /* --------------------------------------------------------
+@@ -171,7 +171,7 @@
+ "duration" int8 DEFAULT 0 NOT NULL,
+ "author_name" varchar(75),
+ "comment_data" varchar(1024)
+-);
++) WITH OIDS;
+
+
+ /* --------------------------------------------------------
Property changes on: nagios/trunk/debian/patches/17_create_pgsql-oids.dpatch
___________________________________________________________________
Name: svn:executable
+ *
More information about the Pkg-nagios-changes
mailing list