asterisk 配置mysql_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)