Re: [SM-USERS] Migrating users from openwebmail to squirrelmail

[Christopher J. H. <ch...@ch...>]

 

> >> > One unfortunately rather crucial step I overlooked in creating my 
> >> > new mail server with a nifty new webmail interface is the fact that 
> >> > I'd need to migrate my users' messages from one to the other.
> >>
> >> > Does anyone know of an automated way (or even a not-so-automated 
> >> > way) to move users' saved messages (separate folders, named all 
> >> > sorts of
> >> > things) from OpenWebMail to SquirrelMail?
> >>
> >> What's the message storage used by OpenWebMail?  Does it interface
> > directly with > the filesystem, via POP3, via IMAP, via something else?
> >>
> >> If it's IMAP, there's nothing needed other than to point SquirrelMail 
> >> at
> > the
> >> IMAP server.
> >>
> >> If it's IMAP, but you want to migrate to another, separate, IMAP 
> >> server,
> > > have a > look at the imapsync program.
> >>
> >> If it's POP3, you can migrate the Inbox using the mail_fetch plugin.
> >> Possibly even the other folders.  Depending on the POP3 server used, 
> >> you
> > can
> >> probably even access it via IMAP (Courier and Cyrus both allow this), 
> >> then
> > see
> >> above.
> >>
> >> If it's direct filesystem access to Maildir or mbox, you'll have lots 
> >> of trouble.  :)
> >
> > Hi Freddie... Unfortunately it looks like OpenWebMail uses its own 
> > method of storage, interacting directly with the filesystem.  I'm 
> > migrating from sendmail (POP3)/OpenWebMail to a new box that has 
> > postfix/dovecot/squirrelmail.
> >
> > I'm thinking I need to either write a script to handle it or find one 
> > already written.  It looks like the mail's stored in the same format 
> > as squirrelmail's mail, but when I moved a test mailbox over, it 
> > didn't appear automatically... I looked in the Folders section and it 
> > had it available as a subscription.  So instead of clicking the 
> > "subscribe" button I tried just adding the line to the .subscriptions 
> > file in the user's directory and reloaded the web page.  It caused 
> > this error when I clicked the new folder
> > ("Sent2") from the left hand side nav bar:
> >
> > ERROR: Could not complete request.
> > Query: SELECT "Sent2"
> > Reason Given: Internal error occured. Error report written to server
log.
> > [2006-06-23 19:21:20]
> 
> 
> "Error report written to server log"
> 
> Check your server logs.
> 
> --
> Tomas

You are correct, of course, and I should heed my own adage of "Never Drink
and Debug."  The log indicated a permissions problem.

The question remains, does anyone have a script for migrating mail folders
from OpenWebMail to SquirrelMail?

chris, who isn't drinking (yet) today.