Como escribir una base de datos desde el Dial Plan de Asterisk

Hay muchas formas para realizar la tarea describa  en el titulo  de  mas arriba y este es una muy sencilla pero efectiva.


[mysql-context]
exten=>*59,1,Answer()
exten=>*59,2,Set(idcaller=${CALLERID(num)})
exten=>*59,3,system(/usr/bin/mysql --user=root --password='19582' asterisk -e 'UPDATE users SET password="${idcaller}"  where username="kl"';
)
same=>n,hangup()


exten=>*60,1,Read(pass,agent-pass)
exten=>*60,2,system(/usr/bin/mysql --user=root --password='19582' asterisk -e 'UPDATE users SET password="${pass}"  where username="kl"';
same=>n,Hangup()

Asterisk Standard Channel Variables

There are a number of variables that are defined or read by Asterisk. Here is a listing of them. More information is available in each application's help text. All these variables are in UPPER CASE only.
Variables marked with a * are builtin functions and can't be set, only read in the dialplan. Writes to such variables are silently ignored.