- dovecot - dovecot.org

[Dovecot] Quotas with MySQL
by Neil Smith 07 Sep '06

07 Sep '06

Hello, I've had a look through past messages and I think this has been brought up but I'm not sure what the outcome of it was. I'm trying to use quotas with a MySQL dict backend. I am using Dovecot version 1.0.rc6-1 from the Debian Testing package on a x86 machine. My dovecot.conf file has the following entries which I took from the Wiki: dict { quotadict = mysql:/etc/dovecot/dovecot-dict-quota.conf } plugin { quota = dict:storage=10240 proxy::quotadict } and my dovecot-dict-quota.conf looks like the following, again from the Wiki: connect = host=127.0.0.1 dbname=mail user=<user> password=<passwd> table = quota select_field = current where_field = path username_field = username and my MySQL table is as follows: create table quota ( username varchar(255) not null, path varchar(255) not null, current integer, primary key (username, path) ); Now with this setup, the query for looking up the current quota appears in the MySQL logs as: SELECT current FROM quota WHERE path = 'quota/storage' AND username = 'neil(a)example.com' and the query for Inserting/Updating the quota is: BEGIN;INSERT INTO quota (current, path, username ) VALUES ('quota/storage', 0, 'neil(a)example.com') ON DUPLICATE KEY UPDATE current = current + 0;COMMIT With latter query, it appears to be trying to insert 'quota/storage' into `current` and 0 into `path`. This seems to be the wrong way around. Is that correct? If I change my dovecot-dict-quota.conf file to read: connect = host=127.0.0.1 dbname=mail user=<user> password=<passwd> table = quota select_field = path where_field = current username_field = username the two queries now look like: SELECT path FROM quota WHERE current = 'quota/storage' AND username = 'neil(a)example.com' and BEGIN;INSERT INTO quota (path, current, username ) VALUES ('quota/storage', 0, 'neil(a)example.com') ON DUPLICATE KEY UPDATE current = current + 0;COMMIT Although the latter query now works as expected and does update the quota in the database, the former query is now incorrect. Is this a problem with my configuration or is it a bug? If a bug, has it been corrected in Version 1.0.rc7? Thank you all. Neil

2 2

[Dovecot] Using Dovecot SASL with postfix
by Jonathan Stewart 06 Sep '06

06 Sep '06

I'm trying to use Dovecot SASL with postfix 2.3.3 and when trying to send mail I get the debug output below. I don't know enough about whats going on to know where the problem is but something clearly is not right. I would send the configurations for postfix and dovecot except they are clearly talking to each other so I kinda doubt its a configuration issue. The machine can afford to be down for an hour or two at a time for testing stuff if needed. Sep 6 12:04:10 server postfix/smtpd[13555]: connect from mobile-166-137-248-219.mycingular.net[166.137.248.219] Sep 6 12:04:17 server dovecot: auth(default): client in: AUTH 1 PLAIN service=smtp Sep 6 12:04:17 server dovecot: auth(default): client out: CONT 1 Sep 6 12:04:18 server dovecot: auth(default): client in: CONT 1 jonathan Sep 6 12:04:18 server dovecot: auth(default): plain(?): invalid input Sep 6 12:04:19 server dovecot: auth(default): client out: FAIL 1 Sep 6 12:04:19 server postfix/smtpd[13555]: warning: mobile-166-137-248-219.mycingular.net[166.137.248.219]: SASL PLAIN authentication failed: Sep 6 12:04:20 server postfix/smtpd[13555]: lost connection after AUTH from mobile-166-137-248-219.mycingular.net[166.137.248.219] Sep 6 12:04:20 server postfix/smtpd[13555]: disconnect from mobile-166-137-248-219.mycingular.net[166.137.248.219] A working auth looks like this, I'm thinking that IMAP versus SMTP should not be *too* big a difference in this case. Sep 6 12:06:22 server dovecot: auth(default): client in: AUTH 1 PLAIN service=IMAP secured lip=10.70.3.1 rip=10.70.3.254 Sep 6 12:06:22 server dovecot: auth(default): client out: CONT 1 Sep 6 12:06:22 server dovecot: auth(default): client in: CONT 1 (some kind of hash looking thing) Sep 6 12:06:22 server dovecot: auth(default): client out: OK 1 user=jonathan Sep 6 12:06:22 server dovecot: auth(default): master in: REQUEST 1 13554 1 Sep 6 12:06:22 server dovecot: auth(default): master out: USER 1 jonathan system_user=jonathan uid=1001 gid=1001 home=/home/jonathan Sep 6 12:06:22 server dovecot: imap-login: Login: user=<jonathan>, method=plain, rip=10.70.3.254, lip=10.70.3.1, TLS Thanks, Jonathan

2 2

[Dovecot] Migrando DOVECOT -> Cyrrus-imapd
by Kleiton L R Soares 06 Sep '06

