This module is both an administration component for Linuxconf and
a email solution using an SQL (MySQL for now) to store email messages,
user accounts and aliases.

The package provides the following component

-A Linuxconf module called mailsql. It is automatically registered
 if installed as an RPM. If not, do

	linuxconf --setmod mailsql

 This module is tied to the mailconf module. It registers 3 menus.

	-One in the networking/server tasks/mail configuration
	 to configure new virtual email domains

	-One is the user account/special accounts to edit SQL user
	 accounts

	-And another to edit email aliases.

-A delivery agent /usr/lib/linuxconf/lib/vdeliver_sql. It accepts
 a message from sendmail and stores it in SQL.

-A POP-3 server called vpop3d_sql (working, but only tested by me)

-An IMAP server (one day)

-A web mail front-end (one day)

-A little script to initialise the database. It is called table.sh. You just
 run it like this

	sh table.sh create

 It will create a database on the local MySQL server called "mailsql".

--
Operation

	Once installed and the database intialised with table.sh, you must
	define virtual email domains using the mailsql module. You define
	one or more domains and then you must request the generation of a new
	sendmail.cf.

	Add some users to the domain.

	At this point, if you DNS is correctly setupped for the domain, you should
	be able to send email.

	To retrieve email, you must setup the vpop3d_sql server. Here is a
	ipop3 configuration file for xinetd on redhat 7.0

		# default: off
		# description: The POP3 service allows remote users to access their mail \
		#              using an POP3 client such as Netscape Communicator, mutt, \
		#	       or fetchmail.
		service pop3
		{
			socket_type		= stream
			wait			= no
			user			= root
			server			= /usr/lib/linuxconf/lib/vpop3d_sql
			server_args		= /usr/lib/linuxconf/lib/vpop3d /usr/sbin/ipop3d
			log_on_success		+= USERID
			log_on_failure		+= USERID
			disable			= no
		}

	vpop3d_sql relies on proper dns reverse lookup to tell if it is
	serving an SQL virtual email domain or not. If it is not
	serving such a domain, it will deleguate to another pop3 server
	as passed on the command line. In the above configuration, it will
	delegate to the original linuxconf vpop3d server which will ultimatly
	delegate to the standard RedHat ipop3d server.

--

The goal of this module is to provide a high performance mail system
At this point, this package can be seen as a proof of concept.

Comments welcome.

Jacques Gelinas
jack@solucorp.qc.ca