Hello
A strange problem: When I use "search" in Squirrelmail 1.4.3a (using
DBMail 2.0.1) on the field "address", everything works fine. If I search
the "subjects", I get this error:
FEHLER : Aktion konnte nicht ausgeführt werden.
Unbekannte Antwort vom IMAP Server: 1.
(translation:
ERROR: action could not be performed.
Unknown answer from IMAP server: 1.)
The only "hits" showing up are some messages with empty subject lines
Mailboxsize is < 1MB, about 80 messages. Log level for the imap server is
5. MTA is postfix.
Log extract:
<------------------------ schnipp ------------------------------------>
Dec 13 10:31:23 merry dbmail/imap4d[1237]: arg[0]: 'SEARCH'
Dec 13 10:31:24 merry dbmail/imap4d[1237]: arg[1]: 'CHARSET'
Dec 13 10:31:24 merry dbmail/imap4d[1237]: arg[2]: 'ISO-8859-1'
Dec 13 10:31:24 merry dbmail/imap4d[1237]: arg[3]: 'ALL'
Dec 13 10:31:24 merry dbmail/imap4d[1237]: arg[4]: 'SUBJECT'
Dec 13 10:31:24 merry dbmail/imap4d[1237]: arg[5]: 'dlck'
Dec 13 10:31:24 merry dbmail/imap4d[1237]: IMAPClientHandler(): Executing
command uid...
Dec 13 10:31:24 merry dbmail/imap4d[1237]: IMAPClientHandler(): Finished
command uid
Dec 13 10:31:25 merry dbmail/imap4d[1237]: IMAPClientHandler(): line read
for PID 1237
Dec 13 10:31:25 merry dbmail/imap4d[1237]: COMMAND: [A005 SEARCH CHARSET
"US-ASCII" ALL SUBJECT {4}]
Dec 13 10:31:25 merry dbmail/imap4d[1237]:
imaputil.c,build_args_array_ext: last char = }
Dec 13 10:31:25 merry dbmail/imap4d[1237]: build_args_array_ext(): got
extra line []
Dec 13 10:31:25 merry dbmail/imap4d[1237]: arg[0]: 'CHARSET'
Dec 13 10:31:25 merry dbmail/imap4d[1237]: arg[1]: 'US-ASCII'
Dec 13 10:31:25 merry dbmail/imap4d[1237]: arg[2]: 'ALL'
Dec 13 10:31:25 merry dbmail/imap4d[1237]: arg[3]: 'SUBJECT'
Dec 13 10:31:26 merry dbmail/imap4d[1237]: arg[4]: 'dlck'
Dec 13 10:31:26 merry dbmail/imap4d[1237]: IMAPClientHandler(): Executing
command search...
Dec 13 10:31:26 merry dbmail/imap4d[1237]: db.c,db_acl_has_right: checking
ACL for user [3] on mailbox [25]
Dec 13 10:31:26 merry dbmail/imap4d[1237]: dbmysql.c,db_query: executing
query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '25'
AND owner_idnr = '3']
Dec 13 10:31:26 merry dbmail/imap4d[1237]: dbmysql.c,db_query: executing
query [SELECT messageblk FROM dbmail_messageblks blk, dbmail_messages msg
WHERE blk.physmessage_id = msg.physmessage_id AND msg.message_idnr =
'230868' ORDER BY blk.messageblk_idnr ASC LIMIT 1]
Dec 13 10:31:26 merry dbmail/imap4d[1237]: mime_readheader(): entering
mime loop
Dec 13 10:31:26 merry dbmail/imap4d[1237]: mime_readheader(): found double
newline; header size: 20 lines
< .... a lot mor of those last few lines .... >
Dec 13 10:32:05 merry dbmail/imap4d[1237]: IMAPClientHandler(): Finished
command search
Dec 13 10:32:05 merry dbmail/imap4d[1237]: IMAPClientHandler(): line read
for PID 1237
Dec 13 10:32:05 merry dbmail/imap4d[1237]: COMMAND: [A006 UID FETCH 57:58
(FLAGS UID RFC822.SIZE BODY.PEEK[HEADER.FIELDS (Date To Cc From Subject
X-Priority Content-Type)])]
Dec 13 10:32:05 merry dbmail/imap4d[1237]: arg[0]: 'FETCH'
Dec 13 10:32:06 merry dbmail/imap4d[1237]: arg[1]: '57:58'
Dec 13 10:32:06 merry dbmail/imap4d[1237]: arg[2]: '('
Dec 13 10:32:06 merry dbmail/imap4d[1237]: arg[3]: 'FLAGS'
Dec 13 10:32:06 merry dbmail/imap4d[1237]: arg[4]: 'UID'
Dec 13 10:32:06 merry dbmail/imap4d[1237]: arg[5]: 'RFC822.SIZE'
Dec 13 10:32:06 merry dbmail/imap4d[1237]: arg[6]: 'BODY.PEEK'
Dec 13 10:32:06 merry dbmail/imap4d[1237]: arg[7]: '['
Dec 13 10:32:06 merry dbmail/imap4d[1237]: arg[8]: 'HEADER.FIELDS'
Dec 13 10:32:07 merry dbmail/imap4d[1237]: arg[9]: '('
Dec 13 10:32:07 merry dbmail/imap4d[1237]: arg[10]: 'Date'
Dec 13 10:32:07 merry dbmail/imap4d[1237]: arg[11]: 'To'
Dec 13 10:32:07 merry dbmail/imap4d[1237]: arg[12]: 'Cc'
Dec 13 10:32:07 merry dbmail/imap4d[1237]: arg[13]: 'From'
Dec 13 10:32:07 merry dbmail/imap4d[1237]: arg[14]: 'Subject'
Dec 13 10:32:07 merry dbmail/imap4d[1237]: arg[15]: 'X-Priority'
Dec 13 10:32:07 merry dbmail/imap4d[1237]: arg[16]: 'Content-Type'
Dec 13 10:32:08 merry dbmail/imap4d[1237]: arg[17]: ')'
Dec 13 10:32:08 merry dbmail/imap4d[1237]: arg[18]: ']'
Dec 13 10:32:08 merry dbmail/imap4d[1237]: arg[19]: ')'
Dec 13 10:32:08 merry dbmail/imap4d[1237]: IMAPClientHandler(): Executing
command uid...
Dec 13 10:32:08 merry dbmail/imap4d[1237]: db.c,db_acl_has_right: checking
ACL for user [3] on mailbox [25]
Dec 13 10:32:08 merry dbmail/imap4d[1237]: dbmysql.c,db_query: executing
query [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '25'
AND owner_idnr = '3']
Dec 13 10:32:08 merry dbmail/imap4d[1237]: next_fetch_item(): args[idx =
2] = FLAGS (returning 3)
Dec 13 10:32:08 merry dbmail/imap4d[1237]: next_fetch_item(): args[idx =
3] = UID (returning 4)
Dec 13 10:32:09 merry dbmail/imap4d[1237]: next_fetch_item(): args[idx =
4] = RFC822.SIZE (returning 5)
Dec 13 10:32:09 merry dbmail/imap4d[1237]: next_fetch_item(): args[idx =
17] = ] (returning 18)
Dec 13 10:32:09 merry dbmail/imap4d[1237]: dbmysql.c,db_free_result:
Trying to free result set that is already NULL!
Dec 13 10:32:09 merry dbmail/imap4d[1237]: dbmysql.c,db_query: executing
query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag,
draft_flag, recent_flag, DATE_FORMAT(internal_date, '%Y-%m-%d %T'),
rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm
WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN '57' AND '58'
AND mailbox_idnr = '25' AND status < '2' ORDER BY message_idnr ASC]
Dec 13 10:32:09 merry dbmail/imap4d[1237]: IMAPClientHandler(): Finished
command uid
Dec 13 10:32:09 merry dbmail/imap4d[1237]: IMAPClientHandler(): line read
for PID 1237
Dec 13 10:32:09 merry dbmail/imap4d[1237]: COMMAND: [A007 LOGOUT]
Dec 13 10:32:09 merry dbmail/imap4d[1237]: IMAPClientHandler(): Executing
command logout...
Dec 13 10:32:10 merry dbmail/imap4d[1237]: _ic_logout(): user (id:3)
logging out @ [2004-12-13 10:32:10]
Dec 13 10:32:10 merry dbmail/imap4d[1237]: IMAPClientHandler(): Finished
command logout
Dec 13 10:32:10 merry dbmail/imap4d[1237]: IMAPClientHandler(): Closing
connection for client from IP [127.0.0.1]
Dec 13 10:32:10 merry dbmail/imap4d[1237]: PerformChildTask(): client
handling complete, closing streams
Dec 13 10:32:10 merry dbmail/imap4d[1237]: PerformChildTask(): connection
closed
Dec 13 10:32:10 merry dbmail/imap4d[1237]: PerformChildTask(): waiting for
connection
<------------------------ schnapp ------------------------------------>
My guess would be that dbmail hits any special characters in the subject
field, but then I'm not sure why this should be a problem. I don't see any
problems with Squirrelmail; the search function works fine on other
systems.
Apart from this, DBMail works REALLY fine, both smooth and fast.
Any ideas?
Thanks for any advice
Stefan