TRY THIS What's the simplest way to query a database from within Dialplan?

[pbxtest]

I'd like store a few values in a local database (mySQL) when calls are dialed. Nothing complex. What would be the simplest option for running a query from the dialplan?

I've done a lot of searching haven't found a clear answer to the basic questions, probably due to my inexperience with Asterisk / FreePBX and PIAF. (Do I need to install odbc? Additional modules? What function(s) do you use to connect the db from within the dialplan? Can I create tables in the existing asterisk/asteriskcrddb databases and use that dsn... and if so how? ...)

Any pointers in the right direction would be greatly appreciated

 

[pbxtest]

Thank you! That worked perfectly. Apparently I can't see the forest for the trees on Friday ;-)

I'd heard about using the Asterisk db, but wasn't sure if it'd be a good fit for my task or not. How do you access it - with the DB() command? It is only for storing key + prop pairs ?

 

[pbxtest]

BTW, have you ever used ODBC? I tried setting it up last week but didn't have any luck. Not sure if I need to install something extra ... ?

 

[pbxtest]

Makes sense. I'll have to see if it's a good fit for this task.

Thanks again for the quick response!