i have updated asterisk 1.6 asterisk 11. using mysql command in asterisk dialplan access database on asterisk 1.6, command seems not working. after going through previous posts, guess mysql command not supported asterisk 11. can please tell me can alternative mysql , how can configure such alternative?
following i'm trying in dialplan:
exten => _xxxx,n,mysql(connect connid localhost user pswd db) exten => _xxxx,n(noerror),mysql(query resultid ${connid} select system user_to_system callerid='${cid}') exten => _xxxx,n(fetchrow),mysql(fetch foundrow ${resultid} system) exten => _xxxx,n,mysql(clear ${resultid}) exten => _xxxx,n,mysql(disconnect ${connid})
most likly mean have no app_mysql , res_mysql compiled.
for new dialplan recommend use res_odbc , func_odbc database access. manage connections you, need put sql want , use usual dialplan function.
this page describe how use func_odbc
http://www.voip-info.org/wiki/view/asterisk+func+func_odbc
as other option can use realtime function, more complex use. mysql realtime can compiled, not recommended use becuase of mysql license issues(will removed in future builds)
Comments
Post a Comment