[cvs] [Wiki] changed: RemoveUserData

[Wiki Guest]

guest [129.27.145.220]  Mon, 03 Aug 2009 11:53:21 -0400

Modified page: http://wiki.horde.org/RemoveUserData
New Revision:  2.2
Change log:  Perl scripts to remove all user data

@@ -80,4 +80,52 @@
  ++ A stand-alone script

  From Bill Graham:
  http://www2.hurleybulldogs.com/billsblog/?p=21
+
+
+++ Stand-alone Perl scripts that remove user data from all Horde applications
+
+By Didi Rieder <adrieder at sbox dot tugraz dot at>
+
+The attached perl scripts help you to remove user data form all  
applications in your horde system.
+One script does that by connecting to your mySQL database and the  
other uses XMLRPC to call a Horde API method.
+
+The SQL solution will be much faster when one needs to bulk remove  
users and it does not need patching of the
+non CVS horde API.
+
++++ SQL driven
+
+**Required Perl modules:**
+> DBI (download from CPAN)
+> DBD::mysql (download from CPAN)
+> !HordeSQL.pm (attached)
+
+**Script file:**
+> removeHordeUserSQL.pl (attached)
+
+**Usage:**
+Edit the script file and provide the connection parameters in the  
!HordeSQL->new() method.
+Then run the script as follows:
+>> removeHordeUserSQL.pl <user|userfile> [realm]
+the first argument is the user you want to remove, or a file that  
contains a list of users that should be removed (one user each line).
+You can optionally provide a second argument which is interpreted as  
realm and gets added to each user that is to be removed.
+>
++++ XMLRPC & API driven
+
+**Required Perl modules:**
+> SOAP::Lite (download from CPAN)
+> !HordeSQL.pm (attached)
+
+**Script file:**
+> removeHordeUserSQL.pl (attached)
+
+**Usage:**
+Edit the script file and provide the connection parameters in the  
!HordeXMLRPC->new() method.
+Then run the script as follows:
+>> removeHordeUserXMLRPC.pl <user|userfile> [realm]
+the first argument is the user you want to remove, or a file that  
contains a list of users that should be removed (one user each line).
+You can optionally provide a second argument which is interpreted as  
realm and gets added to each user that is to be removed.
+
+##red|Note##: At this time you need to patch the horde API in order  
to add the removeUserDataFromAllApps() method which is used by the
+perl script:  
[http://bugs.horde.org/view.php?actionID=view_file&type=patch&file=horde_removeUserDataFromAllApps.2.patch&ticket=8454 Patch]  
\
+(The patch is not needed if you are running an up to date CVS version  
of horde.)