[horde] Question about removing userdata from horde (mysql)
Bill Graham
grahamcw at hurleybulldogs.com
Wed Oct 25 15:29:23 PDT 2006
I had seem some other posts for this same sort of thing and found
Jacques script. I used it as a base for my own - and I just thought I
would get something out there because cleaning house after deleting a
user is something that was necissary.
I would not assume that the script works for shared anything.
Also - it if you are using non-standard data base names - you will
have to change them in the cript.
I use it - but have not done exhaustive testing to see what dribbles
are left out there.
I am running a snapshot from a month or so ago - on two different
systems - and it has not seem to damage anything.
Thanks to Jacques for the original
Bill
Quoting Jacques Beaudoin <jacques-beaudoin at cspi.qc.ca>:
> Hi Daniel and Bill,
>
> Its basicaly the same script.
>
> Did not know that my (modified) script was on the Wiki.
>
> Thanks Bill I will take a look at your modifications.
>
> --
> 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 jacques-beaudoin at cspi.qc.ca ---------
> Date : Wed, 25 Oct 2006 17:55:11 -0400
> De : Jacques Beaudoin <jacques-beaudoin at cspi.qc.ca>
> Répondre à : Jacques Beaudoin <jacques-beaudoin at cspi.qc.ca>
> Objet : Re: [horde] Question about removing userdata from horde (mysql)
> À : horde at lists.horde.org
>
>
>> 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.
>
>
> ----- Fin du message de jacques-beaudoin at cspi.qc.ca -----
>
>
> ----------------------------------------------------
> Ce message a été acheminé par le Webmail de la CSPI.
>
> --
> 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/8a0cc3d2/attachment.bin
More information about the horde
mailing list