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

Single characters always ring the bell of strings used as arrays.  
Maybe some code assumes it's dealing with an array of users and calls  
something like $users[0], while $users is a string instead, like  
"foo". OTOH there should be much more, different single character  
entries then.
-- 
Jan Schneider
The Horde Project
http://www.horde.org/
https://www.facebook.com/hordeproject