Save the following script to /home/idmgr as something like remove_all_users:
______________________________________ #!/bin/sh ##LIST ALL SERIAL NUMBERS## sqlite3 /home/idmgr/identity.db "SELECT serial FROM laptops" > dellist.txt ##DELETE ALL ACCOUNTS IN LIST## for serial in $(< dellist.txt); do echo "$serial" | grep -s -E '^[A-Z]{3}[A-F0-9]{8}$' || exit 1 sqlite3 /home/idmgr/identity.db "DELETE FROM laptops WHERE serial = '$serial'" || exit 1 /usr/sbin/userdel -r $serial done ______________________________________ Don't forget to make it executable... Again, remove the '-r' option if you don't want to delete the users files. # chmod +x /home/idmgr/remove_all_users Cleaning up the moodle database should be similarly simple. > # su - postgres > # psql > # \connect moodle-xs > # DELETE FROM mdl_user; If you use the admin account, be careful not to delete it. You can always just make another one after though. On Sat, 17 Oct 2009 19:37:12 -0000, David Leeming <da...@leeming-consulting.com> wrote: > Is there a way to delete all users from the XS? I.e. I have upgraded from > 0.5.2 and wish to start afresh with a "clean" upgrade. > > > > David Leeming > Solomon Islands Rural Link > http://www.leeming-consulting.com > > -----Original Message----- > From: server-devel-boun...@lists.laptop.org > [mailto:server-devel-boun...@lists.laptop.org] On Behalf Of Devon > Connolly > Sent: Sunday, 18 October 2009 5:13 a.m. > To: server-devel@lists.laptop.org > Subject: Re: [Server-devel] unregister soas > > With the latest XO build you need to: > > # rm .sugar/default/config > > Then press CTL+ALT+ERASE. You will need to re-enter the students name > and > the register option will have returned. > > From what I've experienced "sugar-control-panel -c registration" only > seems to allow laptops that were having trouble registering register. If > they are already registered, I don't think it does anything. > > To clear the server of all history of the registration: > > # /home/idmgr/remove_user "SERIAL#" > > This will delete the user from the registration sqlite database. It also > deletes the user account fromt he server. I modified the script so it > also deletes the users backup files... > > /home/idmgr/remove_user > _______________________________________________ > > #!/bin/sh > > for serial; do > echo "$serial" | grep -s -E '^[A-Z]{3}[A-F0-9]{8}$' || exit 1 > sqlite3 /home/idmgr/identity.db "DELETE FROM laptops WHERE serial = > '$serial'" || exit 1 > /usr/sbin/userdel -r $serial > done > _______________________________________________ > > Take away the '-r' option from userdel to refrain from deleting the users > files. > > When deleting the users from Moodle, they should be just marked deleted > but are not removed from the Moodle database. To get rid of them you > need > to: > > ______________________________________________________ > # su - postgres > # psql > # \connect moodle-xs > # DELETE FROM mdl_user WHERE mdl_user.deleted = 1; //To delete all > users > that were deleted from the moodle interface. > # DELETE FROM mdl_user WHERE mdl_user.username = 'USERSNAME'; //To > delete > a specific user > # \quit > _______________________________________________________ > > I believe the above removes all traces from the server. > > On Sat, 17 Oct 2009 15:41:30 -0000, Tim Moody <timmo...@sympatico.ca> > wrote: > >> Is there a way to unregister a client with the xs? >> >> sugar-control-panel -c register didn't seem to do anything. >> _______________________________________________ >> Server-devel mailing list >> Server-devel@lists.laptop.org >> http://lists.laptop.org/listinfo/server-devel > > > > _______________________________________________ > Server-devel mailing list > Server-devel@lists.laptop.org > http://lists.laptop.org/listinfo/server-devel > > > -- Devon Connolly _______________________________________________ Server-devel mailing list Server-devel@lists.laptop.org http://lists.laptop.org/listinfo/server-devel