[horde] horde-db-migrate error

[LALOT Dominique]

Hi Jan,

I did that, but our database is there for years. And in some parts of horde,
hooks are not working. I posted a mail a long time ago about syncml.
Somebody configured syncml with a first capital as his login, it works and I
had no proper way to avoid that.
Some years later, trying to update the database, I lost hours because of
some data coming from syncml sync

Dom

2011/4/11 Jan Schneider <jan at horde.org>

>
> Zitat von Vilius ?umskas <vilius at lnk.lt>:
>
>
>  Sveiki,
>>
>> Monday, April 11, 2011, 4:12:01 PM, you wrote:
>>
>>  Thanks to ronan from another thread. That problem found a solution:
>>>
>>
>> mysql>> update kronolith_events set event_creator_id=lower(event_
>>
>>> creator_id);
>>>
>>
>>  some users logged in a long time ago, and ldap is case insensitive. So
>>> some
>>> records were added using a capital and generating a duplicate key error.
>>> Don't know what could be the fix is uids are sensitive..
>>>
>>
>> I  saw  similar  behaviour with IMAP auth backend, which in my case is
>> also  case  insensitive. Did not had trouble upgrading, but saw a fair
>> amount  of "duplicate" uids in pref table. There were "duplicates" not
>> only
>> by   case,  but  also such  usernames  as  "user1 at example.com"  and
>> "user1 @example.com" (note space after username).
>>
>
> User names are case and whitespace sensitive in Horde. If your
> authentication backend is not, you have to normalize user names with user
> name hooks.
>
> Jan.
>
> --
> Do you need professional PHP or Horde consulting?
> http://horde.org/consulting/
>
>
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>



-- 
Dominique LALOT
Ingénieur Systèmes et Réseaux
http://annuaire.univmed.fr/showuser.php?uid=lalot