Hello Sirs,
I have random res_odbc errors and have searched on Internet for weeks however there are many toppics about this I did not find an answare.
I have one Centos 7.0 server which is running Asterisk 13.7.0:
I have updated the ODBC to latest version: mysql-connector-odbc-5.3.7-1.el7.x86_64
Another server is running Mysql:
mysql-community-libs-5.6.29-2.el7.x86_64
mysql-community-release-el7-5.noarch
mysql-community-common-5.6.29-2.el7.x86_64
mysql-community-client-5.6.29-2.el7.x86_64
mysql-community-server-5.6.29-2.el7.x86_64
A prefect match in drivers is not available since I already update it.
The error is Random, sometimes days not and somtimes each hour multiple times.
Sometime my Asterisk did chrash but since a >> pooling => yes << it does not crash anymore but still these errors.
It cause realtime issues all over the platform , Extensions, CDRS etc.
ERROR[8573][C-0000793a] res_config_odbc.c: No database handle available with the name of ‘asterisk’ (check res_odbc.conf)
ERROR[25101][C-00006e8a] res_config_odbc.c: No database handle available with the name of ‘asterisk’ (check res_odbc.conf)
[asterisk]
enabled => yes
dsn => asterisk-connector
pre-connect => yes
pooling => yes
limit => 1
idlecheck => 3600
[asterisk-connector]
Description = MySQL connection to ‘asterisk’ database
Driver = MySQL ODBC 5.3 ANSI Driver
Driver = MySQL
Database = asterisk
Server = xxx.xxx.xxx.xxx
User = asterisk
Password = xxx
Port = 3306