Ref: DbMail Administrator (DBMA) V1.0.4 http://library.mobrien.com/dbmailadministrator/
This package now contains identical MySQL and PgSQL (PostgreSQL) tools. Each will list all users; produce a list of relevant aliases for deletion prior to deleting a user; list all user data ranging from actual current mailbox usage to passwords and aliases and more. NOTE: There is also a corresponding MySQL tool for Win32 use (dbmail_mysql.cgi.win32.ver) enabling you to obtain read-only data from the MySQL DbMail database. Change the shebang line according to your Windows PERL and make the configuration changes in the same manner you would for a Unix box. This read-only Win32 variant is included for the purpose of aiding a HelpDesk situation where a Level One Support person may need read-only access to Mail User accounts. The main package uses both PERL calls to 'dbmail-adduser' and SQL queries to either MySQL or PostgreSQL to obtain data and then relies exclusively on 'dbmail-adduser' to implement administrative changes. I will look a little deeper into a variant that makes SQL query changes directly to the database if there is any interest in doing that. best... Mike
