- dovecot - dovecot.org

[Dovecot] Dovecot deliver and IMAP - separate user db queries possible?
by Michael 02 Jan '10

02 Jan '10

How can I get deliver LDA and IMAP to use separate user DB SQL queries?

2 1

[Dovecot] Quota with Dict + SQL not updating
by Michael 01 Jan '10

01 Jan '10

Hello all, I have a Dovecot server deployed with a MySQL back end. If the user logs in and there is no quota set for them in table 'quota', the system will automatically inset a line with their username and current messages/storage. However after this it fails to update the information when to reflect new messages coming to their inbox after the original insert of the information. It will only update the information when a user deletes a message. Why is it not updating this information every time their mail is checked with IMAP? Cheers, Michael

2 2

[Dovecot] Oracle SQL driver
by Alexander Bukharov 31 Dec '09

31 Dec '09

Hi all. Recently I was looking for an IMAP-server with Oracle support and unfortunatelly I couldn't find one. It was a surprise for me but there is no such functionality at all. So I've chosen an IMAP-server with most flexible and convinient architecture that was Dovecot-1.2.9 and written a driver for Oracle RDBMS support. I used Oracle Pro*C so a Pro*C preprocessor is needed to compile the driver. There is a lot of logging there that should be removed. It would be great if you consider to include this driver to mainstream so Dovecot will be the first IMAP server supporting Oracle as auth backend. All related files are attached. Cheers.

2 2

[Dovecot] A Dovecot Sieve spam filter question.
by aja-lists＠tni.org 31 Dec '09

31 Dec '09

Hi, I'd like to make a filtering threshold for users to let them deal with spamassassin spam-level starred < 8 themselves, but spam-level starred higher than 8 should be discarded how can one do that with the "anyof" option ? the following doesn't work with a test email with "gtube", which scores > 999 : # require "fileinto"; if header :matches "X-Spam-Level" "\*\*\*\*\*\*" { fileinto "discard"; } and I think it would be nice to have not so many lines in the globalsieverc file. TIA, Regards, Adrian

5 11

[Dovecot] configure optimization
by Luigi Rosa 31 Dec '09

31 Dec '09

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Given a server with MySQL userdb/passwd and maildir storage, excluding unused storages and authentications in configure options does save some memory and/or speed or is it worthless? I mean, is there a performance difference between this two versions of configure parameters or is just a waste of time to exclude what is not used? ./configure --with-mysql --without-ssl --sysconfdir=/etc --localstatedir=/var ./configure --with-mysql --without-ssl --with-storages=maildir - --sysconfdir=/etc --localstatedir=/var --without-passwd --without-nss - --without-passwd-file --without-shadow --without-pam --without-ssl Thank you. Ciao, luigi - -- / +--[Luigi Rosa]-- \ I told the doctor I broke my leg in two places. He told me to quit going to those places. --Henny Youngman -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAks7YWkACgkQ3kWu7Tfl6ZReewCgw97USlBGkggJre49cGp/cgsd M/sAniVsEOISC2YKKXbivTKN//JwnZhs =GEk+ -----END PGP SIGNATURE-----

2 2

[Dovecot] Pigeonhole Sieve IMAP flag question
by Julian Cowley 31 Dec '09

31 Dec '09

Hello, Here is a small script that I've been running to test a problem I've been seeing. Shouldn't this result in the mail being delivered to the inbox as a new message (ie. without the \Seen flag)? require "imap4flags"; addflag "\\Seen"; removeflag "\\Seen"; Every message gets delivered to the inbox as though it's already been read. Using Dovecot 1.2.9 and Pigeonhole Sieve 0.1.14.

3 4

[Dovecot] Hostname setting defaults
by Timo Sirainen 30 Dec '09

30 Dec '09

Any thoughts about the following? hostname setting currently defaults to system's host name, without the domain part. It's used (in v2.0): - dovecot-lda (new deliver): If -a parameter isn't specified and there's no Envelope-To: header, the destination address is generated as <username>@<hostname setting> - lda/lmtp: In generated Message-Id: headers ("dovecot-stuff@<hostname>") for rejects, vacation, etc. - lda/lmtp: in reject messages as part of MIME boundary, and also in "Reporting-UA: <hostname>; Dovecot mail delivery agent" header. - lmtp: In the protocol, e.g. "220 <hostname> Dovecot ready" or "421 4.4.2 <hostname> Disconnected for inactivity" - lmtp: In added Received: header Seems pretty clear to me that it should be host.domain.org, not just host. So I suppose I'll change that default. The other thing is postmaster_address. That's accidentally been postmaster(a)example.com in dovecot-example.conf and uncommented. So who knows how many installations have their postmaster address set to that.. I'm thinking of just commenting it out in next v1.2 release so admins needs to change that. But for v2.0 maybe there could be a good default for postmaster_address? "postmaster@<hostname setting>" I think? Because it's postmaster(a)host.domain.org instead of postmaster(a)domain.org, it might not be correct in most installations, but I'm thinking that maybe it's safer. Someone trying out Dovecot on testbox.biguni.edu probably doesn't want bounces going to postmaster(a)biguni.edu..

1 0

[Dovecot] dovecot-shared
by Frank Cusack 30 Dec '09

30 Dec '09

