[horde] Rampage error

[Ralph Ballier]

  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

Just in this moment I notice, I have a new addressbook with the same
content as my personal addressbook, but owned by "Ba" (not "ba"). I don't
have administrative right and can't delete it. If I logged in as "Ba", it's
not possible to delete too.

I found, that authentication by LDAP is case insensitive (uid=ba and uid=Ba
are the same), but Horde is case sensitive. This is a problem.

I can change the case insensitivity of uid in the schema file, but I mean
that is not a good idea. What think you about this?

Ralph