we have an Asterisk 16.9.0 in a Centos 7.
After setting up realtime for ps_endpoint, ps_contacts, etc. and restart the asterisk service, it crashes.
The odbc driver is → mysql-connector-odbc-5.3.14-linux-el7-x86-64bit
The configuration of the odbc.ini, etc is ok but as soon as res_odbc.so is loaded it crashes.
This is the log:
asterisk[26472]: segfault at 1010070 ip 00007f25729a166e sp 00007ffdd2731980 error 4 in libmyodbc5w.so
We’re not sure what would be the proper version of the odbc driver to get this working or at least not crashing Asterisk.
Also, for crashes, you are likely to need the logs that Asterisk, itself, produces, leading up to the crash. The initial cause of the crash may happen some time before the crash.
I’ve always done it manually, directly issuing gdb commands, and the actual processing time is quite short. I wouldn’t expect the script to take more than a few seconds to run, but I’ve run it on systems where all the files are probably still in the cache.
The problem was the mysql-odbc-connector. The version really installed was the mysql-connector-odbc-5.2.7 one.
We uninstall that one and install mysql-connector-odbc-8.0.23-1.el7.x86_64.rpm with: