[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