[horde] Rampage error

[Ralph Ballier]

  Zitat von Michael J Rubinsky <mrubinsk at horde.org>:

> Quoting Ralph Ballier <ballier at mail.schule.de>:
>
>> Zitat von Ralph Ballier <ballier at mail.schule.de>:
>>
>>> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>>>
>>>> Quoting Ralph Ballier <ballier at mail.schule.de>:
>>>>
>>>>> Hello,
>>>>>
>>>>> an user had sent to me the followed error message:
>>>>>
>>>>> exception 'Horde_Db_Exception' with message 'QUERY FAILED: Duplicate
>>>>> entry
>>>>> 'web' for key 'rampage_users_user_name' INSERT INTO `rampage_users`
>>>>> (user_name) VALUES ('web')' in
>>>>> /usr/lib/php/Horde/Db/Adapter/Mysqli.php:317
>>>>> Stack trace: #0 /usr/lib/php/Horde/Db/Adapter/Mysqli.php(342):
>>>>> Horde_Db_Adapter_Mysqli->execute('INSERT INTO `ra...', NULL, NULL) #1
>>>>> /usr/lib/php/Horde/Db/Adapter/SplitRead.php(355):
>>>>> Horde_Db_Adapter_Mysqli->insert('INSERT INTO `ra...', NULL, NULL,
>>>>> NULL,
>>>>> NULL, NULL) #2 /www/htdocs/horde2/content/lib/Users/Manager.php(75):
>>>>> Horde_Db_Adapter_SplitRead->insert('INSERT INTO `ra...') #3
>>>>> /www/htdocs/horde2/trean/lib/Bookmarks.php(44):
>>>>> Content_Users_Manager->ensureUsers('web') #4 [internal function]:
>>>>> Trean_Bookmarks->__construct(Object(Content_Users_Manager)) #5
>>>>> /usr/lib/php/Horde/Injector/Binder/Implementation.php(88):
>>>>> ReflectionClass->newInstanceArgs(Array) #6
>>>>> /usr/lib/php/Horde/Injector/Binder/Implementation.php(70):
>>>>>
>>>>> What does it mean? Shall I delete the entry "web" in the table
>>>>> "rampage_users"?
>>>>
>>>> My guess is that the authentication backend is not case sensitive and
>>>> this user is logging in using a different capitalization in the
>>
>> username.
>>>> Do not delete the entry, since this will disassociate all of the
user's
>>>> tags from the account.
>>>>
>>>> --
>>>> mike
>>>> The Horde Project
>>>> http://www.horde.org
>>
>>
https://www.facebook.com/hordeprojecthttps://www.twitter.com/hordeproject
>>> I had try this with my own account. I logged me in with "Ba" instead of
>>> "ba" and got the same error message. But this was unique. After this I
>>> couldn't repeat this behavior.
>>>
>>> Perhaps it was an unique event by the user too.
>>>
>>> Ralph
>>> --
>>> Horde mailing list
>>> Frequently Asked Questions: http://horde.org/faq/To unsubscribe, mail:
>>> horde-unsubscribe at lists.horde.org
>>
>> I have just notice, that I have now a new addressbook. It has the same
>> content as my personal addressbook, but owner is "Ba" (NOT "ba") and I
>> have
>> no administrative rights. I can't delete it. If I logged in as "Ba", it
>> is
>> also not possible to delete this addressbook.
>>
>> Authentication occurs over LDAP, which is case insensitiv (uid=ba is the
>> same like uid=Ba). Horde seems to be case sensitiv. This produces
>> problems.
>
> No, it's not Horde that's case sensitive, it's your preference backend
> that is. You should use create a authusername hook. See config/hooks.php
> for details on this. IIRC, there is even a example of just this case.
>  

  Thank your for your hints. There was an example for this in
hooks.php.dist. I think it works now and all uid are in lowercase.

Now is my personal addressbook empty. I don't know why. And there is still
the other addressbook, owned by "Ba". If I fill my personal addressbook,
this addressbook fills too. But I can delete it.

Ralph