[Vmail-discuss] maildir conversion / courier
Donovan Craig
donovan at snapfrozen.com
Tue, 26 Aug 2003 09:21:39 +1000
Hi,
I finally got courier working !
I now have to convert all the mailbox files to maildir. I have looked at using the mb2md tool but it doesn't seem to like the format of the default mailbox files we use.
Does anyone happen to have a script to do this conversion ? Or any ideas on how this can be done ?
BTW: Here's the winning config file for courier-imap 2.0.0 with vmail-sql. Note that I had to create a new crypted password field using mysql's encrypt() function.
MYSQL_SELECT_CLAUSE SELECT popbox.local_part, popbox.password_hash2, popbox.clearpw, domain.gid, domain.uid, CONCAT(domain.path,'/', popbox.mbox_name,'_maildir'), CONCAT(domain.path, '/', popbox.mbox_name,'_maildir'), popbox.imap_quota, '' FROM popbox, domain WHERE popbox.local_part = '$(local_part)' AND popbox.domain_name = '$(domain)' AND popbox.domain_name = domain.domain_name
It's worth mentioning that this config file reads all white space and comments after the MYSQL_SELECT_CLAUSE.
Thank's to all who helped in getting this working.
Regards,
Donovan
-----------------------------------------
Snapfrozen Solutions
http://www.snapfrozen.com
-----------------------------------------