Date: Fri, 20 Oct 2000 17:27:04 -0400 From: "Troy Settle" <troy@psknet.com> To: "Julien Clauzel" <jclauzel@hotmail.com> Cc: <freebsd-isp@FreeBSD.ORG> Subject: RE: Moving mail to another server for 700 accounts Message-ID: <BFEGKDHLHDNOJEIHJDBAIEFLCAAA.troy@psknet.com> In-Reply-To: <F615SghWb25ZbfpOC4u00000584@hotmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Guessing, it sounds like you're probably using the UW-IMAP and POP3 daemons.
If this is the case, patching both of those to capture passwords is fairly
trivial. I did this last year to move ~5k mailboxes from FreeBSD to NT.
After a month, we only recovered about 90% of the passwords, but it was well
worth the effort. The passwords that we didn't recover were users who never
used their mail anyways.
I'd reccomend that you dump to a text file (mod 0600, owned by root), and
cruch this file on a nightly basis so it doesn't grow too large.
Now, just a bit of advice. I've done the FreeBSD -> NT migration for mail.
The NT mail server, which was twice the hardware, was /NOT/ able to keep up
with the load. I understand that the decision is probably not yours to make
(it was not mine to make either), but I would strongly reccomend that you
re-think the decision to move to NT (assuming that this is the 'other
platform' you're moving to). IMO, such a move is a great dis-service to
your customers.
--
Troy Settle
Pulaski Networks
540.994.4254
It's always a long day, 86400 doesn't fit into a short
> -----Original Message-----
> From: owner-freebsd-isp@FreeBSD.ORG
> [mailto:owner-freebsd-isp@FreeBSD.ORG]On Behalf Of Julien Clauzel
> Sent: Friday, October 20, 2000 8:22 AM
> To: wer@cstone.net
> Cc: jfmays@launchpad.win.net; davew@sai.co.za; freebsd-isp@FreeBSD.ORG;
> sendmail-questions@sendmail.org
> Subject: Re: Moving mail to another server for 700 accounts
>
>
>
> Thx Bill for you're feedback. We are moving the mail to an other
> platform...
> so we cannont move the passwd file. I was thinking of patching the pop3
> daemon if we have source code (to dump login,passwds) but then we
> miss impa4
> users, so we have to patch that too. But the trouble is i think that most
> imap4 clients encrypts passwds... oki, i understant we can
> tcpdump but then
> how to revert imap4 encrypted passwds ?
>
> Julien
>
> >From: Bill Reid <wer@cstone.net>
> >To: Julien Clauzel <jclauzel@hotmail.com>
> >CC: jfmays@launchpad.win.net, davew@sai.co.za,
> freebsd-isp@FreeBSD.ORG,
> >sendmail-questions@sendmail.org
> >Subject: Re: Moving mail to another server for 700 accounts
> >Date: Fri, 20 Oct 2000 05:07:18 -0400
> >MIME-Version: 1.0
> >Received: from [209.145.64.80] by hotmail.com (3.2) with ESMTP id
> >MHotMailBBB95286006BD82197A1D191405005980; Fri Oct 20 01:51:19 2000
> >Received: from cstone.net (bilmax.cho.cstone.net [209.145.79.244])by
> >mail.cstone.net (8.11.1/8.11.0) with ESMTP id e9K8ofx12976;Fri,
> 20 Oct 2000
> >04:50:41 -0400 (EDT)
> >From wer@cstone.net Fri Oct 20 01:52:16 2000
> >Message-ID: <39F00B46.3B533E3E@cstone.net>
> >X-Mailer: Mozilla 4.75 [en] (Win98; U)
> >X-Accept-Language: en
> >References: <F250kP3t9vXkVYeRvB100019fe3@hotmail.com>
> >
> >Probably the best thing to do is sniff them. If it is a non
> unix machine
> >you
> >may not be able to use the encrypted passwords. I don't know all of the
> >types
> >but they may not match up. It should be pretty obvious if you
> look at the
> >size
> >of the string. If it is the same type encryption then just move the
> >encrypted
> >string similar to how you moved the mail.
> >
> >We just went the other way (from post.office on a Digital Unix System to
> >sendmail on FreeBSD) and installed a sniffer. sniff is what we
> used. As
> >for
> >the mail... it was very similar to what you did using formail
> and procmail.
> >Still there was the need to strip a ^M off of every line between formail
> >and
> >procmail because netscape was confusing the headers.. My buddy
> Joe said it
> >was
> >formail inserting the ^M. I still have not figured out why.
> >
> >cat /etc/master.passwd will show you the encrypted strings. you
> can | cut
> >-d":"
> >-f1,2 to get the usernames:encrypted strings.
> >
> >cat /etc/master.passwd | ut -d":" -f1,2
> >
> >What type of system is the mail being moved too?
> >
> >11,000 moved gave us a little trouble. :)
> >aliases, listserv,forwards,blah blah.
> >post.office is not a real mail server.
> >
> >later,
> >-=Bill
> >
> >Julien Clauzel wrote:
> >
> > > Hi,
> > >
> > > What about the users password how do you manage to export
> them is there
> >a
> > > way to do that easyly?
> > >
> > > Julien
> > >
> > > >From: "Joe Mays" <jfmays@launchpad.win.net>
> > > >To: "Dave Wilson" <davew@sai.co.za>, <freebsd-isp@FreeBSD.ORG>
> > > >CC: <sendmail-questions@sendmail.org>
> > > >Subject: Re: Moving mail to another server for 700 accounts
> > > >Date: Thu, 19 Oct 2000 14:20:25 -0400
> > > >MIME-Version: 1.0
> > > >Received: from [216.136.204.125] by hotmail.com (3.2) with ESMTP id
> > > >MHotMailBBB886CD000F40042A15D888CC7D55A00; Thu Oct 19 11:22:15 2000
> > > >Received: from hub.freebsd.org (hub.FreeBSD.org [216.136.204.18])by
> > > >mx1.FreeBSD.org (Postfix) with ESMTPid 191FC6E2869; Thu, 19 Oct 2000
> > > >11:21:50 -0700 (PDT)
> > > >Received: by hub.freebsd.org (Postfix, from userid 538)id
> DE07C37B4E5;
> >Thu,
> > > >19 Oct 2000 11:21:48 -0700 (PDT)
> > > >Received: from localhost (localhost [127.0.0.1])by hub.freebsd.org
> > > >(Postfix) with SMTPid BE91A2E80CA; Thu, 19 Oct 2000 11:21:48 -0700
> >(PDT)
> > > >Received: by hub.freebsd.org (bulk_mailer v1.12); Thu, 19 Oct 2000
> >11:21:48
> > > >-0700
> > > >Received: from ns1.win.net (ns1.win.net [216.24.27.3])by
> >hub.freebsd.org
> > > >(Postfix) with ESMTP id A187637B4CFfor
> <freebsd-isp@FreeBSD.ORG>; Thu,
> >19
> > > >Oct 2000 11:21:45 -0700 (PDT)
> > > >Received: from ENGINEERING01 (216-24-1-215.win.net [216.24.1.215])by
> > > >ns1.win.net (8.11.0/8.11.0) with SMTP id e9JILM118807;Thu,
> 19 Oct 2000
> > > >14:21:23 -0400 (EDT)
> > > >From owner-freebsd-isp@FreeBSD.ORG Thu Oct 19 11:39:23 2000
> > > >Delivered-To: freebsd-isp@freebsd.org
> > > >Message-ID: <001501c039f9$410aa330$d70118d8@ENGINEERING01>
> > > >References: <022d01c039f9$855d5460$112821c4@sai.co.za>
> > > >X-Priority: 3
> > > >X-MSMail-Priority: Normal
> > > >X-Mailer: Microsoft Outlook Express 5.50.4133.2400
> > > >X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
> > > >Sender: owner-freebsd-isp@FreeBSD.ORG
> > > >X-Loop: FreeBSD.org
> > > >Precedence: bulk
> > > >
> > > >Not sure if I've missed something, but it looks to me like
> all you need
> >is
> > > >
> > > >#/bin/sh
> > > >for USERNAME in `cat listofusernames.txt`
> > > > do
> > > > formail -b -Y -f -s /usr/sbin/sendmail -oi
> >$USERNAME@new.mail.server
> > > ><
> > > >/var/mail/$USERNAME
> > > > done
> > > >exit
> > > >
> > > >where "listofusernames.txt" is a text file containing a list
> of all the
> > > >usernames to be moved.
> > > >
> > > >
> > > >
> > > >----- Original Message -----
> > > >From: "Dave Wilson" <davew@sai.co.za>
> > > >To: <freebsd-isp@FreeBSD.ORG>
> > > >Cc: <sendmail-questions@sendmail.org>
> > > >Sent: Thursday, October 19, 2000 2:22 PM
> > > >Subject: Moving mail to another server for 700 accounts
> > > >
> > > >
> > > > > Hi guys, howzit going ?
> > > > >
> > > > > I have been given the wonderful *not* job of moving 700 mail
> >accounts to
> > > >a
> > > > > non-unix mail server.
> > > > > I have a little script that Phillip(FreeBSD-ISP list *thanks*)
> >helped me
> > > >out
> > > > > with that allows me to move each mail accounts data to a
> specified
> >SMTP
> > > > > server, the only problem is that I can only do it one
> account at a
> >time
> > > > > ....which would be a bit tiresome with 700 mail accounts
> > > > > This is the script Phillip gave me which works perfectly for one
> >user at
> > > >a
> > > > > time:
> > > > >
> > > > > formail -b -Y -f -s /usr/sbin/sendmail -oi
> $USERNAME@new.mail.server
> ><
> > > > > /var/mail/$USERNAME
> > > > >
> > > > > So what I would type is:
> > > > > formail -b -Y -f -s /usr/sbin/sendmail -oi
> user1@new.mail.server <
> > > > > /var/mail/user1
> > > > >
> > > > > The problem is that I would have to do this for each account ie.
> >user1,
> > > > > user2, user3 etc. all the way up to user700.
> > > > >
> > > > > Does anyone know how I can get all 700 accounts across in one go ?
> > > > > I have tried various bash variables etc. to get this working but
> >don't
> > > >seem
> > > > > to have any luck
> > > > > Don't laugh, but this is one way I tried ;-) :
> > > > >
> > > > > # awk -F: '$3 > 100 { print $1}' /etc/passwd > /etc/mail/everyone
> > > >#Gets
> > > > > all users listed on /etc/mail/everyone
> > > > > # ALLUSERS=`cat /etc/mail/everyone`
> > > > > #Sets the variable for all my users
> > > > > # formail -b -Y -f -s /usr/sbin/sendmail -oi
> >$ALLUSERS@new.mail.server
> > > ><
> > > > > /var/mail/$ALLUSERS #Tries to mail the whole lot off.
> > > > >
> > > > > Doing the above led to sendmail or bash or something
> complaing about
> >an
> > > > > "ambiguous redirect" ??
> > > > >
> > > > > I donno, I'm really lost and don't feel like spending 5
> hours moving
> > > >each
> > > > > accounts' mail separately, please help if you can.... I would
> >appreciate
> > > >it
> > > > > a hell of a lot.
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > > >
> > > > > Regards
> > > > > Dave Wilson
> > > > > The S.A. Internet
> > > > > (033) 3456777
> > > > > 0825496159
> > > > > http://www.sai.co.za
> > > > > "Who is "General Failure", and what is he doing reading
> my hard disk
> >?"
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org
> > > > > with "unsubscribe freebsd-isp" in the body of the message
> > > > >
> > > >
> > > >
> > > >
> > > >To Unsubscribe: send mail to majordomo@FreeBSD.org
> > > >with "unsubscribe freebsd-isp" in the body of the message
> > >
> > >
> >_________________________________________________________________________
> > > Get Your Private, Free E-mail from MSN Hotmail at
> >http://www.hotmail.com.
> > >
> > > Share information about yourself, create your own public profile at
> > > http://profiles.msn.com.
> > >
> > > To Unsubscribe: send mail to majordomo@FreeBSD.org
> > > with "unsubscribe freebsd-isp" in the body of the message
> >
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
>
>
> To Unsubscribe: send mail to majordomo@FreeBSD.org
> with "unsubscribe freebsd-isp" in the body of the message
>
>
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-isp" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?BFEGKDHLHDNOJEIHJDBAIEFLCAAA.troy>