[horde] in horde_histories history_who = 'f'

lst_hoe02 at kwsoft.de lst_hoe02 at kwsoft.de
Thu Mar 20 11:52:06 UTC 2014


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




More information about the horde mailing list