Forgot VNA mysql password, need to reset it
Dx NetOps Virtual Network Assurance any version
You should keep a list of your passwords.
MAKE SURE THAT THERE ARE PROPER BACKUPS BEFORE USING.
This seemed to work in a LAB env:
1) Stop wildfly and mysql
2) Reset mysql root password:
3) Start mysql and make sure you can login with new password:
4) Generate new password string for use in standalone.xml:
Note: Adjust the above commands for your installation path.
5) In /opt/CA/VNA/wildfly/standalone/configuration/standalone.xml find:
<security-domain name="VNA_MySQL" cache-type="default">
<authentication>
<login-module code="SecureIdentity" flag="required">
<module-option name="username" value="root"/>
<module-option name="password" value="386688ef4285511cff7045aaac1eb160"/>
<module-option name="managedConnectionFactoryName" value="jboss.jca:service=LocalTxCM"/>
</login-module>
</authentication>
</security-domain>
</security-domains>
And use the value from step 4 as the password as noted above
6) Start wildfly: