From owner-freebsd-ports-bugs@FreeBSD.ORG Sat Jul 26 15:10:17 2003 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 98BAE37B401 for ; Sat, 26 Jul 2003 15:10:17 -0700 (PDT) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 73C6F43FB1 for ; Sat, 26 Jul 2003 15:10:16 -0700 (PDT) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.12.9/8.12.9) with ESMTP id h6QMAGUp010647 for ; Sat, 26 Jul 2003 15:10:16 -0700 (PDT) (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.12.9/8.12.9/Submit) id h6QMAGT2010646; Sat, 26 Jul 2003 15:10:16 -0700 (PDT) Resent-Date: Sat, 26 Jul 2003 15:10:16 -0700 (PDT) Resent-Message-Id: <200307262210.h6QMAGT2010646@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, Clement Laforet Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5E62437B401 for ; Sat, 26 Jul 2003 15:06:17 -0700 (PDT) Received: from cultdeadsheep.org (charon.cultdeadsheep.org [80.65.226.72]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7263D43FBF for ; Sat, 26 Jul 2003 15:06:14 -0700 (PDT) (envelope-from sheepkiller@cultdeadsheep.org) Received: (qmail 17688 invoked from network); 26 Jul 2003 22:06:10 -0000 Received: from unknown (HELO ?HOSTNAME?) (192.168.0.12) by goofy.cultdeadsheep.org with SMTP; 26 Jul 2003 22:06:10 -0000 Received: by _HOSTNAME_ (sSMTP sendmail emulation); Sun, 27 Jul 2003 00:06:14 +0200 Message-Id: <20030726220614.7263D43FBF@mx1.FreeBSD.org> Date: Sun, 27 Jul 2003 00:06:14 +0200 From: "Clement Laforet" To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 cc: Clement Laforet Subject: ports/54887: [new port] mail/dbmail: An SQL database-based mail system (POP3 and IMAP) X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: Clement Laforet List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 26 Jul 2003 22:10:17 -0000 >Number: 54887 >Category: ports >Synopsis: [new port] mail/dbmail: An SQL database-based mail system (POP3 and IMAP) >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: Sat Jul 26 15:10:15 PDT 2003 >Closed-Date: >Last-Modified: >Originator: Clement Laforet >Release: FreeBSD 5.1-CURRENT i386 >Organization: cotds >Environment: System: FreeBSD chuck.cultdeadsheep.org 5.1-CURRENT FreeBSD 5.1-CURRENT #0: Mon Jul 14 03:00:24 CEST 2003 clement@chuck.cultdeadsheep.org:/usr/obj/usr/src/sys/CHUCK i386 >Description: (author description) The DBMAIL package replaces the normal UNIX mailing system. All emails and users data are stored in a database. You can create an unlimited number of email accounts, which can be checked using the POP3 or IMAP protocol. Users can maintain their own set of email addresses. It is more scalable, more secure, and faster than traditional mail systems. DBMAIL uses PostgreSQL or MySQL. >How-To-Repeat: N/A. >Fix: --- dbmail.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: # # dbmail # dbmail/Makefile # dbmail/distinfo # dbmail/pkg-descr # dbmail/pkg-plist # echo c - dbmail mkdir -p dbmail > /dev/null 2>&1 echo x - dbmail/Makefile sed 's/^X//' >dbmail/Makefile << 'END-of-dbmail/Makefile' X# New ports collection makefile for: dbmail X# Date created: 07/26/2003 X# Whom: Clement Laforet X# X# $FreeBSD$ X# X XPORTNAME= dbmail XPORTVERSION= 1.1 XCATEGORIES= mail XMASTER_SITES= http://www.dbmail.org/tgz/ XEXTRACT_SUFX= .tgz X XMAINTAINER= sheepkiller@cultdeadsheep.org XCOMMENT= An SQL database-based mail system (POP3 and IMAP) X XUSE_REINPLACE= YES XGNU_CONFIGURE= YES XUSE_GMAKE= YES X X# MySQL deps hack XMYSQL323_LIBVER=10 XMYSQL40_LIBVER= 12 XMYSQL41_LIBVER= 14 X X.include X X.if defined(WITH_MYSQL_VER) XMYSQL_VER= ${WITH_MYSQL_VER} X.elif exists(${LOCALBASE}/lib/mysql/libmysqlclient.so.${MYSQL_323_LIBVER}) XMYSQL_VER= 323 X.elif exists(${LOCALBASE}/lib/mysql/libmysqlclient.so.${MYSQL40_LIBVER}) XMYSQL_VER= 40 X.elif exists(${LOCALBASE}/lib/mysql/libmysqlclient.so.${MYSQL41_LIBVER}) XMYSQL_VER= 41 X.else X# We consider that MySQL 4.0.x is now the default. XMYSQL_VER= 40 X.endif X X.if defined(WITH_PGSQL) XCONFIGURE_ARGS+= --with-pgsql XLIB_DEPENDS+= pq:${PORTSDIR}/databases/postgresql7 XDATABASE= postgresql XPLIST_SUB+= PGSQL="" XPLIST_SUB+= MYSQL="@comment " X.else XCONFIGURE_ARGS+= --with-mysql XLIB_DEPENDS+= mysqlclient.${MYSQL${MYSQL_VER}_LIBVER}:${PORTSDIR}/databases/mysql${MYSQL_VER}-client XDATABASE= mysql XPLIST_SUB+= MYSQL="" XPLIST_SUB+= PGSQL="@comment " X.endif X XCONFIGURE_ENV+= LDFLAGS="-L${LOCALBASE}/lib/ -L${LOCALBASE}/lib/${DATABASE}" XPKGNAMESUFFIX= -${DATABASE} XFILES_TO_PATCH= imapd.c main.c maintenance.c pop3d.c user.c XDOCS= INSTALL README X Xpre-everything:: X @${ECHO} "" X @${ECHO} "You may use the following build options:" X @${ECHO} " By default dbmail uses MySQL backend database." X @${ECHO} "" X @${ECHO} " WITH_MYSQL_VER=323 Enable MySQL 3.23 support" X @${ECHO} " WITH_MYSQL_VER=40 Enable MySQL 4.0 support (default)" X @${ECHO} " WITH_MYSQL_VER=41 Enable MySQL 4.1 support" X @${ECHO} "" X @${ECHO} " To build dbmail with PostgreSQL as backend database," X @${ECHO} " define WITH_PGSQL" X @${ECHO} "" X Xpost-configure: X.for file in ${FILES_TO_PATCH} X @${REINPLACE_CMD} -i.orig 's!/etc/dbmail.conf!${PREFIX}/etc/dbmail.conf!g' \ X ${WRKSRC}/${file} X.endfor X Xpost-install: X @${INSTALL_DATA} ${WRKSRC}/dbmail.conf ${PREFIX}/etc/dbmail.conf-dist X @${MKDIR} ${DATADIR}/sql X @${INSTALL_DATA} ${WRKSRC}/sql/${DATABASE}/* ${DATADIR}/sql X.if !(NOPORTSDOC) X @${MKDIR} ${DOCSDIR} X.for docs in ${DOCS} X @${INSTALL_DATA} ${WRKSRC}/${docs} ${DOCSDIR} X.endfor X.endif X X.include END-of-dbmail/Makefile echo x - dbmail/distinfo sed 's/^X//' >dbmail/distinfo << 'END-of-dbmail/distinfo' XMD5 (dbmail-1.1.tgz) = e6d7be3eff38b69ab82ae6d47e3c83e2 END-of-dbmail/distinfo echo x - dbmail/pkg-descr sed 's/^X//' >dbmail/pkg-descr << 'END-of-dbmail/pkg-descr' XDbmail is the name of a group of programs that enable the possiblilty of storing Xand retrieving mail messages from a database (currently MySQL or PostgreSQL). X XWhat are the advantages? X X * Scalability. X Dbmail is as scalable as the database that is used for the mail storage. X * Manageability. X Dbmail is based upon a database. Dbmail can be managed by changing X settings in the database (f.e. using PHP/Perl/SQL). X * Speed. X Dbmail uses very efficient, database specific queries for retrieving mail X information. This is much faster then parsing a filesystem. X * Security. X Dbmail has got nothing to do with the filesystem or interaction with other X programs in the Unix environment which need special permissions. Dbmail X is as secure as the database it's based upon. X * Flexibility. X Changes on a Dbmail system (adding of users, changing passwords etc.) are X effective immediately. X XWWW: http://www.dbmail.org/ END-of-dbmail/pkg-descr echo x - dbmail/pkg-plist sed 's/^X//' >dbmail/pkg-plist << 'END-of-dbmail/pkg-plist' Xbin/dbmail-smtp Xbin/dbmail-pop3d Xbin/dbmail-imapd Xbin/dbmail-maintenance Xbin/dbmail-adduser Xbin/dbmail-readvut Xbin/raw-convertor Xbin/dbmail-mini-injector Xbin/install-dbmail.sh Xetc/dbmail.conf-dist X%%MYSQL%%lib/libmysqldbmail.a X%%PGSQL%%lib/libpgsqldbmail.a X%%MYSQL%%share/dbmail/sql/add-lastlogin.mysql X%%MYSQL%%share/dbmail/sql/add_auto_notification.mysql X%%MYSQL%%share/dbmail/sql/add_auto_reply.mysql X%%MYSQL%%share/dbmail/sql/add_rfcsize.mysql X%%MYSQL%%share/dbmail/sql/create_tables.mysql X%%MYSQL%%share/dbmail/sql/create_tables_innoDB.mysql X%%MYSQL%%share/dbmail/sql/newnames.mysql X%%MYSQL%%share/dbmail/sql/pop_before_smtp.mysql X%%MYSQL%%share/dbmail/sql/update_encryption.mysql X%%MYSQL%%share/dbmail/sql/update_mailbox_subscribed_folders.mysql X%%MYSQL%%share/dbmail/sql/update_mysql_tmptables.mysql X%%MYSQL%%share/dbmail/sql/update_ownerid_aliases.mysql X%%PGSQL%%share/dbmail/sql/add-constraints.pgsql X%%PGSQL%%share/dbmail/sql/add-lastlogin.postgresql X%%PGSQL%%share/dbmail/sql/add_auto_notification.pgsql X%%PGSQL%%share/dbmail/sql/add_auto_reply.pgsql X%%PGSQL%%share/dbmail/sql/add_rfcsize.postgresql X%%PGSQL%%share/dbmail/sql/create_tables.pgsql X%%PGSQL%%share/dbmail/sql/no-constraint-tables.pgsql X%%PGSQL%%share/dbmail/sql/update_encryption.pgsql X%%PORTDOCS%%%%DOCSDIR%%/INSTALL X%%PORTDOCS%%%%DOCSDIR%%/README X@unexec rmdir %D/share/dbmail/sql X@unexec rmdir %D/share/dbmail X@unexec rmdir %D/%%DOCSDIR%% X END-of-dbmail/pkg-plist exit --- dbmail.shar ends here --- >Release-Note: >Audit-Trail: >Unformatted: