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

[Jacques Beaudoin]

Hi Daniel,

This a script that I made and use.

Have a look at it.

So far so good for me.... in the last 3 months.

-- 
Best regards

Jacques Beaudoin
Agent d'administration
Les services des technologies
de l'information et des communications
Commission scolaire de la Pointe de l'Île


----- Message de daniel at daniel-ritter.de ---------
     Date : Wed, 25 Oct 2006 20:35:19 +0200
      De : Daniel Ritter <daniel at daniel-ritter.de>
Répondre à : Daniel Ritter <daniel at daniel-ritter.de>
  Objet : Re: [horde] Question about removing userdata from horde (mysql)
       À : horde at lists.horde.org


> Thanks for that link.
> Does someone use that script by any chance and knows if it works well
> and bugfree?
> Escpecially when dealing with shared Kronolith calendars and other
> shared data?
>
> Thanks,
> Daniel
>
>
> Bill Graham wrote:
>> 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.
>>
>
> -- 
> 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


----- Fin du message de daniel at daniel-ritter.de -----


----------------------------------------------------
Ce message a été acheminé par le Webmail de la CSPI.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: horde-delete.sh
Type: application/x-shellscript
Size: 6191 bytes
Desc: not available
Url : http://lists.horde.org/archives/horde/attachments/20061025/8da732e0/horde-delete.bin