- dovecot - dovecot.org

[Dovecot] MySQL table for use with dict et quota
by mikael 24 Jul '06

24 Jul '06

In your "http://wiki.dovecot.org/Quota/Dict" documentation, the table to create is : create table quota ( path varchar(255) not null primary key, username varchar(255) not null, current integer ); "path" field is the primary key. But when i see the SELECT queries, "path" is always used ('quota/storage') and username too. I don't understand... If "path" is the primary key, it must be unique in quota table ? Perhaps the table would be like this : create table quota ( path varchar(255) not null, username varchar(255) not null, current integer, primary key (path, username) ); No ? I start to have a headache... :D 2 days with dovecot quota, and no fully working results :'( Please, help me :) -- Mikaël

1 0

[Dovecot] Try with Dictionary proxy server, but... Bug or not ?
by mikael 24 Jul '06

24 Jul '06

Hello again :), I try to use dictionary proxy server to replace my precedent configuration (direct use of dict in plugin quota). Before, i have this configuration in my dovecot.conf : ## Dictionary server settings dict { } ## Plugin settings plugin { # quota = 10 Mo quota = dict:storage=10240 mysql:/etc/dovecot/dict-quota.conf } And after, to use proxy, I have this configuration in my dovecot.conf : ## Dictionary server settings dict { quota = mysql:/etc/dovecot/dict-quota.conf } ## Plugin settings plugin { # quota = 10 Mo quota = dict:storage=10240 proxy::quota } My dict-quota.conf doesn't change : connect = host=localhost dbname=dovecot user=dovecot table = quota select_field = current where_field = path username_field = username My dovecot.info file : dovecot: 2006-07-23 15:07:01 Info: IMAP(test): Effective uid=1019, gid=1019 dovecot: 2006-07-23 15:07:01 Info: IMAP(test): Loading modules from directory: /usr/lib/dovecot/modules/imap dovecot: 2006-07-23 15:07:01 Info: IMAP(test): Module loaded: /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so dovecot: 2006-07-23 15:07:01 Info: IMAP(test): Module loaded: /usr/lib/dovecot/modules/imap/lib02_imap_quota_plugin.so dovecot: 2006-07-23 15:07:01 Info: IMAP(test): maildir: data=/home/test/Mail dovecot: 2006-07-23 15:07:01 Info: IMAP(test): maildir: root=/home/test/Mail, index=/home/test/Mail, control=, inbox= dovecot: 2006-07-23 15:07:01 Info: IMAP(test): dict quota: uri = proxy::quota dovecot: 2006-07-23 15:07:01 Info: IMAP(test): dict quota: byte limit = 10485760 dovecot: 2006-07-23 15:07:01 Info: IMAP(test): dict quota: count limit = 0 dovecot: 2006-07-23 15:07:01 Info: imap-login: Login: user=<test>, method=plain, rip=82.228.176.60, lip=192.168.1.60 When i use the proxy configuration, i have this error : dovecot: 2006-07-23 15:07:51 Error: dict: sql dict: commit failed: Not connected to database dovecot: 2006-07-23 15:07:51 Error: IMAP(test): dict_quota: Couldn't update quota dovecot: 2006-07-23 15:07:51 Error: dict: sql dict: commit failed: Not connected to database dovecot: 2006-07-23 15:07:51 Error: IMAP(test): dict_quota: Couldn't update quota dovecot: 2006-07-23 15:07:51 Error: dict: sql dict: commit failed: Not connected to database dovecot: 2006-07-23 15:07:51 Error: IMAP(test): dict_quota: Couldn't update quota dovecot: 2006-07-23 15:07:52 Error: dict: sql dict: commit failed: Not connected to database dovecot: 2006-07-23 15:07:52 Error: IMAP(test): dict_quota: Couldn't update quota And in MySQL log : 060723 15:07:01 460 Connect Accès refusé pour l'utilisateur: 'dovecot'@'@localhost' (mot de passe: NON) 060723 15:07:45 461 Connect Accès refusé pour l'utilisateur: 'dovecot'@'@localhost' (mot de passe: NON) It try to connect with 'dovecot'@'@localhost'... But it will be 'dovecot'@'localhost'. No ? Thanks for your help, -- Mikaël,

