Use ODBC/Mysql in dialplan

I’d like to use a mysql query in the dialplan. How can I get this working with AsteriskNOW 1.7/Asterisk 1.6/FreePBX 2.7?
I just saw in the documentation of asterisk, that I have to edit /etc/asterisk/res_odbc.conf, which I unfortunatelly don’t have on my system.

I red that I have to install the following packets:
ODBC stuff (optional)
MySQL ODBC interface/connector

But for getting odbc working with asterisk, I have to compile asterisk again.
Is that right - or is there another way with AsteriskNOW/FreePBX?
If I have to compile again - how can I do it with that installetion?



the MYSQL commands worked fine for me! Thanks!

if you happen to have the addons installed (if your call reports are working then you do) then you could just use the MySQL Asterisk commands in the dialplan.

Another common ways that people do this is to use an AGI script to handle the MySQL interactions you need to do.