Hello All: July 3, AM
I have completed an incipient MySQL interface for the DbMail Administrator and will soon get round to marrying it to Postgres. I am a little reluctant to push changes to the database directly as yet so the MySQL tool is a read-only parallel / option to the data derived from dbmail-adduser. The package uses both calls and responses from 'dbmail-adduser' as well as MySQL queries and then pushes Administrator's changes through 'dbmail-adduser'. The package is entirely useable without using the MySQL interface but, because the MySQL tool displays a full set of data including detailed mail size, it is quite handy. I have been able to fetch a fairly adequate output from db.c via 'dbmail-adduser' but for sure the MySQL interface is most informative. Please, anyone, let me know if you find bugs, quirks etc. The DBMA package is based on the current 2.x release of DbMail but also works with the 1.2x releases. Version 1.0.2 of DBMA (DbMail Administrator) can be downloaded from http://library.mobrien.com/dbmailadministrator/ Using this package is quite an intuitive process but for those who read instructions first, there is plenty of help info, a contact method and such at http://library.mobrien.com/ As Paul Stevens pointed out, and I hope it doesn't need further saying, but I say it anyway, don't install DBMA (DbMail Administrator) on a public web server etc. I will be working fairly steadily at it next week so check back often for updates. I will start a change log down the road but for now, expect even radical changes. Upgrade can be done over top original installs but watch out for new scripts needing a chown and chmod. best... Mike (Happy Canada Day weekend; Happy July 4th weekend to all that applies to.) >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 at 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: ilja at ic-s.nl
