Re: [Dovecot] still having problems with deliver , quota , mysql

2007-09-11 Thread Nils Vogels
Osvaldo Alvarez Pozo wrote on 11-9-2007 18:40:
> Hi I have problems with deliver? I can not make it work with mysql.
> I mean I can write over the space declared on mysql.
> does any have a way of setting up deliver to read quota from mysql???
> Thanks
>
>   
Since I have no idea what it is exactly that isn't working, have a look
here:

http://article.gmane.org/gmane.mail.imap.dovecot/24074/match=

it kinda contains a solution for something you might be experiencing :-)

If something else is wrong, I recommend turning on auth_verbose,
auth_debug and giving a description of the problem at hand.

Greetings,

Nils.




signature.asc
Description: OpenPGP digital signature


Re: [Dovecot] Dovecot + Sieve - and passdb/userdb

2007-09-08 Thread Nils Vogels
On Fri, Sep 07, 2007 at 12:26:28PM -0700, Daniel L. Miller (DLM) wrote:
DLM> Nils Vogels wrote:
DLM> >Everything that would for some reason go into the users homedir, you
DLM> >would be able to reach via Imap.
DLM> >
DLM> >If I were you, I'd make home and mail point to a different directory,
DLM> >which could be as simple as home=/var/mail/%d/%n
DLM> >mail=/var/mail/%d/%n/Maildir. This way, dovecot will only look for mail
DLM> >in the $HOME/Maildir, but still can do administrative stuff in $HOME.
DLM> >
DLM> What "administrative stuff"?  These directories are used exclusively for 
mail - if any user actually has a local 
DLM> account their home folders are located under "/home" - but I don't want 
that mixed with mail service at all.

Administrative stuff such as sieve filters, possible error logs, textfiles
that are used by other plugins such as vacation (lda-dupes), etc, etc.

This way you won't be able to see those in your subscribe list, which is a
good thing since they aren't mailboxes/dirs :)

Gr,

Nils
-- 
Simple guidelines to happiness:
Work like you don't need the money,
love like your heart has never been broken and 
dance like no one can see you.


pgpbWPK3RPLFs.pgp
Description: PGP signature


Re: [Dovecot] Dovecot + Sieve - and passdb/userdb

2007-09-07 Thread Nils Vogels
Daniel L. Miller wrote on 7-9-2007 2:24:
> userdb static {
>args = uid=5000 gid=8 home=/var/mail/%d/%n mail=/var/mail/%d/%n
> allow_all_users=yes
>  }
>  plugin {
>sieve = sieve
>  }
>
> Deliver + sieve is working great.  By setting the sieve variable to
> "sieve", a non-hidden file, it doesn't appear in the folder list.  I
> made a similar change to pysieved to use a non-hidden folder - in
> combination with avelsieve and squirrelmail I now have a
> user-maintainable server-side filter solution.  Awesome!
>
> Is there a hidden "gotcha" I'm missing here?  It's doing exactly what
> I want!
Everything that would for some reason go into the users homedir, you
would be able to reach via Imap.

If I were you, I'd make home and mail point to a different directory,
which could be as simple as home=/var/mail/%d/%n
mail=/var/mail/%d/%n/Maildir. This way, dovecot will only look for mail
in the $HOME/Maildir, but still can do administrative stuff in $HOME.

Grts,

Nils




signature.asc
Description: OpenPGP digital signature


Re: [Dovecot] dovecot/postfix+vda

2007-09-06 Thread Nils Vogels
Hey Neil,

Neil Wilson wrote on 5-9-2007 16:41:
> Been fighting with postfix+vda/dovecot/
>
> My postfix delivers the emails to /vmail/ which is owned by user
> maild:users 501(uid):100(gid) without any problems.
>
> Sep  5 16:32:52 mail dovecot: POP3(samichand):
> stat(/vmail/samichand/Maildir/cur) failed: Permission denied
>
> mail:/ # cat /usr/local/etc/dovecot.conf
> mail_location = maildir:/vmail/%u/Maildir
> auth default {
>   mechanisms = plain
>   passdb shadow {
>   }
>   userdb passwd {
>   }
>   user = root
> }
> dict {
> }
> plugin {
> }
>
> All I want is to be able to access the mail, with the same my
> "virtual_uid_maps = static:501"(set in my postfix main.cf)
>
Try using a static userdb: http://wiki.dovecot.org/UserDatabase/Static

HTH & HAND!

Nils.


Re: [Dovecot] quota imap_quota

