[horde] clean DB from unused users (old users)

[Stefan Johänntgen]

  Thanks, but where do I put the xargs < users-to-remove
horde-remove-user-data --force --continue
And there is no file horde/bin/horde-remove-user-data to edit

Zitat von Steffen <skhorde at smail.inf.fh-bonn-rhein-sieg.de>:

> Stefan Johänntgen wrote:> Hi,
>> I have the authentication with the existing IMAP e-mail accounts.
>> Is there a script that I can delete a user from the horde database?
>> Because on the Horde frontend I can not manage the users. But in the
>> database are users (horde_prefs, turba_sharesng etc)
>> I want to clean up the database.
>> Many Thanks to Horde Team!
>
> see horde-remove-user-data in conjunction with this patch:
> http://bugs.horde.org/ticket/12997
>
> I did it so:
>
> 1. generate user list in Horde:
> for me, I query the Postgres SQL DB and dump into a file from psql
> SELECT DISTINCT pref_uid FROM horde_prefs \g /tmp/users
>
> 2. check above list, which users are gone with your user database
>
> 3. xargs < users-to-remove horde-remove-user-data --force --continue
>
> --Steffen