06 Sep '06

Gostaria de saber se alguêm conhece alguma ferramenta de migração de Dovecot para Cyrrus. Tenho minhas inbox em /var/spool/mail. Agradeço desde já. Abraços. -- --- --------------------------- Kleiton L R Soares (21-2620-0735 | 21-9639-5829) PCS - Processos Consultoria Soluções www.pcs.com.br / kleiton(a)pcs.com.br

1 0

[Dovecot] configuration issues / virtual users
by Zbigniew Szalbot 06 Sep '06

06 Sep '06

Hello, It is my first post on this list and I hope someone will be able to help. I have installed dovecot on FreeBSD 6.1. Everything works fine but I wanted to create a way to accept mail to a few virual users and decied to use and example from http://wiki.dovecot.org/VirtualhostingWithExim auth = default auth_userdb = static uid=500 gid=500 home=/home/dovecot/users/%u auth_passdb = passwd-file /home/dovecot/passwd auth_user = dovecot I altered the uid and gid and made sure I have the directories ready and passwd file ok. I altered the conf file to read the following: userdb static { # Template for settings. Can return anything a userdb could normally # return, eg.: uid, gid, home, mail, nice # # A few examples: # # args = uid=500 gid=500 home=/var/mail/%u # args = uid=500 gid=500 home=/home/%u mail=mbox:/home/%u/mail nice=10 # #args = # dovecot virtual users auth_userdb = static uid=1003 gid=1003 home=/home/dovecot/users/%u auth_passdb = passwd-file /home/dovecot/passwd auth_user = dovecot ) However, dovecot complains: Error: Error in configuration file /usr/local/etc/dovecot.conf line 752: Unknown setting: auth_userdb Where did I go wrong? I hope someone can help me. Thanks! Warm regards from Poland, Zbyszek

1 0

[Dovecot] Strange log entry???
by Bill Landry 06 Sep '06

06 Sep '06

Although everything appears to be working fine, I see the following entry in my log file each time someone logs on via the IMAPS service (all other services are disables: POP, IMAP, etc.): ========== Sep 6 02:57:00 mgw1 dovecot: Logins with login process UID xxxx (user someone(a)example.com) not permitted (see login_user in config file). ========== Any idea what this log entry means and is there a config setting I need to adjust to stop these log entries (Dovecot version 1.0.rc7)? Thanks, Bill

2 1

[Dovecot] dovecot-sieve with FreeBSD
by Peter Bauer 06 Sep '06

06 Sep '06

Hello, I've a test system with postfix (SMTP), dovecot (IMAP only) and covecot-LDA (MDA) under FreeBSD-6.1. Currently everything works fine. But I wasn't able to install dovecot-sieve from the CVS. Does anyone has a small documentation howto install dovecot-sieve on FreeBSD. Thanks. -- Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

4 5

[Dovecot] Dovecot problem in RHEL4
by ~adarsh~ 06 Sep '06

06 Sep '06

Hi all, I have some problem with dovecot in RHEL4. IMAP server is dropping connection after woorking for some time. It seems that the login process count keeps increasing?(stale login process are not removed) Any points to sort the problem? -- Adarsh

2 2

[Dovecot] configuration guidelines.
by Ian Mortimer 05 Sep '06

05 Sep '06

Our imap/pop service is moving from UW imap to dovecot 0.99.11 on RHEL4. This is for around 200 users with lots of different email clients, e.g.: Windows: outlook, outlook Express, eudora, thunderbird, netscape OS X: mail, eudora, thunderbird Unix/Linux: evolution, thunderbird, pine, mutt Web: squirrelmail Apart from the example configuration file, I can't find any guides for optimal values to use for dovecot's many configuration options. A few that look like they might need changing are: login_process_size = 32 login_process_per_connection = yes login_processes_count = 3 mbox_dotlock_change_timeout = 30 auth_count = 1 client_workarounds = Does anyone have any pointers to reasonable values for those or other settings? Thanks -- Ian

3 3

Re: [Dovecot] rc7 bug? [Was: deliver LDA and INBOX location] (fwd)
by David Lee 05 Sep '06

05 Sep '06

