Can't load res_odbc.so

devxpress · June 18, 2016, 1:44pm

Hello,
I installed mysql odbc (asterisk 1.8) :
unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel
yum install mysql-connector-odbc

i compiled my asterisk ,

configured /etc/odbcinst.ini and /etc/odbc.in

but when i use CLR

module load res_odbc.so
Unable to load module res_odbc.so
Command ‘module load res_odbc.so’ failed.
[Jun 18 09:41:25] WARNING[9577]: loader.c:777 inspect_module: Module ‘res_odbc.so’ was not compiled with the same compile-time options as this version of Asterisk.
[Jun 18 09:41:25] WARNING[9577]: loader.c:778 inspect_module: Module ‘res_odbc.so’ will not be initialized as it may cause instability.
[Jun 18 09:41:25] WARNING[9577]: loader.c:861 load_resource: Module ‘res_odbc.so’ could not be loaded.

Can someone help me to resole this issue?

Thanks;

david551 · June 18, 2016, 2:38pm

Did you stop and restart Asterisk?

If you did, you probably had a dirty build directory. Remove all the object files and rebuild (I think make clean may be too drastic for the way the sources are distributed), or start over extracting the source from the tarball.

devxpress · June 18, 2016, 4:28pm

tx for your reply,
I made
make distclean
./configure
make menuselect
make install

when i try to restart my asterisk, i get this error :
ERROR: ASTERISK_SBIN_DIR/asterisk not found

david551 · June 18, 2016, 5:41pm

In that case it failed to build and you need to look for the first error message.

devxpress · June 18, 2016, 6:11pm

It’s ok, i resolved this problem, i edited /etc/init.d/asterisk
it works fine now, apparently odbc too is loaded

cl-t222-132cl*CLI> odbc show

ODBC DSN Settings

Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Last connection attempt: 2016-06-18 14:03:41

but in CRL i get this error :

[Jun 18 14:06:41] WARNING[5730]: app_voicemail.c:5204 inboxcount2: Failed to obtain database object for ‘asterisk’!

any idea??