ODBC Help in Asterisk 13.19.1

Hi All

I am trying to connect to an ODBC database as part of the dial plan. I hope it is something simple I have overlooked…

I am running 13.19.1, and I believe I have everything setup as required…

I had to create /etc/asterisk/func_odbc.conf, and this now contains:

[ADMS]
dns=MySQL-davos
readsql=select * from tblADMSOutages where restoretime > NOW();

The odbc show command returns the following:

odbc show

ODBC DSN Settings
-----------------

  Name:   davos
  DSN:    MySQL-davos
    Last connection attempt: 1970-01-01 12:00:00
    Number of active connections: 1 (out of 1)

Which I believe shows things are on the right track…

However odbc read ADMS exec returns no such query ‘readsql’

Its like my func_odbc.conf file isnt getting loaded?

You have a typo.

It’s DSN not DNS.


[ADMS]
dsn=MySQL-davos
readsql=select * from tblADMSOutages where restoretime > NOW();

Try a reload func_odbc and see if there are any errors on the console.

If it reloads try a ‘core show functions like ODBC’