[horde] Question about removing userdata from horde (mysql)

[Bill Graham]

There is something on the wiki abot this - and a sample - crude and  
rude house cleaner
http://wiki.horde.org/DatabaseCleanup?referrer=HowTo

Bill

Quoting Daniel Ritter <daniel at daniel-ritter.de>:

> Hallo,
>
> I am wondering if there is a "right" way to remove all data from a   
> certain user from horde's apps.
>
> I am using Mysql and the Datatree (Mysql) as a backend.
> Authentication is done via IMP and our local IMAP-server.
>
> Now when removing an user from our local UNIX passwb, the user isn't  
>  able to log into Horde anymore,
> because Courier uses PAM as auth. No unix-user, no Courier user, no   
> Horde User.
>
> This leaves all the users data like calendars, addressbooks, etc in   
> hordes mysql-database.
>
> I was wondering if there is a "right" way to remove that leftover   
> data from the horde mysql-tables.
> Is there a premade script I haven't found or would i just do a few
> "remove from horde_foo where uid='$user_to_delete' "?
> Would that be dangerous? Could it break something else?
> What about shared userdata?
>
> Thanks for your help
> Daniel
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org



-- 

Bill Graham
Systems Administrator
Hurley Public Schools
Hurley,SD 57036
USA
grahamcw at hurleybulldogs.com


----------------------------------------------------------------
This electronic  mail sent from Hurley Public Schools - Hurley, South Dakota
http://www.hurleybulldogs.com

NOTICE: This E-mail (including attachments) is covered by the Electronic
Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may
be legally privileged. If you are not the intended recipient, you are hereby
notified that any retention, dissemination, distribution, or copying of this
communication is strictly prohibited. Please reply to the sender that you
have received the message in error, then delete it. Thank you.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 1375 bytes
Desc: PGP Public Key
Url : http://lists.horde.org/archives/horde/attachments/20061025/083a716a/attachment.bin