Re: RE: debian update - Problems with IMAP, POP working

which version of dbmail are you using?

Ilja

Brian Winkers wrote:

> 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
>
>
>
> _______________________________________________
> Dbmail mailing list
> Dbmail@xxxxxxxxxx
> https://mailman.fastxs.nl/mailman/listinfo/dbmail