Lindsay Haisley has written a nice python script to do this. Bear in mind
that he has a slightly custom setup with an added 'domain' field, so you may
have to tweak it for your schema. It's at
http://www.fmp.com/downloads/vmail.tar.gz.
Carey
-----Original Message-----
From: cour...@lists.sourceforge.net
[mailto:cour...@lists.sourceforge.net]On Behalf Of David Oxley
Sent: Wednesday, July 24, 2002 6:09 AM
To: 'cour...@lists.sourceforge.net'
Subject: [courier-users] Adding mail accounts into MySQL DB
Is there a script to add Email accounts into the MySQL Database and create
the necessary directories? If not can anyone supply some sample SQL to do it
or at the very least give an explanation of the various fields (I think I
get the idea of most of them except uid and gid, also is quota in bytes and
should id be 'Na...@host.com' and id just 'Name' and how do I create the
crypt password):
id, crypt, clear, name, uid, gid,
home, maildir, quota
Thanks
Dave.