- dovecot - dovecot.org

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

[Dovecot] Virtual folder, Program terminated with signal 6
by Matthias Rieber 19 Jan '10

19 Jan '10

Hi, I've regularly crashes with a certain virtual folder. Erasing the dovecot-index.* files help just for few hours/days. Here are to backtraces: Core was generated by `imap'. Program terminated with signal 6, Aborted. [New process 25893] #0 0xf7df8556 in raise () from /lib/libc.so.6 #0 0xf7df8556 in raise () from /lib/libc.so.6 No symbol table info available. #1 0xf7df9d78 in abort () from /lib/libc.so.6 No symbol table info available. #2 0x080f2d25 in default_fatal_finish (type=<value optimized out>, status=0) at failures.c:160 backtrace = 0x88ee860 "imap [0x80f2d11] -> imap [0x80f2d92] -> imap [0x80f26e9] -> imap(index_search_result_update_flags+0x295) [0x80b2305] -> /usr/local/lib/dovecot/imap/lib20_virtual_plugin.so [0xf7da937d] -> /usr/local/l"... #3 0x080f2d92 in i_internal_fatal_handler (type=LOG_TYPE_PANIC, status=0, fmt=0x810b88c "file %s: line %d (%s): assertion failed: (%s)", args=0xff8b2ea4 "\\S\021\bW") at failures.c:443 No locals. #4 0x080f26e9 in i_panic (format=0x810b88c "file %s: line %d (%s): assertion failed: (%s)") at failures.c:207 No locals. #5 0x080b2305 in index_search_result_update_flags (result=0x9400cb0, uids=0xff8b3150) at index-search-result.c:87 search_arg = {next = 0x89024c0, type = SEARCH_UIDSET, value = {subargs = 0x0, seqset = {arr = {buffer = 0x88ee4a8, element_size = 8}, v = 0x88ee4a8, v_modifiable = 0x88ee4a8}, str = 0x0, time = 0, size = 0, flags = 0, search_flags = 0, thread_type = MAIL_THREAD_NONE, keywords = 0x0, modseq = 0x0, search_args = 0x0, search_result = 0x0}, context = 0x0, hdr_field_name = 0x0, not = 0, match_always = 0, result = -1} ret = <value optimized out> __PRETTY_FUNCTION__ = "index_search_result_update_flags" #6 0xf7da937d in virtual_sync_backend_boxes (ctx=0x93f6660) at virtual-sync.c:733 _data_stack_cur_id = 4 i = 0 ret = 155151376 #7 0xf7daa25b in virtual_storage_sync_init (box=0xb20e070, flags=65) at virtual-sync.c:1486 sync_ctx = <value optimized out> ret = <value optimized out> #8 0x080b6ab2 in mailbox_sync (box=0x6525, flags=65, status_items=239, status_r=0xff8b3338) at mail-storage.c:593 ctx = <value optimized out> #9 0x080651b8 in cmd_select_full (cmd=0x88fbc88, readonly=false) at cmd-select.c:273 client = (struct client *) 0x88fb9f8 box = (struct mailbox *) 0x0 ctx = (struct imap_select_context *) 0x88fbd28 args = (const struct imap_arg *) 0x88fe508 mailbox = 0x88ee2b8 "obfuscated" ret = <value optimized out> __PRETTY_FUNCTION__ = "cmd_select_full" #10 0x08065919 in cmd_select (cmd=0x88fbc88) at cmd-select.c:389 No locals. #11 0x08067bfc in client_command_input (cmd=0x88fbc88) at client.c:612 client = (struct client *) 0x88fb9f8 command = <value optimized out> __PRETTY_FUNCTION__ = "client_command_input" #12 0x08067c99 in client_command_input (cmd=0x88fbc88) at client.c:661 client = (struct client *) 0x88fb9f8 command = <value optimized out> __PRETTY_FUNCTION__ = "client_command_input" #13 0x08067e0d in client_handle_input (client=0x88fb9f8) at client.c:702 _data_stack_cur_id = 3 ret = false remove_io = <value optimized out> handled_commands = false __PRETTY_FUNCTION__ = "client_handle_input" #14 0x0806876f in client_input (client=0x88fb9f8) at client.c:753 cmd = <value optimized out> output = (struct ostream *) 0x88fbbac bytes = <value optimized out> __PRETTY_FUNCTION__ = "client_input" #15 0x080fbac0 in io_loop_handler_run (ioloop=0x88f61a8) at ioloop-epoll.c:208 ctx = (struct ioloop_handler_context *) 0x88f6c18 event = (const struct epoll_event *) 0x88f6c58 list = (struct io_list *) 0x88fbc30 io = (struct io_file *) 0x88fbc08 tv = {tv_sec = 1, tv_usec = 707102} t_id = 2 msecs = <value optimized out> ret = 1 i = 0 j = 0 call = <value optimized out> #16 0x080faf30 in io_loop_run (ioloop=0x88f61a8) at ioloop.c:335 No locals. #17 0x0807127a in main (argc=) at main.c:327 No locals. Core was generated by `imap'. Program terminated with signal 6, Aborted. [New process 26275] #0 0xf7ea4556 in raise () from /lib/libc.so.6 #0 0xf7ea4556 in raise () from /lib/libc.so.6 No symbol table info available. #1 0xf7ea5d78 in abort () from /lib/libc.so.6 No symbol table info available. #2 0x080f2d25 in default_fatal_finish (type=<value optimized out>, status=0) at failures.c:160 backtrace = 0x88d9860 "imap [0x80f2d11] -> imap [0x80f2d92] -> imap [0x80f26e9] -> imap(index_search_result_update_flags+0x295) [0x80b2305] -> /usr/local/lib/dovecot/imap/lib20_virtual_plugin.so [0xf7e5537d] -> /usr/local/l"... #3 0x080f2d92 in i_internal_fatal_handler (type=LOG_TYPE_PANIC, status=0, fmt=0x810b88c "file %s: line %d (%s): assertion failed: (%s)", args=0xffe03774 "\\S\021\bW") at failures.c:443 No locals. #4 0x080f26e9 in i_panic (format=0x810b88c "file %s: line %d (%s): assertion failed: (%s)") at failures.c:207 No locals. #5 0x080b2305 in index_search_result_update_flags (result=0x9318e10, uids=0xffe03a20) at index-search-result.c:87 search_arg = {next = 0x893dfe8, type = SEARCH_UIDSET, value = {subargs = 0x0, seqset = {arr = {buffer = 0x88d94a8, element_size = 8}, v = 0x88d94a8, v_modifiable = 0x88d94a8}, str = 0x0, time = 0, size = 0, flags = 0, search_flags = 0, thread_type = MAIL_THREAD_NONE, keywords = 0x0, modseq = 0x0, search_args = 0x0, search_result = 0x0}, context = 0x0, hdr_field_name = 0x0, not = 0, match_always = 0, result = -1} ret = <value optimized out> __PRETTY_FUNCTION__ = "index_search_result_update_flags" #6 0xf7e5537d in virtual_sync_backend_boxes (ctx=0x930e9e8) at virtual-sync.c:733 _data_stack_cur_id = 4 i = 0 ret = 154202008 #7 0xf7e5625b in virtual_storage_sync_init (box=0x88ebcf0, flags=65) at virtual-sync.c:1486 sync_ctx = <value optimized out> ret = <value optimized out> #8 0x080b6ab2 in mailbox_sync (box=0x66a3, flags=65, status_items=239, status_r=0xffe03c08) at mail-storage.c:593 ctx = <value optimized out> #9 0x080651b8 in cmd_select_full (cmd=0x88e6c88, readonly=false) at cmd-select.c:273 client = (struct client *) 0x88e69f8 box = (struct mailbox *) 0x0 ctx = (struct imap_select_context *) 0x88e6d28 args = (const struct imap_arg *) 0x88e9508 mailbox = 0x88d92b8 "obfuscated" ret = <value optimized out> __PRETTY_FUNCTION__ = "cmd_select_full" #10 0x08065919 in cmd_select (cmd=0x88e6c88) at cmd-select.c:389 No locals. #11 0x08067bfc in client_command_input (cmd=0x88e6c88) at client.c:612 client = (struct client *) 0x88e69f8 command = <value optimized out> __PRETTY_FUNCTION__ = "client_command_input" #12 0x08067c99 in client_command_input (cmd=0x88e6c88) at client.c:661 client = (struct client *) 0x88e69f8 command = <value optimized out> __PRETTY_FUNCTION__ = "client_command_input" #13 0x08067e0d in client_handle_input (client=0x88e69f8) at client.c:702 _data_stack_cur_id = 3 ret = false remove_io = <value optimized out> handled_commands = false __PRETTY_FUNCTION__ = "client_handle_input" #14 0x0806876f in client_input (client=0x88e69f8) at client.c:753 cmd = <value optimized out> output = (struct ostream *) 0x88e6bac bytes = <value optimized out> __PRETTY_FUNCTION__ = "client_input" #15 0x080fbac0 in io_loop_handler_run (ioloop=0x88e11a8) at ioloop-epoll.c:208 ctx = (struct ioloop_handler_context *) 0x88e1c18 event = (const struct epoll_event *) 0x88e1c58 list = (struct io_list *) 0x88e6c30 io = (struct io_file *) 0x88e6c08 tv = {tv_sec = 1, tv_usec = 627183} t_id = 2 msecs = <value optimized out> ret = 1 i = 0 j = 0 call = <value optimized out> #16 0x080faf30 in io_loop_run (ioloop=0x88e11a8) at ioloop.c:335 No locals. #17 0x0807127a in main (argc=) at main.c:327 No locals. kind regards, Matthias

2 4