[imp] Move horde_prefs from LDAP to Mylsq

[Thierry Voyat]

I want to move all the prefs stored in my LDAP directory to a mysql
database.

I have two problems in one. I can't stay using LDAP because each
connections lasts more than ten seconds and produce a heavy load on my
LDAP server.
So i need to move to mysql but i don't how to proceed.

Actually, i have more than 110.000 entries in my directory for 55.000
differents users.
13.798 users have an hordeperson entry (real Horde/imp user)


Since i changed the directory from netscape 4 to sun directory 5.2, each
login from the imp application (not true from horde login) take more
than 10 seconds.

It seems like the writing of the prefs to the directory cause a very
high load (one cpu jump to 100% use for this time).

The process of writing preferences is also strange.
The are two steps for the writing. First only the HordePrefs is written
and then, immediately after a writing  HordePrefs and impPrefs.
I don't why the hordePrefs is written twice (the same data).




Here is the log forthe LDAP connection

[10/Mar/2006:14:16:20 +0100] conn=332198 op=-1 msgId=-1 - fd=150
slot=150 LDAP connection from XXX.XXX.XXX.XXX to XXX.XXX.XXX.XXX
[10/Mar/2006:14:16:20 +0100] conn=332198 op=0 msgId=1 - BIND
dn="XXXXXXXXXX,ou=ac-amiens,ou=education,o=gouv,c=fr" method=128 version=3
[10/Mar/2006:14:16:20 +0100] conn=332198 op=0 msgId=1 - RESULT err=0
tag=97 nentries=0 etime=0
dn="XXXXXXXXXX,ou=ac-amiens,ou=education,o=gouv,c=fr"
[10/Mar/2006:14:16:20 +0100] conn=332198 op=1 msgId=2 - SRCH
base="o=gouv,c=fr" scope=2 filter="(uid=XXXXXXXXX)" attrs="dn"
[10/Mar/2006:14:16:20 +0100] conn=332198 op=1 msgId=2 - RESULT err=0
tag=101 nentries=1 etime=0
[10/Mar/2006:14:16:20 +0100] conn=332198 op=2 msgId=3 - SRCH
base="o=gouv,c=fr" scope=2 filter="(uid=XXXXXXXXX)" attrs="objectClass"
[10/Mar/2006:14:16:20 +0100] conn=332198 op=2 msgId=3 - RESULT err=0
tag=101 nentries=1 etime=0
[10/Mar/2006:14:16:20 +0100] conn=332198 op=3 msgId=4 - MOD
dn="uid=XXXXXXXXX,ou=ac-amiens,ou=education,o=gouv,c=fr"
[10/Mar/2006:14:16:30 +0100] conn=332198 op=3 msgId=4 - RESULT err=0
tag=103 nentries=0 etime=10 csn=44117c2f000000020000
[10/Mar/2006:14:16:30 +0100] conn=332198 op=4 msgId=5 - UNBIND
[10/Mar/2006:14:16:30 +0100] conn=332198 op=4 msgId=-1 - closing - U1
[10/Mar/2006:14:16:30 +0100] conn=332198 op=-1 msgId=-1 - closed.


Thanks

-- 
Thierry Voyat
System Administrator
Education Nationale - Académie d'Amiens