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

[kjcsb]

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