Can I config the tls-cert and tls-key ?

Question

Hi~

I am trying to connect azure mysql service and pmm monitoring tool.

pmm need tls-ca, tls-cert, tls-key flags. (client-cert.pem, client-key.pem)

But Azure DB only need ca certificate as below command shows:
mysql --user=monitor@db-dddxxxx --password=xxxxx --host=db-dddxxxx.mysql.database.azure.com --ssl-mode=VERIFY_CA --ssl-ca=azure-ca.crt

So, I found this issue below page:

[https://jira.percona.com/browse/PMM-8239

But I don't know where can I execute this command in azure MySQL.

Because Azure mysql doesn't have command shell. only has azure cli(It doesn't have that command)

So, My question is "Is it possible to get the tls-cert, tls-key file ?"

and "where can I get the tls-cert, tls-key file? "

I look forward to your reply.

Thank you!

Answer 1

Hi, @안예리 Welcome to the Microsoft Q&A forum, Thanks for posting your question.

Please refer to this blog https://techcommunity.microsoft.com/t5/azure-database-for-mysql-blog/monitor-azure-database-for-mysql-using-percona-monitoring-and/ba-p/2568545

With the below setting, you should be able to connect.

Hope this will help. Please let us know if any further queries.

Regards

Geetha