TIPS No application 'MYSQL' for extension

[Robert Copelan]

I am running Incredible PBX 13.0.192.19. I have a context that uses the app_mysql to try and build a white list of allowed callers:
exten => s,1,Answer
exten => s,n,NoOp("Caller ID IS: ${CALLERID(number)}")
exten => s,n,MYSQL(Connect connid HOST USER PASSWORD database)
exten => s,n,MYSQL(Query resultid ${connid} SELECT name,ban FROM directory WHERE number='${CALLERID(number)}')
...
In modules.conf there is app_mysql.so listed but the file isn't in /usr/lib/asterisk/modules. I don't see how to load it via the admin GUI. Can someone please point me to where this is documented as clearly I'm looking in all the wrong places.
THanks very much.
Robert

 

[wardmundy]

If I'm not mistaken, I think Digium killed this in Asterisk 13. You have to use ODBC for the queries.

 

[Robert Copelan]

If I'm not mistaken, I think Digium killed this in Asterisk 13. You have to use ODBC for the queries.

Thanks Ward. Switched to ODBC and it works fine!