[asterisk-users] Re: Best way to access MySQL data from dial plan

[Andrea Spadaccini]

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.