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

Document created by Christopher_Walsh Employee on Aug 7, 2014Last modified by Christopher_Walsh Employee on Aug 19, 2014
Version 2Show Document
  • View in full screen mode

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

 

 

 

 

This document was generated from the following discussion: 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

Attachments

    Outcomes