Compiling Asterisk on Ubuntu 14.04: res_odbc depends on generic_odbc, ltdl

Hi everyone. I’m having some difficulty getting Asterisk to compile from source.

To start, I’m running Ubuntu 14.04.04, I’m attempting to compile Asterisk 13.1-cert7, and I’ve installed the following packages:

build-essential checkinstall libsqlite3-dev libxml2-dev ncurses-dev uuid-dev 
libjansson-dev libmyodbc unixodbc libltdl-dev

I’ve closely followed the instructions for installing ODBC for Asterisk at http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/installing_configuring_odbc.html, and I’m able to connect with my ODBC client isql:

# echo "select lastname from cc_limit 5" | isql -v mya2billing
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select lastname from cc_card limit 5
+---------------------------------------------------+
| lastname                                          |
+---------------------------------------------------+
| Strohan                                           |
| West                                              |
| Caretakers                                        |
| Daner                                             |
| Woolner                                           |
+---------------------------------------------------+
SQLRowCount returns 5
5 rows fetched

However, even with ODBC clearly working within the system, the ‘make menuconfig’ command is telling me that res_odbc Depends on: generic_odbc(E), ltdl(E). Both of these packages are installed, as far as I can tell.

I’m not sure what to do from here. Will res_odbc even work with Ubuntu 14.04?

You are missing unixodbc-dev.

D’oh! Ok, that got things going from there!