Displaying 2 results from an estimated 2 matches for "sp_ins_into_avp".
2006 Dec 18
1
Re: Best way to access MySQL data from dial plan
...didn't show up the first time
>I need to access MySQL from the dial plan. Currently I am using the MYSQL
>function:
> exten => *78,n,MYSQL(Connect asterisklocal localhost asteriskuser password
> asterisk)
> exten => *78,n,MYSQL(Query resultid ${asterisklocal} CALL\
> sp_ins_into_avp(\'/DND/${CALLERID(number)}\'\,\'YES\'))
> exten => *78,n,MYSQL(Clear ${resultid})
> exten => *78,n,MYSQL(Disconnect ${asterisklocal})
>
> This shows authentication details in the Asterisk CLI which is not ideal.
> What is the recommended way to access MySQL dat...
2006 Dec 18
0
Re: Best way to access MySQL data from dial plan
...t;I need to access MySQL from the dial plan. Currently I am
> using the MYSQL
> >function:
> > exten => *78,n,MYSQL(Connect asterisklocal localhost
> asteriskuser password
> > asterisk)
> > exten => *78,n,MYSQL(Query resultid ${asterisklocal} CALL\
> > sp_ins_into_avp(\'/DND/${CALLERID(number)}\'\,\'YES\'))
> > exten => *78,n,MYSQL(Clear ${resultid})
> > exten => *78,n,MYSQL(Disconnect ${asterisklocal})
> >
> > This shows authentication details in the Asterisk CLI which
> is not ideal.
> > What is the reco...