Asterisk 动态拨号方案配置说明

Asterisk动态SIP账号及拨号方案配置，所谓“动态”是指这些配置是放在数据库中，而不用存在文件中，好处是方便用户通过Web直接管理Asterisk的配置，而且配置的生效无需重新

加载Asterisk。

基本配置过程如下：

1. 在/etc/asterisk/res_odbc.conf中配置需要访问的数据的用户名和密码，具体说明见配置文件。           

[meetme] enabled => yes dsn => MySQL-Asterisk username => root password => k pre-connect => yes   

2. 在/etc/asterisk/extconfig.conf中配置需要访问的数据库，表以及通过什么样的接口访问，表示为：

具体应用=> 数据库访问接口，数据库名称，表

sipusers => odbc,meetme,sip_buddies ;sippeers => odbc,asterisk sippeers => odbc,meetme,sip_buddies ;sipregs => odbc,asterisk ;voicemail => odbc,asterisk extensions => odbc,meetme,extensions   

3. 根据Asterisk提供给我们的各种配置的表信息，生成表其中，

sip用户表为：

mysql> desc sip_buddies;

+------------------+------------------------------+------+-----+-------------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------------------+------+-----+-------------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(80) | NO | UNI | | | | host | varchar(31) | NO | | | | | nat | varchar(5) | NO | | no | | | type | enum('user','peer','friend') | NO | | friend | | | accountcode | varchar(20) | YES | | NULL | | | amaflags | varchar(13) | YES | | NULL | | | call-limit | smallint(5) | YES | | NULL | | | callgroup | varchar(10) | YES | | NULL | | | callerid | varchar(80) | YES | | NULL | | | cancallforward | char(3) | YES | | yes | | | canreinvite | char(3) | YES | | yes | | | context | varchar(80) | YES | | NULL | | | defaultip | varchar(15) | YES | | NULL | | | dtmfmode | varchar(7) | YES | | NULL | | | fromuser | varchar(80) | YES | | NULL | | | fromdomain | varchar(80) | YES | | NULL | | | insecure | varchar(4) | YES | | NULL | | | language | char(2) | YES | | NULL | | | mailbox | varchar(50) | YES | | NULL | | | md5secret | varchar(80) | YES | | NULL | | | deny | varchar(95) | YES | | NULL | | | permit | varchar(95) | YES | | NULL | | | mask | varchar(95) | YES | | NULL | | | musiconhold | varchar(100) | YES | | NULL | | | pickupgroup | varchar(10) | YES | | NULL | | | qualify | char(3) | YES | | NULL | | | regexten | varchar(80) | YES | | NULL | | | restrictcid | char(3) | YES | | NULL | | | rtptimeout | char(3) | YES | | NULL | | | rtpholdtimeout | char(3) | YES | | NULL | | | secret | varchar(80) | YES | | NULL | | | setvar | varchar(100) | YES | | NULL | | | disallow | varchar(100) | YES | | all | | | allow | varchar(100) | YES | | g729;ilbc;gsm;ulaw;alaw | | | fullcontact | varchar(80) | NO | | | | | ipaddr | varchar(15) | NO | | | | | port | smallint(5) | NO | | 0 | | | regserver | varchar(100) | YES | | NULL | | | regseconds | int(11) | NO | | 0 | | | lastms | int(11) | NO | | 0 | | | username | varchar(80) | NO | | | | | defaultuser | varchar(80) | NO | | | | | subscribecontext | varchar(80) | YES | | NULL | | +------------------+------------------------------+------+-----+-------------------------+----------------+

extensions信息表为：

+----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | MUL | NULL | auto_increment | | context | varchar(20) | NO | PRI | | | | exten | varchar(20) | NO | PRI | | | | priority | tinyint(4) | NO | PRI | 0 | | | app | varchar(20) | NO | | | | | appdata | varchar(128) | NO | | | | +----------+--------------+------+-----+---------+----------------+   

4. 下面的工作就是通过数据库配置SIP用户以及拨号方案extensions。