The only way to resolve this is with two MySql queries against the netqosportal DB on the PC host.
REST can't be used at this point since it relies on the admin users log in details to engage the PC host for REST based requests.
Solution for Cause #1: Authentication type changed
To resolve cause number 1 above where the admin users authentication was changed, we will need to update both the Authentication Type and the password for the default admin user to resolve this. This is because when the Authentication Type is set to External, the users password is reset to the encrypted form of a blank password.
In that situation complete the following:
- Open a terminal window to the CAPC host and log in as the root, or sudo-root install owner
- Go to the directory $CAPC_HOME/CA/Mysql/bin. The default path would be /opt/CA/Mysql/bin
- Connect to MySql by running the command "./mysql -uroot -p netqosportal". Enter the mysql password set on install.
- Run these two queries to modify the necessary values and resolve this.
- First the query to set the Authentication Type to the correct value:
- UPDATE user_definitions SET AuthType=1 where UserId = 1;
- Next we update the password back to the default 'admin' password value:
- For versions prior to 21.2.6:
UPDATE user_definitions SET Password = '21232f297a57a5a743894a0e4a801fc3' where UserId = 1;
OR
update user_definitions set password=MD5('NEW-PASSWORD') where name='admin';
- On 21.2.6 and later:
UPDATE user_definitions SET Password = 'edbd881f1ee2f76ba0bd70fd184f87711be991a0401fd07ccd4b199665f00761afc91731d8d8ba6cbb188b2ed5bfb465b9f3d30231eb0430b9f90fe91d136648' where UserId = 1;
- Once those changes are made, run the command "\q" to exit the MySql prompt.
We should now be able to once more log in to the PC UI as the default admin user using the default password "admin".
Solution for Cause #2: Unknown password, reset required
To resolve cause number 2 we simply reset the admin users password. It's the same solution as above, minus the command to change the authentication type.
In that situation complete the following:
- Open a terminal window to the CAPC host and log in as the root, or sudo-root install owner
- Go to the directory $CAPC_HOME/CA/Mysql/bin. The default path would be /opt/CA/Mysql/bin
- Connect to MySql by running the command "./mysql -uroot -p netqosportal". Enter the mysql password set on install.
- Run this query to modify the password back to the default encrypted value.
- For versions prior to 21.2.6:
UPDATE user_definitions SET Password = '21232f297a57a5a743894a0e4a801fc3' where UserId = 1;
OR
update user_definitions set password=MD5('NEW-PASSWORD') where name='admin';
- On 21.2.6 and later:
UPDATE user_definitions SET Password = 'edbd881f1ee2f76ba0bd70fd184f87711be991a0401fd07ccd4b199665f00761afc91731d8d8ba6cbb188b2ed5bfb465b9f3d30231eb0430b9f90fe91d136648' where UserId = 1;
- Once that change is made run the command "\q" to exit the MySql prompt.