Forced Removal User from VOMS

From Begrid Wiki
Revision as of 09:12, 9 June 2021 by Maintenance script (talk | contribs) (Created page with " == 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search


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


Template:TracNotice