MySql agent fails with error java.sql.SQLException: Unable to read public key (4255275)

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

MySql agent fails with error java.sql.SQLException: Unable to read public key
Descripción

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 ''
Causa

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.
Resolución
Default values have to be kept in order to work without public key:
1. Go to Administration | Agents | Agent Properties
2. Select MySQL Agent
3. Edit Properties.
4. Modify Private properties.
5. 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

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Producto(s):: Foglight
6.1.0, 6.0.0, 5.9.8, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2; Foglight for Databases
6.1.0, 6.0.0, 5.9.7, 5.9.5, 5.9.4, 5.9.3, 5.9.2; Foglight for Virtualization Enterprise Edition
8.9, 8.8.5, 8.8, 8.7.5, 8.7

Historial del artículo:: Creado el: 10/24/2019
Última actualización: 3/1/2024

Título