I would suggest getting a list of the users and thier
clear text passwords. Then write a script to load it
up into the vpopmail mysql table. Leave the pw_dir field
empty. vpopmail will auto create the user dir and auto
update the mysql table. These features were built so
mysql admins could load up the database and vpopmail
would handle the user files.
If you have the clear text passwords you can use the
unix crypt() function call to create the encrypted
text, which you can place in the users pw_passwd field.
Make sure none of the vpopmail sql table values is NULL.
Instead of NULL insert a "", empty string.
You can build a clustered solution if you plan on growing
above 130,000 acounts or if you want to load balence.
In that case read up on mysql replication then turn
on the mysql replication feature in 5.0
--enable-mysql-replication=y
You can use djbdns tinydns server to radomize load across
a set of clustered machines.
Ken Jones
inter7.com
On Mon, 2001-09-17 at 11:30, Angus D Madden wrote:
> I thought I'd answer my own questions:
>
> On Sun, Sep 16, 2001 at 05:33:38PM +0700, Angus D Madden wrote:
> > I am currently migrating about 130,000 accounts from outsourced servers
> > to our own colo. I am going to use qmail, vpopmail, courier-imap and a
> > webmail client to be determined (squirellmail or sqwebmail).
> >
> > I have been rtfming but have not found the answer yet. Is there a
> > script to rebuild vpasswd.cdb from vpasswd? Is this too many records
> > for cdb to handle? Should I authenticate off a database?
> >
>
> Yes, too many records.
> Yes, use authmysql.
> Yes, cross fingers and hope server doesn't croak.
>
> BTW, if anyone uses debian and wants to install vpopmail and
> courier-imap from debs, save yourself the time and forget about it. The
> versions currently in unstable are not compatible. Compile from source.
>
> g
>
