I need ODBC help

I’m trying to set up Asterisk on a new CentOS 7 box. I have unixODBC-devel and freetds installed and I can do “isql server username password” and connect. I can run queries through that just fine. But when I do “make menuselect” all the ODBC related options (like func_odbc and res_odbc) just show XXX instead of a checkbox and I can’t select them. I’ve tried rerunning ./configure but that didn’t change anything. I need my dialplan to be able to talk to my database. What am I doing wrong here?

When you try to select them, menuselect will tell you which dependencies have failed near the bottom of the screen.

Most likely is that you only have the run time, and not the development package, installed,

Thank you. I’ll take a look at that as soon as I get a chance.

Here is what I do on Debian:

  1. apt-get install libodbc

  2. apt-get install unixodbc-dev

  3. apt install unixodbc

And on Cent OS:

27 wget https://repo.mysql.com/yum/mysql-connectors-community/el/8/x86_64/mysql-connector-odbc-setup-8.0.17-1.el8.x86_64.rpm
28 rpm -Uvh rpm -Uvh mysql-connector-odbc-setup-8.0.17-1.el8.x86_64.rpm
29 wget http://repo.mysql.com/mysql80-community-release-el8.rpm
30 rpm -Uvh mysql80-community-release*rpm
31 dnf --enablerepo=mysql-connectors-community install mysql-connector-odbc-setup
32 dnf install mysql-server
33 dnf install unixODBC unixODBC-devel libtool-ltdl libtool-ltdl-devel

Hope this gives you an idea.

Bill

It looks like I was missing libtool-ltdl-devel.

Thank you! This has been driving me nuts!