[horde] Listing of users in horde database

[Michael J Rubinsky]

Quoting Philipp Faeustlin <Philipp.Faeustlin at uni-hohenheim.de>:

> Am 08.03.2016 um 18:13 schrieb Jan Schneider:
>>
>> Zitat von Michael J Rubinsky <mrubinsk at horde.org>:
>>
>>> Quoting Philipp Faeustlin <Philipp.Faeustlin at uni-hohenheim.de>:
>>>
>>>> Hi,
>>>>
>>>> I know listing of users, when using imap as backend is not possible.
>>>>
>>>> But there have to be a way to get a complete list of users known by
>>>> horde in its database?
>>>>
>>>> I want to use the "horde-remove-user-data" script on command line to
>>>> remove old user data, but I don't know the usernames of the old users.
>>>> I only know the names of the actual users, I don't want to remove.
>>>
>>> Probably the easiest way to do this within horde is to get them from
>>> the share system. See e.g., Kronolith_Application::listAlarms for how
>>> this is done via the Horde_Share_Base::listAllShares() method.
>>
>> SELECT pref_uid from horde_prefs WHERE pref_name = 'last_login'
>>
>> is safer.
>>
> For testing purpose I tried to remove all users with  
> "horde-remove-user-data".
>
> After that I expected an practically empty horde database, but I have not.
> My horde_prefs table is empty, but many others are not. Is there a  
> bug in the script or do I have so much junk in my horde database,  
> which did some version changes in the past years.
>
> For example:
> The horde_histories,

horde_histories is not expected to be empty. It logs the history of  
all items so, for example, when all of a user's events are deleted  
from kronolith, it logs these as deleted.

> rampage_*,

If you are using a recent version of any applications that provide  
Tagging features, the entries that attach tags to any removed  
resources should be removed. The table, however would not be expected  
to be completely empty. If this is not the case, see if you can figure  
out which application's data has not been "untagged".


> horde_syncml_*, horde_dav*,

It's possible these two are currently missed in the current code.  
Please create a ticket on bugs.horde.org so we don't forget to look  
into this.

> trean_*

The removeUserData API wasn't added to Trean in the stable branch. It  
exists only in Git and will be in the next major version release.

> tables doesn't seem to be cleaned up at all.
>
> imp_sentmail is the same, but there I have seen in the config, that  
> it should clean up itself when the configured time expires.

Correct.


> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org



-- 
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/20160309/deab8a5d/attachment.bin>