From owner-freebsd-ports-bugs@FreeBSD.ORG Fri Jul 31 09:10:02 2009 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 037C11065672 for ; Fri, 31 Jul 2009 09:10:02 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id CBA8B8FC14 for ; Fri, 31 Jul 2009 09:10:01 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.3/8.14.3) with ESMTP id n6V9A1VO009750 for ; Fri, 31 Jul 2009 09:10:01 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.3/8.14.3/Submit) id n6V9A1Pj009749; Fri, 31 Jul 2009 09:10:01 GMT (envelope-from gnats) Resent-Date: Fri, 31 Jul 2009 09:10:01 GMT Resent-Message-Id: <200907310910.n6V9A1Pj009749@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Pavel I Volkov Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 317F1106567E for ; Fri, 31 Jul 2009 09:00:07 +0000 (UTC) (envelope-from pol@opk.ru) Received: from fire.iib.ru (ns1.iib.ru [195.151.95.16]) by mx1.freebsd.org (Postfix) with ESMTP id B4DD38FC21 for ; Fri, 31 Jul 2009 09:00:06 +0000 (UTC) (envelope-from pol@opk.ru) Received: from mars.iib.ru (mars.iib.ru [192.168.49.100]) by fire.iib.ru (8.9/8.9) with ESMTP id n6V8rqe9022106 for ; Fri, 31 Jul 2009 12:53:53 +0400 (MSD) (envelope-from pol@opk.ru) Received: from pol.iib.ru (pol.iib.ru [192.168.0.45]) by mars.iib.ru (8.13.3/8.13.3) with ESMTP id n6V8rpHe097819 for ; Fri, 31 Jul 2009 12:53:52 +0400 (MSD) (envelope-from pol@opk.ru) Received: from pol.iib.ru (localhost [127.0.0.1]) by pol.iib.ru (8.14.3/8.14.3) with ESMTP id n6V8rpcG072324 for ; Fri, 31 Jul 2009 12:53:51 +0400 (MSD) (envelope-from pol@pol.iib.ru) Received: (from pol@localhost) by pol.iib.ru (8.14.3/8.14.3/Submit) id n6V8rprk072323; Fri, 31 Jul 2009 12:53:51 +0400 (MSD) (envelope-from pol) Message-Id: <200907310853.n6V8rprk072323@pol.iib.ru> Date: Fri, 31 Jul 2009 12:53:51 +0400 (MSD) From: Pavel I Volkov To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: Subject: ports/137295: [NEW PORT] databases/sqlite-ext-inet: Library will provide the ipv4 functions in SQL queries X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 31 Jul 2009 09:10:02 -0000 >Number: 137295 >Category: ports >Synopsis: [NEW PORT] databases/sqlite-ext-inet: Library will provide the ipv4 functions in SQL queries >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Fri Jul 31 09:10:01 UTC 2009 >Closed-Date: >Last-Modified: >Originator: Pavel I Volkov >Release: FreeBSD 7.2-STABLE i386 >Organization: >Environment: System: FreeBSD pol.iib.ru 7.2-STABLE FreeBSD 7.2-STABLE #364: Mon Jul 20 13:50:36 MSD 2009 >Description: This library will provide the ipv4 ISINNET, IP2INT, INT2IP, NETFROM, NETLENGTH, NETMASKLENGTH functions in SQL queries. WWW: http://mobigroup.ru/files/sqlite-ext/inet/ Generated with FreeBSD Port Tools 0.77 >How-To-Repeat: >Fix: --- sqlite-ext-inet-1.0.shar begins here --- # 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: # # sqlite-ext-inet # sqlite-ext-inet/files # sqlite-ext-inet/files/patch-ipv4-ext.c # sqlite-ext-inet/Makefile # sqlite-ext-inet/pkg-descr # sqlite-ext-inet/distinfo # echo c - sqlite-ext-inet mkdir -p sqlite-ext-inet > /dev/null 2>&1 echo c - sqlite-ext-inet/files mkdir -p sqlite-ext-inet/files > /dev/null 2>&1 echo x - sqlite-ext-inet/files/patch-ipv4-ext.c sed 's/^X//' >sqlite-ext-inet/files/patch-ipv4-ext.c << '672d03e037a93b806f61c49d940e6bdb' X--- ipv4-ext.c.orig 2009-07-30 17:21:45.000000000 +0400 X+++ ipv4-ext.c 2009-07-30 17:22:19.000000000 +0400 X@@ -355,6 +355,7 @@ X X #include X #include X+#include X #include X #include X #include 672d03e037a93b806f61c49d940e6bdb echo x - sqlite-ext-inet/Makefile sed 's/^X//' >sqlite-ext-inet/Makefile << 'a907cf69ad56b50d8fa35254544efa3a' X# New ports collection makefile for: sqlite-ext/inet X# Date created: 30 Jul 2009 X# Whom: "Pavel Volkov" X# X# $FreeBSD$ X# X XPORTNAME= sqlite-ext-inet XPORTVERSION= 1.0 XCATEGORIES= databases XMASTER_SITES= http://mobigroup.ru/files/sqlite-ext/inet/ XDISTFILES= ipv4-ext.c ipv4-ext.sql X XMAINTAINER= pol@iib.ru XCOMMENT= Library will provide the ipv4 functions in SQL queries X XUSE_SQLITE= yes X XDIST_SUBDIR= sqlite-ext XNO_WRKSUBDIR= yes X XEXTRACT_CMD= ${CP} XEXTRACT_BEFORE_ARGS= XEXTRACT_AFTER_ARGS= ${WRKSRC}/ X XPLIST_FILES= libexec/${DIST_SUBDIR}/libsqliteipv4.so XPLIST_DIRS= libexec/${DIST_SUBDIR} X.if !defined(NOPORTDOCS) XPLIST_FILES+= %%DATADIR%%/ipv4-ext.sql %%DATADIR%%/README.txt XPLIST_DIRS+= %%DATADIR%% X.endif X XCFLAGS+= -I${PREFIX}/include -fPIC -lm -shared X Xdo-build: X cd ${WRKSRC} && \ X ${CC} ${CFLAGS} ipv4-ext.c -o libsqliteipv4.so X Xdo-install: X ${MKDIR} ${PREFIX}/libexec/${DIST_SUBDIR} X ${INSTALL_PROGRAM} ${WRKSRC}/libsqliteipv4.so ${PREFIX}/libexec/${DIST_SUBDIR} X.if !defined(NOPORTDOCS) X ${MKDIR} ${DATADIR} X ${INSTALL_DATA} ${WRKSRC}/ipv4-ext.sql ${DATADIR} X ${SED} '/\/\*/d;/\*\//,$$d' ${WRKSRC}/ipv4-ext.c > ${WRKSRC}/README.txt X ${INSTALL_DATA} ${WRKSRC}/README.txt ${DATADIR} X.endif X X.include a907cf69ad56b50d8fa35254544efa3a echo x - sqlite-ext-inet/pkg-descr sed 's/^X//' >sqlite-ext-inet/pkg-descr << 'eac9edd8c70b91fd5fa523fe4b082694' XThis library will provide the ipv4 ISINNET, IP2INT, INT2IP, XNETFROM, NETLENGTH, NETMASKLENGTH functions in SQL queries. X XWWW: http://mobigroup.ru/files/sqlite-ext/inet/ eac9edd8c70b91fd5fa523fe4b082694 echo x - sqlite-ext-inet/distinfo sed 's/^X//' >sqlite-ext-inet/distinfo << 'b51fbead654d19ba16243845ba93c426' XMD5 (sqlite-ext/ipv4-ext.c) = 245c1631d97cb4269b2b29a98ee7cb07 XSHA256 (sqlite-ext/ipv4-ext.c) = 0047e3bd133bfa9d26b96f0e923831e7515c650e9cef02b01a243c97d0dd9a24 XSIZE (sqlite-ext/ipv4-ext.c) = 32211 XMD5 (sqlite-ext/ipv4-ext.sql) = ef158590886064a18f008c6ff8988237 XSHA256 (sqlite-ext/ipv4-ext.sql) = 0bbd2c08e26f7712decd598d51f2a2daa8ad36cb969ca310a50f3ebc1564e8b1 XSIZE (sqlite-ext/ipv4-ext.sql) = 6844 b51fbead654d19ba16243845ba93c426 exit --- sqlite-ext-inet-1.0.shar ends here --- >Release-Note: >Audit-Trail: >Unformatted: