Contrib::dbmailadmin

Hello All:
I have built an XHTML interface to DbMail using PERL as an alternative to
what may exist already. It is purpose-built for administrator's to do easy,
remote, mail user-account storage and retrieval management without having to
have ports 22 and 23 open for telnet and SSH.

My intention was to do this as a contribution as I have just discovered
dbmail and plan to dist it out. Dbmail is a very good little package of
programmes for storing and retrieving mail. Very good. I appreciate the
developer's fine work.

Presently I run current daily snapshots of DbMail with Postfix and Mysql on
a dev platform and will continue to maintain the 'dbmailadmin' package on
that basis. I have tested it with the stable-current 1.2.8b release and it
is good thus far but I contemplete pressing ahead with the 2.xx versions
exclusively.

To facilitate use of 'dbmailadmin' on any database (Postgres or MySQL) I
rely almost exclusively on system calls to the 'dbmail-adduser' tool. There
will be some MySQL InnoDB queries from a side-bar package if need exists.

In a few days I will be posting a download bundle link at
http://library.mobrien.com free for all to share but before I do that I
wanted to check for input on what if anything folks would like to have in
the early release if I haven't thought of it already.

Here's where it's at:
1) The package MUST run on a DbMail host (I use a password protected SSL
virtual host on DbMail host so I can address mail issues from anywhere.)
This could also be LAN-side-only on a multi-homed or dmz-firewalled
installation.

2) No special perl modules required. Just DBI if SQL part is to be used.

3) Runs as www:www or whatever user:group your HTTPD likes.

4) Package runs from a single name space below VHOST-root (/dbmailadmin/) or
it can run from VHOST-root (/), i.e.:
/usr/local/www/dbmail.virtualhost.tld/dbmailadmin ('ExecCGI' and 'AddHandler
cgi-script .cgi' must be implemented for the name space in the HTTP Daemon's
config (i.e.: apache's httpd.conf))

Current capabilities:
* List all Users
* Show User Account Details
* Add a User (PLAIN password so far)
* Delete A User
* Empty a User's Mailbox
* Change some User Account details (i.e.: pass, alias etc.)
* Send user a message
* Send all user's a message (still in dev)

Please, your comments and suggestions are invited.

best... Mike

Mike O'Brien
Aurora ON CANADA

Reply via email to