I'm guessing that somewhere in g_tree_merge, my 50 messages got cut down to
zero, but I can't figure out why.
>From what I can tell, this should return 50 messages. Yes, no?
Do I have something set incorrectly?
I'm using a sample/demo app, and had to modify an existing IMAP account they
had, and can't delete/recreate.
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+298): Executing command login...
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_handle_auth(+1618): trying to validate
user [EMAIL PROTECTED], pass [XXXX]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT userid FROM dbmail_usermap WHERE 1 = 2]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_use_usermap(+167): enabling usermap lookups
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_usermap_resolve(+4668): checking userid [EMAIL PROTECTED] in usermap
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_usermap_resolve(+4679): client on inet socket [inet:192.168.184.31:143]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT login, sock_allow, sock_deny, userid FROM
dbmail_usermap WHERE login in ('[EMAIL PROTECTED]','ANY') ORDER BY sock_allow,
sock_deny]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_usermap_resolve(+4705): login [EMAIL PROTECTED] not found in usermap
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT user_idnr FROM dbmail_users WHERE
lower(userid) = lower('[EMAIL PROTECTED]')]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT user_idnr, passwd, encryption_type FROM
dbmail_users WHERE user_idnr = 4]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[auth]
authsql.c,auth_validate(+421): validating using plaintext passwords
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [UPDATE dbmail_users SET last_login = '2008-06-09
20:42:30' WHERE user_idnr = 4]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Message:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_handle_auth(+1623): user (id:4, name
[EMAIL PROTECTED]) tries login
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Message:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_handle_auth(+1644): user (id 4, name
[EMAIL PROTECTED]) login accepted
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_set_state(+2133): state [2]
]n 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [0002 OK
LOGIN completed
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+317): Finished command login [0]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+187): COMMAND: [0003 LIST "" "INBOX"]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[0]: ''
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[1]: 'INBOX'
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+298): Executing command list...
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Info:[imap]
imapcommands.c,_ic_list(+721): search with pattern: [INBOX]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT distinct(mbx.name), mbx.mailbox_idnr,
mbx.owner_idnr FROM dbmail_mailboxes mbx LEFT JOIN dbmail_acl acl ON
mbx.mailbox_idnr = acl.mailbox_id LEFT JOIN dbmail_users usr ON acl.user_id =
usr.user_idnr WHERE mbx.name ILIKE 'INBOX' AND ((mbx.owner_idnr = 4) OR
(acl.user_id = 4 AND acl.lookup_flag = 1) OR (usr.userid = 'anyone' AND
acl.lookup_flag = 1))]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,mailboxes_by_regex(+2861): adding namespace prefix to [INBOX] got [INBOX]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Info:[db]
db.c,db_findmailbox_by_regex(+2910): found [1] mailboxes
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT owner_idnr, name, no_select, no_inferiors
FROM dbmail_mailboxes WHERE mailbox_idnr = 1]
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT COUNT(*) AS nr_children FROM dbmail_mailboxes
WHERE owner_idnr = 4 AND name ILIKE 'INBOX/%']
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [* LIST
(\haschildren) "/" " ]BOX"
]n 9 20:42:30 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [0003 OK LIST
completed
Jun 9 20:42:30 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+317): Finished command list [0]
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+187): COMMAND: [0004 SELECT "INBOX"]
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[0]: 'INBOX'
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+298): Executing command select...
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_findmailbox(+2597): looking for mailbox with FQN [INBOX].
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name
ILIKE 'INBOX' AND owner_idnr=4]
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_set_state(+2133): state [2]
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_acl_has_right(+4196): checking ACL [read_flag] for user [4] on mailbox
[1]
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT owner_idnr FROM dbmail_mailboxes WHERE
mailbox_idnr = 1]
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_acl_has_right(+4207): mailbox [1] is owned by user [4], giving all
rights
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT no_select FROM dbmail_mailboxes WHERE
mailbox_idnr = 1]
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = 1]
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT 'a',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr=1 AND (status < 2) UNION SELECT 'b',COUNT(*) FROM dbmail_messages
WHERE mailbox_idnr=1 AND (status < 2) AND seen_flag=1 UNION SELECT 'c',COUNT(*)
FROM dbmail_messages WHERE mailbox_idnr=1 AND (status < 2) AND recent_flag=1]
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT message_idnr+1 FROM dbmail_messages WHERE
mailbox_idnr=1 ORDER BY message_idnr DESC LIMIT 1]
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT message_idnr FROM dbmail_messages WHERE
mailbox_idnr = 1 AND status IN (0,1) ORDER BY message_idnr]
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,mailbox_build_uid_map(+184): ids [1735], msn [1735]
Jun 9 20:42:31 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT seen_flag, answered_flag, deleted_flag,
flagged_flag, draft_flag, recent_flag, TO_CHAR(internal_date, 'YYYY-MM-DD
HH24:MI:SS' ), rfcsize, message_idnr FROM dbmail_messages msg,
dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN
59766 AND 639003 AND mailbox_idnr = 1 AND status IN (0,1,2) ORDER BY
message_idnr ASC]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [1] seconds
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_set_state(+2133): state [3]
]n 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [* 1735 EXISTS
]n 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [* 0 RECENT
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [* FLAGS
(\Seen \Answered \D ]eted \Flagged \Draft)
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [* OK
[PERMANENTFLAGS (\Seen ]Answered \Deleted \Flagged \Draft)]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [* OK
[UIDNEXT 639004] Predi ]ed next UID
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [* OK
[UIDVALIDITY 1] UID va ]e
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT message_idnr FROM dbmail_messages WHERE
mailbox_idnr = 1 AND status < 2 AND seen_flag = 0 ORDER BY message_idnr LIMIT 1]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [0004 OK
[READ-WRITE] SELECT ]ompleted
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+317): Finished command select [0]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+187): COMMAND: [0005 UID SEARCH 936:1735 SINCE
2-Jun-2008]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[0]: 'SEARCH'
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[1]: '936:1735'
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[2]: 'SINCE'
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[3]: '2-Jun-2008'
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+298): Executing command uid...
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_acl_has_right(+4196): checking ACL [read_flag] for user [4] on mailbox
[1]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT owner_idnr FROM dbmail_mailboxes WHERE
mailbox_idnr = 1]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_acl_has_right(+4207): mailbox [1] is owned by user [4], giving all
rights
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT message_idnr FROM dbmail_messages WHERE
mailbox_idnr = 1 AND status IN (0,1) ORDER BY message_idnr]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,mailbox_build_uid_map(+184): ids [1735], msn [1735]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[misc]
misc.c,check_msg_set(+1004): [936:1735] [ok]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,append_search(+614): [0x8867f00] leaf [1] type [2] field []
search [936:1735] at depth [1]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,append_search(+614): [0x886a720] leaf [1] type [9] field []
search [internal_date > '2008-06-02 00:00:00'] at depth [1]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_build_imap_search(+1168): done [0] at idx [4]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_get_set(+1429): [936:1735] uid [1]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[misc]
misc.c,g_tree_merge(+1275): (0x8895480) (0x8868fa8): a[0] [OR] b[1] -> a[1]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,_do_search(+1619): [0x8867f00] depth [1] type [2] rows [1]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT message_idnr FROM dbmail_messages m JOIN
dbmail_physmessage p ON m.physmessage_id=p.id WHERE mailbox_idnr = 1 AND status
IN (0,1) AND p.internal_date > '2008-06-02 00:00:00' ORDER BY message_idnr]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,_do_search(+1619): [0x886a720] depth [2] type [9] rows [50]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[misc]
misc.c,g_tree_merge(+1275): (0x8867970) (0x8895480): a[1735] [AND] b[1] -> a[1]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,_merge_search(+1696): [0x8867f00] leaf [0] depth [1] type [2]
found [1]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[misc]
misc.c,g_tree_merge(+1275): (0x8867970) (0x8868fa8): a[1] [AND] b[50] -> a[0]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,_merge_search(+1696): [0x886a720] leaf [1] depth [2] type [9]
found [0]
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_search(+1728): found [0] ids
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_ids_as_string(+531): no ids found
]n 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [* SEARCH
]n 9 20:42:32 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [0005 OK
SEARCH completed
Jun 9 20:42:32 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+317): Finished command uid [0]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+187): COMMAND: [0006 UID SEARCH 136:935 SINCE
2-Jun-2008]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[0]: 'SEARCH'
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[1]: '136:935'
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[2]: 'SINCE'
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[3]: '2-Jun-2008'
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+298): Executing command uid...
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_acl_has_right(+4196): checking ACL [read_flag] for user [4] on mailbox
[1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_acl_has_right(+4207): mailbox [1] is owned by user [4], giving all
rights
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT message_idnr FROM dbmail_messages WHERE
mailbox_idnr = 1 AND status IN (0,1) ORDER BY message_idnr]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,mailbox_build_uid_map(+184): ids [1735], msn [1735]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[misc]
misc.c,check_msg_set(+1004): [136:935] [ok]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,append_search(+614): [0x886c000] leaf [1] type [2] field []
search [136:935] at depth [1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,append_search(+614): [0x886d0a8] leaf [1] type [9] field []
search [internal_date > '2008-06-02 00:00:00'] at depth [1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_build_imap_search(+1168): done [0] at idx [4]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_get_set(+1429): [136:935] uid [1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[misc]
misc.c,g_tree_merge(+1275): (0x886ba80) (0x886baa0): a[0] [OR] b[1] -> a[1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,_do_search(+1619): [0x886c000] depth [1] type [2] rows [1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT message_idnr FROM dbmail_messages m JOIN
dbmail_physmessage p ON m.physmessage_id=p.id WHERE mailbox_idnr = 1 AND status
IN (0,1) AND p.internal_date > '2008-06-02 00:00:00' ORDER BY message_idnr]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,_do_search(+1619): [0x886d0a8] depth [2] type [9] rows [50]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[misc]
misc.c,g_tree_merge(+1275): (0x8867970) (0x886ba80): a[1735] [AND] b[1] -> a[1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,_merge_search(+1696): [0x886c000] leaf [0] depth [1] type [2]
found [1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[misc]
misc.c,g_tree_merge(+1275): (0x8867970) (0x886baa0): a[1] [AND] b[50] -> a[0]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,_merge_search(+1696): [0x886d0a8] leaf [1] depth [2] type [9]
found [0]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_search(+1728): found [0] ids
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_ids_as_string(+531): no ids found
]n 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [* SEARCH
]n 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [0006 OK
SEARCH completed
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+317): Finished command uid [0]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+187): COMMAND: [0007 UID SEARCH 1:135 SINCE
2-Jun-2008]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[0]: 'SEARCH'
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[1]: '1:135'
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[2]: 'SINCE'
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,build_args_array_ext(+2540): arg[3]: '2-Jun-2008'
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+298): Executing command uid...
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_acl_has_right(+4196): checking ACL [read_flag] for user [4] on mailbox
[1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[db]
db.c,db_acl_has_right(+4207): mailbox [1] is owned by user [4], giving all
rights
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT message_idnr FROM dbmail_messages WHERE
mailbox_idnr = 1 AND status IN (0,1) ORDER BY message_idnr]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [0] seconds
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,mailbox_build_uid_map(+184): ids [1735], msn [1735]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[misc]
misc.c,check_msg_set(+1004): [1:135] [ok]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,append_search(+614): [0x886c000] leaf [1] type [2] field []
search [1:135] at depth [1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,append_search(+614): [0x886d0a8] leaf [1] type [9] field []
search [internal_date > '2008-06-02 00:00:00'] at depth [1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_build_imap_search(+1168): done [0] at idx [4]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_get_set(+1429): [1:135] uid [1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[misc]
misc.c,g_tree_merge(+1275): (0x886a300) (0x886a320): a[0] [OR] b[1] -> a[1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,_do_search(+1619): [0x886c000] depth [1] type [2] rows [1]
Jun 9 20:42:33 mail1 dbmail/imap4d[7017]: Debug:[sql]
dbpgsql.c,db_query(+279): [SELECT message_idnr FROM dbmail_messages m JOIN
dbmail_physmessage p ON m.physmessage_id=p.id WHERE mailbox_idnr = 1 AND status
IN (0,1) AND p.internal_date > '2008-06-02 00:00:00' ORDER BY message_idnr]
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[db]
dbmodule.c,db_query(+145): last query took [1] seconds
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,_do_search(+1619): [0x886d0a8] depth [2] type [9] rows [50]
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[misc]
misc.c,g_tree_merge(+1275): (0x8867970) (0x886a300): a[1735] [AND] b[1] -> a[1]
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,_merge_search(+1696): [0x886c000] leaf [0] depth [1] type [2]
found [1]
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[misc]
misc.c,g_tree_merge(+1275): (0x8867970) (0x886a320): a[1] [AND] b[50] -> a[0]
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,_merge_search(+1696): [0x886d0a8] leaf [1] depth [2] type [9]
found [0]
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_search(+1728): found [0] ids
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[mailbox]
dbmail-mailbox.c,dbmail_mailbox_ids_as_string(+531): no ids found
]n 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [* SEARCH
]n 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [0007 OK
SEARCH completed
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+317): Finished command uid [0]
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+187): COMMAND: [0008 LOGOUT]
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+298): Executing command logout...
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_set_state(+2133): state [4]
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Message:[imap]
imapcommands.c,_ic_logout(+126): user (id:4) logging out @ [2008-06-09 20:42:34]
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [* BYE dbmail
imap server ki ]es you goodbye
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Info:[imap]
imap4.c,IMAPClientHandler(+317): Finished command logout [0]
]n 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[imapsession]
dbmail-imapsession.c,dbmail_imap_session_printf(+1523): RESPONSE: [0008 OK
completed
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Message:[imap]
imap4.c,IMAPClientHandler(+323): Closing connection for client from IP
[99.206.26.142]
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Debug:[serverchild]
serverchild.c,PerformChildTask(+379): client handling complete, closing streams
Jun 9 20:42:34 mail1 dbmail/imap4d[7017]: Info:[serverchild]
serverchild.c,PerformChildTask(+381): connection closed
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail