Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Jerry
On Fri, 23 Apr 2010 16:07:20 +0100 Ed articulated: > Err to be fair, I was about to reply and say that it's IS achievable, > but on the flip side I would concede that it does require a bit of > thought to make this stuff work correctly. I think you are being a > bit harsh to suggest it's *that

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Ed W
On 23/04/2010 15:51, Jerry wrote: There are numerous ways to export/backup a live MySQL database. I have employed several of them myself. You might want to check out this URL for starters: http://www.noupe.com/how-tos/10-ways-to-automatically-manually-backup-mysql-database.html Your statement t

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Jerry
On Fri, 23 Apr 2010 09:03:02 -0400 Phil articulated: > You rsync the files an SQL database (like MySQL) works from, and don't > expect corruption? That's only safe if the database is synced and > shut down. I don't want to be doing that. If I did run a database > engine, it would have to impor

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Phil Howard
On Fri, Apr 23, 2010 at 5:23 AM, Ed W wrote: > P.S. The "idiot" who kept breaking the plain text format file in my > original setup was da da ... me ... So given I think of myself as > reasonably technical, I would claim that text format "databases" are way > more fragile than you might exp

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Phil Howard
On Fri, Apr 23, 2010 at 3:45 AM, Ed W wrote: You need to look at where you are going with this One way or another you > need a database - call it a banana if you prefer, but it's still a database > whether it's a flat file or a BDB file or whatever > One must be careful with the term "databa

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-23 Thread Phil Howard
On Fri, Apr 23, 2010 at 2:49 AM, Rainer Frey wrote: > On Thursday 22 April 2010 18:15:18 Phil Howard wrote: > [ ... all standard stuff that is well documented ... ] > > > 5. Passwords stored encrypted, such as MD5. And it should be a scheme > > that both Postfix and Dovecot can use so I don't h

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-23 Thread Ed W
On 23/04/2010 10:30, Gábor Lénárt wrote: On Wed, Apr 21, 2010 at 01:45:35PM -0400, Phil Howard wrote: Then I think MySQL will do the job. Both postfix and dovecot support MySQL, and you can use SASL to authenticate SMTP with Dovecot, so Dovecot would do all the auth work. Finally, you could

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-23 Thread Gábor Lénárt
On Wed, Apr 21, 2010 at 01:45:35PM -0400, Phil Howard wrote: > > Then I think MySQL will do the job. Both postfix and dovecot support MySQL, > > and you can use SASL to authenticate SMTP with Dovecot, so Dovecot would do > > all the auth work. Finally, you could use Postfix's VDA patch if you want

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Ed W
P.S. The "idiot" who kept breaking the plain text format file in my original setup was da da ... me ... So given I think of myself as reasonably technical, I would claim that text format "databases" are way more fragile than you might expect (good luck getting a non technical user not

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-23 Thread Ed W
On 22/04/2010 17:18, Phil Howard wrote: I have not been following this thread as closely as I probably should have; however, I was wondering what the OP's problem was with using MySQL? It would greatly simplify the job of constructing and maintaining databases. It is even possible to create tab

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Rainer Frey
On Thursday 22 April 2010 18:15:18 Phil Howard wrote: [ ... all standard stuff that is well documented ... ] > 5. Passwords stored encrypted, such as MD5. And it should be a scheme > that both Postfix and Dovecot can use so I don't have keep two different > encryption schemes. Postfix doesn't n

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-22 Thread Phil Howard
On Thu, Apr 22, 2010 at 5:19 PM, Stan Hoeppner wrote: > One nice thing about Postfix is that the documentation is _very_ thorough, > even if sometimes hard to digest. > Yes, I would agree. Sometimes a twisty maze of passages, but you can eventually find things. Good luck, and please keep us up

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-22 Thread Phil Howard
On Thu, Apr 22, 2010 at 4:31 PM, Arne K. Haaje wrote: Have you looked into Postfix Admin? http://postfixadmin.sourceforge.net/ > > It might be a good solution for you. I'm using it for a a growing database > of users and I'm very happy with it. The setup with postfix, dovecot and > mysql was quit

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-22 Thread Stan Hoeppner
Phil Howard put forth on 4/22/2010 3:07 PM: > I would think the general (insert some character here)-separated file should > be doable: > comma-delimited:/some/file/name > colon-delimited:/some/file/name > tab-delimited:/some/file/name > space-delimited:/some/file/name > But it has

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-22 Thread Arne K. Haaje
Phil Howard skrev: On Thu, Apr 22, 2010 at 12:12 PM, Jerry wrote: On Thu, 22 Apr 2010 17:03:00 +0200 Rainer articulated: Well, it leaves out the *one tricky part* of using a flat file database for virtual users with dovecot and postfix: there is no common format that both understand

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-22 Thread Phil Howard
On Thu, Apr 22, 2010 at 3:12 PM, Stan Hoeppner wrote: > With this many lookup table types supported by Postfix, is it true that it > has no "simple" table type in common with Dovecot? > There are some ... like mysql for example. The ones I call "simple" are ones that have a single file in some r

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-22 Thread Stan Hoeppner
Phil Howard put forth on 4/22/2010 11:18 AM: > On Thu, Apr 22, 2010 at 12:12 PM, Jerry wrote: > >> On Thu, 22 Apr 2010 17:03:00 +0200 >> Rainer articulated: >> >>> Well, it leaves out the *one tricky part* of using a flat file >>> database for virtual users with dovecot and postfix: there is no

Re: [Dovecot] best choice of user database file to work with?postfix?

2010-04-22 Thread Thomas Leuxner
Am 22.04.2010 um 17:03 schrieb Rainer Frey (Inxmail GmbH): > So a valid recipient must be in the passwd file and in the postfix virtual > alias file? This does not solve the problem of using the same flat-file user > database between doevecot and postfix, and of course int that case you can > de

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-22 Thread Phil Howard
On Thu, Apr 22, 2010 at 12:40 PM, Jerry wrote: > On Thu, 22 Apr 2010 12:18:41 -0400 > Phil articulated: > > > The administration is going to be handed off to less technical > > people, and my goal is to mimize the number of elements in this. > > It's not about MySQL itself ... it's about not run

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-22 Thread Jerry
On Thu, 22 Apr 2010 12:18:41 -0400 Phil articulated: > The administration is going to be handed off to less technical > people, and my goal is to mimize the number of elements in this. > It's not about MySQL itself ... it's about not running yet another > server/daemon. Excuse my ignorance here;

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Phil Howard
On Thu, Apr 22, 2010 at 12:07 PM, Jim Trigg wrote: > On Thu, Apr 22, 2010 at 09:48:36AM -0400, Phil Howard wrote: > > The ideal would be a complete mail server package that handled it all in > one > > ... SMTP, submission, IMAP(S), POP3(S). But what I've seen as attempts > to > > do that so far

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-22 Thread Phil Howard
On Thu, Apr 22, 2010 at 12:12 PM, Jerry wrote: > On Thu, 22 Apr 2010 17:03:00 +0200 > Rainer articulated: > > > Well, it leaves out the *one tricky part* of using a flat file > > database for virtual users with dovecot and postfix: there is no > > common format that both understand directly. > >

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Phil Howard
On Thu, Apr 22, 2010 at 10:43 AM, Rainer Frey wrote: > If you can't wait for Dovecot 2.0, you need to use dovecot deliver, but you > should set it up as a pipe transport in master - see > http://wiki.dovecot.org/LDA/Postfix for virtual users. mailbox_command > again > is for real system users onl

Re: [Dovecot] best choice of user database file to work with postfix

2010-04-22 Thread Jerry
On Thu, 22 Apr 2010 17:03:00 +0200 Rainer articulated: > Well, it leaves out the *one tricky part* of using a flat file > database for virtual users with dovecot and postfix: there is no > common format that both understand directly. I have not been following this thread as closely as I probably

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Jim Trigg
On Thu, Apr 22, 2010 at 09:48:36AM -0400, Phil Howard wrote: > The ideal would be a complete mail server package that handled it all in one > ... SMTP, submission, IMAP(S), POP3(S). But what I've seen as attempts to > do that so far were less than promising (even though I have no need for what > m

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Rainer Frey
On Thursday 22 April 2010 15:34:40 Phil Howard wrote: > So what would local_recipient_maps look like in this case? As the suggested setup uses virtual_mailbox_domains for the mailboxes hosted by dovecot, it would be virtual_mailbox_maps. Alternatively one could define relay_domains, relay_tran

Re: [Dovecot] best choice of user database file to work with?postfix?

2010-04-22 Thread Thomas Leuxner
On Thu, Apr 22, 2010 at 01:12:24PM +0200, Rainer Frey wrote: > Do you define all valid recipients there (e.g. in you example virtual file > lo...@domain.tld)? Yes. > But this is at the delivery stage, when the mail has already been accepted. > This means, if no homedir/mailbox is found, bounce

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Phil Howard
On Thu, Apr 22, 2010 at 5:42 AM, Thomas Leuxner wrote: > On Thu, Apr 22, 2010 at 11:18:09AM +0200, Rainer Frey wrote: > > What I don't see here at all (and neither in your Wiki Howto) is how > Postfix > > determines the valid recipients for the domains in > virtual_mailbox_domains. > > Postfix wi

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Phil Howard
On Thu, Apr 22, 2010 at 7:12 AM, Rainer Frey wrote: > This is wrong. The auth service is not queried for recipient, only for > valid > SASL users (that connect to the submission service as *senders*). I'm > talking > about determining valid *recipients* for the virtual_mailbox_domains. > That's

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Phil Howard
On Thu, Apr 22, 2010 at 3:33 AM, Thomas Leuxner wrote: > On Wed, Apr 21, 2010 at 04:34:30PM -0400, Phil Howard wrote: > > > userdb { > > > args = username_format=%u /var/vmail/auth.d/%d/passwd > > > driver = passwd-file > > > } > > What does it take to get Postfix to read this? > > Basically th

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Phil Howard
On Wed, Apr 21, 2010 at 5:45 PM, Heiko Schlittermann wrote: > Hello Phil, > > Phil Howard (Mi 21 Apr 2010 16:32:36 CEST): > > I'm setting up a Postfix and Dovecot combination. What I want to do is > have > > a user database that (1) is not running from some engine (so not LDAP or > SQL > > or s

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Thomas Leuxner
On Thu, Apr 22, 2010 at 11:18:09AM +0200, Rainer Frey wrote: > What I don't see here at all (and neither in your Wiki Howto) is how Postfix > determines the valid recipients for the domains in virtual_mailbox_domains. Postfix will expand possible aliases first and determine the final recipient ha

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Rainer Frey
On Wednesday 21 April 2010 21:30:12 Thomas Leuxner wrote: > I'm running a setup that should be good enough for what you are trying to > achieve. All user information is stored in flat files per domain and you > may override per user settings individually: > > passdb { > args = username_format=%u

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Thomas Leuxner
I have now created a basic How To for the desired configuration on the 2.0 Wiki. Although it has some 2.0 specifics it should work with 1.2 for most parts too. Maybe someone with a higher privilege level on the Wiki than I have can beautify the URL by removing the Whitespaces :) http://wiki2.dovec

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-22 Thread Thomas Leuxner
On Wed, Apr 21, 2010 at 04:34:30PM -0400, Phil Howard wrote: > > userdb { > > args = username_format=%u /var/vmail/auth.d/%d/passwd > > driver = passwd-file > > } > What does it take to get Postfix to read this? Basically these two parameters in 'main.cf': [main.cf] smtpd_sasl_type=dovecot smtp

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Curtis Maloney
On 04/22/10 00:58, Peter Hessler wrote: postfix: smtpd_sasl_type = dovecot smtpd_sasl_path = private/auth dovecot: auth default { socket listen { client { path = /var/spool/postfix/private/auth user = _postfix group = wheel mode = 0660 } } } Then c

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Heiko Schlittermann
Hello Phil, Phil Howard (Mi 21 Apr 2010 16:32:36 CEST): > I'm setting up a Postfix and Dovecot combination. What I want to do is have > a user database that (1) is not running from some engine (so not LDAP or SQL > or such) ... and (2) is completely disassociated from system users (e.g. > most e

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Phil Howard
On Wed, Apr 21, 2010 at 3:30 PM, Thomas Leuxner wrote: > I'm running a setup that should be good enough for what you are trying to > achieve. All user information is stored in flat files per domain and you may > override per user settings individually: > > passdb { > args = username_format=%u /v

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Thomas Leuxner
I'm running a setup that should be good enough for what you are trying to achieve. All user information is stored in flat files per domain and you may override per user settings individually: passdb { args = username_format=%u /var/vmail/auth.d/%d/passwd driver = passwd-file } userdb { ar

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Phil Howard
On Wed, Apr 21, 2010 at 1:30 PM, Rodolfo Gonzalez wrote: > Phil Howard escribió: > > On Wed, Apr 21, 2010 at 10:47 AM, Patrick Nagel > >wrote: >> >> I think /etc/passwd is as close as it gets to your requirements... why >>> not >>> just add the users as system users, and set their shell to /bin

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Phil Howard
On Wed, Apr 21, 2010 at 10:58 AM, Peter Hessler wrote: > postfix: > > smtpd_sasl_type = dovecot > smtpd_sasl_path = private/auth > > > dovecot: > > auth default { > socket listen { >client { > path = /var/spool/postfix/private/auth > user = _postfix > group = wheel > mode

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Rodolfo Gonzalez
Phil Howard escribió: On Wed, Apr 21, 2010 at 10:47 AM, Patrick Nagel wrote: I think /etc/passwd is as close as it gets to your requirements... why not just add the users as system users, and set their shell to /bin/false? There would be conflicts in this, especially with multiple domain nam

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Phil Howard
On Wed, Apr 21, 2010 at 10:47 AM, Patrick Nagel wrote: > I think /etc/passwd is as close as it gets to your requirements... why not > just add the users as system users, and set their shell to /bin/false? > There would be conflicts in this, especially with multiple domain names (sorry, forgot to

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Brian Candler
On Wed, Apr 21, 2010 at 10:32:36AM -0400, Phil Howard wrote: > Ideal would be a one-file solution, which can be managed by > text editing or simple command line tools. But what I want is ONE file that > both Postfix (for valid recipients) and Dovecot (for user login > authentication) can use toget

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Alexander
, April 21, 2010 3:32 PM Subject: [Dovecot] best choice of user database file to work with postfix? > I'm setting up a Postfix and Dovecot combination. What I want to do is have > a user database that (1) is not running from some engine (so not LDAP or SQL > or such) ... and (2) is

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Peter Hessler
postfix: smtpd_sasl_type = dovecot smtpd_sasl_path = private/auth dovecot: auth default { socket listen { client { path = /var/spool/postfix/private/auth user = _postfix group = wheel mode = 0660 } } } Then configure your favorite auth mechanism for dovecot.

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Patrick Nagel
I think /etc/passwd is as close as it gets to your requirements... why not just add the users as system users, and set their shell to /bin/false? Patrick "Phil Howard" wrote: >I'm setting up a Postfix and Dovecot combination. What I want to do is have >a user database that (1) is not running

Re: [Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Andreas Schulze
build as passdb ( http://wiki.dovecot.org/AuthDatabase/PasswdFile ) and write a sript which builds an valid postfix lookuptable usable as local_recipient_maps. Andreas Am 21.04.2010 10:32 schrieb Phil Howard: > I'm setting up a Postfix and Dovecot combination. What I want to do is have > a user

[Dovecot] best choice of user database file to work with postfix?

2010-04-21 Thread Phil Howard
I'm setting up a Postfix and Dovecot combination. What I want to do is have a user database that (1) is not running from some engine (so not LDAP or SQL or such) ... and (2) is completely disassociated from system users (e.g. most email users are not in /etc/passwd and most /etc/passwd users are n