ports/54887: [new port] mail/dbmail: An SQL database-based mail system (POP3 and IMAP)

Sat Jul 26 22:10:17 UTC 2003

>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 at 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 at 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 at 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 at unexec rmdir %D/share/dbmail/sql
X at unexec rmdir %D/share/dbmail
X at unexec rmdir %D/%%DOCSDIR%%
X
END-of-dbmail/pkg-plist
exit
--- dbmail.shar ends here ---


>Release-Note:
>Audit-Trail:
>Unformatted: