From: Alan J. Cooper <alan@ed...> - 2003-10-27 14:09:43
I am about to migrate around 2,500 users from a Horde/IMP webmail
system over to Squirrelmail-1.4.2.
I am planning on doing some SQL selects and some perl scripting to get the
user prefs and address books out of the mySQL database that Horde is
running from and plant them into the Squirrelmail .sis, .pref etc files.
Before I start on this and gain a few grey hairs, has anyone done this
before or is there a project for this anywhere?
Any advice gratefully received.
Alan J. Cooper
t: 0845 1199 900
f: 0845 1199 901
From: Tomas Kuliavas <tokul@us...> - 2003-10-28 16:51:37
> I am about to migrate around 2,500 users from a Horde/IMP webmail
> system over to Squirrelmail-1.4.2.
> I am planning on doing some SQL selects and some perl scripting to get
> the user prefs and address books out of the mySQL database that Horde is
> running from and plant them into the Squirrelmail .sis, .pref etc files.
> Before I start on this and gain a few grey hairs, has anyone done this
> before or is there a project for this anywhere?
> Any advice gratefully received.
Don't loose your hair. your user data can stay in database.
Compare IMP and SquirrelMail database formats and think about using
database instead of 5000+ files.
If you still want to use file based pref:
1. address books (username.abook) is csv files with '|' symbol used as
field separator. Original SM supports five fields.
2. signatures (username.sig - default id, username.si# - other id) are
plain text files
3. you might also need user name and email address, it is stored in
(for default ID)
(for special ID number #)
Not sure what other preferences can be found in IMP. if you have some
filtering - these 2500 users will kill your servers with filters plugin.
If you have some other features - enable these features in SquirrelMail
test install and see how they are reflected (what variables are added) in
Also you might need to enable directory hashing (4. General options -> 4.
Directory Hash Level : 0). Make it bigger that 0. Directories that contain
big number of files are harder to access.
- A perlscript to convert neomail Addressbook and preferance to
- Perl Scripts to migrate sqwebmail address book and some preferences to