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

Reply via email to