Func_odbc missing in Asterisk odbc


Description=ODBC for MySQL

I have the following library two libraries in my /lib64 directory since I couldnt find any matching one in my /lib directory so I used the /lib64 for driver and setup values


Description= MySQL connection to ‘root’ database
Driver= MySQL
Server= serveraddress
Socket= /var/lib/mysql/mysql.sock


enabled => yes
dsn => asterisk-connector
username => fastproducts
password => XGYUpOING
pooling => no
limit => 1
pre-connect => yes

I am using Asterisk 13.10.0 when I run the odbc show in the CLI

Shouldnt I see the “connected : yes” parameter

And also when I run module show like odbc

Only 1 module is loaded which is, no and other related odbc modules.

Also when I run isql -vvv asterisk-connector, it gives a connection error saying access is denied until I run the command with the username and password of the database like this

isql -vvv asterisk-connector fastproducts XGYUpOING then it connect

Also when I checked for the absent odbc modules on /usr/lib/asterisk/modules, I CAN SEE THE MODULES THERE BUT I DO NOT KNOW WHY THEY ARE NOT LOADED

Even if I try module load, it says no module named but I can see it in the modules direectory


asterisk-sinlimites42*CLI> module load
Unable to load module
Command ‘module load’ failed.
[Aug 15 23:55:16] WARNING[4615]: loader.c:599 load_dynamic_module: Error loading module ‘’: /usr/lib/asterisk/modules/ undefined symbol: ast_odbc_retrieve_transaction_obj

Other related ODBC modules are available and running. But I don’t know why is not loaded

You will need to load as well before

Thank you @jcolp, I have installed it, now it works but when I run odbc show command, I get this

Shouldnt it be something that says it is connected. It only shows name and DSN

You have an active connection, so it appears to be connected.

Okay @jcolp, thank you very much.

But look at the warnings I’ve got

Those are not from res_odbc. That is from the astdb, which is a local sqlite database. Were there any errors at startup about the database? Permissions maybe?

I don’t have any local sqlite database, I am trying to access an external MySQL database

The errors you pasted are for the local AstDB which is a sqlite database like I mentioned. It is created on startup by Asterisk if it does not exist already, unless permissions do not allow it to be created.

Okay, since I am not using the local database, do you think it will affect the application from running well, or do I have to create it for the application to run well

Other parts of Asterisk can and will use the AstDB to store stuff depending on your usage, it’s recommended that it be available and working.

AstDB, what do I need to do now. I dont even know the next thing to do now. The AstDB, how do I make it work as expected.