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

[Anant Athavale]

Dear Jacques:

I was always looking for such script.  Thanks.  I use cyrus-imap.  I  
will modify the script if required.

-Anant.

Quoting Jacques Beaudoin <jacques-beaudoin at cspi.qc.ca>:

> 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.



Regards,

Anant.