Diameter Signaling Router (DSR) - IDIH - How To Reset Password for IDIH

Asset ID:	1-72-2372898.1
Update Date:	2018-03-13
Keywords:

Solution Type Problem Resolution Sure

Solution 2372898.1 : Diameter Signaling Router (DSR) - IDIH - How To Reset Password for IDIH

Applies to:

Oracle Communications Diameter Signaling Router (DSR) - Version DSR 7.3.0 and later
Tekelec

Symptoms

Customer is unable to login to NSP GUI on IDIH using idihtrace / idihadmin user.

They seem to have forgotten the password for idihtrace / idihadmin user.

Cause

Customer forgot the password for idihtrace / idihadmin user

Solution

Please contact Oracle Support to retrieve / change the password for these users.

********* Internal Procedure**********

<Based on Information from DSR Field Help Queue #18199>

- Retrieve the password information from mysql database
Here are the steps to retrieve the password:

- Login to mediation server as "admusr" and change user as "tekelec" (sudo su - tekelec)
- Connect to oracle db using this command "sqlplus /@NSP;"
- Then run the below command from SQL prompt to retrieve the user and password information
- SQL> select *from USERS
2 ;

- In this table you can see the username, password and user Description for each user.

- The password information from this table can be used to verify the login again.

- See the sample output below.

[admusr@med ~]$ sudo su - tekelec
/usr/TKLC/xIH/profiles/cm.completion.sh /usr/TKLC/xIH/profiles/xih-mediation.sh
Loading component profile /usr/TKLC/xIH/profiles/cm.completion.sh...
Loading component profile /usr/TKLC/xIH/profiles/xih-mediation.sh...

VPATH: /var/TKLC/xIH/mediation:/usr/TKLC/xIH/mediation
PRODPATH: /usr/TKLC/comagent:/usr/TKLC/awpcommon:/usr/TKLC/ttr:/usr/TKLC/TKLCcomcol/cm6.4
RUNID: 00
LD_LIBRARY_PATH: /usr/lib/oracle/12.1/client64/lib::/V0:/usr/TKLC/xIH/mediation/prod/lib:/usr/TKLC/comagent/lib:/usr/TKLC/awpcommon/lib:/usr/TKLC/ttr/lib:/usr/TKLC/TKLCcomcol/cm6.4/prod/lib:/V9

med:/usr/TKLC/xIH sqlplus /@NSP;

SQL*Plus: Release 12.1.0.2.0 Production on Tue Mar 13 04:26:03 2018

Last Successful login time: Tue Mar 13 2018 02:00:01 -04:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> select *from USERS;

U_NAME
--------------------------------------------------------------------------------
U_PASSWORD
--------------------------------------------------
U_DESCRIPTION
--------------------------------------------------------------------------------
idihadmin
<Password for idihadmin>
Built-in IDIH Administrator user for customer support

idihtrace
<Password for idihtrace>
Built-in IDIH Business user for DSR support

NSPInternal
<Password for NSPInternal>
Built-in system user

SQL>

- If the Login still does not works then due to account lock out (because o multiple attempts of wrong password) then password can be changed as following:

1.login to mediation server as "admusr" and change user as "tekelec" (sudo su - tekelec)
2.connect to oracle db using this command "sqlplus /@NSP;"

3 . run this command from SQL Prompt : SQL> update USERS set U_PASSWORD='xxxxxxxxxx' where U_NAME='idihadmin';

e.g :
SQL> update USERS set U_PASSWORD='xxxxxxxxxx' where U_NAME='idihadmin';

1 row updated.

4. run this command from SQL prompt : SQL> commit;

e.g

SQL> commit;

Commit complete.

5. then try to login Protrace GUI as " idihadmin /xxxxxxxxxx".

Note : after successful login you can change the password as to previous after running above 3 and 4 steps.

Attachments

This solution has no attachment