[asterisk-users] cdr_mysql: Cannot connect to database server - SSL error: SSL_CTX_set_default_verify_paths failed

[Markus]

Hi,

Am 08.06.2020 um 12:25 schrieb Antony Stone:
> On Monday 08 June 2020 at 12:15:56, Markus wrote:
> 
>> Hi list!
>>
>> I'm getting this error frequently:
>>
>> ERROR[25193][C-0004f387]: cdr_mysql.c:203 mysql_log: Cannot connect to
>> database server localhost: (2026) SSL connection error:
>> SSL_CTX_set_default_verify_paths failed
> 
> Hmmm... talking to localhost over SSL... seems a bit computationally wasteful.

I switched to connecting via sock. My cdr_mysql.conf looks like this:

[global]
;hostname=localhost
dbname=asterisk
table=cdr
password=somepassword
user=someuser
;port=3306
sock=/var/lib/mysql/mysql.sock

However, I'm still frequently getting:

"[Jun 29 12:40:08] ERROR[12977][C-000007cc]: cdr_mysql.c:203 mysql_log: 
Cannot connect to database server localhost: (2026) SSL connection 
error: SSL_CTX_set_default_verify_paths failed"

Which makes no sense because I'm no longer connecting via localhost. The 
error message still mentions localhost, though. Maybe the error message 
is not accurate enough?!

Strange?

As explained previously, the error comes and go. Right now I'm losing 
about 10% of my CDRs. But that means it's not a general problem with the 
SSL stuff.

Thanks!
Markus