Date: Sun, 27 Jul 2003 00:06:14 +0200 From: "Clement Laforet" <sheepkiller@cultdeadsheep.org> To: FreeBSD-gnats-submit@FreeBSD.org Cc: Clement Laforet <sheepkiller@cultdeadsheep.org> Subject: ports/54887: [new port] mail/dbmail: An SQL database-based mail system (POP3 and IMAP) Message-ID: <20030726220614.7263D43FBF@mx1.FreeBSD.org> Resent-Message-ID: <200307262210.h6QMAGT2010646@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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 <sheepkiller@cultdeadsheep.org> 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 <bsd.port.pre.mk> 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 <bsd.port.post.mk> 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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030726220614.7263D43FBF>