- dovecot - dovecot.org

[Dovecot] mysql-5.0.26 stored procedure authorization, take 2
by Chaos Engine 22 Oct '06

22 Oct '06

Last time I came up with a problem with concernin MySQL authorization with stored procedures. Timo helped me get going by with modified client_flags (MULTISTATEMENT keyword). Now all it happened again but from another way. My stored proce for MySQL is causing fillowing error: "Oct 21 12:39:22 haos dovecot: auth-worker(default): sql(user,192.168.X.X): Password query fai led: Commands out of sync; you can't run this command now" Looks like it is partly mysql-5.0.26 thing because of this: http://dev.mysql.com/doc/refman/5.0/en/commands-out-of-sync.html On the other hand with my previous mysql installation (mysql-5.0.24-r1) this error is gone (I checked by downgrading). My dovecot-sql.conf: driver = mysql connect = host=/var/run/mysqld/mysqld.sock dbname=mailbase user=mailuser password=******** client_flags=65536 #655536 is equivalent of CLIENT_MULTI_STATEMENTS flag #yes, I still insist on using stored proc for authorization. This gives me few usefull features I like. password_query = call Authenticat('%u', '%n', '%d') With this config on mysq-5.0.26 I get "...Commands out of sync; you can't run this command now..." but not on mysql-5.0.24-r1. Personally I think mysql guys changed something; I can't tell what and why (changelog review?) Maybe you guys know what it was? -- Chaos greets U

2 1

[Dovecot] Using saslauthd with dovecot
by Gerard Seibert 21 Oct '06

21 Oct '06

FreeBSD 6.1 STABLE Postfix-2.4-20061006 Dovecot-1.0.rc7 I am using 'saslauthd -a sasldb -c' for authentication with Postfix. Since Dovecot and Postfix are using the same users and passwords, I was wondering if it would be possible to use this mechanism with Dovecot also. -- Gerard "There is nothing wrong with making love with the light on. Just make sure the car door is closed." George Burns

2 3

[Dovecot] Virtual Users
by Gerard Seibert 20 Oct '06

20 Oct '06

Dovecot 1.0.rc7 Postfix 2.4-20061006 FreeBSD 6.1 STABLE I have dovecot up and running with postfix. I now want to switch over to a system using purely virtual users. I have gotten postfix configured to deliver the mail to virtual mailboxes correctly. The problem I am having is with dovecot. After configuring the dovecot.conf file, dovecot will POP mail from the virtual mailboxes. However, that is only for users who are in the /etc/password file. I will have a large number of users who are truly virtual and therefore not be in that file. I know I am dumb, but I do not know how to set up either a MySQL data base, or just a plain flat file with the required information. I tried Googling, but I cannot find the exact syntax to use. Perhaps someone could point me in the right direction or give me a brief example of how to go about this. Thanks! -- Gerard "It is not the OS's job to stop you from shooting your foot. If you so choose to do so, then it is OS's job to deliver Mr. Bullet to Mr Foot in the most efficient way it knows."

2 1

[Dovecot] md5 password storage
by Andrey Bibiano Jardim 20 Oct '06

20 Oct '06

Hi List. I've got a dovecot running with mysql. All my users data are there. But I intend to use MD5 instead of clear passwords at MySQL. Someone can help-me? []s; Andrey Here's my dovecot-mysql.conf: # Dovecot queries db_host = localhost db_unix_socket = /var/lib/mysql/mysql.sock db_port = 3306 db = mail db_user = my_conn_user db_passwd = my_conn_passwd # # Pehapes i need to change this, but I tryied changing it do md5 with no success. # default_pass_scheme = PLAIN # # This I changed for own reasons, but works. # password_query = SELECT clear FROM postfix_users WHERE user=substring_index('%u', "@", 1) user_query = SELECT concat('/var/spool/mail/', maildir) AS mail, uid, gid FROM postfix_users WHERE user=substring_index('%u', "@", 1)

2 1

[Dovecot] 1.0.rc10 in inetd mode
by Phil Oleson 20 Oct '06

20 Oct '06

Hey.. I'm finding that I can force dovecot (setup in inetd mode) into a wedged state by spamming it with carrage returns. As I've not had enough time to familiarize myself with the code.. I thought I'd ping the list before 1.0 is christened. -Phil.

2 3

[Dovecot] Problem with indexes
by crs 20 Oct '06

20 Oct '06

Hello. Dovecot is really good software but I have one big problem with indexes. I have server with a lot of mailboxes - filesystem has quota enabled and I can't resign it from different reasons. When mailbox achieve quota size and user wants to pick mails via pop3, error "-ERR Mailbox is in inconsistent state, please relogin." is given. I know it's because dovecot can't write indexes. Is it possible to force dovecot to write indexes with definite owner/group f.e dovecot/dovecot and not owner/group of mailbox? I can set quotas for user dovecot to unlimited and problem would disappear. Thanks in advance for any answers. Best regards - Chris. ---------------------------------------------------------------------- PS. >>> http://link.interia.pl/f19a6

3 2

[Dovecot] POP State
by LDB 20 Oct '06

20 Oct '06

I upgraded Dovecot and it was smooth except some of my users using POP3 and leaving their mail on the server, are getting all their mail again. Is there a way to prevent this from happening in the future? /var/run/dovecot was kept during the upgrade ... Thanks, LDB

2 2

[Dovecot] Subscription file
by Steven F Siirila 19 Oct '06

19 Oct '06

Background: We are a UW-IMAP shop, using mbox format. (!) We are in the process of upgrading to Dovecot, hopefully to 1.0 proper. :) One of the modifications we have been using in test versions of Dovecot involve the move of the user subscription file from: IMAP-root/.subscriptions to: $HOME/.mailboxlist Rather than having to make changes to Dovecot source code each time a new release comes out, it would seem to make sense to have a way to configure this from dovecot.conf. Something like: # Default (%i denotes IMAP root): #imap_subscription_file = %i/.subscriptions # UW-imap-style (%h denotes home directory): #imap_subscription_file = %h/.mailboxlist While it makes sense to me to have the subscription file where it is in Dovecot by default, it would be a substantial undertaking to determine where to move the .mailboxlist to in our environment for each user, since there is no easy way to determine what a user's IMAP root directory is set to in their client. Thoughts? -- Steven F. Siirila Office: Lind Hall, Room 130B Internet Services E-mail: sfs(a)umn.edu Office of Information Technology Voice: (612) 626-0244 University of Minnesota Fax: (612) 626-7593

3 3

Re: [Dovecot] open-folder limit
by Bill Boebel 19 Oct '06

19 Oct '06

On Thu, October 19, 2006 11:57 am, "T. Horsnell" <tsh(a)mrc-lmb.cam.ac.uk> said: > Is there a way to limit the number of folders a user can > have open simultaneously? I am fairly certain that there is no way to do this. Bill

1 0

[Dovecot] open-folder limit
by T. Horsnell 19 Oct '06

19 Oct '06

Is there a way to limit the number of folders a user can have open simultaneously? I seem to remember a config option which would only permit one imap process per user, and would share this between his folders, but I cant find anything relevant in the docs now. Am I talking nonsense here? I'm new to Dovecot. Cheers, Terry.

1 0