Paul J Stevens wrote: > Other than the lack of any perceivable added benefit (for me at least), > my main objections are with regard to change management and security. > For example, I like being able to stick /etc/dbmail/ into a git > repository. And I *really* don't want my ldap bind_dn parameters in a > database. > For ldap, I think that the ldap bind_dn and bind_pw, and possibly ldap_host could be items in the flat file only. I don't think that the rest of the ldap information would be a huge security risk.
For hydra, you can't just do it per message as it would break sorting with messages spread across multiple databases. The only real solution I can see is to have a mailbox assigned to a backend database. This will keep all of the messages for that mailbox on the same server. Header caching, and sorting would remain on that server. I'm not sure about UID overlap between mailboxes though. If I had a UID 1 in multiple mailboxes, would clients go nuts? I think they would be ok, but I'm not sure if that breaks a RFC. Front end database tables: dbmail_acl dbmail_aliases dbmail_config (storage of most of the configurable items and information about the backend database server locations, also defines rules for which backend to use) dbmail_filters dbmail_keywords dbmail_mailboxes (with new column of which backend storage database contains the message - probably just and int that has a server defined in the dbmail_config table) dbmail_pbsp dbmail_replycache dbmail_sievescripts dbmail_subscription dbmail_usermap dbmail_users Back end single-instance storage databases: (sort views) dbmail_ccfield dbmail_datefield dbmail_fromfield dbmail_subjectfield dbmail_tofield (tables) dbmail_envelope dbmail_header dbmail_headername dbmail_headervalue dbmail_messages dbmail_mimeparts dbmail_partlists dbmail_physmessage dbmail_referencesfield -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev