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

JR Richardson jmr.richardson at gmail.com
Mon Dec 18 18:27:30 MST 2006


> >
> > 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



More information about the asterisk-users mailing list