[horde] in horde_histories history_who = 'f'

[Jan Schneider]

Zitat von lst_hoe02 at kwsoft.de:

> Zitat von Jan Schneider <jan at horde.org>:
>
>> Zitat von "Jens-U. Mozdzen" <jmozdzen at nde.ag>:
>>
>>> Hi Steffen,
>>>
>>> Zitat von Steffen <skhorde at smail.inf.fh-bonn-rhein-sieg.de>:
>>>> if an user adds/deletes/... events via CalDAV or ActiveSync or  
>>>> Mnemos or Tasks via "Task & notes" for Android, horde_histories  
>>>> gets an entry where history_who is 'f'. I do not have no user 'f'  
>>>> and the users in question do not configured this user 'f', but  
>>>> their own.
>>>>
>>>> I've created a backtrace for one issue, when prefs_init() called  
>>>> user data for the non-existing user 'f'. Here _buildNote() called  
>>>> getUserName(), which queried horde_histories, which returned 'f'.  
>>>> The note is located in my notepad and I've setup the app to use  
>>>> my account.
>>>>
>>>> If I add a new note with "Task& notes" for Android, I get a new  
>>>> entry in horde_histories with history_who = 'f'. The same  
>>>> applies, if I add a new event with CalDAV clients in KDE and  
>>>> Android.
>>>>
>>>> Shouldn't history_who contain the username used to make the  
>>>> changes? Besides the fact, that there might exist the user "f".
>>>> Or might there a configuration mistake?
>>
>> Cannot reproduce, my history table looks fine.
>>
>>> I just checked our according table - while most of the entries do  
>>> have the user's email address in the history_who field, some do  
>>> have "0". These entries seem to be spread access all applications  
>>> - object_uid does start with "imp:", "turba:", "nag:",  
>>> "kronolith:" and so on. "history_action" is "add, "modify",  
>>> "delete" - so again spread.
>>
>> I see this on exactly 6 records, which I can lightheartedly justify  
>> with some development reminiscence.
>>
>
> We have around 19.000 entries out of ~100k with history_who='f' at  
> our main site. Some of them are pretty old, some are rather new with  
> all apps affected. I will have a look if it is user specific. Can  
> someone comment on how the history_who is used by Horde?
>
> Regards
>
> Andreas

Pretty intuitive: it logs who updated the history.
-- 
Jan Schneider
The Horde Project
http://www.horde.org/
https://www.facebook.com/hordeproject