I'm confused about dovecot-shared. If the file exists, \SEEN flags are NOT shared? So if dovecot-shared exists, flags are actually private. The doc seems clear on this (albeit not worded very well). I only question it because intuitively you would think the opposite. If backwards compatibility is the reason for this reverse behavior, the file should have been named dovecot-private-flags. In fact that's a great name to stick a list of flags (one-per-line) that are private. -frnak

2 6

[Dovecot] Issue Authenticating to a new dovecot-postfix installation
by Anthony Nedland 30 Dec '09

30 Dec '09

I have installed dovecot-postfix and postfixadmin on an Ubuntu 9.10 machine. The userdb and passdb are both mysql. If I set up a user in postfixadmin they are able to send. I can successfully telnet into the server remotely by name on 110 and 25. I'm not looking for any authentication encryption/ssl any of that, just POP3/SMTP. When I telnet into 110 I can enter a username with user [username] then when I do pass [password] I get -ERR Authentication failed. I know the user info is correct. When I set up an account in Outlook Express I get "There was a problem logging onto your mail server. Your Password was rejected:" Also saying -ERR Authentication failed.'. (0x800ccc90,0x800ccc92) So basically the same thing. I can attach the tutorial I used in as a .doc if that would help. Anyway, here is my relevant info I think. -- -- -- Version 1.1.11 -------------------------------------------------------------- ---------------------------------------------------------------- ----------------------------------------------------------------- dovecot-sql.conf GREP driver = mysql connect = host=localhost dbname=postfix user=postfix password=password default_pass_scheme = PLAIN user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n' as mail, 150 AS uis, 8 AS gid, concat(dirsize:storage=',quota) AS quota FROM mailbox WHERE username = '%u' AND active = 1 password_query = SELECT username as user, password, '/var/vmail/%d/%n' as userdb_home,'maildir:/var/vmail/%d/%n' as userdb_mail, 150 as userdb_uid, 8 as userdb_gid FROM mailbox WHERE username = '%u' AND active = 1 -------------------------------------------------------------- ------------------------------------------------------------- ------------------------------------------------------------- root@mail:/etc/dovecot# dovecot -n # 1.1.11: /etc/dovecot/dovecot.conf Error: Error in configuration file /etc/dovecot/dovecot.conf line 1076: Unknown section type (section changed in /etc/dovecot/dovecot.conf at line 1038) Fatal: Invalid configuration in /etc/dovecot/dovecot.conf Starting line 1076---> master { # Master socket provides access to userdb information. It's typically # used to give Dovecot's local delivery agent access to userdb so it # can find mailbox locations. path = /var/run/dovecot/auth-master mode = 0660 # Default user/group is the one who started dovecot-auth (root) user = vmail group = mail } # SQL database <doc/wiki/AuthDatabase.SQL.txt> userdb sql { # Path for SQL configuration file args = /etc/dovecot/dovecot-sql.conf Line 138 --> } I don't understand the issue with these lines. They refer to dovecot.conf though. The config file is clearly dovecot-postfix.conf so I am confused as to why the other matters. I had noticed changes only when I changed dovecot.conf though. (In dovecot -n output) --

1 0

Re: [Dovecot] Retrieve Physical Message Filename
by Tony Rutherford 30 Dec '09

30 Dec '09

Thanks for the reply. I won't be changing any files, or even accessing them, i'll simply be passing the filename along to "another system". I'm not allowed to change this other system or any of its interfaces. The other system has been in place and is "off limits" as far as changes go (I'm told). To make it simple, this other system needs to be notified of any flag changes on emails. So, when we detect a flag change (in our plugin), we need to pass the message filename along to this other system. I hope this makes sense...and again...i'm not justifying the need for it, but I have to play the hand i'm dealt....Tony RutherfordSoftware EngineerBlueTie Inc.arutherford(a)bluetie.com(585) 586-2000 x1040-----Original Message-----From: "Timo Sirainen" [tss(a)iki.fi]Date: 12/29/2009 04:02 PMTo: "Tony Rutherford" CC: dovecot(a)dovecot.orgSubject: Re: [Dovecot] Retrieve Physical Message FilenameOn Tue, 2009-12-29 at 15:50 -0500, Tony Rutherford wrote: > Hi,Using Dovecot 1.2.9 with Maildir and Layout=FS.In a plugin, i'm > overriding "update_flags":void my_mail_update_flags(struct mail > *_mail, enum modify_type modify_type, enum mail_flags flags)For this > email which is having its flags updated, I need to retrieve the > physical filename of the message. I see where > using:mail_get_special(_mail, MAIL_FETCH_UIDL_FILE_NAME, &fname);...I > can retrieve part of the filename, but without the ":2" and the flags > part.Is there a method I can use to get the whole filename (without > having to reassemble it myself). I've looked around, and I'm guessing > it exists, but I don't see it offhand. The problem is that by the time you're trying to access the file, its flags may have already changed, which also means its filename could have changed. So even if you got it, your code would probably randomly fail. What exactly are you going to do with the filename? Maybe you should instead be opening the file with mail_get_stream() and doing something with the fd. This message is intended solely for the individual(s) to whom it is addressed. If you are not the intended recipient, any dissemination or copying is strictly prohibited. If you believe you received this message in error, please notify the sender and delete from your system. Thank you.

3 2