asterisk users - Dec 2006 - Re: Best way to access MySQL data from dial plan

Resending as message 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 data?
>
> Asterisk 1.2
> CentOS 4.4
> MySQL 5.0
>
> Regards
>
> Cameron

Ciao kjcsb,
> >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 data?
Well, you can easily modify the MYSQL() application in order to prevent
it from showing auth data in the logs.

If you aren't a C programmer, I can write for you a small patch that
will get the job done.

Bye,

-- 
Andrea Spadaccini
Multimedia Technologies Institute s.r.l.