There's an example on wiki about fetching data from MySQL and setting them as channel variables that could be of use to you...

http://wiki.freeswitch.org/wiki/Lua_freeswitch_dbh#XML_Dialplan


On Sun, Dec 29, 2013 at 9:42 PM, baskar <yudha2008@gmail.com> wrote:
Hi All,

How to fetch password from MySQL through dialplan in freeswitch.

In MySQL i have table name with "ext_passwd" in that 1001 password is 4587.
How to enable outbound call with password protected. If i need to make a
outbound call from extension say 1001 to some toll free number. When i dial
it should prompt for password. If password successful outbound should be
enabled or else it should be Hangup.

As off now there is no restriction on outbound calls. Through prefix calls
are routed to make outbound calls.

Can some one assist me how to fetch data from MySQL in dialplan.

Thanks,
N.Baskar



--
View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Outbound-call-with-password-tp7596034.html
Sent from the freeswitch-users mailing list archive at Nabble.com.

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org