2007-08-28 Thread Nils Vogels
Bazy wrote on 28-8-2007 23:05:
> plugin {
> # 10 MB + 1000 messages quota limit
> # quota = maildir:storage=10240:messages=1000
>
> driver = mysql
> connect = host=/var/lib/mysql/mysql.sock user=mail_admin
> password= dbname=mail
> user_query = SELECT CONCAT(('/home/vmail/'),
> SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'),
> CONCAT('5000'), CONCAT('5000'), CONCAT('maildir:storage=', quota) FROM
> users AS quota WHERE email = '%u';
> }
>
> The querry output looks like this:
>
> +--+++---+
> | CONCAT(('/home/vmail/'),
> SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') |
> CONCAT('5000') | CONCAT('5000') | CONCAT('maildir:storage=', quota) |
> +--+++---+
> | /home/vmail/goofy.celuloza.ro/bazy/
>| 5000   | 5000   |
> maildir:storage=10240 |
> +--+++---+
>   

I'm not the expert on the matter, but I think your columns are named
wrong. Try changing the latter part of the user_query to
'CONCAT('maildir:storage=', quote) AS quota FROM users WHERE email = '%u';

As an example, I've posted my userdb query:

user_query = SELECT concat('/mail/', maildir) as home,
concat('maildir:/mail/', maildir) as mail, 108 AS uid, 116 AS gid,
concat('maildir:storage=', quota) AS quota FROM mailbox WHERE username =
'%u' AND active = '1'


Hope this helps!

Nils.



signature.asc
Description: OpenPGP digital signature


Re: [Dovecot] sieve discard

2007-07-31 Thread Nils Vogels
Hi Timo,

Timo Sirainen wrote on 23-7-2007 7:13:
> On Mon, 2007-07-23 at 00:52 -0400, Jim Horner wrote:
>   
>> Does the keyword/action discard work by default or is there something I have 
>> to do in the configuration to get to work...
>> 
>
> Sorry, looks like I broke this for Dovecot v1.0.2. Could you verify that
> this patch fixes it: http://hg.dovecot.org/dovecot-1.0/rev/be2c4dacae2c
>
> I'll release v1.0.3 then.
>   
Any plans for releasing sieve 1.0.3?

I'm working on upgrading the FreeBSD port, but dont want to be caught in
upgrading to an instantly old version :-)

Greets,

Nils



signature.asc
Description: OpenPGP digital signature


Re: [Dovecot] Dovecot 1.0.0 and Seive 1.0.1 on FreeBSD

2007-04-20 Thread Nils Vogels
Ed Lucero wrote on 20-4-2007 18:00:
>> deliver([EMAIL PROTECTED]): Apr 19 14:07:19 Info: Loading modules from
>> 
>>> directory: /usr/local/libexec/dovecot
>>> deliver([EMAIL PROTECTED]): Apr 19 14:07:19 Fatal: Plugin sieved not
>>> found from directory /usr/local/libexec/dovecot
>>>   
>
> This is a FreeBSD port. It creates two binaries sievec and sieved. I looked
> at the src in the port and the one downloaded from the web. They are
> identical except for some files used nthe FreeBSD port.
>
> I'll contact the man doing the p[ort.
>   
That would be me.

Your dovecot is looking in the wrong place to find the sieve plugin. Try
pointing it to

/usr/local/lib/dovecot/lda

Greets,

Nils

-- 
Those who desire to give up freedom in order to gain security, will not have, 
nor do they deserve, either one.

~Benjamin Franklin (American Statesman, Scientist, Philosopher, Printer, Writer 
and Inventor. 1706-1790)




signature.asc
Description: OpenPGP digital signature


Re: [Dovecot] How to get rid of locks

2007-04-07 Thread Nils Vogels
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
 
Timo Sirainen wrote on 7-4-2007 21:30:
> Could you BSD people try if it works there?
> http://dovecot.org/tmp/append.c and see if it says "offset = 0"
> (bad) or non-zero (yay). The O_APPEND at least doesn't work with
> NFS, so it'll have to be optional anyway.
5.4-RELEASE-p6: yay
6.0-RELEASE: yay

Greets,

Nils
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (MingW32)
 
iD8DBQFGGDMqMzNX/a06Wq0RAkhiAJ9RjtMRHDRASuHiIrCxmPTJZZ1MFwCfasOR
6W2/mjFuPyf7jbTQfe6zpII=
=Y9Zk
-END PGP SIGNATURE-


Re: [Dovecot] uiddir mailbox format with benchmarks

2007-03-29 Thread Nils Vogels
On Thu, Mar 29, 2007 at 06:44:32PM +0300, Timo Sirainen (TS) wrote:
TS> On 29.3.2007, at 18.41, Nils Vogels wrote:
TS> >On Thu, Mar 29, 2007 at 06:28:04PM +0300, Timo Sirainen (TS) wrote:
TS> >TS>
TS> >TS> BTW. Does anyone have better naming ideas than "uiddir"? I'll commit it
TS> >TS> to CVS HEAD once I'm sure about the name. :)
TS> >
TS> >What about dstore?
TS> 
TS> There already exists dbox, which is another one of Dovecot's own formats. I 
did think 
TS> about ddir, but that sounds a bit stupid. :) Probably better if it doesn't 
start with d 
TS> anyway so it won't get mixed with dbox.

