Retour
-
Titre
MySql agent fails with error java.sql.SQLException: Unable to read public key -
Description
MySQL agent fails with error java.sql.SQLException: Unable to read public key
ERROR [FglAM:RestoreAgent[20]-16] com.sma.mysql.agent.VersionInfo - An unexpected error occurred which may cause undesired behavior. You may want to contact customer support if you see this error again: Error retrieving server version.java.sql.SQLException: Unable to read public key '' -
Cause
MySQL Agent is not required to use the public key but that was set inadvertently. After removing the period(.) the agent started collecting data fine. -
Résolution
Default values have to be kept in order to work without public key:- Go to Administration | Agents | Agent Properties
- Select MySQL Agent
- Edit Properties.
- Modify Private properties.
- Set values to default as follow:
- Local Public Key File Path [(.)] a period is default value
- Allow Remote Public Key Retrieval? [checked]
- SSL mode preferred
6. Save