[horde] Rampage error

[Michael J Rubinsky]

Quoting Ralph Ballier <ballier at mail.schule.de>:

> 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.
>>  
>
> Look my other mail.I have create an authusername hook which convert
> username to all lowercase.
>
> But if the user "web" calls the calender, the error message is the same.
> This is a new user. He has not create any tags. Can I delete the entry
> "web" in the table "rampage_users" without other problems?

Yes, this is currently only used for tags, so if there are no tags  
this will not be an issue.

-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5751 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20151105/08728a21/attachment.bin>