Anyone had any thoughts on the item below? If the problem is with my config, I'd like to be guided towards how I might resolve it. If it is a bug in rc7, it would be good to fix it, and I'd be happy to beta-test. -- : David Lee I.T. Service : : Senior Systems Programmer Computer Centre : : Durham University : : http://www.dur.ac.uk/t.d.lee/ South Road : : Durham DH1 3LE : : Phone: +44 191 334 2752 U.K. : ---------- Forwarded message ---------- Date: Fri, 1 Sep 2006 10:22:20 +0100 (BST) From: David Lee <t.d.lee(a)durham.ac.uk> To: dovecot(a)dovecot.org Subject: Re: [Dovecot] rc7 bug? [Was: deliver LDA and INBOX location] On Thu, 31 Aug 2006, David Lee wrote: > [...] > We have a well-established different convention which subdivides this, > based on the last two digits of the uid: "/var/spool/mail/12/fred" (for > fred's uid as something ending "[...]12"). This is working nicely with > dovecot, using the new rc7 functionality: > default_mail_env = mbox:%h:INBOX=/var/spool/mail/%-2.02i/%u:[...] > > I am now trying to get sendmail to use dovecot's "deliver" as the LDA, > [...] The main problem is that, according to the log file, the delivery > attempt is being made to an INBOX "/var/spool/mail//fred". That is, it > seems to be ignoring the "default_mail_env" setting. > > Have I missed something in the wiki, or is this a bug of some sort? I have looked deeper at my problem (abov). It seems to be a bug in rc7, and probably an "always been there" bug. I sprinked a few "i_info(...)" diagnostics into "deliver.c" where it does 'getenv("MAIL")' and 'getenv("DEFAULT_MAIL_ENV")'. It shows that these are being successfully read from the 'dovecot.conf' file (good). But, crucially, it seems that the "%" variable substitution is incomplete: line 483: MAIL [null] line 486: MAIL mbox:%h:INBOX=/var/spool/mail/%-2.02i/%u:INDEX=/var/spool/mail/indexes/%d/%n line 492: MAIL mbox:/home/fred:INBOX=/var/spool/mail//fred:INDEX=/var/spool/mail/indexes//fred (Aside: The act of inserting the 'i_info' will have knocked the line numbers adrift by a couple. But it shows what is (not) happening.) Note in the "INBOX=..." clause that while "%u" and "%h" have been successfully expanded (good), the "%i" variant (UNIX uid) has failed to get expanded (bad). I'm new to dovecot, so am on a steep learning curve and am unfamiliar with the source code and dovecot's principles. So it would probably take me ages to work out a suitable patch, and even then it might be inappropriate. But hopefully the above information is sufficient and suitable for someone (Timo?) to investigate more expertly and fully. If someone can produce a patch (or hints of what to patch and where) I would certainly intend to test it and work on it for you. Hope that helps. Many thanks in advance. -- : David Lee I.T. Service : : Senior Systems Programmer Computer Centre : : Durham University : : http://www.dur.ac.uk/t.d.lee/ South Road : : Durham DH1 3LE : : Phone: +44 191 334 2752 U.K. :

2 3

[Dovecot] Effective UIDs Nad GID for VIrtual Users
by rammstein-den 05 Sep '06

05 Sep '06

Hello to All. I have a system with FreeBSD 6.1 Release, Dovecot 1.0 Release Candidate 7. I am a novice user in unix world and when my first deal with with Dovecot is Virtual users. User databes in master.passwd file (like a /etc/master.passwd) created by "pw". All works fine, BUT --- If user exclusivly virtual (there is no user with same name in system) IMAP folders are created normal with a right access rights(they described in dovecot.conf statically UID 555) - all cool - BUT when i trying to login with a Virtual user with the SAME LOGIN NAME as in SYSTEM (FreeBSD's /etc/master.passwd user) USER ---- going something strange: imap folders that creating for this user takig wrong ACCES RIGHTS (access rights for system user), not statically with UID 555! What the ... ?! -----------------------Edited Part of Dovecot.conf----------------------------------------------------- default_mail_env = mbox:/var/new/%u:INBOX=/var/virtual/%u auth default { # Space separated list of wanted authentication mechanisms: # plain login digest-md5 cram-md5 ntlm rpa apop anonymous gssapi #mechanisms = digest-md5 # /etc/passwd or similar, using getpwnam() # In many systems nowadays this uses Name Service Switch, which is # configured in /etc/nsswitch.conf. # passdb passwd { # } #auth_user=root #userdb passwd-file { # args = /bsd/dove/passwd #} userdb passwd { args = /bsd/dove/passwd } passdb passwd-file { args = /bsd/dove/master.passwd } # /etc/passwd or similar, using getpwnam() # In many systems nowadays this uses Name Service Switch, which is # configured in /etc/nsswitch.conf. # static settings generated from template userdb static { # Template for settings. Can return anything a userdb could normally # return, eg.: uid, gid, home, mail, nice # # A few examples: # # args = uid=500 gid=500 home=/var/mail/%u # args = uid=500 gid=500 home=/home/%u mail=mbox:/home/%u/mail nice=10 # args = uid=555 gid=125 } } ------------------------------------END------------------------------------- In logs I also have: dovecot: Sep 04 22:47:03 Info: IMAP(radeon): Effective uid=1001, gid=1001 instead dovecot: Sep 04 22:59:39 Info: IMAP( ): Effective uid=555, gid=125 - - - - -- - -- - - I so angry! P.S. Sorry for my english,my native language is Russian :)

1 0