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

> >
> > What is a better way to do it then in terms of performance, security,
> and
> > flexibility? Using exec and a shell script, or agi or something else?
> >

Setup extconfig to have realtime access to the database/table you want to
pull info from, then in the dialplan use the app Realtime.

  -= Info about application 'RealTime' =- 

[Synopsis]
Realtime Data Lookup

[Description]
Use the RealTime config handler system to read data into channel variables.
RealTime(<family>|<colmatch>|<value>[|<prefix>])

All unique column names will be set as channel variables with optional
prefix to the name.
e.g. prefix of 'var_' would make the column 'name' become the
variable
${var_name}

This will not show any auth info in the asterisk cli and automatically
clears connect and fetch id's, works great and decreases the number of
priority routines within an extension.

JR

> Setup extconfig to have realtime access to the database/table you want to
> pull info from, then in the dialplan use the app Realtime.
>
Thanks. I didn't know that you could use RealTime in the dialplan like that.
I thought is was just for sip, extensions etc.

I created a wiki page at 
http://www.voip-info.org/wiki/view/Asterisk+cmd+RealTime. Feel free to edit 
if it's wrong!

Cameron