Jochen,
Could you plz try the following:
telnet imapserver imap
1 LOGIN username password
2 select yourmailboxname
3 uid search 1:* undeleted body "Anfrage"
4 logout
This looks like a bug a fixed after 2.1.6 was released.
About time 2.1.7 saw the light of day.
Jochen Schroer wrote:
> Hi,
> I recycle this old subject because I have the same problem described in
> May without a solution for it.
> At the moment I evaluate dbmail for migrating from our old
> courier-imap-1.4.3 to a newer, and faster !!!, system.
>
> What we need is a fast body-search, but the only feature that is not
> running looks like searching in the body :-(
>
> Server: dbmail 2.1.6, compiled on debian sarge.
> Database Backend: mysql4
> Mailclient: Thunderbird
>
> here a log from my try to serach the messagebody with thunderbird:
>
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: COMMAND: [21 uid SEARCH
> UNDELETED BODY "Anfrage"]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: arg[0]: 'SEARCH'
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: arg[1]: 'UNDELETED'
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: arg[2]: 'BODY'
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: arg[3]: 'Anfrage'
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]:
> imap4.c,IMAPClientHandler: Executing command uid...
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: db.c,db_acl_has_right:
> checking ACL [read_flag] for user [3] on mailbox [1]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: db.c, db_acl_has_right:
> mailbox [1] is owned by user [3], is that also [3]?
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: db.c, db_acl_has_right:
> mailbox [1] is owned by user [3], giving all rights
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: dbmysql.c,db_query:
> query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '1'
> AND status IN ('0','1') ORDER BY message_idnr]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]:
> dbmail-mailbox.c,append_search: [134959360] [1] type [2] field [] search
> [deleted_flag=0] at depth [1]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]:
> dbmail-mailbox.c,append_search: [134761072] [0] type [11] field []
> search [Anfrage] at depth [1]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: dbmysql.c,db_query:
> query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '1'
> AND status IN ('0','1') AND deleted_flag=0 ORDER BY message_idnr]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]:
> dbmail-mailbox.c,_do_search: [134959360] depth [1] type [2] rows [2674]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]:
> dbmail-mailbox.c,_do_search: [134761072] depth [2] type [11] rows [0]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]:
> dbmail-mailbox.c,_merge_search: [134959360] depth [1] type [2]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: misc.c,g_tree_merge:
> a[2674] [AND] b[2674] -> a[2674]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]:
> dbmail-mailbox.c,_merge_search: [134761072] depth [2] type [11]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: misc.c,g_tree_merge:
> a[2674] [AND] b[0] -> a[0]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]:
> dbmail-mailbox.c,dbmail_mailbox_search: found [0] ids
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: RESPONSE: [* SEARCH ]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]: RESPONSE: [^M 21 OK
> SEARCH completed^M ]
> Jul 9 14:17:13 localhost dbmail/imap4d[14978]:
> imap4.c,IMAPClientHandler: Finished command uid [0]
>
> what I find out was that in line 1264 of dbmail-mailbox.c (function
> mailbox_search_parsed) $self->set is empty.
> ids = self->set;
> while (ids) {
> the routine comes never into the while loop.
>
> Has somebody a solution for it? I take a look into this c-file in the
> svn, but it looks like that there was made no changes.
>
> Kind regards,
>
> Jochen
>
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