1 2

[Dovecot] Bug or not ?
by mikael 23 Jul '06

23 Jul '06

Hello, I can't have quota with dict working... In my error file, i have a "killed with signal 11". I don't know if it's a bug or a bad dovecot configuration... I hope i'll give you enough informations that you can help me... (sorry for my very bas english ;p) Dovecot version : 1.0 RC2 (debian package backports : 1.0.rc2-1bpo1) Linux distribution name : Debian GNU/Linux, Sarge CPU architecture : x86 ==> My /var/log/dovecot/dovecot.info file : dovecot: 2006-07-23 14:30:52 Info: IMAP(myuser): Effective uid=1011, gid=1011 dovecot: 2006-07-23 14:30:52 Info: IMAP(myuser): Loading modules from directory: /usr/lib/dovecot/modules/imap dovecot: 2006-07-23 14:30:52 Info: IMAP(myuser): Module loaded: /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so dovecot: 2006-07-23 14:30:52 Info: IMAP(myuser): Module loaded: /usr/lib/dovecot/modules/imap/lib02_imap_quota_plugin.so dovecot: 2006-07-23 14:30:52 Info: IMAP(myuser): maildir: data=/home/myuser/Mail dovecot: 2006-07-23 14:30:52 Info: IMAP(myuser): maildir: root=/home/myuser/Mail, index=/home/ecoffornic/Mail, control=, inbox= dovecot: 2006-07-23 14:30:52 Info: IMAP(myuser): dict quota: uri = mysql:/etc/dovecot/dict-quota.conf dovecot: 2006-07-23 14:30:52 Info: IMAP(myuser): dict quota: byte limit = 10485760 dovecot: 2006-07-23 14:30:52 Info: IMAP(myuser): dict quota: count limit = 0 dovecot: 2006-07-23 14:30:52 Info: imap-login: Login: user=<myuser>, method=plain, rip=82.228.176.60, lip=192.168.1.60 ==> My /var/log/dovecot/dovecot.err file : dovecot: 2006-07-23 14:30:52 Error: IMAP(myuser): Unknown dict module: mysql dovecot: 2006-07-23 14:30:52 Error: child 5702 (imap) killed with signal 11 ==> My /etc/dovecot/dovecot.conf file : protocols = imap pop3 disable_plaintext_auth = no ## Logging log_path = /var/log/dovecot.err info_log_path = /var/log/dovecot.info log_timestamp = "%Y-%m-%d %H:%M:%S " ## Mailbox default_mail_env = maildir:~/Mail ## Mail processes mail_debug = yes ## IMAP specific settings protocol imap { login_executable = /usr/lib/dovecot/imap-login mail_executable = /usr/lib/dovecot/imap mail_plugins = quota imap_quota } ## POP3 specific settings protocol pop3 { login_executable = /usr/lib/dovecot/pop3-login mail_executable = /usr/lib/dovecot/pop3 pop3_uidl_format = %v.%u } ## LDA specific settings protocol lda { postmaster_address = postmaster(a)pirio.org mail_plugins = quota } ## Authentication processes auth default { mechanisms = plain ## dovecot-lda specific settings socket listen { master { path = /var/run/dovecot-auth-master mode = 0600 user = postfix } } # PAM authentication passdb pam { } # /etc/passwd userdb passwd { } } ## Dictionary server settings dict { } ## Plugin settings plugin { # quota = 10 Mo quota = dict:storage=10240 mysql:/etc/dovecot/dict-quota.conf } ==> My /etc/dovecot/dict-quota.conf : connect = host=localhost dbname=dovecot user=dovecot table = quota select_field = current where_field = path username_field = username ==> Information about MySQL : I have created a "dovecot" db with a "quota" table, and a "dovecot" mysql user with all rights access on the "dovecot" db. I have one line in my "quota" table : path | username | current | ?? | myuser | 1024 | (I don't know what to enter in "path" field...) ==> Core dumps I have try the "Core Dumps" procedure, but i don't know if it's a success... There is what i get : root@dmz# gdb /usr/lib/dovecot/imap /home/myuser/core GNU gdb 6.3-debian Copyright 2004 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i386-linux"...(no debugging symbols found) Using host libthread_db library "/lib/libthread_db.so.1". Core was generated by `imap'. Program terminated with signal 11, Segmentation fault. Reading symbols from /lib/libdl.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/libdl.so.2 Reading symbols from /lib/libc.so.6...(no debugging symbols found)...done. Loaded symbols for /lib/libc.so.6 Reading symbols from /lib/ld-linux.so.2...(no debugging symbols found)...done. Loaded symbols for /lib/ld-linux.so.2 Reading symbols from /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so...(no debugging symbols found)...done. Loaded symbols for /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so Reading symbols from /usr/lib/dovecot/modules/imap/lib02_imap_quota_plugin.so... (no debugging symbols found)...done. Loaded symbols for /usr/lib/dovecot/modules/imap/lib02_imap_quota_plugin.so #0 0x40158dd4 in quota_root_init () from /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so (gdb) bt full #0 0x40158dd4 in quota_root_init () from /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so No symbol table info available. #1 0x4015908b in quota_add_user_storage () from /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so No symbol table info available. #2 0x4015d2d4 in quota_mail_storage_created () from /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so No symbol table info available. #3 0x0806383b in main () No symbol table info available. (gdb) bt full #0 0x40158dd4 in quota_root_init () from /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so No symbol table info available. #1 0x4015908b in quota_add_user_storage () from /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so No symbol table info available. #2 0x4015d2d4 in quota_mail_storage_created () from /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so No symbol table info available. #3 0x0806383b in main () No symbol table info available. (gdb) Very thanks for your help, -- Mikaël,

