I have always seen some people indicate they use MySQL for mailboxes in Postfix and I wondered how difficult something like this would be? I have 300 users on my company Postfix server right now. I am just using Postfix, Dovecot (IMAP4 only), & Roundcube (Webmail). I have MySQL loaded on the machine that runs Postfix but only to manage the database for Roundcube. Do you think that 300+ users is recommended for a MySQL database for mailboxes? Secondly, how difficult is it to configure this? Right now everyone user has a home directory and a mailbox in their private home folder. Is it hard to configure Postfix & Dovecot to use MySQL mailboxes? Just looking for some suggestions since I couldn't find a log of info via Google. *PS* I was told that Dovecot doesn't support MySQL mailboxes. I think it does. Am I wrong? http://howtoforge.com/forums/showthread.php?p=221396#post221396
On Mon, 2010-03-08 at 10:52 -0500, Carlos Mennens wrote:> *PS* I was told that Dovecot doesn't support MySQL mailboxes. I think > it does. Am I wrong?Dovecot supports looking up user information from MySQL, but not actually storing mails there. If you really wanted to store mails on MySQL, you'd have to use dbmail instead of Dovecot. -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 198 bytes Desc: This is a digitally signed message part URL: <http://dovecot.org/pipermail/dovecot/attachments/20100308/57c0afe2/attachment-0002.bin>
On Mon, Mar 8, 2010 at 10:55 AM, Timo Sirainen <tss at iki.fi> wrote:> Dovecot supports looking up user information from MySQL, but not > actually storing mails there. If you really wanted to store mails on > MySQL, you'd have to use dbmail instead of Dovecot.Is it even worth it with less than 500 users? I mean I don't have any problems right now creating individual users and their home directories in Linux but I have never used MySQL for mail so can't differentiate the two. I guess I don't even know if this worth the effort to change my configuration especially if it involves changing out my IMAP server for 'dbmail' which I know nothing about until you mentioned it.
On 2010-03-08 10:52 AM, Carlos Mennens wrote:> *PS* I was told that Dovecot doesn't support MySQL mailboxes. I > think it does. Am I wrong?You're confusing 'mailboxes' with user mail 'settings' and/or user management. Dovecot does not currently support storing users mail in any sql database, although 2.0 is supposedly going to make it easier to implement this with a plugin for anyone wants to write the code. What you are reading about re: dovecot+mysql is simply using MySQL as the backend for your user info. It can be as simple as username and password, or you can add quota management, and even more (custom user storage locations, etc) with extra_fields: http://wiki.dovecot.org/UserDatabase/ExtraFields Dovecot is extremely flexible with respect to configuration management. -- Best regards, Charles
Am 09.03.2010 14:41, schrieb Marcus Rueckert:> On 2010-03-09 14:30:14 +0100, Robert Schetterer wrote: >> sql storage would be a nice idea anyway for clustering loadbalancing >> setups etc > > looked into drbd? > > darix >jep, i ve tested it allready and will implement it soon but nevertheless having all in sql ( mail storage and dovecot setup as well as horde , spamassassin etc ) seems to make ha setup more easy, but youre right for drbd with maildir is good enough for me yet -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria