Hi, I needed to migrate to an another machine fast and I decided to change my IMAP server from bincimap to dbmail. I am having a couple of problems, and I was hoping some of you can help me.
Platform: dbmail 2.1.1 on gentoo 2.6.10-co-0.6.2 (gentoo on colinux). MySQL 4.1.12a-nt on Windows XP SP2 i) I used mailbox2dbmail to move all my emails to the database, unfortunately I named the mailboxes (mbox from now on) wrong. I forgot to add 'INBOX/' as a prefix... wrong mbox name : work/foo intended mbox name : INBOX/work/foo Is there any way I can fix this using SQL queries? Guessing from the ER-model page, http://dbmail.org/dokuwiki/doku.php?id=er-model . I thought the following would do the trick but I am not sure... UPDATE dbmail_mailboxes SET name = (CONCAT("INBOX",name)) WHERE NOT ( name LIKE 'INBOX%'); ii) Even if I was able to fix i) I still need to merge duplicate mboxes name since I already have intended working mailboxes. Ex. Present mboxes: INBOX INBOX/work/foo INBOX/work/foo/boo /work/foo If I used the sql statement on i), i would have the following mboxes: INBOX INBOX/work/foo INBOX/work/foo/boo INBOX/work/foo # 2 duplicate "INBOX/work/foo" mboxes. I believe dbmail schema allows this. What would be the ideal way to merge these 2 duplicates? Or perhaps, there are other elegent ways to fix both i) & ii) at once? I would like to avoid using IMAP clients, since there are quite a lot of email with large sizes. Anyhow, thunderbird and outlook does not show the wrongly named mboxes. iii) I created a valid sub-mailboxes (INBOX/*) via Outlook and there is a case where some are accessible via IMAP clients but some are not. Ex. INBOX/ml/fooml <- accessible INBOX/work <- accessible INBOX/work/group/a <- not accessible INBOX/work/group/b <- not accessible What is the problem here and how do I fix it? Currently some emails are being dbmail-smtp'ed to INBOX/work/group/{a,b} but I cannot read them! :( iv) Last problems are symptoms I am experiencing /w my IMAP client, thunderbird but probably not dbmail problem. In case, it is a combination problem, I will state them here. - In folder view mode, when I click on some messages, some messages turn up blank. - In folder view mode, when I click on some messages, wrong messages turn up. The wrong messages are usually 1-3 rows above the original message. I hope you guys can help me! Seiji T.
