Forced Removal User from VOMS

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.

Back to Servers