This is very interesting. It seems like something that would be very
useful to add to the
dbmail distribution.
It might be useful though to use SQL queries instead of dbmail-adduser,
to be able to display stuff like current mail size, etc. Using Perl DBI
and portable queries (like we use in db.c in DBMail) it should be quite
easy to make a package that works on both MySQL and PostgreSQL.
Ilja
M. J. [Mike] O'Brien wrote:
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
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
Ilja Booij
IC&S B.V.
Stadhouderslaan 57
3583 JD Utrecht
www.ic-s.nl
T algemeen: 030 6355730
T direct: 030 6355739
F: 030 6355731
E: [EMAIL PROTECTED]
