### Description
Recent commit
```
d53843c75da src/modules/db_mysql/km_my_con.c (Sergey Safarov 2024-05-11 17:45:08
+0300 182) #ifdef MYSQL_OPT_SSL_CA
```
breaks db_mysql on 5.8.2
```
Jul 09 08:40:31 voip-ssl3.voip.test /usr/local/kamailio/sbin/kamailio[10982]: WARNING:
db_mysql [km_my_con.c:187]: db_mysql_new_connection(): opt_ssl_ca option not supported by
mysql version (value /etc/pki/tls/certs/ca-cert.pem) - ignoring
Jul 09 08:40:31 voip-ssl3.voip.test /usr/local/kamailio/sbin/kamailio[10982]: ERROR:
db_mysql [km_my_con.c:217]: db_mysql_new_connection(): driver error: SSL connection error:
CA certificate is required if ssl-mode is VERIFY_CA or VERIFY_IDENTITY
```
Ping @sergey-safarov
### Troubleshooting
#### Reproduction
* use 5.8.2
* configure `db_mysql` to use TLS with verification
#### Debugging Data
#### Log Messages
```
Jul 09 08:40:31 voip-ssl3.voip.test /usr/local/kamailio/sbin/kamailio[10982]: WARNING:
db_mysql [km_my_con.c:187]: db_mysql_new_connection(): opt_ssl_ca option not supported by
mysql version (value /etc/pki/tls/certs/ca-cert.pem) - ignoring
Jul 09 08:40:31 voip-ssl3.voip.test /usr/local/kamailio/sbin/kamailio[10982]: ERROR:
db_mysql [km_my_con.c:217]: db_mysql_new_connection(): driver error: SSL connection error:
CA certificate is required if ssl-mode is VERIFY_CA or VERIFY_IDENTITY
```
### Additional Information
* **Kamailio Version** - 5.8.2
--
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/3910
You are receiving this because you are subscribed to this thread.
Message ID: <kamailio/kamailio/issues/3910(a)github.com>