[horde] in horde_histories history_who = 'f'

lst_hoe02 at kwsoft.de lst_hoe02 at kwsoft.de
Thu Mar 20 12:07:50 UTC 2014


Zitat von Jan Schneider <jan at horde.org>:

> 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.

But who the f... is "f" ???
Maybe this question includes the answer and it is simply some error  
placeholder. Bad to scan the PHP code for "f" though.

Regards

Andreas



More information about the horde mailing list