A C implementation of the stored procedure written in plpgsql that's bundled

with OpenNMS, this is the preferred version for use as is offers better
performance

WWW: http://www.opennms.org/wiki/IPLIKE

PR:		ports/142581
Submitted by:	Sevan Janiyan <venture37 at geeklan.co.uk>

8 files changed, 318 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index f27c165d024c..bf4f8d99dbca 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -106,6 +106,7 @@
     SUBDIR += innotop
     SUBDIR += ip4r
     SUBDIR += ipa_sdb
+    SUBDIR += iplike
     SUBDIR += isql-viewer
     SUBDIR += jakarta-commons-dbutils
     SUBDIR += jasperreports
diff --git a/databases/iplike/142581 b/databases/iplike/142581
new file mode 100644
index 000000000000..904355871245
--- /dev/null
+++ b/databases/iplike/142581
@@ -0,0 +1,167 @@
+From nobody@FreeBSD.org  Sun Jan 10 17:09:43 2010
+Return-Path: <nobody@FreeBSD.org>
+Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
+	by hub.freebsd.org (Postfix) with ESMTP id 0645C106566B
+	for <freebsd-gnats-submit@FreeBSD.org>; Sun, 10 Jan 2010 17:09:43 +0000 (UTC)
+	(envelope-from nobody@FreeBSD.org)
+Received: from www.freebsd.org (www.freebsd.org [IPv6:2001:4f8:fff6::21])
+	by mx1.freebsd.org (Postfix) with ESMTP id E099A8FC13
+	for <freebsd-gnats-submit@FreeBSD.org>; Sun, 10 Jan 2010 17:09:42 +0000 (UTC)
+Received: from www.freebsd.org (localhost [127.0.0.1])
+	by www.freebsd.org (8.14.3/8.14.3) with ESMTP id o0AH9gcU022079
+	for <freebsd-gnats-submit@FreeBSD.org>; Sun, 10 Jan 2010 17:09:42 GMT
+	(envelope-from nobody@www.freebsd.org)
+Received: (from nobody@localhost)
+	by www.freebsd.org (8.14.3/8.14.3/Submit) id o0AH9gH0022072;
+	Sun, 10 Jan 2010 17:09:42 GMT
+	(envelope-from nobody)
+Message-Id: <201001101709.o0AH9gH0022072@www.freebsd.org>
+Date: Sun, 10 Jan 2010 17:09:42 GMT
+From: Sevan Janiyan <venture37@geeklan.co.uk>
+To: freebsd-gnats-submit@FreeBSD.org
+Subject: [new port] databases/iplike
+X-Send-Pr-Version: www-3.1
+X-GNATS-Notify:
+
+>Number:         142581
+>Category:       ports
+>Synopsis:       [new port] databases/iplike
+>Confidential:   no
+>Severity:       non-critical
+>Priority:       low
+>Responsible:    pgollucci
+>State:          open
+>Quarter:        
+>Keywords:       
+>Date-Required:  
+>Class:          change-request
+>Submitter-Id:   current-users
+>Arrival-Date:   Sun Jan 10 17:10:04 UTC 2010
+>Closed-Date:    
+>Last-Modified:  Sun Jan 10 23:46:03 UTC 2010
+>Originator:     Sevan Janiyan
+>Release:        
+>Organization:
+>Environment:
+>Description:
+
+>How-To-Repeat:
+
+>Fix:
+
+
+Patch attached with submission follows:
+
+# This is a shell archive.  Save it in a file, remove anything before
+# this line, and then unpack it by entering "sh file".  Note, it may
+# create directories; files and directories will be owned by you and
+# have default permissions.
+#
+# This archive contains:
+#
+#	.
+#	./Makefile
+#	./distinfo
+#	./pkg-descr
+#	./files
+#	./files/pkg-message.in
+#	./files/patch-install_iplike.sh.in
+#	./pkg-plist
+#
+echo c - .
+mkdir -p . > /dev/null 2>&1
+echo x - ./Makefile
+sed 's/^X//' >./Makefile << '464ef7c6571951809b23e262cbe26e19'
+X# New ports collection makefile for:	iplike
+X# Date created:		5 January 2010
+X# Whom:			Sevan Janiyan <venture37@geeklan.co.uk>
+X#
+X# $FreeBSD$
+X#
+X
+XPORTNAME=	iplike
+XPORTVERSION=	1.0.8
+XCATEGORIES=	databases
+XMASTER_SITES=	SF/opennms/IPLIKE/stable-1.0/
+X
+XMAINTAINER=	venture37@geeklan.co.uk
+XCOMMENT=	C implementation of the OpenNMS iplike stored procedure
+X
+XGNU_CONFIGURE=	yes
+XUSE_PGSQL=	yes
+XSUB_FILES=	pkg-message
+X
+X.include <bsd.port.pre.mk>
+X
+Xpost-install:
+X	@${CAT} ${PKGMESSAGE}
+X
+X.include <bsd.port.post.mk>
+464ef7c6571951809b23e262cbe26e19
+echo x - ./distinfo
+sed 's/^X//' >./distinfo << 'aec8793adfd5b7c3f00e62ae41a09ac2'
+XMD5 (iplike-1.0.8.tar.gz) = 85bcafd5e96a79e7d0ab6eee0b4b0b75
+XSHA256 (iplike-1.0.8.tar.gz) = f4c4a2ed00f538e4dd242189860969775a60fac0abab8683ad82061e40202802
+XSIZE (iplike-1.0.8.tar.gz) = 319791
+aec8793adfd5b7c3f00e62ae41a09ac2
+echo x - ./pkg-descr
+sed 's/^X//' >./pkg-descr << '0e313719ff012ceaf97a028d51caa8f5'
+XA C implementation of the stored procedure written in plpgsql that's bundled
+Xwith OpenNMS, this is the preferred version for use as is offers better
+Xperformance
+X
+XWWW: http://www.opennms.org/wiki/IPLIKE
+0e313719ff012ceaf97a028d51caa8f5
+echo c - ./files
+mkdir -p ./files > /dev/null 2>&1
+echo x - ./files/pkg-message.in
+sed 's/^X//' >./files/pkg-message.in << 'f63be51668f70461c30a5539f7c148ef'
+X| Don't forget to run %%PREFIX%%/sbin/install_iplike.sh to make the relevant
+X| changes to your OpenNMS database.
+X| To confirm the changes have been made run:
+X| psql -U opennms -h localhost -c '\df+ iplike' | head
+X| Check the Language column, It should say "c" and not "plpgsql"
+f63be51668f70461c30a5539f7c148ef
+echo x - ./files/patch-install_iplike.sh.in
+sed 's/^X//' >./files/patch-install_iplike.sh.in << 'ded61e823b9bea920c1e8720425fff1c'
+X--- install_iplike.sh.in.orig	2010-01-05 19:52:07.000000000 +0000
+X+++ install_iplike.sh.in	2010-01-05 19:53:15.000000000 +0000
+X@@ -5,7 +5,7 @@
+X libdir="@libdir@"
+X 
+X [ -z "$PG_DATABASE" ] && PG_DATABASE="opennms"
+X-[ -z "$PG_USER"     ] && PG_USER="postgres"
+X+[ -z "$PG_USER"     ] && PG_USER="pgsql"
+X [ -z "$PG_HOST"     ] && PG_HOST="localhost"
+X [ -z "$PG_PORT"     ] && PG_PORT="5432"
+X [ -z "$PG_PSQL"     ] && PG_PSQL="@PSQL_BINDIR@/psql"
+ded61e823b9bea920c1e8720425fff1c
+echo x - ./pkg-plist
+sed 's/^X//' >./pkg-plist << 'ef3e7f63841ae908ba397c2bef1fbad6'
+Xlib/iplike.la
+Xlib/iplike.so
+Xsbin/install_iplike.sh
+ef3e7f63841ae908ba397c2bef1fbad6
+exit
+
+
+
+>Release-Note:
+>Audit-Trail:
+Class-Changed-From-To: maintainer-update->change-request 
+Class-Changed-By: edwin 
+Class-Changed-When: Sun Jan 10 17:10:52 UTC 2010 
+Class-Changed-Why:  
+Fix category (new ports should be change-requests) (via the GNATS Auto 
+Assign Tool) 
+
+http://www.freebsd.org/cgi/query-pr.cgi?pr=142581 
+Responsible-Changed-From-To: freebsd-ports-bugs->pgollucci 
+Responsible-Changed-By: pgollucci 
+Responsible-Changed-When: Sun Jan 10 23:46:02 UTC 2010 
+Responsible-Changed-Why:  
+I'll take it. 
+
+http://www.freebsd.org/cgi/query-pr.cgi?pr=142581 
+>Unformatted:
+
diff --git a/databases/iplike/Makefile b/databases/iplike/Makefile
new file mode 100644
index 000000000000..197346ae810d
--- /dev/null
+++ b/databases/iplike/Makefile
@@ -0,0 +1,28 @@
+# New ports collection makefile for:	iplike
+# Date created:		5 January 2010
+# Whom:			Sevan Janiyan <venture37@geeklan.co.uk>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	iplike
+PORTVERSION=	1.0.8
+CATEGORIES=	databases
+MASTER_SITES=	SF/opennms/IPLIKE/stable-1.0/
+
+MAINTAINER=	venture37@geeklan.co.uk
+COMMENT=	C implementation of the OpenNMS iplike stored procedure
+
+GNU_CONFIGURE=	yes
+USE_LDCONFIG=	yes
+USE_PGSQL=	yes
+SUB_FILES=	pkg-message
+
+PLIST_FILES=	lib/iplike.la \
+	lib/iplike.so \
+	sbin/install_iplike.sh
+
+post-install:
+	@${CAT} ${PKGMESSAGE}
+
+.include <bsd.port.mk>
diff --git a/databases/iplike/distinfo b/databases/iplike/distinfo
new file mode 100644
index 000000000000..65fceb4a40be
--- /dev/null
+++ b/databases/iplike/distinfo
@@ -0,0 +1,3 @@
+MD5 (iplike-1.0.8.tar.gz) = 85bcafd5e96a79e7d0ab6eee0b4b0b75
+SHA256 (iplike-1.0.8.tar.gz) = f4c4a2ed00f538e4dd242189860969775a60fac0abab8683ad82061e40202802
+SIZE (iplike-1.0.8.tar.gz) = 319791
diff --git a/databases/iplike/files/patch-install_iplike.sh.in b/databases/iplike/files/patch-install_iplike.sh.in
new file mode 100644
index 000000000000..b4618d0f89c8
--- /dev/null
+++ b/databases/iplike/files/patch-install_iplike.sh.in
@@ -0,0 +1,11 @@
+--- install_iplike.sh.in.orig	2010-01-05 19:52:07.000000000 +0000
++++ install_iplike.sh.in	2010-01-05 19:53:15.000000000 +0000
+@@ -5,7 +5,7 @@
+ libdir="@libdir@"
+ 
+ [ -z "$PG_DATABASE" ] && PG_DATABASE="opennms"
+-[ -z "$PG_USER"     ] && PG_USER="postgres"
++[ -z "$PG_USER"     ] && PG_USER="pgsql"
+ [ -z "$PG_HOST"     ] && PG_HOST="localhost"
+ [ -z "$PG_PORT"     ] && PG_PORT="5432"
+ [ -z "$PG_PSQL"     ] && PG_PSQL="@PSQL_BINDIR@/psql"
diff --git a/databases/iplike/files/pkg-message.in b/databases/iplike/files/pkg-message.in
new file mode 100644
index 000000000000..d1fd47751ea6
--- /dev/null
+++ b/databases/iplike/files/pkg-message.in
@@ -0,0 +1,5 @@
+| Don't forget to run %%PREFIX%%/sbin/install_iplike.sh to make the relevant
+| changes to your OpenNMS database.
+| To confirm the changes have been made run:
+| psql -U opennms -h localhost -c '\df+ iplike' | head
+| Check the Language column, It should say "c" and not "plpgsql"
diff --git a/databases/iplike/pkg-descr b/databases/iplike/pkg-descr
new file mode 100644
index 000000000000..b44cc213c9a3
--- /dev/null
+++ b/databases/iplike/pkg-descr
@@ -0,0 +1,5 @@
+A C implementation of the stored procedure written in plpgsql that's bundled
+with OpenNMS, this is the preferred version for use as is offers better
+performance
+
+WWW: http://www.opennms.org/wiki/IPLIKE
diff --git a/databases/iplike/pr-patch b/databases/iplike/pr-patch
new file mode 100644
index 000000000000..ef628d2be789
--- /dev/null
+++ b/databases/iplike/pr-patch
@@ -0,0 +1,98 @@
+
+
+Patch attached with submission follows:
+
+# This is a shell archive.  Save it in a file, remove anything before
+# this line, and then unpack it by entering "sh file".  Note, it may
+# create directories; files and directories will be owned by you and
+# have default permissions.
+#
+# This archive contains:
+#
+#	.
+#	./Makefile
+#	./distinfo
+#	./pkg-descr
+#	./files
+#	./files/pkg-message.in
+#	./files/patch-install_iplike.sh.in
+#	./pkg-plist
+#
+echo c - .
+mkdir -p . > /dev/null 2>&1
+echo x - ./Makefile
+sed 's/^X//' >./Makefile << '464ef7c6571951809b23e262cbe26e19'
+X# New ports collection makefile for:	iplike
+X# Date created:		5 January 2010
+X# Whom:			Sevan Janiyan <venture37@geeklan.co.uk>
+X#
+X# $FreeBSD$
+X#
+X
+XPORTNAME=	iplike
+XPORTVERSION=	1.0.8
+XCATEGORIES=	databases
+XMASTER_SITES=	SF/opennms/IPLIKE/stable-1.0/
+X
+XMAINTAINER=	venture37@geeklan.co.uk
+XCOMMENT=	C implementation of the OpenNMS iplike stored procedure
+X
+XGNU_CONFIGURE=	yes
+XUSE_PGSQL=	yes
+XSUB_FILES=	pkg-message
+X
+X.include <bsd.port.pre.mk>
+X
+Xpost-install:
+X	@${CAT} ${PKGMESSAGE}
+X
+X.include <bsd.port.post.mk>
+464ef7c6571951809b23e262cbe26e19
+echo x - ./distinfo
+sed 's/^X//' >./distinfo << 'aec8793adfd5b7c3f00e62ae41a09ac2'
+XMD5 (iplike-1.0.8.tar.gz) = 85bcafd5e96a79e7d0ab6eee0b4b0b75
+XSHA256 (iplike-1.0.8.tar.gz) = f4c4a2ed00f538e4dd242189860969775a60fac0abab8683ad82061e40202802
+XSIZE (iplike-1.0.8.tar.gz) = 319791
+aec8793adfd5b7c3f00e62ae41a09ac2
+echo x - ./pkg-descr
+sed 's/^X//' >./pkg-descr << '0e313719ff012ceaf97a028d51caa8f5'
+XA C implementation of the stored procedure written in plpgsql that's bundled
+Xwith OpenNMS, this is the preferred version for use as is offers better
+Xperformance
+X
+XWWW: http://www.opennms.org/wiki/IPLIKE
+0e313719ff012ceaf97a028d51caa8f5
+echo c - ./files
+mkdir -p ./files > /dev/null 2>&1
+echo x - ./files/pkg-message.in
+sed 's/^X//' >./files/pkg-message.in << 'f63be51668f70461c30a5539f7c148ef'
+X| Don't forget to run %%PREFIX%%/sbin/install_iplike.sh to make the relevant
+X| changes to your OpenNMS database.
+X| To confirm the changes have been made run:
+X| psql -U opennms -h localhost -c '\df+ iplike' | head
+X| Check the Language column, It should say "c" and not "plpgsql"
+f63be51668f70461c30a5539f7c148ef
+echo x - ./files/patch-install_iplike.sh.in
+sed 's/^X//' >./files/patch-install_iplike.sh.in << 'ded61e823b9bea920c1e8720425fff1c'
+X--- install_iplike.sh.in.orig	2010-01-05 19:52:07.000000000 +0000
+X+++ install_iplike.sh.in	2010-01-05 19:53:15.000000000 +0000
+X@@ -5,7 +5,7 @@
+X libdir="@libdir@"
+X 
+X [ -z "$PG_DATABASE" ] && PG_DATABASE="opennms"
+X-[ -z "$PG_USER"     ] && PG_USER="postgres"
+X+[ -z "$PG_USER"     ] && PG_USER="pgsql"
+X [ -z "$PG_HOST"     ] && PG_HOST="localhost"
+X [ -z "$PG_PORT"     ] && PG_PORT="5432"
+X [ -z "$PG_PSQL"     ] && PG_PSQL="@PSQL_BINDIR@/psql"
+ded61e823b9bea920c1e8720425fff1c
+echo x - ./pkg-plist
+sed 's/^X//' >./pkg-plist << 'ef3e7f63841ae908ba397c2bef1fbad6'
+Xlib/iplike.la
+Xlib/iplike.so
+Xsbin/install_iplike.sh
+ef3e7f63841ae908ba397c2bef1fbad6
+exit
+
+
+