1 0

[Dovecot] POP does not seem to be working
by Gerard 23 Jul '06

23 Jul '06

OK, I am brand new to this so please bear with me. I have an FreeBSD 6.1 STABLE system. Postfix is installed with qpopper. The mailboxes are standard mbox format. I just installed Dovecot. At some point I want to update to a mdir format, etc., but quite frankly I do not know how to go about that. In any case, I shut down qpopper and started Dovecot. I modified the Dovecot.conf file SSL settings (turned them off) since I do not have the files it needs built yet. Anyway, when using a mail client on another PC on my network, although it makes a connection, no mail is ever downloaded. Ther is mail in the folders however. Obviously I am doing something really wrong, but I am not sure what. I would sure appreciate any assistance available. The only information I have is in the 'log' file which shows the a pop3-login, the user name, method=PLAIN, and two numeric addresses. Thanks! -- Gerard Seibert gerard(a)seibercom.net

3 2

[Dovecot] Module dict... How it works
by mikael 23 Jul '06

23 Jul '06

Hello, I try to use dict for quota... But it's impossible :) I have this error message : === dovecot.err === dovecot: 2006-07-23 03:00:47 Error: IMAP(myuser): Unknown dict module: mysql =================== But, mysql is supported... I don't understand... My config about dict : ==== dovecot.conf ==== ... plugin { quota = dict:storage=10240 mysql:/etc/dovecot/dict-quota.conf } ====================== And my dict-quota.conf file : ==== connect = host=localhost dbname=dovecot user=dovecot table = quota select_field = current where_field = path username_field = username ==== I have created a "dovecot" database and a "dovecot" mysql user with all access on this db. I have created a "quota" table too and add this entry in this table : *------*----------*---------* * path * username * current * *------*----------*---------* * ?? * myuser * 1024 * *------*----------*---------* I don't know what to do with the "path" field... My log file... Perhaps it will be usefull : === dovecot.info === dovecot: 2006-07-23 03:19:02 Info: IMAP(myuser): Effective uid=1011, gid=1011 dovecot: 2006-07-23 03:19:02 Info: IMAP(myuser): Loading modules from directory: /usr/lib/dovecot/modules/imap dovecot: 2006-07-23 03:19:02 Info: IMAP(myuser): Module loaded: /usr/lib/dovecot/modules/imap/lib01_quota_plugin.so dovecot: 2006-07-23 03:19:02 Info: IMAP(myuser): Module loaded: /usr/lib/dovecot/modules/imap/lib02_imap_quota_plugin.so dovecot: 2006-07-23 03:19:02 Info: IMAP(myuser): maildir: data=/home/myuser/Mail dovecot: 2006-07-23 03:19:02 Info: IMAP(myuser): maildir: root=/home/myuser/Mail, index=/home/myuser/Mail, control=, inbox= dovecot: 2006-07-23 03:19:02 Info: IMAP(myuser): dict quota: uri = mysql:/etc/dovecot/dict-quota.conf dovecot: 2006-07-23 03:19:02 Info: IMAP(myuser): dict quota: byte limit = 10485760 dovecot: 2006-07-23 03:19:02 Info: IMAP(myuser): dict quota: count limit = 0 dovecot: 2006-07-23 03:19:02 Info: imap-login: Login: user=<myuser>, method=plain, rip=82.228.176.60, lip=192.168.1.60 ==== Could you help me to use dict with quota ? Really thanks in advance for all your help. -- Mikaël,

