I have ISE 2.2+ and mysql 8.0
I have tried to use
https://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-22/210521-Configure-ISE-2-2-for-integration-with-M.html to configure MYSQL as external identity source.
https://www.cisco.com/c/en/us/td/docs/security/ise/1-2/troubleshooting_guide/ise_tsg.html
I'm having trouble with that ISE not sending the password to mysql. I have tried both mysql_native_password caching_sha2_password as the user to authenitcate. I can login from mysqlcli on a other machine with "mysql -h XXX -user dot1x -p".
When I click "Test connection" in ISE I can see that the password get sent with the http-request.
rawJsonData: {"id":"f0e8dfc0-3081-11eb-8a03-005056834713","name":"XXXX","hostName":"XXXX","databaseName":"dot1x","userName":"dot1x","passwd":"XXXXXXXX","timeout":5,"retries":1,"driver":"MYSQL","procedureType":"RECORDSET","passwdFetch":"ISEFetchPasswordReturnsRecordset","passwdAuthen":"ISEAuthUserPlainReturnsRecordset","MACFormat":"RAW","odbcLookup":"ISEUserLookupReturnsRecordset","fetchGroupsProcedure":"ISEGroupsH","fetchAttributesProcedure":"ISEAttrsH","securedConnection":false}
Anyone else had same problem and how did you solve it?
