Forced Removal User from VOMS
From Begrid Wiki
Forced removal of a corrupted user DN in the VOMS server
This explain how to remove a user DN from the VOMS server when the VOMS web interface and the voms-admin commands fail to do so.
- Identify the VO where the user is registred, e.g.: beapps
- On the VOMS server, run the mysql client:
[root@voms root]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 581 to server version: 4.1.11-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>
- Use the correct VO DB, e.g.:
mysql> use beappsdb;
- Print the user list and identify the correct userid:
mysql> select * from usr;
- Print the located user, e.g.:
mysql> select * from usr where userid=21;
- Replace the corrupted DN by removing the unsupported character:
mysql> update usr set dn="/C=BE/O=BEGRID/OU=ThisIsValid/OU=ThisAlso/CN=Valid Name" where userid=21;
- Check if the changes are correctly applied:
mysql> select * from usr where userid=21;
- From now you can use the standard tools to remove the user, the VOMS web interface or the voms-admin commands.
