DX Unified Infrastructure Management

Expand all | Collapse all

Tech Tips: When logging into the MTP the error The User ID x associated with your account either does not exist or is not enabled

  • 1.  Tech Tips: When logging into the MTP the error The User ID x associated with your account either does not exist or is not enabled

    Broadcom Employee
    Posted Jul 28, 2014 10:40 AM

    Details:

    When logging into the MTP you may see an error like below:


    The user ID (1) associated with your account either does not exist or is
    not enabled.

     

    This could be caused by an incorrect user ID in your Single Sign-On cookie.
    Delete your browser cookies and try again. If this does not resolve the
    problem, the issue could be an incorrect configuration of the "Anonymous User
    ID" field in the Single Sign-On Configuration Tool. Ask your administrator to
    verify that these settings are correct.

     

    The user ID may be different depending on how you are logging in.

     

    If you compare nqmpcdb.user_definitions table on the MTP to the super.users table in ADA you will see they do not match up.

     

    There may be missing users in the MTP database, or the number of rows will be different and/or the user ID's will not much up for specific users.

     

    On MTP you can check this by opeing an SSH session to the MTP server and logging into mysql with:

    mysql -P3308 nqmpcdb

    Then running the query below:

    select userid, name from user_definitions order by userid;

    Then RDP to the ADA server and login to mysql via the command prompt with:

    mysql -P3308 super

    Then run the query below and compare the results to the MTP results.

    select user_id, user_name from users order by user_id;

    Solution:

     

    If you find the results are different there is a user sync issue between ADA and MTP and you may need to manually force the users to sync properly.

     

     

    To do so follow the steps below or open an issue with CA Support and reference this post for assistance with these steps.

     

     

    1)In the MTP SSH session, backup the user_definitions and tmp_users tables with the commands below:

    mysqldump -P3308 nqmpcdb user_definitions > /tmp/user_definitions.sql

    mysqldump -P3308 nqmpcdb tmp_users > /tmp/tmp_users.sql

     

    2)Verify the files are in the /tmp directory with:

    ls -l /tmp/*.sql

     

    3)Then truncate the user_defintions and tmp_users table in the nqmpcdb database with:

    mysql -P3308 nqmpcdb

     

    truncate user_definitions;

     

    truncate tmp_users;

     

    exit

    4)Then run the script below in MTP to manually force the sync of the users:

    sudo /opt/NetQoS/scripts/syncSAUsers.php --force -verbose

     

    5)Attempt to login to the MTP Web interface again and you should no longer see the error from above.

     

     

    **Note** If the above procedure does not work and you should need to restore the user_defintions and tmp_users table you can use the commands below

    mysql nqmpcdb < user_definitions.sql

    mysql nqmpcdb < tmp_users.sql

     

     



  • 2.  Re: Tech Tips: When logging into the MTP the error The User ID x associated with your account either does not exist or is not enabled

    Posted Jul 28, 2014 10:53 AM

    On a related note, if you drill down from the ADA master console on the data collectors page, your session token isn't passed as part of the URL so you may have to log in again. This is a problem with the token not being included in the URL. Should be an easy fix, but I haven't seen whether or not it was fixed in the most recent release.



  • 3.  Re: Tech Tips: When logging into the MTP the error The User ID x associated with your account either does not exist or is not enabled

    Broadcom Employee
    Posted Jul 28, 2014 11:04 AM

    Just tried this in my ADA/MTP 10.0 lab.

    Logged into ADA->Admin->Data Monitoring page, and clicked the MTP link under the ADA monitoring device list, and it works fine without having to login again.  Looks like this was fixed.



  • 4.  Re: Tech Tips: When logging into the MTP the error The User ID x associated with your account either does not exist or is not enabled

    Posted Jul 28, 2014 11:40 AM

    Awesome. Could you check that the url actually includes the token? The symptom doesn't always show up. For example, if you drill into MTP from the engineering tab, then go to the ADA->Admin->Data Monitoring->MTP you'll get logged into the MTP without having to provide credentials because you had recently passed the token. Looking at the URL will tell if the token is included and if this defect is actually fixed.



  • 5.  Re: Tech Tips: When logging into the MTP the error The User ID x associated with your account either does not exist or is not enabled

    Broadcom Employee
    Posted Jul 28, 2014 11:42 AM

    Yes the token is in the URL.



  • 6.  Re: Tech Tips: When logging into the MTP the error The User ID x associated with your account either does not exist or is not enabled

    Posted Jul 28, 2014 11:46 AM

    Awesome! Problem fixed. Thanks Christopher_Walsh