Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 13th February 2009, 12:56
rbartz rbartz is offline
Member
 
Join Date: Apr 2006
Posts: 80
Thanks: 9
Thanked 6 Times in 5 Posts
Default Migration to new server and mbox to Maildir

I am looking forward this weekend to moving about 60 domains from one old ispconfig server to a new one. The old one (Fedora Core 3) uses mbox and the now server (Core 10) will use Dovecot with Maildir...

So I will be converting about 300 mailboxes. Is the any way I can extract a list of users with "groups" from the ispconfig database?

If I can get that info, as in user = "admin", group = "web1" then I can create the maildirs in all the right places (/var/www/web1/user/admin/), set permissions, and then convert the mail from the /var/spool/mail directory with perfect_maildir just before the move, and just maybe have a working mail system after the migration.

Thanks in advance...

Richard
Reply With Quote
Sponsored Links
  #2  
Old 14th February 2009, 13:44
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Are you using username prefixes in ISPConfig (like web1_)? If so, the users have the group in their usernames.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 14th February 2009, 14:28
rbartz rbartz is offline
Member
 
Join Date: Apr 2006
Posts: 80
Thanks: 9
Thanked 6 Times in 5 Posts
Default

Ah yes, had we had the wisdom to use web#_ prefixes in the first place, this would have been simple. However, way back then we were moving sites from an existing NON-ispConfig server and there were already dozens of user names and passwords and domains... so we took the EASY way out then, and now we pay.

Hint for those who want to disable the default way of creating users. Don't... there are good reasons not to.

Anyway, I was able to retrieve a group/user/home directory list via webmin from the user and groups table page therein, and with some manipulation created all the necessary Maildir directories on the OLD server.

I will shut down the mail and convert all the mboxes and then do a rsync of the www directory tomorrow, which should put all the old mail in place on the new server so that when we change the DNS and nameservers to point to it, things will start and run right.

I am looking forward to version 3 where, hopefully, we will be able to move a client and site with mail users and ftp logins and everything else from one server directly to another with a click and approve. That would be neat.

If anyone has taken time to put together the sql to pull users@domain or users and webs from the ispConfig database tables, it would be useful if for nothing else than creating server wide mail lists and so on.

Thanks Falko,

Richard
Reply With Quote
  #4  
Old 15th February 2009, 16:36
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
 
Default

Quote:
Originally Posted by rbartz View Post
Is the any way I can extract a list of users with "groups" from the ispconfig database?[/B]
Try this SQL query:

Code:
SELECT parent_doc_id FROM isp_dep WHERE child_doc_id = '$doc_id' AND child_doctype_id = 1014
($doc_id is the doc_id of the user. The group would be "web" + the parent_doc_id.)
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing from mbox to maildir after installing ISPConfig Rustin Installation/Configuration 21 12th October 2010 14:57
How to set Maildir instead of mbox patrol HOWTO-Related Questions 1 29th October 2006 11:50
How to move from Maildir to mbox? dedibox Installation/Configuration 3 1st September 2006 16:56
Trouble with Mail Server Jcorrea920 General 5 21st February 2006 20:42
Convert mbox to Maildir? tommyboy Server Operation 1 19th April 2005 16:43


All times are GMT +2. The time now is 01:36.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.