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