Arch Linux

JHeaton

Member

From: United Kingdom

Registered: 2009-05-16

Posts: 158

[Solved]Using MySQL for mail users and boxes

Hey everyone, hopefully just a quick one. I've used this guide several times to set up small mail servers before, but I've just come to setting up a larger one and I'd really like to use virtual users and mailboxes in a MySQL database rather than creating a bunch of local users and directories for it all. The PostFix guide on the wiki does mention it's possible to set up PostFix and Dovecot to use a SQL database, but there's no information or links that explains how to do this. After searching through the wiki, I haven't been able to find anything so I'm a little bit stuck, though it's possible I may have missed something.

If anyone has set up their mail server in the way I'm looking for, would they be willing to provide some information or walk me through the process? I've had a quick look at the PostFix and Dovecot documentation but I don't really see too much on the matter and, well, I'll be honest and say that sometimes I have real trouble reading the documentation. Yeah, I have my moments

Eventually, I plan on having people able to connect to the mail server with their mail clients (Thunderbird, Claws, Outlook etc.) to send and receive mail, as well as using Roundcube for a web interface, but I think that's a fairly easy thing to get set up. Mostly it's getting the MySQL bit sorted out that I haven't a clue with.

All help is really appreciated and sorry if I've missed something really obvious in my searches.

Kind regards,

Joel.

Last edited by JHeaton (2010-08-02 10:57:00)

rusty99

Member

Registered: 2009-03-18

Posts: 253

Re: [Solved]Using MySQL for mail users and boxes

Slicehost Postfix/MySQL setup - http://articles.slicehost.com/2008/9/2/ … l-database

JHeaton

Member

From: United Kingdom

Registered: 2009-05-16

Posts: 158

Re: [Solved]Using MySQL for mail users and boxes

Slicehost Postfix/MySQL setup - http://articles.slicehost.com/2008/9/2/ … l-database

Wow, thanks for that. That will be very useful and I guess in this case Courier is used instead of Dovecot?

rusty99

Member

Registered: 2009-03-18

Posts: 253

Re: [Solved]Using MySQL for mail users and boxes

Yes it is http://articles.slicehost.com/2008/9/2/ … stallation

JHeaton

Member

From: United Kingdom

Registered: 2009-05-16

Posts: 158

Re: [Solved]Using MySQL for mail users and boxes

Yes it is http://articles.slicehost.com/2008/9/2/ … stallation

Sweet, thank you very much for that, it is much appreciated.

Edit: After finding this, I feel like an idiot. http://wiki.archlinux.org/index.php/Postfix

Last edited by JHeaton (2010-08-02 10:54:00)