Fpbx13 + Asterisk 13 ... ODBC errors in Console res_odbc.c?

I’ve installed a fresh Centos7 system and then Freepbx13 v13.0.5 on top of it. All Modules are up-to-date. System is mostly working well ! However during reload (apply changes) I am seeing errors about ODBC in the console, and Not sure if I should just ignore them or if they indicate a real problem

# grep odbc /var/log/asterisk/full

[2015-10-21 14:24:10] VERBOSE[7637] loader.c: Reloading module 'res_odbc.so' (ODBC resource)
[2015-10-21 14:24:10] VERBOSE[7637] config.c: Parsing '/etc/asterisk/res_odbc.conf': Found
[2015-10-21 14:24:10] VERBOSE[7637] config.c: Parsing '/etc/asterisk/res_odbc_custom.conf': Found
[2015-10-21 14:24:10] VERBOSE[7637] config.c: Parsing '/etc/asterisk/res_odbc_additional.conf': Found
[2015-10-21 14:24:10] NOTICE[7637] res_odbc.c: Connecting asteriskcdrdb
[2015-10-21 14:24:10] WARNING[7637] res_odbc.c: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libmyodbc5.so' : file not found
[2015-10-21 14:24:10] WARNING[7637] res_odbc.c: Failed to connect to asteriskcdrdb
[2015-10-21 14:24:10] NOTICE[7637] res_odbc.c: Registered ODBC class 'asteriskcdrdb' dsn->[MySQL-asteriskcdrdb]
[2015-10-21 14:24:10] VERBOSE[7637] loader.c: Reloading module 'res_config_odbc.so' (Realtime ODBC configuration)
[2015-10-21 14:24:10] VERBOSE[7637] loader.c: Reloading module 'cdr_adaptive_odbc.so' (Adaptive ODBC CDR backend)
[2015-10-21 14:24:10] VERBOSE[7637] config.c: Parsing '/etc/asterisk/cdr_adaptive_odbc.conf': Found
[2015-10-21 14:24:10] NOTICE[7637] res_odbc.c: Connecting asteriskcdrdb
[2015-10-21 14:24:10] WARNING[7637] res_odbc.c: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libmyodbc5.so' : file not found
[2015-10-21 14:24:10] WARNING[7637] res_odbc.c: Failed to connect to asteriskcdrdb
[2015-10-21 14:24:10] WARNING[7637] cdr_adaptive_odbc.c: No such connection 'asteriskcdrdb' in the 'asteriskcdrdb' section of cdr_adaptive_odbc.conf.  Check res_odbc.conf.
[2015-10-21 14:24:10] VERBOSE[7637] loader.c: Reloading module 'cel_odbc.so' (ODBC CEL backend)
[2015-10-21 14:24:10] VERBOSE[7637] config.c: Parsing '/etc/asterisk/cel_odbc.conf': Found
[2015-10-21 14:24:10] VERBOSE[7637] config.c: Parsing '/etc/asterisk/cel_odbc_custom.conf': Found
[2015-10-21 14:24:10] NOTICE[7637] res_odbc.c: Connecting asteriskcdrdb
[2015-10-21 14:24:10] WARNING[7637] res_odbc.c: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libmyodbc5.so' : file not found
[2015-10-21 14:24:10] WARNING[7637] res_odbc.c: Failed to connect to asteriskcdrdb
[2015-10-21 14:24:10] WARNING[7637] cel_odbc.c: No such connection 'asteriskcdrdb' in the 'cel' section of cel_odbc.conf.  Check res_odbc.conf.

Any ideas? Have I missed some modules during asterisk compilation? Or maybe need to install something via yum?

Yeap:

Can’t open lib ‘/usr/lib64/libmyodbc5.so’ : file not found

yum search odbc
apr-util-odbc.x86_64 : APR utility library ODBC DBD driver
asterisk11-odbc.x86_64 : Open Database Connectivity (ODBC) drivers for Asterisk
asterisk11-voicemail-odbcstorage.x86_64 : Voicemail with ODBC storage module for Asterisk
asterisk12-odbc.x86_64 : Open Database Connectivity (ODBC) drivers for Asterisk
asterisk12-voicemail-odbcstorage.x86_64 : Voicemail with ODBC storage module for Asterisk
asterisk13-odbc.x86_64 : Open Database Connectivity (ODBC) drivers for Asterisk
asterisk13-voicemail-odbcstorage.x86_64 : Voicemail with ODBC storage module for Asterisk
asterisk18-odbc.x86_64 : Open Database Connectivity (ODBC) drivers for Asterisk
asterisk18-voicemail-odbcstorage.x86_64 : Voicemail with ODBC storage module for Asterisk
freeradius-unixODBC.x86_64 : Unix ODBC support for freeradius
mysql-connector-odbc.x86_64 : ODBC driver for MySQL
php-odbc.x86_64 : A module for PHP applications that use ODBC databases
postgresql-odbc.x86_64 : PostgreSQL ODBC driver
qt-odbc.i686 : ODBC driver for Qt’s SQL classes
qt-odbc.x86_64 : ODBC driver for Qt’s SQL classes
qt3-ODBC.i686 : ODBC drivers for Qt 3’s SQL classes
qt3-ODBC.x86_64 : ODBC drivers for Qt 3’s SQL classes
unixODBC.i686 : A complete ODBC driver manager for Linux
unixODBC.x86_64 : A complete ODBC driver manager for Linux
unixODBC-devel.i686 : Development files for programs which will use the unixODBC library
unixODBC-devel.x86_64 : Development files for programs which will use the unixODBC library
unixODBC-kde.i686 : KDE driver manager components for ODBC
unixODBC-kde.x86_64 : KDE driver manager components for ODBC

Thank you for the info! Looking at that output I would assume I need at the very least

asterisk13-odbc.x86_64 : Open Database Connectivity (ODBC) drivers for Asterisk
asterisk13-voicemail-odbcstorage.x86_64 : Voicemail with ODBC storage module for Asterisk

Any others? Should I just test each one until the error disappears? (seems primitive)

I have odbc work fine with postgresql in FreePBX 13 using official distro. I suggest that you use too FreePBX with Official Distro - Centos 6.6.

Sorry for my english.

asterisk13-voicemail-odbcstorage.x86_64 this package not exist in Centos 7. I believe you have to compile Asterisk with ODBC support. So the ideal would be to use the official distribution.

I would have loved to do that but for some reason the hardware I was building on (Intel D525MW motherboard) would not boot from the Freepbx distro no matter what I tried. So I’m 99% there with the manual install but I think a few of these modules are missing. Guess I will just try them one by one.

have you tried with yum provides libmyodbc5.so??

yum provides */libmyodbc5.so
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 : ODBC driver for MySQL
Repo : base
Matched from:
Filename : /usr/lib64/libmyodbc5.so

mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 : ODBC driver for MySQL
Repo : installed
Matched from:
Filename : /usr/lib64/libmyodbc5.so

I tried yum provides libmyodbc5.so but it returned no results. Since then the box has been shut down and he’s going to give it back to me to pave and try again. :pensive:

Thank you all for the suggestions.