----- Original Message -----
From: "Jake Vickers" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, April 03, 2007 2:07 PM
Subject: Re: [qmailtoaster] migration from qmailrocks to qmailtoaster
[EMAIL PROTECTED] wrote:
Hello, I am doing a migration from an old Mandriva 2005 and qmailrocks
installation WITHOUT the use of MYSQL but with Vpopmail.
My new machine is actually a QMT-iso version 1.0.
I usually just transferred the mails in the old Maildir to the same place
into the new machines Maildir, I understand that this wont work with qmt
and mysql.
Please advice me how to do this.
You can create the users in the QMT version, and then once they're created
copy the emails to the directories. That's the easiest way to do it.
You can also uses the vconvert function for qmail instead of manually adding
them (if you have a large group of users or encrypted passwords importing is
much easier). I've done it a few times from QMR and Shupp's installations
and here are the basics. I wish I was at work to look at my notes, but this
should be all you need. I have some scripts i wrote which zip and rsync to
a new server and such, but they are overkill for only a couple of domains.
I'm not sure I've seen anyone else post correct info on using vconvert
elsewhere so I'll share because I know this works (10 minutes to write
....):
###################################
#zip up your old files and move them to the new server... gzip, zip, bzip2
whatever flavor you like
#i unzip the vpopmail directory from the old server and put it where it
goes.
# I unzip and untar the archive like this:
tar -xzvf domain.net.vpopmail.tar.gz
# change to the directory where it goes (move the files here if you unzipped
it elsewhere):
cd /home/vpopmail/domains/
#IMPORTANT>>> THE PATH MUST BE CORRECT OR DELIVERY WILL FAIL
#you should edit the .vpasswd file to correct the paths to the mailboxes or
it won't work because mysql will have an incorrect location for the
toaster's mail files:
# use perl, sed or gsub to fix it; i like perl:
#syntax for single words
perl -pi -e's/oldinfo/newinfo/' file-to-work.on
#you have to use a "\"before the directory slashes so a path looks like
this:
perl -pi -e's/\/oldpath\/goes\/here/\/newpath\/goes\/here/' .vpasswd
#add them to mysql using the built-in converter (reads the vpasswd files and
imports it)
/var/bin/vconvert -c -m domain1.com
#(you can list more if you want just by using a space and then another
domain)
#get your vpopmail user password for the next step:
cat /home/vpopmail/etc/vpopmail.mysql | awk -F\| '{print $4}'
#export the mysql database and grep for the domain you added to see if it
imported (you'll need to know your vpopmail pass):
#(don't worry this just exports... drop is how you get rid of a database)
mysqldump -uvpopmail vpopmail -p | grep domain
#note - there seems to be an issue with the usercount after importing the
users and i haven't looked into it to fix it (other than manually editing
the table value)
#note as a separate reminder (not related to converting) - you may want to
compile with roaming users because it's not built by default by the toaster.
##################################
George Sweetnam
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
