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.