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

[Douglas Garstang]

I'm not sure that any solution with the MySQL dialplan command is going to be ideal. You also can't nest your queries, ie the connectid/result id seems to only be good for one resultset at a time... try doing something like findme/followme with that!

Doug.

> -----Original Message-----
> From: kjcsb [mailto:kjcsb at orcon.net.nz]
> Sent: Monday, December 18, 2006 11:33 AM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: [asterisk-users] 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 
> 
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>