aptem wrote: > I just compiled dbmail, applied create_tables.mysql, created new user > and tried to login with TB, and I've got error. > Why dbmail doesn't handle sql error? The result is TB infinitely tries > to connect imap. > How can I fix the problem? :)
upgrade mysql. You are on mysql-4.1 right? I've tested 2.3.2 *extensively* against mysql-5.0, postgresql-8.2 and sqlite3. Not that below query can't be made to work on mysql-4.1, but if you are on a distro which doesn't have mysql-5, your distro will most likely also encounter all kinds of trouble with gmime as well. > > > telnet localhost 143 > Trying 127.0.0.1... > Connected to localhost. > Escape character is '^]'. > * OK dbmail imap (protocol version 4r1) server 0.9.9 ready to run 0.9.9??? That must be a configure bug. On my systems that string reads '[email protected]' which is also incorrect. > 2 authenticate login > + dXNlcm5hbWUNCg== > dGVzdHVzZXI= > + cGFzc3dvcmQNCg== > dGVzdHBhc3M= > 2 OK AUTHENTICATE completed > 3 select "INBOX" > * 1 EXISTS > * 0 RECENT > * FLAGS (\Seen \Answered \Deleted \Flagged \Draft) > * OK [PERMANENTFLAGS (\Seen \Answered \Deleted \Flagged \Draft \*)] > * OK [UIDNEXT 3] Predicted next UID > * OK [UIDVALIDITY 1] UID value > 3 OK [READ-WRITE] SELECT completed > 4 UID fetch 1:* (FLAGS) > Connection closed by foreign host. > > > > mysql> use dbmail > mysql> SELECT message_idnr, keyword FROM dbmail_keywords k JOIN > dbmail_messages m USING (message_idnr) JOIN dbmail_mailboxes b USING > (mailbox_idnr) WHERE b.mailbox_idnr = 1; > ERROR 1052 (23000): Column 'message_idnr' in field list is ambiguous > > > > ________________________________________________________________________________________________________________________________________________ > > > > Feb 08 19:43:35 art dbmail-imapd[29230]: Debug:[sql] > dbmysql.c,db_query(+301): query [SELECT message_idnr, keyword FROM > dbmail_keywords k JOIN dbmail_messages m USING (message_idnr) JOIN > dbmail_mailboxes b USING (mailbox_idnr) WHERE b.mailbox_idnr = 1 ] > Feb 08 19:43:35 art dbmail-imapd[29230]: Error:[sql] > dbmysql.c,db_query(+304): [Column 'message_idnr' in field list is > ambiguous] [SELECT message_idnr, keyword FROM dbmail_keywords k JOIN > dbmail_messages m USING (message_idnr) JOIN dbmail_mailboxes b USING > (mailbox_idnr) WHERE b.mailbox_idnr = 1 ] > Feb 08 19:43:35 art dbmail-imapd[29230]: Debug:[db] > dbmodule.c,db_query(+154): last query took [0] seconds > Feb 08 19:43:35 art dbmail-imapd[29230]: Error:[mailbox] > dbmail-mailbox.c,dbmail_mailbox_open(+269): db failure retrieving keywords > Feb 08 19:43:35 art dbmail-imapd[29230]: Error:[mailbox] > dbmail-mailbox.c,dbmail_mailbox_new(+46): opening mailbox failed > > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- ________________________________________________________________ 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
