ODBC can not connect to mariadb with ssl ca

Asterisk Asterisk Support
1

I want to use the Asterisk Realtime feature with MariaDB. I have successfully configured it, and Asterisk can read the database. Here is my configuration:

Driver=MySQL ODBC 5.0 Driver
Description=MySQL connection to the Asterisk database
Server=localhost
Port=3306
Database=asterisk
UserName=user
Password=password
Socket=/var/run/mysqld/mysqld.sock

However, I need to use SSLCA, and I believe I have set up SSLCA for the database correctly because I can connect using the MySQL CMD with the SSLCA option. But when I add the SSLCA option to the ODBC.ini file, Asterisk reports an error:

res_odbc.c:1060 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=2026 [unixODBC][MySQL][ODBC 5.3(w) Driver]SSL connection error: error:00000001:lib(0):func(0):reason(1)

ODBC.ini with SSLCA:

Driver=MySQL ODBC 5.0 Driver
Description=MySQL connection to the Asterisk database
Server=host
Port=3306
Database=asterisk
Username=user@host
Password=password
sslca=/home/sslca.pem
Socket=/var/run/mysqld/mysqld.sock

Thank you for reviewing. Please provide me with instructions for troubleshooting.

2

I have never seen a domain socket that uses SSL. It’s basically inter-process comminication on the same box. You should be able to enable encryption if you switch to a network socket.