A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=250 ====================================================================== Reported By: ezaton Assigned To: ====================================================================== Project: DBMail Issue ID: 250 Category: IMAP daemon Reproducibility: always Severity: minor Priority: normal Status: new ====================================================================== Date Submitted: 18-Aug-05 01:08 CEST Last Modified: 31-Aug-05 14:11 CEST ====================================================================== Summary: DB failure when trying to subscribe to an imap folder Description: Reproducable with both SquirrelMail and Mozilla-Thunderbird, both using the same mailbox. The DB was migrated from 1.x, long time ago. When trying to subscribe, the following error message is shown on the server:
Aug 18 01:56:11 rafael dbmail/imap4d[32142]: _ic_login(): user (id:1, name ezaton) tries login Aug 18 01:56:11 rafael dbmail/imap4d[32142]: _ic_login(): user (id 1, name ezaton) login accepted @ 2005-08-18 01:56:11 Aug 18 01:56:11 rafael dbmail/imap4d[32142]: dbmysql.c,db_query: query [INSERT INTO dbmail_subscription (user_id, mailbox_id) VALUES ('1', '41')] failed Aug 18 01:56:11 rafael dbmail/imap4d[32142]: dbmysql.c,db_query: mysql_real_query failed: Cannot add or update a child row: a foreign key constraint fails Aug 18 01:56:11 rafael dbmail/imap4d[32142]: db.c,db_subscribe: could not insert subscription Aug 18 01:56:11 rafael dbmail/imap4d[32142]: imap4.c,IMAPClientHandler: command return with error [subscribe] Aug 18 01:56:11 rafael dbmail/imap4d[32142]: IMAPClientHandler(): Closing connection for client from IP [127.0.0.1] Trace Level 2 on dbmail-imapd The client disconnects and reports imap error. This problem (although I've never tried to submit a bug here before) is reproducable on all dbmail 2.0.x ====================================================================== ---------------------------------------------------------------------- ilja - 18-Aug-05 10:25 ---------------------------------------------------------------------- Can you show a log with log level 5? That would give us some more information. ---------------------------------------------------------------------- ezaton - 19-Aug-05 04:22 ---------------------------------------------------------------------- Both errors when trying to subscribe to a folder (the first case, the name is W2L, the 2nd case is to a folder called layer7). Note: If not using subscription (Thunderbird support accessing folders without subscribing), everything's work just fine. It's just the act of subscribing which fails. Thanks. Ez ---------------------------------------------------------------------- paul - 31-Aug-05 14:11 ---------------------------------------------------------------------- There has to be some weirdness in your table setup. Please send us: mysqldump -d dbmail mysql -e "select user_idnr,userid from dbmail_users where userid='ezaton' or user_idnr=1" dbmail mysql -e "select * from dbmail_mailboxes where owner_idnr=1 and mailbox_idnr=41" dbmail Issue History Date Modified Username Field Change ====================================================================== 18-Aug-05 01:08 ezaton New Issue 18-Aug-05 10:25 ilja Note Added: 0000843 19-Aug-05 04:19 ezaton File Added: dbmail-error1.txt 19-Aug-05 04:20 ezaton File Added: dbmail-error2.txt 19-Aug-05 04:22 ezaton Note Added: 0000844 31-Aug-05 14:11 paul Note Added: 0000898 ======================================================================