How to search for a user in Times Ten Data Authority Server (TTDAS)

Document

Jun 22, 2009 4:12 PM
Jun 22nd, 2009

Resolution

To find a user in the TTDAS perform these steps:

  1. Log in as dsuser to the machines where TimesTen (TT) is located for the specific POP to which the user exists.

  2. Navigate to TT install directory. For example, cd /opt/TimesTen/5_0_30/bin directory.

  3. Issue the proper command to get into sql command line for a specific instance. For example, ./ttIsql -connStr DSN="POP_0".

    Type ? or help for help, type exit to quit ttIsql. All commands must end with a semicolon character.

  4. There are three main tables to find a subscriber that exists in the database:

  • NRS_MAPPING

    Command> select * from SIP.NRS_MAPPING where sub_uri='test_0@cisco.com';

    < test_0@cisco.com, 4767269464969809936, 1, 0, KCI ,1109966415, 4228BE520005D627 >

    1 row found.

    Note: The next two commands use the internal_id, which is pulled from the previous command.

  • SUBSCRIBER

    Command> select * from SIP.SUBSCRIBER where internal_id=4767269464969809936;

    < 4767269464969809936, 66feecfe567af0c42f5502f461f272e0, 102,2121112200, 1109966415, 1109966415, 1109966415, 4228BE520005D87F >

    1 row found.

  • REGISTRATIONINFO

    Command> select * from SIP.REGISTRATIONINFO where internal_id=4767269464969809936;

    < 4767269464969809936, 0, 

The above commands should be issued on both schemas 0,1, and on the primary and buddy POPs.


Average Rating: 0 (0 ratings)

Actions

Login or Register to take actions

This Document

Posted June 22, 2009 at 4:12 PM
Stats:
Comments:0 Avg. Rating:0
Views:1365 Contributors:0
Shares:0
Tags: faq, sip, cscp, ttdas, k37643162
+

Related Content

Documents Leaderboard

Rank Username Points
1 54
2 5
Rank Username Points
5