Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-09 Thread Timo Sirainen
On Wed, 2009-12-09 at 13:23 -0800, Richard Stockton wrote: > At 01:10 PM 12/9/2009, Timo Sirainen wrote: > >On Wed, 2009-12-09 at 13:05 -0800, Richard Stockton wrote: > > > I just tried: concat('mail/', home) as userdb_home > > > >Was it really 'mail/', not '/mail/'? I forgot those / characters abo

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-09 Thread Richard Stockton
At 01:10 PM 12/9/2009, Timo Sirainen wrote: On Wed, 2009-12-09 at 13:05 -0800, Richard Stockton wrote: > I just tried: concat('mail/', home) as userdb_home Was it really 'mail/', not '/mail/'? I forgot those / characters above.. Yes, I figured the "maildir:~/" was putting in the first "/". >

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-09 Thread Timo Sirainen
On Wed, 2009-12-09 at 13:05 -0800, Richard Stockton wrote: > At 12:28 PM 12/9/2009, Timo Sirainen wrote: > >Oh. || wasn't concat operator in MySQL after all. I just recently tested > >that it didn't give an error so I assumed it was concat, not logical > >or. :) > > > > > I believe these errors wer

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-09 Thread Richard Stockton
At 12:28 PM 12/9/2009, Timo Sirainen wrote: Oh. || wasn't concat operator in MySQL after all. I just recently tested that it didn't give an error so I assumed it was concat, not logical or. :) > I believe these errors were from my first attempt, when I just had > "'/mail/' || home as userdb_home

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-09 Thread Timo Sirainen
On Wed, 2009-12-09 at 12:22 -0800, Richard Stockton wrote: > At 11:45 AM 12/9/2009, Timo Sirainen wrote: > >On Wed, 2009-12-09 at 11:38 -0800, Richard Stockton wrote: > > > >password_query = .., 'maildir:/mail/' || home as userdb_mail, .. > > > > > > Sorry, that doesn't work either. I get an "imap

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-09 Thread Richard Stockton
At 11:45 AM 12/9/2009, Timo Sirainen wrote: On Wed, 2009-12-09 at 11:38 -0800, Richard Stockton wrote: > >password_query = .., 'maildir:/mail/' || home as userdb_mail, .. > > Sorry, that doesn't work either. I get an "imap protocol error" in > squirrelmail. And what did Dovecot's logs say? http

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-09 Thread Timo Sirainen
On Wed, 2009-12-09 at 11:38 -0800, Richard Stockton wrote: > >password_query = .., 'maildir:/mail/' || home as userdb_mail, .. > > Sorry, that doesn't work either. I get an "imap protocol error" in > squirrelmail. And what did Dovecot's logs say? http://wiki.dovecot.org/Logging > I see your ot

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-09 Thread Richard Stockton
At 11:21 AM 12/9/2009, Timo Sirainen wrote: On Wed, 2009-12-09 at 11:13 -0800, Richard Stockton wrote: > >password_query = .., '/mail/' || home as userdb_mail, .. > > > >Then the mail_location in dovecot.conf will be completely ignored. > > I assume you meant to have me change it to: > password_q

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-09 Thread Timo Sirainen
On Wed, 2009-12-09 at 11:13 -0800, Richard Stockton wrote: > I assume you meant to have me change it to: > password_query = .., '/mail/' || home as userdb_home, .. > since there is no "mail" field in my DB table. Although this should work too with: mail_location = maildir:~/ That's actually bett

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-09 Thread Timo Sirainen
On Wed, 2009-12-09 at 11:13 -0800, Richard Stockton wrote: > >password_query = .., '/mail/' || home as userdb_mail, .. > > > >Then the mail_location in dovecot.conf will be completely ignored. > > I assume you meant to have me change it to: > password_query = .., '/mail/' || home as userdb_home, .

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-09 Thread Richard Stockton
Hi Timo, At 07:32 PM 12/8/2009, Timo wrote: On Dec 8, 2009, at 7:01 PM, Richard Stockton wrote: > Here is what we are using with 1.1.19: > > password_query = SELECT password, home as userdb_home, 5000 as userdb_uid, > 5000 as userdb_gid FROM mailbox where userid = '%n' > > mail_location = maild

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-08 Thread Timo Sirainen
On Dec 8, 2009, at 7:01 PM, Richard Stockton wrote: > Here is what we are using with 1.1.19: > > password_query = SELECT password, home as userdb_home, 5000 as userdb_uid, > 5000 as userdb_gid FROM mailbox where userid = '%n' > > mail_location = maildir:/mail/%h:INDEX=MEMORY So you're using rel

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-08 Thread Richard Stockton
Hi Timo, Okay, I'm confused now... Here is what we are using with 1.1.19: password_query = SELECT password, home as userdb_home, 5000 as userdb_uid, 5000 as userdb_gid FROM mailbox where userid = '%n' mail_location = maildir:/mail/%h:INDEX=MEMORY The "/mail/" dir contains 26 NFS mounted part

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-08 Thread Noel Butler
On Tue, 2009-12-08 at 18:20 -0500, Timo Sirainen wrote: > On Wed, 2009-12-09 at 08:58 +1000, Noel Butler wrote: > > So, in using... > > > > user_query = select 26 as uid, 26 as gid, '/var/vmail/%d/%1n/%1.1n/% > > 2.1n/%n' as home, > > > > mail_location = maildir:/var/vmail/%d/%1n/%1.1n/%2.1n/%n

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-08 Thread Timo Sirainen
On Wed, 2009-12-09 at 08:58 +1000, Noel Butler wrote: > So, in using... > > user_query = select 26 as uid, 26 as gid, '/var/vmail/%d/%1n/%1.1n/% > 2.1n/%n' as home, > > mail_location = maildir:/var/vmail/%d/%1n/%1.1n/%2.1n/%n/Maildir > > ... that is no longer the preferred way? I don't th

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-08 Thread Noel Butler
On Tue, 2009-12-08 at 10:26 -0500, Timo Sirainen wrote: > On Dec 8, 2009, at 4:48 AM, Proskurin Kirill wrote: > > > /usr/local/etc/dovecot.conf: > > mail_location = maildir:/var/spool/dovecot/domains/%d/%n > > > > /usr/local/etc/dovecot-ldap.conf: > > user_attrs = mailQuotaSize=quota_rule=*:stor

Re: [Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-08 Thread Timo Sirainen
On Dec 8, 2009, at 4:48 AM, Proskurin Kirill wrote: > /usr/local/etc/dovecot.conf: > mail_location = maildir:/var/spool/dovecot/domains/%d/%n > > /usr/local/etc/dovecot-ldap.conf: > user_attrs = mailQuotaSize=quota_rule=*:storage=%$M > ,=uid=1002,=gid=1002,=home=/var/spool/dovecot/domains/%d/%n

[Dovecot] After upgrading to 1.2 - absolute path questions

2009-12-08 Thread Proskurin Kirill
Hello. I have this: /usr/local/etc/dovecot.conf: mail_location = maildir:/var/spool/dovecot/domains/%d/%n /usr/local/etc/dovecot-ldap.conf: user_attrs = mailQuotaSize=quota_rule=*:storage=%$M ,=uid=1002,=gid=1002,=home=/var/spool/dovecot/domains/%d/%n Two absolute paths seems to it is not ri