And the log for IMAP 2.0.10:
Apr 5 06:21:22 mail dbmail/imap4d[27395]: pool.c,child_register: register
child [27395]
Apr 5 06:21:22 mail dbmail/imap4d[27395]: pool.c,child_register: initializing
child_state [27395] using slot [0]
Apr 5 06:21:22 mail dbmail/imap4d[27397]: pool.c,child_register: register
child [27397]
Apr 5 06:21:22 mail dbmail/imap4d[27397]: pool.c,child_register: initializing
child_state [27397] using slot [1]
Apr 5 06:21:22 mail dbmail/imap4d[27399]: pool.c,child_register: register
child [27399]
Apr 5 06:21:22 mail dbmail/imap4d[27399]: pool.c,child_register: initializing
child_state [27399] using slot [2]
Apr 5 06:21:22 mail dbmail/imap4d[27401]: pool.c,child_register: register
child [27401]
Apr 5 06:21:22 mail dbmail/imap4d[27401]: pool.c,child_register: initializing
child_state [27401] using slot [3]
Apr 5 06:21:22 mail dbmail/imap4d[27403]: pool.c,child_register: register
child [27403]
Apr 5 06:21:22 mail dbmail/imap4d[27403]: pool.c,child_register: initializing
child_state [27403] using slot [4]
Apr 5 06:21:37 mail dbmail/imap4d[27395]: serverchild.c,PerformChildTask:
incoming connection from [172.16.15.253 (mail.itnavigate.com.au)]
Apr 5 06:21:37 mail dbmail/imap4d[27395]: IMAPD [PID 27395]: user (id 2, name
crm) login accepted @ 2006-04-05 06:21:37
Apr 5 06:22:02 mail postfix/smtpd[27417]: connect from
web38013.mail.mud.yahoo.com[209.191.124.124]
Apr 5 06:22:03 mail postfix/smtpd[27417]: B1DDF2AFD3:
client=web38013.mail.mud.yahoo.com[209.191.124.124]
Apr 5 06:22:04 mail postfix/cleanup[27419]: B1DDF2AFD3: message-id=<[EMAIL
PROTECTED]>
Apr 5 06:22:04 mail postfix/qmgr[27381]: B1DDF2AFD3: from=<[EMAIL
PROTECTED]>, size=15215, nrcpt=1 (queue active)
Apr 5 06:22:05 mail postfix/smtpd[27417]: disconnect from
web38013.mail.mud.yahoo.com[209.191.124.124]
Apr 5 06:22:06 mail dbmail/smtp[27421]: sort.c, sort_and_deliver: message
id=42240, size=15040 is inserted
Apr 5 06:22:07 mail postfix/pipe[27385]: B1DDF2AFD3: to=<[EMAIL PROTECTED]>,
relay=dbmail-smtp, delay=4, status=sent (itnavigate.com.au)
Apr 5 06:22:07 mail postfix/qmgr[27381]: B1DDF2AFD3: removed
Apr 5 06:25:10 mail postfix/postfix-script: stopping the Postfix mail system
Apr 5 06:25:10 mail postfix/master[27379]: terminating on signal 15
Apr 5 06:28:54 mail dbmail/imap4d[27397]: serverchild.c,PerformChildTask:
incoming connection from [172.16.15.253 (mail.itnavigate.com.au)]
Apr 5 06:28:54 mail dbmail/imap4d[27397]: IMAPD [PID 27397]: user (id 2, name
crm) login accepted @ 2006-04-05 06:28:54
Apr 5 06:30:49 mail dbmail/imap4d[27399]: serverchild.c,PerformChildTask:
incoming connection from [172.16.15.253 (mail.itnavigate.com.au)]
Apr 5 06:30:53 mail dbmail/imap4d[27399]: IMAPD [PID 27399]: user (id 4, name
nlm) login accepted @ 2006-04-05 06:30:53
Apr 5 06:34:15 mail dbmail/imap4d[27511]: pool.c,child_register: register
child [27511]
Apr 5 06:34:15 mail dbmail/imap4d[27511]: pool.c,child_register: initializing
child_state [27511] using slot [2]
Apr 5 06:34:15 mail dbmail/imap4d[27393]: pool.c,manage_spare_children:
children [5/20], spares [3 (2 - 4)]
Apr 5 06:34:44 mail dbmail/imap4d[27401]: serverchild.c,PerformChildTask:
incoming connection from [172.16.15.253 (mail.itnavigate.com.au)]
Apr 5 06:34:44 mail dbmail/imap4d[27401]: IMAPD [PID 27401]: user (id 4, name
nlm) login accepted @ 2006-04-05 06:34:44
Apr 5 06:34:49 mail dbmail/imap4d[27517]: pool.c,child_register: register
child [27517]
Apr 5 06:34:49 mail dbmail/imap4d[27517]: pool.c,child_register: initializing
child_state [27517] using slot [3]
Apr 5 06:34:49 mail dbmail/imap4d[27393]: pool.c,manage_spare_children:
children [5/20], spares [3 (2 - 4)]
Apr 5 06:34:52 mail dbmail/imap4d[27403]: serverchild.c,PerformChildTask:
incoming connection from [172.16.15.253 (mail.itnavigate.com.au)]
Apr 5 06:34:52 mail dbmail/imap4d[27403]: IMAPD [PID 27403]: user (id 4, name
nlm) login accepted @ 2006-04-05 06:34:52
Apr 5 06:34:56 mail dbmail/imap4d[27521]: pool.c,child_register: register
child [27521]
Apr 5 06:34:56 mail dbmail/imap4d[27521]: pool.c,child_register: initializing
child_state [27521] using slot [4]
Apr 5 06:34:57 mail dbmail/imap4d[27393]: pool.c,manage_spare_children:
children [5/20], spares [3 (2 - 4)]
Apr 5 06:35:01 mail dbmail/imap4d[27511]: serverchild.c,PerformChildTask:
incoming connection from [172.16.15.253 (mail.itnavigate.com.au)]
Apr 5 06:35:01 mail dbmail/imap4d[27511]: IMAPD [PID 27511]: user (id 4, name
nlm) login accepted @ 2006-04-05 06:35:01
Apr 5 06:35:05 mail dbmail/imap4d[27527]: pool.c,child_register: register
child [27527]
Apr 5 06:35:05 mail dbmail/imap4d[27527]: pool.c,child_register: initializing
child_state [27527] using slot [2]
Apr 5 06:35:05 mail dbmail/imap4d[27393]: pool.c,manage_spare_children:
children [5/20], spares [3 (2 - 4)]
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): searching value
for config item [host]
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): NULL item value
in item-list
Apr 5 06:35:45 mail last message repeated 3 times
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): found value
[127.0.0.1]
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): searching value
for config item [db]
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): NULL item value
in item-list
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): found value
[dbmail]
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): searching value
for config item [user]
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): NULL item value
in item-list
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): NULL item value
in item-list
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): found value
[dbmail]
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): searching value
for config item [pass]
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): NULL item value
in item-list
Apr 5 06:35:45 mail last message repeated 3 times
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): item not found
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): searching value
for config item [sqlport]
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): NULL item value
in item-list
Apr 5 06:35:45 mail last message repeated 3 times
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): item not found
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): searching value
for config item [sqlsocket]
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): NULL item value
in item-list
Apr 5 06:35:45 mail last message repeated 3 times
Apr 5 06:35:45 mail dbmail/imap4d[27535]: GetConfigValue(): item not found
Apr 5 06:35:45 mail dbmail/imap4d[27535]: CreateSocket(): socket created
Apr 5 06:35:45 mail dbmail/imap4d[27535]: CreateSocket(): socket IP requested
[*] OK
Apr 5 06:35:45 mail dbmail/imap4d[27535]: CreateSocket(): IP bound to socket
Apr 5 06:35:45 mail dbmail/imap4d[27535]: CreateSocket(): socket creation
complete
Apr 5 06:35:45 mail dbmail/imap4d[27536]: misc.c,drop_privileges: could not
find group nogroup
Apr 5 06:35:45 mail dbmail/imap4d[27536]: StartServer(): init
Apr 5 06:35:45 mail dbmail/imap4d[27536]: dbpgsql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Apr 5 06:35:45 mail dbmail/imap4d[27536]: StartServer(): init ok. Creating
children..
Apr 5 06:35:45 mail dbmail/imap4d[27538]: pool.c,child_register: register
child [27538]
Apr 5 06:35:45 mail dbmail/imap4d[27538]: pool.c,child_register: initializing
child_state [27538] using slot [0]
Apr 5 06:35:45 mail dbmail/imap4d[27538]: serverchild.c,CreateChild: signal
handler placed, going to perform task now
Apr 5 06:35:45 mail dbmail/imap4d[27540]: pool.c,child_register: register
child [27540]
Apr 5 06:35:45 mail dbmail/imap4d[27540]: pool.c,child_register: initializing
child_state [27540] using slot [1]
Apr 5 06:35:45 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Apr 5 06:35:45 mail dbmail/imap4d[27541]: pool.c,child_register: register
child [27541]
Apr 5 06:35:45 mail dbmail/imap4d[27541]: pool.c,child_register: initializing
child_state [27541] using slot [2]
Apr 5 06:35:45 mail dbmail/imap4d[27541]: serverchild.c,CreateChild: signal
handler placed, going to perform task now
Apr 5 06:35:45 mail dbmail/imap4d[27540]: serverchild.c,CreateChild: signal
handler placed, going to perform task now
Apr 5 06:35:45 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: previous result
set is possibly not freed.
Apr 5 06:35:45 mail dbmail/imap4d[27538]: serverchild.c,PerformChildTask:
waiting for connection
Apr 5 06:35:45 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Apr 5 06:35:45 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: previous result
set is possibly not freed.
Apr 5 06:35:45 mail dbmail/imap4d[27540]: serverchild.c,PerformChildTask:
waiting for connection
Apr 5 06:35:45 mail dbmail/imap4d[27545]: pool.c,child_register: register
child [27545]
Apr 5 06:35:45 mail dbmail/imap4d[27542]: pool.c,child_register: register
child [27542]
Apr 5 06:35:45 mail dbmail/imap4d[27541]: dbpgsql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Apr 5 06:35:45 mail dbmail/imap4d[27541]: dbpgsql.c,db_query: previous result
set is possibly not freed.
Apr 5 06:35:45 mail dbmail/imap4d[27541]: serverchild.c,PerformChildTask:
waiting for connection
Apr 5 06:35:45 mail dbmail/imap4d[27536]: pool.c,manage_spare_children:
creating spare child
Apr 5 06:35:45 mail dbmail/imap4d[27546]: pool.c,child_register: register
child [27546]
Apr 5 06:35:45 mail dbmail/imap4d[27546]: pool.c,child_register: initializing
child_state [27546] using slot [3]
Apr 5 06:35:45 mail dbmail/imap4d[27546]: serverchild.c,CreateChild: signal
handler placed, going to perform task now
Apr 5 06:35:45 mail dbmail/imap4d[27546]: dbpgsql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Apr 5 06:35:45 mail dbmail/imap4d[27546]: dbpgsql.c,db_query: previous result
set is possibly not freed.
Apr 5 06:35:45 mail dbmail/imap4d[27546]: serverchild.c,PerformChildTask:
waiting for connection
Apr 5 06:35:45 mail dbmail/imap4d[27545]: pool.c,child_register: initializing
child_state [27545] using slot [4]
Apr 5 06:35:45 mail dbmail/imap4d[27545]: serverchild.c,CreateChild: signal
handler placed, going to perform task now
Apr 5 06:35:45 mail dbmail/imap4d[27545]: dbpgsql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Apr 5 06:35:45 mail dbmail/imap4d[27545]: dbpgsql.c,db_query: previous result
set is possibly not freed.
Apr 5 06:35:45 mail dbmail/imap4d[27545]: serverchild.c,PerformChildTask:
waiting for connection
Apr 5 06:35:45 mail dbmail/imap4d[27542]: pool.c,child_register: initializing
child_state [27542] using slot [5]
Apr 5 06:35:45 mail dbmail/imap4d[27542]: serverchild.c,CreateChild: signal
handler placed, going to perform task now
Apr 5 06:35:45 mail dbmail/imap4d[27536]: pool.c,manage_spare_children:
killing overcomplete spare [27542]
Apr 5 06:35:45 mail dbmail/imap4d[27542]: dbpgsql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Apr 5 06:35:45 mail dbmail/imap4d[27542]: dbpgsql.c,db_query: previous result
set is possibly not freed.
Apr 5 06:35:45 mail dbmail/imap4d[27542]: serverchild.c,PerformChildTask:
stop requested
Apr 5 06:35:45 mail dbmail/imap4d[27542]: serverchild.c,disconnect_all:
database connection still open, closing
Apr 5 06:35:45 mail dbmail/imap4d[27536]: pool.c,manage_spare_children: spare
child [27542] has exited
Apr 5 06:35:45 mail dbmail/imap4d[27536]: pool.c,manage_spare_children:
children [5/20], spares [5 (2 - 4)]
Apr 5 06:35:45 mail dbmail/imap4d[27536]: StartServer(): children created,
starting main service loop
Apr 5 06:35:49 mail dbmail/imap4d[27538]: serverchild.c,PerformChildTask:
incoming connection from [172.16.15.253 (mail.itnavigate.com.au)]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): line read for
PID 27538
Apr 5 06:35:49 mail dbmail/imap4d[27538]: COMMAND: [1 authenticate login]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[0]: 'login'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): Executing
command authenticate...
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid =
'nlm']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: previous result
set is possibly not freed.
Apr 5 06:35:49 mail dbmail/imap4d[27538]: authsql.c,auth_validate: validating
using plaintext passwords
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-04-05 06:35:49' WHERE user_idnr =
'4']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPD [PID 27538]: user (id 4, name
nlm) login accepted @ 2006-04-05 06:35:49
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): Finished
command authenticate
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): line read for
PID 27538
Apr 5 06:35:49 mail dbmail/imap4d[27538]: COMMAND: [2 select "INBOX"]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[0]: 'INBOX'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): Executing
command select...
Apr 5 06:35:49 mail dbmail/imap4d[27538]: db.c,db_findmailbox: looking for
mailbox with FQN [INBOX].
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='4']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: db.c,db_acl_has_right: checking ACL
for user [4] on mailbox [9]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '9' AND
owner_idnr = '4']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '9']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '9']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='9' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='9' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='9' AND (status='0' OR
status='1') AND recent_flag=1]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '9' AND status <
'2' ORDER BY message_idnr ASC]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT message_idnr + 1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT
1]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT MIN(message_idnr) FROM dbmail_messages WHERE mailbox_idnr = '9' AND
status < '2' AND seen_flag = '0']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): Finished
command select
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '9']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='9' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='9' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='9' AND (status='0' OR
status='1') AND recent_flag=1]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '9' AND status <
'2' ORDER BY message_idnr ASC]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT message_idnr + 1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT
1]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): line read for
PID 27538
Apr 5 06:35:49 mail dbmail/imap4d[27538]: COMMAND: [3 getquotaroot "INBOX"]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[0]: 'INBOX'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): Executing
command getquotaroot...
Apr 5 06:35:49 mail dbmail/imap4d[27538]: db.c,db_findmailbox: looking for
mailbox with FQN [INBOX].
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='4']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT maxmail_size FROM dbmail_users WHERE user_idnr = '4']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT curmail_size FROM dbmail_users WHERE user_idnr = '4']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): Finished
command getquotaroot
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): line read for
PID 27538
Apr 5 06:35:49 mail dbmail/imap4d[27538]: COMMAND: [4 UID fetch 1:* (FLAGS)]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[0]: 'fetch'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[1]: '1:*'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[2]: '('
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[3]: 'FLAGS'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[4]: ')'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): Executing
command uid...
Apr 5 06:35:49 mail dbmail/imap4d[27538]: db.c,db_acl_has_right: checking ACL
for user [4] on mailbox [9]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '9' AND
owner_idnr = '4']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: next_fetch_item(): args[idx = 2] =
FLAGS (returning 3)
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[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 '1' AND '42240' AND mailbox_idnr =
'9' AND status < '2' ORDER BY message_idnr ASC]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: ic_fetch(): no parsing at all
Apr 5 06:35:49 mail dbmail/imap4d[27538]: _ic_fetch(): no parsing, into fetch
loop
Apr 5 06:35:49 mail last message repeated 297 times
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): Finished
command uid
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): line read for
PID 27538
Apr 5 06:35:49 mail dbmail/imap4d[27538]: COMMAND: [5 UID fetch 42107:42231
(UID RFC822.SIZE FLAGS BODY.PEEK[HEADER.FIELDS (From To Cc Subject Date
Message-ID Priority X-Priority References Newsgroups In-Reply-To
Content-Type)])]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[0]: 'fetch'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[1]: '42107:42231'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[2]: '('
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[3]: 'UID'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[4]: 'RFC822.SIZE'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[5]: 'FLAGS'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[6]: 'BODY.PEEK'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[7]: '['
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[8]: 'HEADER.FIELDS'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[9]: '('
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[10]: 'From'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[11]: 'To'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[12]: 'Cc'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[13]: 'Subject'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[14]: 'Date'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[15]: 'Message-ID'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[16]: 'Priority'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[17]: 'X-Priority'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[18]: 'References'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[19]: 'Newsgroups'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[20]: 'In-Reply-To'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[21]: 'Content-Type'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[22]: ')'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[23]: ']'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: arg[24]: ')'
Apr 5 06:35:49 mail dbmail/imap4d[27538]: IMAPClientHandler(): Executing
command uid...
Apr 5 06:35:49 mail dbmail/imap4d[27538]: db.c,db_acl_has_right: checking ACL
for user [4] on mailbox [9]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '9' AND
owner_idnr = '4']
Apr 5 06:35:49 mail dbmail/imap4d[27538]: next_fetch_item(): args[idx = 2] =
UID (returning 3)
Apr 5 06:35:49 mail dbmail/imap4d[27538]: next_fetch_item(): args[idx = 3] =
RFC822.SIZE (returning 4)
Apr 5 06:35:49 mail dbmail/imap4d[27538]: next_fetch_item(): args[idx = 4] =
FLAGS (returning 5)
Apr 5 06:35:49 mail dbmail/imap4d[27538]: next_fetch_item(): args[idx = 22] =
] (returning 23)
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.c,db_query: executing query
[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 '42107' AND '42231' AND
mailbox_idnr = '9' AND status < '2' ORDER BY message_idnr ASC]
Apr 5 06:35:49 mail dbmail/imap4d[27538]: Fetching msgID 42107 (fetch num
42108)
Apr 5 06:35:49 mail dbmail/imap4d[27538]: dbpgsql.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 = '42107' ORDER BY
blk.messageblk_idnr ASC LIMIT 1]
Apr 5 06:35:52 mail dbmail/imap4d[27538]: mime_readheader(): entering mime
loop
Apr 5 06:35:52 mail dbmail/imap4d[27538]: Fetching msgID 42109 (fetch num
42110)
Apr 5 06:35:52 mail dbmail/imap4d[27538]: dbpgsql.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 = '42109' ORDER BY
blk.messageblk_idnr ASC LIMIT 1]
Apr 5 06:35:53 mail dbmail/imap4d[27538]: mime_readheader(): entering mime
loop
Apr 5 06:35:53 mail dbmail/imap4d[27536]: pool.c,manage_spare_children:
creating spare child
Apr 5 06:35:53 mail dbmail/imap4d[27553]: pool.c,child_register: register
child [27553]
Apr 5 06:35:53 mail dbmail/imap4d[27553]: pool.c,child_register: initializing
child_state [27553] using slot [0]
Apr 5 06:35:53 mail dbmail/imap4d[27553]: serverchild.c,CreateChild: signal
handler placed, going to perform task now
Apr 5 06:35:53 mail dbmail/imap4d[27553]: dbpgsql.c,db_query: executing query
[SELECT 1=1 FROM dbmail_physmessage LIMIT 1 OFFSET 0]
Apr 5 06:35:53 mail dbmail/imap4d[27553]: dbpgsql.c,db_query: previous result
set is possibly not freed.
Apr 5 06:35:53 mail dbmail/imap4d[27553]: serverchild.c,PerformChildTask:
waiting for connection
Apr 5 06:35:53 mail dbmail/imap4d[27536]: pool.c,manage_spare_children:
children [5/20], spares [5 (2 - 4)]
Apr 5 06:37:38 mail dbmail/imap4d[27540]: serverchild.c,PerformChildTask:
incoming connection from [172.16.15.253 (mail.itnavigate.com.au)]
Apr 5 06:37:38 mail dbmail/imap4d[27540]: serverchild.c,PerformChildTask:
client info init complete, calling client handler
Apr 5 06:37:38 mail dbmail/imap4d[27540]: IMAPClientHandler(): line read for
PID 27540
Apr 5 06:37:38 mail dbmail/imap4d[27540]: COMMAND: [1 authenticate login]
Apr 5 06:37:38 mail dbmail/imap4d[27540]: arg[0]: 'login'
Apr 5 06:37:38 mail dbmail/imap4d[27540]: IMAPClientHandler(): Executing
command authenticate...
Apr 5 06:37:38 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT user_idnr, passwd, encryption_type FROM dbmail_users WHERE userid =
'crm']
Apr 5 06:37:38 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: previous result
set is possibly not freed.
Apr 5 06:37:38 mail dbmail/imap4d[27540]: authsql.c,auth_validate: validating
using plaintext passwords
Apr 5 06:37:38 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[UPDATE dbmail_users SET last_login = '2006-04-05 06:37:38' WHERE user_idnr =
'2']
Apr 5 06:37:38 mail dbmail/imap4d[27540]: IMAPD [PID 27540]: user (id 2, name
crm) login accepted @ 2006-04-05 06:37:38
Apr 5 06:37:38 mail dbmail/imap4d[27540]: IMAPClientHandler(): Finished
command authenticate
Apr 5 06:37:38 mail dbmail/imap4d[27540]: IMAPClientHandler(): line read for
PID 27540
Apr 5 06:37:38 mail dbmail/imap4d[27540]: COMMAND: [2 select "INBOX"]
Apr 5 06:37:38 mail dbmail/imap4d[27540]: arg[0]: 'INBOX'
Apr 5 06:37:38 mail dbmail/imap4d[27540]: IMAPClientHandler(): Executing
command select...
Apr 5 06:37:38 mail dbmail/imap4d[27540]: db.c,db_findmailbox: looking for
mailbox with FQN [INBOX].
Apr 5 06:37:38 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE name='INBOX' AND
owner_idnr='2']
Apr 5 06:37:38 mail dbmail/imap4d[27540]: db.c,db_acl_has_right: checking ACL
for user [2] on mailbox [2]
Apr 5 06:37:38 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '2' AND
owner_idnr = '2']
Apr 5 06:37:38 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT no_select FROM dbmail_mailboxes WHERE mailbox_idnr = '2']
Apr 5 06:37:38 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '2']
Apr 5 06:37:38 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='2' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='2' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='2' AND (status='0' OR
status='1') AND recent_flag=1]
Apr 5 06:37:40 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '2' AND status <
'2' ORDER BY message_idnr ASC]
Apr 5 06:37:40 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT message_idnr + 1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT
1]
Apr 5 06:37:40 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT MIN(message_idnr) FROM dbmail_messages WHERE mailbox_idnr = '2' AND
status < '2' AND seen_flag = '0']
Apr 5 06:37:41 mail dbmail/imap4d[27540]: IMAPClientHandler(): Finished
command select
Apr 5 06:37:41 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT
permission,seen_flag,answered_flag,deleted_flag,flagged_flag,recent_flag,draft_flag
FROM dbmail_mailboxes WHERE mailbox_idnr = '2']
Apr 5 06:37:41 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT 'a',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='2' AND
(status='0' OR status='1') UNION SELECT 'b',COUNT(*) FROM dbmail_messages WHERE
mailbox_idnr='2' AND (status='0' OR status='1') AND seen_flag=1 UNION SELECT
'c',COUNT(*) FROM dbmail_messages WHERE mailbox_idnr='2' AND (status='0' OR
status='1') AND recent_flag=1]
Apr 5 06:37:41 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = '2' AND status <
'2' ORDER BY message_idnr ASC]
Apr 5 06:37:41 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT message_idnr + 1 FROM dbmail_messages ORDER BY message_idnr DESC LIMIT
1]
Apr 5 06:37:41 mail dbmail/imap4d[27540]: IMAPClientHandler(): line read for
PID 27540
Apr 5 06:37:41 mail dbmail/imap4d[27540]: COMMAND: [3 UID fetch 1:* (FLAGS)]
Apr 5 06:37:41 mail dbmail/imap4d[27540]: arg[0]: 'fetch'
Apr 5 06:37:41 mail dbmail/imap4d[27540]: arg[1]: '1:*'
Apr 5 06:37:41 mail dbmail/imap4d[27540]: arg[2]: '('
Apr 5 06:37:41 mail dbmail/imap4d[27540]: arg[3]: 'FLAGS'
Apr 5 06:37:41 mail dbmail/imap4d[27540]: arg[4]: ')'
Apr 5 06:37:41 mail dbmail/imap4d[27540]: IMAPClientHandler(): Executing
command uid...
Apr 5 06:37:41 mail dbmail/imap4d[27540]: db.c,db_acl_has_right: checking ACL
for user [2] on mailbox [2]
Apr 5 06:37:41 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '2' AND
owner_idnr = '2']
Apr 5 06:37:41 mail dbmail/imap4d[27540]: next_fetch_item(): args[idx = 2] =
FLAGS (returning 3)
Apr 5 06:37:41 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[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 '1' AND '42240' AND mailbox_idnr =
'2' AND status < '2' ORDER BY message_idnr ASC]
Apr 5 06:37:43 mail dbmail/imap4d[27540]: ic_fetch(): no parsing at all
Apr 5 06:37:43 mail dbmail/imap4d[27540]: _ic_fetch(): no parsing, into fetch
loop
Apr 5 06:37:43 mail last message repeated 2417 times
Apr 5 06:37:43 mail dbmail/imap4d[27540]: IMAPClientHandler(): Finished
command uid
Apr 5 06:37:43 mail dbmail/imap4d[27540]: IMAPClientHandler(): line read for
PID 27540
Apr 5 06:37:43 mail dbmail/imap4d[27540]: COMMAND: [4 UID fetch 42240 (UID
RFC822.SIZE FLAGS BODY.PEEK[HEADER.FIELDS (From To Cc Subject Date Message-ID
Priority X-Priority References Newsgroups In-Reply-To Content-Type)])]
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[0]: 'fetch'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[1]: '42240'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[2]: '('
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[3]: 'UID'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[4]: 'RFC822.SIZE'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[5]: 'FLAGS'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[6]: 'BODY.PEEK'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[7]: '['
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[8]: 'HEADER.FIELDS'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[9]: '('
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[10]: 'From'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[11]: 'To'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[12]: 'Cc'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[13]: 'Subject'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[14]: 'Date'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[15]: 'Message-ID'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[16]: 'Priority'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[17]: 'X-Priority'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[18]: 'References'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[19]: 'Newsgroups'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[20]: 'In-Reply-To'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[21]: 'Content-Type'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[22]: ')'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[23]: ']'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: arg[24]: ')'
Apr 5 06:37:43 mail dbmail/imap4d[27540]: IMAPClientHandler(): Executing
command uid...
Apr 5 06:37:43 mail dbmail/imap4d[27540]: db.c,db_acl_has_right: checking ACL
for user [2] on mailbox [2]
Apr 5 06:37:43 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[SELECT mailbox_idnr FROM dbmail_mailboxes WHERE mailbox_idnr = '2' AND
owner_idnr = '2']
Apr 5 06:37:43 mail dbmail/imap4d[27540]: next_fetch_item(): args[idx = 2] =
UID (returning 3)
Apr 5 06:37:43 mail dbmail/imap4d[27540]: next_fetch_item(): args[idx = 3] =
RFC822.SIZE (returning 4)
Apr 5 06:37:43 mail dbmail/imap4d[27540]: next_fetch_item(): args[idx = 4] =
FLAGS (returning 5)
Apr 5 06:37:43 mail dbmail/imap4d[27540]: next_fetch_item(): args[idx = 22] =
] (returning 23)
Apr 5 06:37:43 mail dbmail/imap4d[27540]: dbpgsql.c,db_query: executing query
[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 '42240' AND '42240' AND
mailbox_idnr = '2' AND status < '2' ORDER BY message_idnr ASC]
Apr 5 06:37:43 mail dbmail/imap4d[27540]: Fetching msgID 42240 (fetch num
42241)
Apr 5 06:37:43 mail dbmail/imap4d[27540]: dbpgsql.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 = '42240' ORDER BY
blk.messageblk_idnr ASC LIMIT 1]
Apr 5 06:37:45 mail dbmail/imap4d[27540]: mime_readheader(): entering mime
loop
Apr 5 06:37:45 mail dbmail/imap4d[27540]: mime_readheader(): found double
newline; header size: 19 lines
Apr 5 06:37:45 mail dbmail/imap4d[27540]: IMAPClientHandler(): Finished
command uid
Paul J Stevens <[EMAIL PROTECTED]> wrote: Colin Manning wrote:
> Hi All,
>
> I have been running dbmail for some time now, and waiting for seive -
> thanks to everyone involved in getting it going.
>
> So I thought that today would be a good day to install 2.1.5 - after
> finally getting it to compile.
>
> So, understanding that it is unstable, a backup of the database and the
> ability to re-install to existing executables is all I need to recover
> if anything goes sour.
>
> Fine so far - so I thought (pg_dump file failed - operator error, to
> much rush, so not checked properly :-)
>
> make
> make install
> add_header_tables
> add_sieve_tables
> add_auto_replies_fields
> add_replycache
> add_usermap
> dbmail-util -byv
>
> The makes went fine, dbmail-util failed with some messages in cache,
None of those look fatal.
>
> dbmail-smtp -V
>
> *** DBMAIL: dbmail-smtp version $Revision: 2058 $ (c) 1999-2004 IC&S,
> 2004-2006 NFG, The Netherlands
>
> No errors in maillog (That I can detect).
>
> The header is visible in my mail clients ( I'v tried evoulution,
> thunderbird and M$ Outlook 2003 all using imap), but the body is nowhere
> to be seen. I can see it in the database (dbmail_messageblks), but can't
> get it to my mail client.
>
> So methinks I'll restore my original database and executables. WRONG.
> Backup failed.
Running 2.0.9 or 2.0.10 would be fine, without restoring the data.
>
> Is there any way back? Or anyway forward?
>
> I would prefer to go forward.
great.
>
> here is an extract from my maillog:
I only see logs from dbmail-smtp. Show me some imap logs.
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
---------------------------------
On Yahoo!7
Messenger: Make free PC-to-PC calls to your friends overseas.
