### 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/3...@github.com>
_______________________________________________
Kamailio (SER) - Development Mailing List
To unsubscribe send an email to sr-dev-le...@lists.kamailio.org
