RE: debian update - Problems with IMAP, POP working

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 = 'brian@xxxxxxxxxx']
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 brian@xxxxxxxxxx) 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 = 'brian@xxxxxxxxxx'
                   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     dbmail@localhost on dbmail

Brian Winkers
brian@xxxxxxxxx
http://www.ultri.com