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? :)
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
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
