Certificate expiration information

15 views
Skip to first unread message

Ekundayo Lasode

unread,
May 14, 2024, 10:51:55 AM5/14/24
to proxysql
Hello

Does ProxySQL expose any details about the expiration  dates of  certificates it uses? i.e. similar to global status variable 'Ssl_server_not_after' which is available in MySQL 
 
I have a ProxySQL server running the below version in production:

~$ sudo mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 1454
Server version: 8.0.15 (ProxySQL) (ProxySQL Admin Module)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

The documentation suggests that I can get status variables  as shown here: https://proxysql.com/documentation/ssl-support/ but the command throws an error when executed

~$ sudo mysql -e "SHOW SESSION STATUS LIKE "Ssl_%""
ERROR 1045 (28000) at line 1: ProxySQL Admin Error: near "SHOW": syntax error

If possible, the goal is to be able to get the cert expiration details from the running instance.

Thanks 
Reply all
Reply to author
Forward
0 new messages