It bombs out after the query below.
The query runs just fine.
Any suggestions?
The problem appears to be around here in the mail.log:
Feb 24 13:54:36 debian dbmail/imap4d[17678]: dbmysql.c,db_query:
executing query [SELECT name FROM mailboxes WHERE mailbox_idnr = '2']
Feb 24 13:54:36 debian dbmail/imap4d[17678]: ChildSighandler(): got
signal [11]
Feb 24 13:54:36 debian dbmail/imap4d[17678]: ChildSighandler(): cannot
ignore this. Terminating
Feb 24 13:54:36 debian dbmail/imap4d[16709]: ParentSigHandler(): got
signal [17]
Feb 24 13:54:36 debian dbmail/imap4d[16709]: StartServer(): child
[17678] has exited
---------- /var/log/mail.log ----------
Feb 24 13:54:36 debian dbmail/imap4d[17678]: PerformChildTask():
incoming connection from [192.168.254.31]
Feb 24 13:54:36 debian dbmail/imap4d[17678]: PerformChildTask(): client
info init complete, calling client handler
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler(): line
read for PID 17678
Feb 24 13:54:36 debian dbmail/imap4d[17678]: COMMAND: [1 authenticate login]
Feb 24 13:54:36 debian dbmail/imap4d[17678]: arg[0]: 'login'
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler():
Executing command authenticate...
Feb 24 13:54:36 debian dbmail/imap4d[17678]: dbmysql.c,db_query:
executing query [SELECT user_idnr, passwd, encryption_type FROM users
WHERE userid = '[EMAIL PROTECTED]']
Feb 24 13:54:36 debian dbmail/imap4d[17678]: authsql.c,auth_validate:
validating using cleartext passwords
Feb 24 13:54:36 debian dbmail/imap4d[17678]: dbmysql.c,db_query:
executing query [UPDATE users SET last_login = '2004-02-24 13:54:36'
WHERE user_idnr = '3']
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPD [PID 17678]: user (id
3, name [EMAIL PROTECTED]) login accepted @ 2004-02-24 13:54:36^M
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler():
Finished command authenticate
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler(): line
read for PID 17678
Feb 24 13:54:36 debian dbmail/imap4d[17678]: COMMAND: [2 lsub "" "*"]
Feb 24 13:54:36 debian dbmail/imap4d[17678]: arg[0]: ''
Feb 24 13:54:36 debian dbmail/imap4d[17678]: arg[1]: '*'
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler():
Executing command lsub...
Feb 24 13:54:36 debian dbmail/imap4d[17678]: ic_list(): build the
pattern: [^.*$]
Feb 24 13:54:36 debian dbmail/imap4d[17678]: dbmysql.c,db_query:
executing query [SELECT mbx.name, mbx.mailbox_idnr, mbx.owner_idnr FROM
mailboxes mbx LEFT JOIN acl ON acl.mailbox_id = mbx.mailbox_idnr JOIN
subscription sub ON sub.user_id = '3' AND sub.mailbox_id =
mbx.mailbox_idnr WHERE mbx.owner_idnr = '3' OR (acl.user_id = '3' AND
acl.lookup_flag = '1') GROUP BY mbx.name, mbx.mailbox_idnr, mbx.owner_idnr]
Feb 24 13:54:36 debian dbmail/imap4d[17678]:
db.c,db_findmailbox_by_regex: found [0] mailboxes
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler():
Finished command lsub
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler(): line
read for PID 17678
Feb 24 13:54:36 debian dbmail/imap4d[17678]: COMMAND: [3 lsub "" "#Users*"]
Feb 24 13:54:36 debian dbmail/imap4d[17678]: arg[0]: ''
Feb 24 13:54:36 debian dbmail/imap4d[17678]: arg[1]: '#Users*'
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler():
Executing command lsub...
Feb 24 13:54:36 debian dbmail/imap4d[17678]: ic_list(): build the
pattern: [^#Users.*$]
Feb 24 13:54:36 debian dbmail/imap4d[17678]: dbmysql.c,db_query:
executing query [SELECT mbx.name, mbx.mailbox_idnr, mbx.owner_idnr FROM
mailboxes mbx LEFT JOIN acl ON acl.mailbox_id = mbx.mailbox_idnr JOIN
subscription sub ON sub.user_id = '3' AND sub.mailbox_id =
mbx.mailbox_idnr WHERE mbx.owner_idnr = '3' OR (acl.user_id = '3' AND
acl.lookup_flag = '1') GROUP BY mbx.name, mbx.mailbox_idnr, mbx.owner_idnr]
Feb 24 13:54:36 debian dbmail/imap4d[17678]:
db.c,db_findmailbox_by_regex: found [0] mailboxes
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler():
Finished command lsub
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler(): line
read for PID 17678
Feb 24 13:54:36 debian dbmail/imap4d[17678]: COMMAND: [4 lsub "" "#Public*"]
Feb 24 13:54:36 debian dbmail/imap4d[17678]: arg[0]: ''
Feb 24 13:54:36 debian dbmail/imap4d[17678]: arg[1]: '#Public*'
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler():
Executing command lsub...
Feb 24 13:54:36 debian dbmail/imap4d[17678]: ic_list(): build the
pattern: [^#Public.*$]
Feb 24 13:54:36 debian dbmail/imap4d[17678]: dbmysql.c,db_query:
executing query [SELECT mbx.name, mbx.mailbox_idnr, mbx.owner_idnr FROM
mailboxes mbx LEFT JOIN acl ON acl.mailbox_id = mbx.mailbox_idnr JOIN
subscription sub ON sub.user_id = '3' AND sub.mailbox_id =
mbx.mailbox_idnr WHERE mbx.owner_idnr = '3' OR (acl.user_id = '3' AND
acl.lookup_flag = '1') GROUP BY mbx.name, mbx.mailbox_idnr, mbx.owner_idnr]
Feb 24 13:54:36 debian dbmail/imap4d[17678]:
db.c,db_findmailbox_by_regex: found [0] mailboxes
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler():
Finished command lsub
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler(): line
read for PID 17678
Feb 24 13:54:36 debian dbmail/imap4d[17678]: COMMAND: [5 list "" "INBOX"]
Feb 24 13:54:36 debian dbmail/imap4d[17678]: arg[0]: ''
Feb 24 13:54:36 debian dbmail/imap4d[17678]: arg[1]: 'INBOX'
Feb 24 13:54:36 debian dbmail/imap4d[17678]: IMAPClientHandler():
Executing command list...
Feb 24 13:54:36 debian dbmail/imap4d[17678]: ic_list(): build the
pattern: [^INBOX$]
Feb 24 13:54:36 debian dbmail/imap4d[17678]: dbmysql.c,db_query:
executing query [SELECT mbx.name, mbx.mailbox_idnr, mbx.owner_idnr FROM
mailboxes mbx LEFT JOIN acl ON mbx.mailbox_idnr = acl.mailbox_id WHERE
(acl.user_id = '3' AND acl.lookup_flag = '1') OR mbx.owner_idnr = '3']
Feb 24 13:54:36 debian dbmail/imap4d[17678]:
db.c,db_list_mailboxes_by_regex: comparing mailbox [INBOX] to regular
expression
Feb 24 13:54:36 debian dbmail/imap4d[17678]:
db.c,db_list_mailboxes_by_regex: regex match INBOX
Feb 24 13:54:36 debian dbmail/imap4d[17678]:
db.c,db_findmailbox_by_regex: found [1] mailboxes
Feb 24 13:54:36 debian dbmail/imap4d[17678]: dbmysql.c,db_query:
executing query [SELECT owner_idnr FROM mailboxes WHERE mailbox_idnr = '2']
Feb 24 13:54:36 debian dbmail/imap4d[17678]: dbmysql.c,db_query:
executing query [SELECT name FROM mailboxes WHERE mailbox_idnr = '2']
Feb 24 13:54:36 debian dbmail/imap4d[17678]: ChildSighandler(): got
signal [11]
Feb 24 13:54:36 debian dbmail/imap4d[17678]: ChildSighandler(): cannot
ignore this. Terminating
Feb 24 13:54:36 debian dbmail/imap4d[16709]: ParentSigHandler(): got
signal [17]
Feb 24 13:54:36 debian dbmail/imap4d[16709]: StartServer(): child
[17678] has exited
Feb 24 13:54:36 debian dbmail/imap4d[16709]: StartServer(): creating new
child
Feb 24 13:54:36 debian dbmail/imap4d[17703]: CreateChild(): signal
handler placed, going to perform task now
Feb 24 13:54:36 debian dbmail/imap4d[17703]: PerformChildTask(): waiting
for connection
---------- /var/log/mysql/mysql.log ----------
040224 13:53:55 887 Query SELECT user_idnr, passwd,
encryption_type FROM users WHERE userid = '[EMAIL PROTECTED]'
887 Query UPDATE users SET last_login =
'2004-02-24 13:53:55' WHERE user_idnr = '3'
887 Query SELECT mbx.name, mbx.mailbox_idnr,
mbx.owner_idnr FROM mailboxes mbx LEFT JOIN acl ON acl.mailbox_id =
mbx.mailbox_idnr JOIN subscription sub ON sub.user_id = '3' AND
sub.mailbox_id = mbx.mailbox_idnr WHERE mbx.owner_idnr = '3' OR
(acl.user_id = '3' AND acl.lookup_flag = '1') GROUP BY mbx.name,
mbx.mailbox_idnr, mbx.owner_idnr
887 Query SELECT mbx.name, mbx.mailbox_idnr,
mbx.owner_idnr FROM mailboxes mbx LEFT JOIN acl ON acl.mailbox_id =
mbx.mailbox_idnr JOIN subscription sub ON sub.user_id = '3' AND
sub.mailbox_id = mbx.mailbox_idnr WHERE mbx.owner_idnr = '3' OR
(acl.user_id = '3' AND acl.lookup_flag = '1') GROUP BY mbx.name,
mbx.mailbox_idnr, mbx.owner_idnr
887 Query SELECT mbx.name, mbx.mailbox_idnr,
mbx.owner_idnr FROM mailboxes mbx LEFT JOIN acl ON acl.mailbox_id =
mbx.mailbox_idnr JOIN subscription sub ON sub.user_id = '3' AND
sub.mailbox_id = mbx.mailbox_idnr WHERE mbx.owner_idnr = '3' OR
(acl.user_id = '3' AND acl.lookup_flag = '1') GROUP BY mbx.name,
mbx.mailbox_idnr, mbx.owner_idnr
887 Query SELECT mbx.name, mbx.mailbox_idnr,
mbx.owner_idnr FROM mailboxes mbx LEFT JOIN acl ON mbx.mailbox_idnr =
acl.mailbox_id WHERE (acl.user_id = '3' AND acl.lookup_flag = '1') OR
mbx.owner_idnr = '3'
887 Query SELECT owner_idnr FROM mailboxes
WHERE mailbox_idnr = '2'
887 Query SELECT name FROM mailboxes WHERE
mailbox_idnr = '2'
892 Connect [EMAIL PROTECTED] on dbmail
Brian Winkers
[EMAIL PROTECTED]
http://www.ultri.com
