DBMail Administrator (DBMA v2.5.4)

Free To Download, Free To Use - DBMA is a GUI for Administering All Versions of DBMail
DBMA - Download DBMail Administrator Latest TarBallDownload DBMA v2.5.4 | Demo | Contact | Security | FAQ | RFCs | Bugs(Email) [ Installing DBMA | How to Use DBMA | News | Search| README | Screenshots ]
New:ldap:://keyserver.dbma.ca:11371 ~ DBMA Demo | MTA Black_List / White_List DEMO
Packages are available in this format too: dbma-2.5.2.tar.gz (see RSS) RSS Feed: http://dbma.ca/DBMA.rss RSS Feed, Updates and Changes

About DBMail - The Mail System

DBMail is an open source, Unix IMAP/POP3 mail storage and retrieval system which together with an MTA (Mail Transfer Agent) like Postfix enables vastly scalable mail systems with SQL database (RDBMS) storage (i.e.: MySQL, PostgreSQL) and retrieval of all e-mail and user data. DBMail's IMAP4 and POP3 Daemon's are fast; scalable to the limits of MySQL/PostgreSQL. Development and support of DBMail is done by NFG Net Facilities Group BV. Join the Users Forum.

About DBMA - The Administrator (DBMA Demo)

This software was written soley by Micheal O'Brien and is still supported by him. Micheal ([Mike]) is a DBMail list member and you can also contact him here. DBMailAdministrator administers all DBMail versions from a Unix or Windows Workstation while reporting on your e-mail system's health. DBMA now provides an MTA (i.e.: Postfix) GUI to store and manage Virtual Domains, Destination, Transports and Access configuration of your MTA. DBMA, the Web front end for DBMail, provides a scalable, menu-driven interface for administering e-mail; user accounts; global configs; sending & fetching email and more. Learn more: DBMA Features | Managing Your E-Mail System.

Use "update.pl" to upgrade DBMA and you preserve your DBMA settings :o)

This script uses "wget" so you must have "wget" installed. Simply type "perl update.pl" or "./update.pl" in the dbmailadministrator/ directory.

Recent Changes

V2.5.4
Numerous minor fixes
V2.5.2
June 1, 2008
* further changes made to PostgreSQL functionality to allow DBMail users to exploit the significant new functionality and performance enhancements of PostgreSQL 8.3.1 and beyond.
V2.5.1
May 12, 2008
* substantial changes made to PostgreSQL functionality.
V2.5.0
January 25, 2008
* a few minor bug fixes including syntax management for 'SQL-illegal' characters in Auto reply Messages
* reminders for configuring dbmail.conf to use AutoNotify and AutoReply
* speed increase

Quickly find the help you need.



DBMA Quick Reference

Please change your default password

This refers to the htaccess/htpasswd files stored within the DBMA tarball. Change (dbmail:dbmail and dbma:dbma for Win32) as soon as possible. See security for more details. Password protection should be enabled in your HTTP Daemon configuration (i.e.: httpd.conf).

Don't Allow Public Access To DBMA

DBMail Administrator (DBMA) can administer your DBMail system with an HTML GUI you can use to connect to mail server(s); from across the LAN; or around the globe via VPN. On the LAN or VPN, authenticated SSL is the best approach. See Apache Configuration and Security Help or feel free to ask for help if you are in doubt about providing a secure environment for this management software. Running any mail system for the public puts you in the honourable shoes of a Postmaster with all the incumbant responsibilites for users' PRIVACY AND INFORMATION SECURITY.

DBMA: Administering IMAP Shared Folders

IMAP4 Access Control Lists (ACL's) (RFC 2086) provide the option to share IMAP folders. If you do not have any shared folders, this is your tool to create them. DBMA first checks your system to make certain that the critical system accounts exist within Group 0. See IMAP Shared Folders to learn more about how you manage ACLs and Shared IMAP Folders using DBMA.

DBMA: SQL Database Cleanup

DBMA includes an increasing range of tools to supplement command-line utilities in managing your email database. In regular operation, finding orphaned users and aliases DBMA will give you transparent editing options to either fix or delete problems. DBMA provides a manual 'Database Cleanup' function to perform utilitarian chores like searching out and deleting orphaned messages; accelerating the deletion schedule of "flagged for delete" messages. For MySQL only, DBMA runs a defragmentation on the following tables by performing a 'null' alter table operation:
            dbmail_aliases
            dbmail_users
            dbmail_mailboxes
            dbmail_messages
            dbmail_messageblks
            dbmail_physmessage
            dbmail_subscription

Finding and Removing 'Orphans' : Database Cleaning

The 'Database Cleanup' from the Main (Global Admin) menu function runs a scan of the database, wary of the diverse range of RDBMS options in use with DBMail and its rather intelligent schema. DBMA seeks both minor and more serious problems. These often are admin errors but are sometimes caused by broken clients, minor bugs in older releases, connection interruptions, system failures or quirks, or just routine stuff waiting yet-to-be performed crontab utility runs. DBMA looks for
  • messages marked delete by the client but status is still 000 or 001;
  • messages having no 'owner mailbox';
  • messages unattached to a user;
  • mailboxes unattached to a user; and
  • aliases where the group mismatches the owner's.

Keeping it Clean with Staged Mail Deletion

You might want to speed up deletion of hundreds of mail messages all at once. DBMA's "delete mail" function (located in every mailbox list) will set dbmail_messages.status to level 003.

  • When DBMA's 'Database Cleanup' finds orphaned messages dbmail_messages.status is set to 002.
  • Re-running 'Database Cleanup' sets status to 003.
  • You can check the status of any message either from a list or by searching for the message.
  • Open a "User Account Window" and either use the search box or select a relevant mailbox.
  • DBMA will list the messages with full technical details.
  • You can individually delete/UNdelete the mailboxes messages
  • or globally delete or undelete everything in that mailbox.
  • Verify changes in "deletes pending" in "My Mail System" (Main) after "Database Cleanup".
  • Optionally you can repeat the 'Database Cleanup' action to push all status to '003'.
  • The next crontab 'dbmail-util -a -y' removes them from the database.
NOTE: The Database Cleanup function is not available under the RESTRICTGroupID regime where DBMA is throttled down to one Clinet_IDNR only. DBMA does, on the fly, verify that aliases have the correct client_idnr (GroupID) to avoid cross-Group pollution or security issues.

DBMA: Administering E-Mail Users

  • Single User Admin
    • DBMA User Search from the top, left of the Main (Global Admin) menu is an 'intelligent' tool for finding a user and taking you immediately to the User Account Window. From the User Account Window most user administration is conducted.
    • The search box accepts non-alphanumeric, email address as username, mail address as alias, alpha string name, alpha-numeric+RFC2822-allowed-chars name, or the user number. Some DBMail operators store user names as full email addresses.
    • DBMA User Search will decide if input is a real user name or if the search is for an alias's account and return a result accordingly.
    • The fastest and most powerful tools for user administration are in the User Account Window.
  • Group User Admin
    • This is the quintessential core of user management.
    • Users can be listed from individual Groups (client_idnr) by selecting the group number in top, middle of the Main menu and pressing 'List Group Users'.
    • For each user you now know their last login, current mail useage, account number, Group number, and something about their password.
    • For each user is a tool to Modify, Delete, Alias or Notify as well as open the User Account Window where all administrative functions are available.
  • Global User Admin
    • Select "All users all groups" from the Main (Global Admin) menu and enter a number of listings to show (default 200).
    • Each user listing is a link to the User Account Window.
    • Each green icon under "Groups" is a function call to list all users of that group.

DBMA: Administering E-Mail Aliases or Forwards

  • Global Admin
    • The Main menu (Global Admin) provides full view of your entire system. Be wary of system size. The fastest and most powerful tools for user adminstration are in the User Account Window.
    • Select 'List All Aliases' from the Main menu and enter the number of listings you would like to see.
    • This tool displays everything in the aliases table, including forwards...
    • plus DBMA will find and list at the very top (with some action options) any "Orphans" which may exist in your system.
    • Each alias listing is a link to the User Account Window.
    • For each user shown you now know their last login, current mail useage, account number, Group number, and something about their password.
    • A green icon beside the Group number is a function call for an extensive list for that group.
    • A red 'delete' icon at the far right of each item allows you to quickly delete an alias.
  • Group Admin
    • At the top right of the Main menu (Global Admin) select a group and press 'List Group Aliases'.
    • Functionality is identical to Global Listing above, on a smaller set of your total system.
  • Managing Mail Forwards
  • Here the magic button is "Edit".
  • Selecting 'List All Forwards' from the main menu lists all forwards on the system.
  • The 'Group', 'From' and 'To' data are displayed along with a 'delete' and 'edit' icon.
  • Here, and in fact, anywhere in DBMA you see either 'edit' or 'forward' options attached to an email address, you have the opportunity to redirect mail for that address anywhere. You can even convert the forward back to an alias for any account. Make sure that you have the "From" address correctly entered -- DBMA validates on the basis of the alias ID number and will send you back to the start if there is no match on the system. Next, you can enter a username, a user ID number or an email address as the recipient ("Forward to:"). DBMA will check if the user number or name exists on the system and give you a final option to edit your entry before commiting. (Be careful using external forwards. Check if the recipient mail server's DNS (SPF etc) indicates acceptance or rejection of mail forwarded in this manner.)

Now that you have read a little, try out your new administrative skills on the Demo.

DBMA: User Mail Account Management

The "Modify User Account Window" is reached from any "Group List" of users or from the main User Account Window. Wherever you are in DBMA you can click an account or enter a name or number in the User Search box and open a "User Account Window". Click the "Modify..." button and you arrive here: the heart of user management where you can change passwords, user names, Group, encryption type, aliases, forwards and more.

Most Work Done From 'Modify User Account' Window

Modify User Account.

DBMA: Privacy Warning

DBMA can both Send and Receive Mail, acting as an administrative Email Client.

In the event you observe the mail contents addressed to a real person's account (not referring to yourself or 'webmaster', 'abuse', 'sales', etc.), you may not disclose the content of that message to any person nor may you interrupt nor tamper with that message in any manner. Period.

DBMailAdministrator (DBMA) provides methods for searching mail headers and message blocks for administrative troubleshooting only.

DBMA's message block displays are not content-friendly but ASCII-forced with emphasis on routing and embedded header-fields tracing the internet 'hops' the message travels.

An example of appropriate use would be:

  • finding and Undeleting a critical message a user inadvertantly deleted;
  • troubleshooting headers when a delivery breaks;
  • evaluating anti-spam/virus software deployments;
  • providing help-phone assistance to users in the identification or removal of SPAM, 'message-jams', viruses; and so on.
  • reading your administrative mail;
  • running 'echo' mail tests....

DBMA: User Account Window

MailBox Content, Shared Mailboxes, Notify...

From the User Account Window you will most often jump to the Modify User Account Window. Or you may have a user who is a magnet for viruses and unparsebale messages so you may spend time seaching for problem mail or tracking delivery issues, all of which are done from the User Account Window. You can select and open user mailboxes for troubleshooting jammed mail, undelating mail accidentally deleted, tracking virus and spam issues, searching all mailboxes; adding or updating ACLs if your system uses that feature; creating an auto notification; sending the account owner a report of the changes accomplished in a mail message; in short, managing the user's account.

Use the search headers option wherever possible for speed, eficiency and privacy. Anything you read, keep it to yourself. If something you feel is alarming comes into view, refer the message ID to an immediate supervisor or consult with your employer's privacy/security authority.

click the mailbox icon in the user account window to list all mail in that box

.

DBMA: Configuration from The GUI Only Installation

Point your browser to /dbmailadministrator/DBMA.cgi and use the GUI to configure DBMA for your environment. See Managing Users for more information about using the features in DBMA.

Valid XHTML 1.1!