Products | Versions |
---|---|
Spotfire Connector for Oracle MySQL | All Versions |
The following is the error message which is present in the Spotfire Analyst logs
------------------------------------------
MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication with old password no longer supported, use 4.1 style passwords.
at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
at MySql.Data.MySqlClient.NativeDriver.Open()
at MySql.Data.MySqlClient.Driver.Open()
at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
at MySql.Data.MySqlClient.MySqlPool.GetConnection()
at MySql.Data.MySqlClient.MySqlConnection.Open()
at Spotfire.Dxp.Data.Adapters.MySql.MySqlAdapterConnection.ConnectAndGetDatabaseNames(String connectionString, List`1& databases)
-------------------------------------------
The original hashing algorithm used by MySQL (prior to 4.1) has been deemed to be unsecure. Version 4.1 implements a new hashing algorithm. The password in your connection string does not need to be hashed, the hashing is performed internally in your .Net connector during authentication to the database (it is done for you). The problem is if you have upgraded your database from a pre-4.1 version and not reset the password to use the new hashing.
To get the Spotfire Analyst/Client logs:
1. Open Spotfire Analyst/Client.
2. Browse to "Help > Support Diagnostics and Logging" > Logging tab
3. Set the Log level to "Debug" and make a note of the "Log file" location
4. Click on OK button.
5. Replicate the issue and then open the "Log file" path to open the "Spotfire.Dxp.SupportDiagnostics.log" file.