Cannot Delete A User On 13.2 LSMS PROD AND DR

Asset ID:	1-72-2371197.1
Update Date:	2018-03-14
Keywords:

Solution Type Problem Resolution Sure

Solution 2371197.1 : Cannot Delete A User On 13.2 LSMS PROD AND DR

Applies to:

Oracle Communications EAGLE (Software) - Version LSMS 13.2 and later
Information in this document applies to any platform.

Symptoms

On : LSMS 13.2 version, LSMS (Production)

Problem Details:
Not able to delete the user

Error:
====
/usr/TKLC/lsms/tools/lsmsdb: Tried to delete user from Active LSMS. User deletion failed on Active

Cause

After upgrading to 13.3 some users were not migrated correctly
Migration to 13.3

Solution

lsmsdb deletes from three locations, /etc/passwd, supDB.LsmsUser and mysql.user tables.

Here an example to delete user from supDB.LsmsUser table. follow same steps to delete user from other tables.

Log into mysql in the new window
# mysql –udbroot –p
Passcode -

mysql> use supDB;
Database changed
mysql> select * from LsmsUser where name='';
+----------+--------+-----------+-------------------+-------------------+----------------+-------------+
| name | golden | groupName | inactivityTimeout | UsrPwdExpInterval | FirstLogonFlag | LastUpdDate |
+----------+--------+-----------+-------------------+-------------------+----------------+-------------+
| user to be deleted | 0 | lsmsview | -1 | -1 | 1 | 2010-06-28 |
+----------+--------+-----------+-------------------+-------------------+----------------+-------------+
1 row in set (0.00 sec)

mysql> delete from LsmsUser where name='user to be deleted';
Query OK, 1 row affected (0.00 sec)

mysql>

Attachments

This solution has no attachment