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\
: kjcsb [mailto:[EMAIL PROTECTED]
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
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!
Thanks
What is a better way to do it
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