Hi All, We are in the process of setting up the MySQL database for Asterisk( Goal is ARA). We got to the step → Configuring Asterisk to Use the New ODBC and MySQL Install ( reference link: https://docs.asterisk.org/Configuration/Interfaces/Back-end-Database-and-Realtime-Connectivity/ODBC/Getting-Asterisk-Connected-to-MySQL-via-ODBC/.
) and we find the func_odbc.so fails to load. What might be the problem? See snapshot. Logs below.
[Aug 28 14:57:47] WARNING[708433] loader.c: Some non-required modules failed to load.
[Aug 28 14:57:47] ERROR[708433] loader.c: Error loading module ‘res_ari_device_states.so’, missing dependency: res_stasis_device_state
[Aug 28 14:57:47] ERROR[708433] loader.c: Error loading module ‘func_odbc.so’: /usr/lib/asterisk/modules/func_odbc.so: undefined symbol: ast_odbc_retrieve_transaction_obj
[Aug 28 14:57:47] ERROR[708433] loader.c: Failed to resolve dependencies for res_odbc
[Aug 28 14:57:47] ERROR[708433] loader.c: res_odbc declined to load.
[Aug 28 14:57:47] ERROR[708433] loader.c: Failed to resolve dependencies for res_config_odbc
[Aug 28 14:57:47] ERROR[708433] loader.c: res_config_odbc declined to load.
[Aug 28 14:57:47] ERROR[708433] loader.c: Failed to resolve dependencies for cdr_odbc
[Aug 28 14:57:47] ERROR[708433] loader.c: cdr_odbc declined to load.
[Aug 28 14:57:47] ERROR[708433] loader.c: Failed to resolve dependencies for cdr_adaptive_odbc
[Aug 28 14:57:47] ERROR[708433] loader.c: cdr_adaptive_odbc declined to load.
[Aug 28 14:57:47] VERBOSE[708433] asterisk.c: Asterisk Ready.
module show like odbc retruns:
ip-10-10-8-171*CLI> module show like odbc
Module Description Use Count Status Support Level
cdr_adaptive_odbc.so Adaptive ODBC CDR backend 0 Not Running core
cdr_odbc.so ODBC CDR Backend 0 Not Running extended
res_config_odbc.so Realtime ODBC configuration 0 Not Running core
res_odbc.so ODBC resource 0 Not Running core
4 modules loaded