- dovecot - dovecot.org

[Dovecot] Autobuilder packages for Debian stable/i386 now available
by Stephan Bosch 20 Jan '10

20 Jan '10

Hi, A few days back I started the first automated slave builder that produces bleeding edge Debian stable packages for Dovecot v1.2 and v2.0. It uses the source packages already provided by the automated master repository (which builds binary packages for Debian testing), so that the version numbers and content are equal throughout all Debian releases. The repository is available as follows: deb http://xi.rename-it.nl/debian/ stable-auto/dovecot-1.2 main Or, for Dovecot v2.0: deb http://xi.rename-it.nl/debian/ stable-auto/dovecot-2.0 main Read this for more information: http://wiki.dovecot.org/PrebuiltBinaries#Automatically_Built_Packages I hope to add amd64 binary support soon. Regards, Stephan.

1 0

Re: [Dovecot] Oracle SQL driver
by Alexander Bukharov 20 Jan '10

20 Jan '10

> The transaction handling doesn't look correct to me. The sql_update()s > just add the change to a linked list and commit() is then supposed to > run them in one transaction and either everything should succeed or > fail. Your commit appears to ignore errors and just commit everything > that goes through? Also since nothing is actually sent before commit(), > your rollback() shouldn't need to send ROLLBACK. You right. I've corrected the transaction handling mechanism. The only thing I couldn't understand: why rollback() shouldn't need to make real ROLLBACK? In case when whole transaction was failed succeded statements will remain uncommited. Then they will be commited later on next successful transaction. May be ROLLBACK is still needed? > The "VARCHAR sqltext[2048]" seems like an unnecessary restriction on the > query length. Wasn't there a way to do this without the limit? Or in AFAIK there is no possibility to use C types in PREPARE statement. Also Oracle cannot handle unsized VARCHARs. I've increased VARCHAR size to 65535. > test_connection() seems unnecessary. Right you are. > Couldn't driver_oracle_generate_name() be simply: > static unsigned int counter = 0; > return i_strdup_printf("ORACONN_%x", ++counter); =) Right. > driver_oracle_escape_string() really should be escaping the string. I made this function to replace single quote in string with two single quotes. IMHO this should be enough. How do you think? > Kind of annoying that each query needs a cursor, even though nearly all > queries are expected to return only a single row, but I guess that can't > be helped with the current API.. Yes. There are no other ways to work with untyped statements in OCI. But Oracle claims that all these statements shouldn't produce significant performance impact. The new version attached.

2 3

[Dovecot] ManageSieve doe not work
by Mike Werner 20 Jan '10

20 Jan '10

Hi, I use MailScanner 4.74.16 (Ubuntu karmic). I convigured ManageSieve as discribed in http://wiki.dovecot.org/ManageSieve/Configuration. But sieve scripts are not applied to incoming mail. How can I determin what went wrong? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

2 1

[Dovecot] Dovecot 2.0 beta imap session crash report
by wenjie zheng 20 Jan '10

20 Jan '10

System config: RHEL 5.3, 64 bit Dovecot 2.0 beta (changeset "2882650531e0", 10 days old) installed with lda and lmtp Symptom: IMAP session crashed when I tried to delete a non-exist mailbox, e.g., Trash in my test [root@mail4a LocalIntegrationTest]# telnet localhost 143 * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE AUTH=PLAIN] Dovecot ready. a login testmail4a2(a)dev.p4nt5.com xxxxxx a OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS MULTIAPPEND UNSELECT IDLE CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH QUOTA] Logged in a delete Trash Connection closed by foreign host. Error log: Jan 12 12:33:26 mail4a dovecot: imap(testmail4a2(a)dev.p4nt5.com): maildir++: root=/data/mail/de/dev.p4nt5.com/te/testmail4a2, index=, control=, inbox= Jan 12 12:33:31 mail4a dovecot: imap(testmail4a2(a)dev.p4nt5.com): open() failed with index file (null): Bad address Jan 12 12:33:31 mail4a dovecot: master: service(imap): child 20867 killed with signal 11 (core dumps disabled) How to reproduce: Delete a non-exist mailbox after login Thanks, Wenjie

2 3

Re: [Dovecot] ManageSieve doe not work
by Nick Rosier 20 Jan '10

20 Jan '10

Mike Werner wrote: > Hi, > > I use MailScanner 4.74.16 (Ubuntu karmic). I convigured ManageSieve as > discribed in http://wiki.dovecot.org/ManageSieve/Configuration. But sieve > scripts are not applied to incoming mail. How can I determin what went > wrong? ManageSieve is to manage sieve filters. Your MDA does the filtering. Have you configured Dovecot deliver as your MDA? See: http://wiki.dovecot.org/LDA N.

1 0

Re: [Dovecot] How can I configure dovecot as gmail imap proxy
by Supratik Goswami 20 Jan '10

20 Jan '10

Here the proxy server should authenticate the user. If the user is in the list of authenticated users then dovecot will allow to connect to imap.gmail.com. Consider a scenario where a client tries to read his mailbox from imap.gmail.com:993. Client executes the command "mutt -f imaps://imap.gmail.com", the request is first authenticated at the proxy server. If the request is coming from a valid user, dovecot will allow to connect to imap.gmail.com and fetch mails for that user. Can you please help me with the steps to configure the server. Warm Regards Supratik

2 1

[Dovecot] LDA and POP3/IMAP user_query
by Michael 20 Jan '10

20 Jan '10

How do I get IMAP+POP3 vs. LDA to use different user_query statements? The problem is that the input fields are different. IMAP/POP3 is an email address LDA is a username I have written a long statement to try and cater for both however it still only works 99% of the time, and the remaining 1% fails. The 1% that fails sees the mail being delivered to the wrong mbox. In this particular case the same client owned both mboxes so it was ok, but if this had not been the case things could have gotten real embarrassing. Think of the following: abcwidgets(a)theirdomain.tld mailuser1 mailuser1(a)adomain.tld mailuser2 Now when using the Postfix LDA, email for each address is properly delivered to the specified mbox, however in this case because their is a matching name for the mbox and the email address lefthand content, the compound SQL query returns both results and the LDA will use the first one, which in this case was the wrong one. This is the query used: user_query = \ SELECT mailboxes.username AS user, mailboxes.uid, mailboxes.gid, \ concat('*:storage=',mailquota,'M') AS quota_rule \ FROM mailboxes JOIN accounts ON accounts.username = mailboxes.username \ WHERE ((mailboxes.username = '%n' AND accounts.active='1') || \ (mailboxes.email = '%u' AND mailboxes.active='1' AND accounts.active='1') || \ (mailboxes.email = CONCAT('@','%d') AND mailboxes.active='1' \ AND (SELECT COUNT(email) FROM mailboxes WHERE email='%u') = '0')) which additionally caters for the few catch alls our users have. I think this is a massive oversight in the design of Dovecot to use one query to for 2 separate and distinct processes, that both use different parameters. From what I can tell it seems to assume that a mail system will always use username@domain addresses, and never anything more arbitrary. Has anyone found a way around this? Michael

3 4

[Dovecot] shared namespaces with common prefix prefix
by Frank Cusack 19 Jan '10

19 Jan '10

Can shared/public namespaces' prefixes have a common prefix? :) namespace public { separator = / prefix = zz/shared/ location = maildir:/var/maildir/shared:INDEX=/var/maildir/%n/shared subscriptions = no } # to share other employees mailboxes (term'd or admin access) namespace shared { separator = / prefix = zz/shared/%%u/ location = maildir:/var/maildir/%%n:INDEX=/var/maildir/users/%%u subscriptions = no list = children } Since I added the shared namespace, I can no longer access the public namespace. The folders show up but then trying to access one gets the error that the mailbox doesn't exist. If they can't have a common part of the prefix, is that an IMAP limitation or could dovecot conceivably handle it? -frank

2 4

[Dovecot] Auto Discard Vacation Sieve in a date
by Andrés Yacopino 19 Jan '10

19 Jan '10

I have deploy an environment with pigeon sieve, managesieve, dovecot, squirrelmail and avelsieve plugin. The vacation messages are working fine. I am looking for a method to discard vacation messages in some date, when the user returns. ¿Has somebody looked in this feature? Thanks a lot, -- Andrés Fernando Yacopino Infraestructura - Dpto Sistemas AcaSalud Cooperativa de Prestaciones Médico Asistenciales Limitada Tel: 0341-4208726 ayacopino(a)acasalud.com.ar

2 1

[Dovecot] Auto discard sieve vacation messages
by Andrés Yacopino 19 Jan '10

19 Jan '10

I have deploy an environment with pigeon sieve, managesieve, dovecot, squirrelmail and avelsieve plugin. The vacation messages are working fine. I am looking for a method to discard vacation messages in some date, when the user returns. Has somebody looked in this feature? Thanks a lot, -- Andrés Fernando Yacopino Infraestructura - Dpto Sistemas AcaSalud Cooperativa de Prestaciones Médico Asistenciales Limitada Tel: 0341-4208726 ayacopino(a)acasalud.com.ar

2 1