1 1

[Dovecot] help with authentication - cpanel
by allan hardy 22 Jul '06

22 Jul '06

I am trying to install dovecot as a second pop3 service in my RH9 system. It is a Cpanel based system using Courier for primary IP By primary I mean all the other domains use courier on xxx.xxx.xxx.21 port 110 I have a domain with special pop3 needs that is dedicated to xxx.xxx.xxx.22 port 110 The two mail systems are installed, I can tell via telenet that dovecot is listening and responding on the desired IP and port Cpanel is the tool being used by all domains to create mail accounts and hence setting the 'policy' for the mailboxes, userdb and passdb information. I am trying to make dovecot use those files and can't get past authentication. What I guess I don't know is the encryption type being used by Cpanel Any help appreciated.!!!! What Cpanel appears to do for authentication is use a passwd and shadow file for each domain, placed as follows: /home/accountname/etc/domainname/passwd holds the list of mail accounts names /home/accountname/etc/domain/shadow holds the passwords This is the message log from a telnet session on local machine: dovecot: Jul 22 13:45:27 Info: auth(default): client in: AUTH 1 PLAIN service=POP3 secured lip=xxx.xxx.179.22 rip=xxx.xxx.179.22 resp=AGFsbGFuAHRlc3Q= dovecot: Jul 22 13:45:27 Info: auth(default): shadow(allan,xxx.xxx.179.22): password mismatch dovecot: Jul 22 13:45:29 Info: auth(default): client out: FAIL 1 user=allan dovecot: Jul 22 13:45:36 Info: pop3-login: Aborted login: user=<allan>, method=PLAIN, rip=xxx.xxx.179.22, lip=xxx.xxx.179.22, secured ~ This was in the shadow file: ---Shadow file entry allan:$1$V0lG6T6P$eNQoX3J3N5RJNxT5yH8gz1::::::: These are my relevant (At least I think they are relevant) dovecot.conf settings: disable_plaintext_auth = no ssl_disable = yes auth default { mechanisms = plain login anonymous passdb shadow { /home/xxxxxx/etc/xxxxx.com/shadow } userdb passwd-file { # Path for passwd-file args = /home/xxxxxxx/etc/xxxxx.com/passwd } --PAM is commented out As a side note, I tried to see if I could tell from the courier setup how it was authenticating. The courier/etc/pop3d file was set POP3AUTH="" And there was a note "To advertise the SASL capability, per RFC 2449, uncomment the POP3AUTH variable" So it this may indicate sasl is being used, what ever that means

1 0

[Dovecot] Dovecot dict and quota
by mikael 22 Jul '06

22 Jul '06

Hello, I try to understand the dict configuration for quota. In http://wiki.dovecot.org/Quota/Dict, i read : ==== Example dovecot-dict-quota.conf: connect = host=localhost dbname=mails user=mailuser table = quota select_field = current where_field = path username_field = username Create the table like this: create table quota ( path varchar(255) not null primary key, username varchar(255) not null, current integer ); ==== What is "path" ? which is the utility of this field for quota ? Thanks for your help, -- Mikaël PIRIO 4 Square de Massouah - 35000 RENNES Tel : 02 99 30 49 98 - 06 63 34 03 02

1 0

[Dovecot] Dovecot and quotas
by mikael 22 Jul '06

22 Jul '06

Hello, I have succesfully installed dovecot version 1.0.rc2 on my Debian Sarge. I have configured quotas (just for tests) like this : == dovecot.conf == ... auth default { mechanisms = plain passdb pam { } userdb passwd { } } protocol imap { mail_plugins = quota imap_quota } plugin { # quota = 10 Mb quota = dirsize:storage=10240 } ... ================== Quotas works without problem : 10Mb for all users... But i would like quotas per user and kept thi default value of 10Mb... How to override this default value ? How to do peruser-quota with "passwd" userdb (or "passwd-file") ? Really thanks for your help, -- Mikaël,

1 1

[Dovecot] cmusieve plugin
by Stuart Sears 21 Jul '06

21 Jul '06

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi guys I have been doing a lot of searching, but maybe I am being dim (not unheard of!). I have dovecot-1.0rc2 built and running on Fedora Core 5. The wiki page (dated yesterday) states that I need the cmusieve plugin to use sieve scripts with the dovecot lda. Is this a new development? They seem to work quite happily on my soon-to-be retired 1.0-beta7 debian box without an extra plugin. secondly, if it is now necessary, where do I get this plugin from? (this may be the dim part) I have a cvs checkout of the dovecot sources, but I see nothing obviously connected to cmusieve anywhere in the source tree If this is in a different module, then can someone let me know the name of it, so that I can check it out of CVS as well? Kind Regards Stuart - -- Stuart Sears RHCA RHCX To err is human, to forgive is Not Company Policy. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.4 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFEwNaTamPtx1brPQ4RAr9rAJ91WRb32KmMZhSmBIHYGRcWCtCwhACffmYe fpoeqo9wFQfh8LIsGT21Dp8= =C6To -----END PGP SIGNATURE----- -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

2 2

[Dovecot] Migrating to dovecot
by Johann Spies 21 Jul '06

21 Jul '06

I do not have much experience in setting up imap servers - only that I have tried several and experienced the same problem with all of them. I suppose that is because I do not really know the in's and out's of an imap server. What I want to do is to setup an IMAP server on my PC with full access to all the emails already there in a maildir structure. I have the following setup: fetchmail -> procmail -> maildir exim for outgoing mail. When I install an imap server, I loose access to my present emails in ~/Mail and most imap-servers (dovecot included) seems to create a new structure within ~/Mail. ~/Maildir is a symlink to ~/Mail. Now my questions: 1. How do I set up dovecot to serve the present maildir to the user? 2. Related to 1: How do I migrate my emails to the new imap-maildir structure without losing any? 3. How would my present procmail-setup change? At the moment I have entries like the following: MAILDIR=$HOME/Mail # you'd better make sure it exists DEFAULT=$MAILDIR/Ander/new # completely optional :0: * X-Spam-Flag: YES saspam/new :0: * ^List-Id: <users.spamassassin.apache.org> spamassassin/new ... Regards Johann -- Johann Spies Telefoon: 021-808 4036 Informasietegnologie, Universiteit van Stellenbosch "God is our refuge and strength, a very present help in trouble." Psalms 46:1

4 4