Running temporal-mysql-tool script with postgres instance with SSL enabled

Community Support
1

Hi there,

Trying to run the temporal-mysql-tool command with a postgres instance that has SSL mode enabled. This is what I am running

./temporal-sql-tool --ep $SQL_HOST_ADDR -p $port --plugin postgres --db temporal --tls --tls-cert-file $CLIENT_CERT --tls-ca-file $SERVER_CERT --tls-key-file $CLIENT_KEY setup-schema

but I’m getting the following error back

"error": "x509: cannot validate certificate for xx.xxx.x.x because it doesn't contain any IP SANs", "logging-call-at": "handler.go:52"

Anyone else know why this may be happening?

2

Could be an issue with certificate creation, see here for similar issue and a number of possible options to correct it: https://newbedev.com/failed-tls-handshake-does-not-contain-any-ip-sans

hope this helps.