Thanks Jake. I'm hoping to make this process as automated as possible...

What I'm wondering, is does the database need to be converted somehow to work properly on the new server since the old server is running mysql 4 and the new one is mysql 5? Also, in theory, if I recompiled vpopmail to include the same features as the old server is running, and then modified the sql dump file to replace the domain paths from the old server with the correct ones on the new server (/home/vpopmail/domains), and then rsync'd the mail over and kept it in the same type of structure as it was on the old server...shouldn't that work?

When I first tried doing that, I had copied over all of the config files, hadn't copied all of the data from the domain folders, and hadn't done any compiling beyond enabling many domains. Like I mentioned before, I was able to get vuserinfo to recognize the accounts with the quotas, username, password, encrypted password, etc...but the major problem was that vqadmin would show the domain, but wouldn't recognize that there were accounts associated with it.

I guess I can kind of break this project up into to parts...my main concern is getting everything moved to the new server, and then once thats done I'd like to standardize things so that in the future if I want to migrate I can just use the backup/restore scripts. I'm not sure if this is better to try to tackle all at once, or two break up into multiple tasks. It just seems like theres gotta be a way that this can be done without a ton of scripting and manual entry - especially considering i have everything in the database, I just need to make sure that the domains/accounts are mapped to the correct location in the file system.

Another question...theres been alot of talk on here about enabling "many domains" vs. disabling it. As far as I know, in the current version it is disabled, so when you create a new domain it creates a table for that domain, opposed to putting them all under the vpopmail table. Any idea how this will be setup in the future? Our existing system has it enabled, and we have 300+ domains with alot of users, so naturally it seems easier to try to keep things the same on our migration, but that also means recompiling vpopmail every time we want to update, so are we better off trying to convert our "many domains" database to the current format?

Thanks in advance,
Casey

Smile Global Technical Support
Submit or check trouble tickets http://billing.smileglobal.com
www.smileglobal.com <http://www.smileglobal.com>

On 9/26/11 3:04 PM, Jake vickers wrote:
On 09/26/2011 05:45 PM, Casey wrote:
I'm trying to migrate all of the domains, user accounts, and mail from an old Sun Ultra2 running Solaris 9 with vpopmail 5.4.10 and mysql Ver. 14.7 distribution 4.1.21 to a newer server running CentOS 5 with Qmail Toaster.

There are a couple of issues I'm running into - the current server is setup with vpopmail install on its own set of disk arrays (/u1), and then as that drive ran out of room, /u2 and /u3 were added, domains were moved to those partitions and symlinks created to point to /u1

The other problem is that vpopmail is compiled with "many domains", "big user dirs", and "learn passwords". The version of vpopmail on the new server (5.4.17) is compiled without those features, which can easily be resolved by recompiling, which I've done but I really want to standardize things so that I don't have to recompile every time I want to update.

This sounds like a rather manual process, unless someone else has done something similar and can offer insight/scripts. From what I'm thinking (shooting from the hip): You may try a dump of the database (or vuserinfo scripted) to get the usernames (emails) and passwords. This in a text file can be scripted to run in a loop to create the users on the new server. As far as the emails - rsync them over to the new server. Assuming you were using courier, the dir structure should remain the same.


--------------------------------------------------------------------------------- Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations.
     If you need professional help with your setup, contact them today!
--------------------------------------------------------------------------------- Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com


Reply via email to