Save DTMF input to DB


#1

Hello guys, im trying to make a dial plan that allow me to save called input to mysql db, is there any procedure to do this ?


#2

All of the tools required to do so exist in Asterisk. It’s up to you to put the pieces[1][2] together.

[1] https://wiki.asterisk.org/wiki/display/AST/Asterisk+13+Application_Read
[2] https://github.com/asterisk/asterisk/blob/13/configs/samples/func_odbc.conf.sample


#3

Beside read app you can also also System() and MYSQL command whichis easier to configure than ODBC


#4

thanks for the replay @ambiorixg12, but how can i manage to make it with System() and MYSQL ?


#5

system(mysql --user=root --password=‘1112’ dialer -e “INSERT INTO dnc (dnc_phone) values (”${telephone}")"))


#6

wow!! thats more easy than i was doing with the reference jcolp told me, Thank!!