asterisk 操作mysql
[globals]
DBCurrentHost=localhost
DBuser=root
DBpass=passw0rd
DBname=asterisk
[sip]
exten => _X.,1,Set(CALLERID(num)=58837999)
exten => _X.,n,MySql(connect connid ${DBCurrentHost} ${DBuser} ${DBpass} ${DBname}) ;连接mysql 操作
exten => _X.,n,set(ID=12)
exten => _X.,n,MySql(query resultid ${connid} insert into jd set id=14\, name =\'ppp\') ; //进行查询
exten => _X.,n,MySql(query resultidr ${connid} select name from jd where id=${ID}) ; //进行查询
exten => _X.,n,MySql(Fetch foundrow ${resultidr} name) ;//读取
exten => _X.,n,MySql(clear ${resultidr}) ;//清除什么什么东东
exten => _X.,n,MySql(disconnect ${connid}) ; //关闭连接
exten => _X.,n,noop(${name})
exten => _X.,n,Queue(sipqueue,t,,,150)
exten => _X.,n,hangup
exten => 3000,1,SetMusicOnHold(default)
exten => 3000,n,WaitMusicOnHold(20)