Added sql to create additional database indices supporting deletion. Without

these indices web browser will often timeout before delete operation completes.

Update to libpreludedb 0.9.8. Changes:
- Always use prelude_escape_binary() when inserting additional data, even in case
  we're inserting a string, since the database field might be of a type that require
  binary kind of escaping. Fix #143.
- Implement reading of message_processing_model, security_model, security_level.
  Handling of community member is deprecated (IDMEFv16 update).
- Fix a bug where Service->ip_version would not be read from database.
- Error reporting improvement.

4 files changed, 17 insertions, 8 deletions

diff --git a/security/libpreludedb/Makefile b/security/libpreludedb/Makefile
index 987688bf9d7..ad304950da3 100644
--- a/security/libpreludedb/Makefile
+++ b/security/libpreludedb/Makefile
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.9 2006/05/20 18:47:20 joerg Exp $
+# $NetBSD: Makefile,v 1.10 2006/06/06 12:26:00 shannonjr Exp $
 #
 
-DISTNAME=		libpreludedb-0.9.7.1
-PKGREVISION=		1
+DISTNAME=		libpreludedb-0.9.8
 CATEGORIES=		security
 MASTER_SITES=		http://prelude-ids.org/download/releases/
 
@@ -25,6 +24,8 @@ LDFLAGS+=		${BUILDLINK_LDFLAGS.mysql-client}
 PYBINMODULE=		yes
 PY_PATCHPLIST=		yes
 
+post-install:
+	${INSTALL_DATA} ${FILESDIR}/addIndices.sql ${PREFIX}/share/libpreludedb/classic
 
 .include "../../security/libprelude/buildlink3.mk"
 .include "../../lang/python/application.mk"
diff --git a/security/libpreludedb/PLIST b/security/libpreludedb/PLIST
index 3218e6e2108..789a6f59ce6 100644
--- a/security/libpreludedb/PLIST
+++ b/security/libpreludedb/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.4 2006/05/20 18:47:20 joerg Exp $
+@comment $NetBSD: PLIST,v 1.5 2006/06/06 12:26:00 shannonjr Exp $
 bin/libpreludedb-config
 bin/preludedb-admin
 include/libpreludedb/preludedb-error.h
@@ -42,6 +42,9 @@ share/libpreludedb/classic/mysql-update-14-1.sql
 share/libpreludedb/classic/mysql-update-14-2.sql
 share/libpreludedb/classic/mysql-update-14-3.sql
 share/libpreludedb/classic/mysql-update-14-4.sql
+share/libpreludedb/classic/mysql-update-14-5.sql
+share/libpreludedb/classic/pgsql-update-14-5.sql
+share/libpreludedb/classic/sqlite-update-14-5.sql
 share/libpreludedb/classic/mysql.sql
 share/libpreludedb/classic/mysql2pgsql.sh
 share/libpreludedb/classic/mysql2sqlite.sh
@@ -49,6 +52,7 @@ share/libpreludedb/classic/pgsql-update-14-1.sql
 share/libpreludedb/classic/pgsql-update-14-2.sql
 share/libpreludedb/classic/pgsql-update-14-3.sql
 share/libpreludedb/classic/pgsql-update-14-4.sql
+share/libpreludedb/classic/addIndices.sql
 share/libpreludedb/classic/pgsql.sql
 share/libpreludedb/classic/sqlite.sql
 share/libpreludedb/classic/sqlite-update-14-4.sql
diff --git a/security/libpreludedb/distinfo b/security/libpreludedb/distinfo
index 5f32ca8aae4..e5946ac74fe 100644
--- a/security/libpreludedb/distinfo
+++ b/security/libpreludedb/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.6 2006/04/24 10:21:43 shannonjr Exp $
+$NetBSD: distinfo,v 1.7 2006/06/06 12:26:00 shannonjr Exp $
 
-SHA1 (libpreludedb-0.9.7.1.tar.gz) = 45033ccf4777284a4de5a7ead6a972242e18c094
-RMD160 (libpreludedb-0.9.7.1.tar.gz) = fcb728d19d4364534583cb68c2859ad92cf8bd04
-Size (libpreludedb-0.9.7.1.tar.gz) = 716862 bytes
+SHA1 (libpreludedb-0.9.8.tar.gz) = e78a07712b1e525d80a1b9ce2ce205de10c9c196
+RMD160 (libpreludedb-0.9.8.tar.gz) = a4b81aa9a067e7c9f9501c948b6993c51e8dbac2
+Size (libpreludedb-0.9.8.tar.gz) = 719497 bytes
diff --git a/security/libpreludedb/files/addIndices.sql b/security/libpreludedb/files/addIndices.sql
new file mode 100644
index 00000000000..0d27ada82c7
--- /dev/null
+++ b/security/libpreludedb/files/addIndices.sql
@@ -0,0 +1,4 @@
+alter table Prelude_Service add index (_message_ident,_parent_type);
+alter table Prelude_Service add index (_message_ident);
+alter table Prelude_Node add index (_message_ident,_parent_type);
+alter table Prelude_Process add index (_message_ident,_parent_type);