In that case I think sds has a nice ring to it -- Single Directory Store

Greetings,

Nils

-- 
Simple guidelines to happiness:
Work like you don't need the money,
love like your heart has never been broken and 
dance like no one can see you.


pgpAlnmiLa5xN.pgp
Description: PGP signature


Re: [Dovecot] uiddir mailbox format with benchmarks

2007-03-29 Thread Nils Vogels
On Thu, Mar 29, 2007 at 06:28:04PM +0300, Timo Sirainen (TS) wrote:
TS> 
TS> BTW. Does anyone have better naming ideas than "uiddir"? I'll commit it
TS> to CVS HEAD once I'm sure about the name. :)

What about dstore?

Greetings,

Nils

-- 
Simple guidelines to happiness:
Work like you don't need the money,
love like your heart has never been broken and 
dance like no one can see you.


pgpCR5ATiK6Fn.pgp
Description: PGP signature


Re: [Dovecot] Version numbering

2007-03-29 Thread Nils Vogels
On Thu, Mar 29, 2007 at 02:05:13AM +0300, Timo Sirainen (TS) wrote:
TS> 
TS> I don't think packaging is going to be that big of a problem. If the 
packagers 
TS> can't handle that, then just don't package it. Development versions don't 
TS> really need binary packages anyway.. And for those using the binary 
packages, 
TS> the alpha/beta/rc in the version make it pretty easy to understand what 
kind 
TS> of a release it is.

This will work just fine for FreeBSD ports!

Greets,

Nils

-- 
Simple guidelines to happiness:
Work like you don't need the money,
love like your heart has never been broken and 
dance like no one can see you.


pgpCL6RlhSssY.pgp
Description: PGP signature


Re: [Dovecot] Benchmarking CVS HEAD vs. v1.0

2007-03-15 Thread Nils Vogels
On Thu, Mar 15, 2007 at 12:45:45PM +0200, Timo Sirainen (TS) wrote:

TS> Another thing that I was planning was to send updated STATUS replies 
automatically to 
TS> client without it even asking them. That would probably have to be optional 
and could be 
TS> enabled either with config file option or with some new IMAP extension.

It would be great if this would be tunable at the user level, since I can
think of users (roaming mobile) that wouldn't want a status message to cause
their 3G connection to keep on using time/data.

Then again, most mobile operators would possibly love it! :)

Greetings,

Nils

-- 
Simple guidelines to happiness:
Work like you don't need the money,
love like your heart has never been broken and 
dance like no one can see you.


pgpXBgUhRLZx9.pgp
Description: PGP signature


Re: [Dovecot] Issue with pop3 & phpList

2007-03-14 Thread Nils Vogels
On Wed, Mar 14, 2007 at 07:17:31AM -0700, Chris Harner (CH) wrote:
CH> were too many login attempts.  Does dovecot have a default
CH> username/password?  How do I set up a username and password?

No, dovecot uses various plugins for authentication and authorization of users
with passwords that belong to them. My guess is that it would be best for you
to create a user on your dovecot box specially for phplist, most likely
dovecot's default authentication configuration will work just fine for you.

CH> Is there a special way to just have the pop3 portion of Dovecot load?  I
CH> went through the config file and took out some of the #'s like the docs
CH> said.  Thanks!

Disabling the "protocol imap" section should get you started.
Don't forget to enable pop3 as well!

Gr,

Nils

-- 
Simple guidelines to happiness:
Work like you don't need the money,
love like your heart has never been broken and 
dance like no one can see you.


pgpWl8ncap2iG.pgp
Description: PGP signature