asterisk realtime sip数据库实时添加sip peers

通话数据库维护sip 用户信息，

1、首先我们需要创建保存用户信息的表

## Table structure for table `sip_devices`#CREATE TABLE IF NOT EXISTS `sip_devices` (      `id` int(11) NOT NULL AUTO_INCREMENT,      `name` varchar(10) NOT NULL,      `ipaddr` varchar(15) DEFAULT NULL,      `port` int(5) DEFAULT NULL,      `regseconds` int(11) DEFAULT NULL,      `defaultuser` varchar(10) DEFAULT NULL,      `fullcontact` varchar(35) DEFAULT NULL,      `regserver` varchar(20) DEFAULT NULL,      `useragent` varchar(20) DEFAULT NULL,      `lastms` int(11) DEFAULT NULL,      `host` varchar(40) DEFAULT NULL,      `type` enum('friend','user','peer') DEFAULT NULL,      `context` varchar(40) DEFAULT NULL,      `permit` varchar(40) DEFAULT NULL,      `deny` varchar(40) DEFAULT NULL,      `secret` varchar(40) DEFAULT NULL,      `md5secret` varchar(40) DEFAULT NULL,      `remotesecret` varchar(40) DEFAULT NULL,      `transport` enum('udp','tcp','udp,tcp','tcp,udp') DEFAULT NULL,      `dtmfmode` enum('rfc2833','info','shortinfo','inband','auto') DEFAULT NULL,      `directmedia` enum('yes','no','nonat','update') DEFAULT NULL,      `nat` enum('yes','no','never','route') DEFAULT NULL,      `callgroup` varchar(40) DEFAULT NULL,      `pickupgroup` varchar(40) DEFAULT NULL,      `language` varchar(40) DEFAULT NULL,      `allow` varchar(40) DEFAULT NULL,      `disallow` varchar(40) DEFAULT NULL,      `insecure` varchar(40) DEFAULT NULL,      `trustrpid` enum('yes','no') DEFAULT NULL,      `progressinband` enum('yes','no','never') DEFAULT NULL,      `promiscredir` enum('yes','no') DEFAULT NULL,      `useclientcode` enum('yes','no') DEFAULT NULL,      `accountcode` varchar(40) DEFAULT NULL,      `setvar` varchar(40) DEFAULT NULL,      `callerid` varchar(40) DEFAULT NULL,      `amaflags` varchar(40) DEFAULT NULL,      `callcounter` enum('yes','no') DEFAULT NULL,      `busylevel` int(11) DEFAULT NULL,      `allowoverlap` enum('yes','no') DEFAULT NULL,      `allowsubscribe` enum('yes','no') DEFAULT NULL,      `videosupport` enum('yes','no') DEFAULT NULL,      `maxcallbitrate` int(11) DEFAULT NULL,      `rfc2833compensate` enum('yes','no') DEFAULT NULL,      `mailbox` varchar(40) DEFAULT NULL,      `session-timers` enum('accept','refuse','originate') DEFAULT NULL,      `session-expires` int(11) DEFAULT NULL,      `session-minse` int(11) DEFAULT NULL,      `session-refresher` enum('uac','uas') DEFAULT NULL,      `t38pt_usertpsource` varchar(40) DEFAULT NULL,      `regexten` varchar(40) DEFAULT NULL,      `fromdomain` varchar(40) DEFAULT NULL,      `fromuser` varchar(40) DEFAULT NULL,      `qualify` varchar(40) DEFAULT NULL,      `defaultip` varchar(40) DEFAULT NULL,      `rtptimeout` int(11) DEFAULT NULL,      `rtpholdtimeout` int(11) DEFAULT NULL,      `sendrpid` enum('yes','no') DEFAULT NULL,      `outboundproxy` varchar(40) DEFAULT NULL,      `callbackextension` varchar(40) DEFAULT NULL,      `registertrying` enum('yes','no') DEFAULT NULL,      `timert1` int(11) DEFAULT NULL,      `timerb` int(11) DEFAULT NULL,      `qualifyfreq` int(11) DEFAULT NULL,      `constantssrc` enum('yes','no') DEFAULT NULL,      `contactpermit` varchar(40) DEFAULT NULL,      `contactdeny` varchar(40) DEFAULT NULL,      `usereqphone` enum('yes','no') DEFAULT NULL,      `textsupport` enum('yes','no') DEFAULT NULL,      `faxdetect` enum('yes','no') DEFAULT NULL,      `buggymwi` enum('yes','no') DEFAULT NULL,      `auth` varchar(40) DEFAULT NULL,      `fullname` varchar(40) DEFAULT NULL,      `trunkname` varchar(40) DEFAULT NULL,      `cid_number` varchar(40) DEFAULT NULL,      `callingpres` enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib') DEFAULT NULL,      `mohinterpret` varchar(40) DEFAULT NULL,      `mohsuggest` varchar(40) DEFAULT NULL,      `parkinglot` varchar(40) DEFAULT NULL,      `hasvoicemail` enum('yes','no') DEFAULT NULL,      `subscribemwi` enum('yes','no') DEFAULT NULL,      `vmexten` varchar(40) DEFAULT NULL,      `autoframing` enum('yes','no') DEFAULT NULL,      `rtpkeepalive` int(11) DEFAULT NULL,      `call-limit` int(11) DEFAULT NULL,      `g726nonstandard` enum('yes','no') DEFAULT NULL,      `ignoresdpversion` enum('yes','no') DEFAULT NULL,      `allowtransfer` enum('yes','no') DEFAULT NULL,      `dynamic` enum('yes','no') DEFAULT NULL,      PRIMARY KEY (`id`),      UNIQUE KEY `name` (`name`),      KEY `ipaddr` (`ipaddr`,`port`),      KEY `host` (`host`,`port`)) ENGINE=MyISAM;

2、修改配置文件extconfig.conf，开启realtime sip 访问mysql数据

;iaxusers => odbc,asterisk;iaxpeers => odbc,asterisk;sippeers => odbc,asterisk;sipregs => odbc,asterisk ; (avoid sipregs if possible, e.g. by using a view);voicemail => odbc,asterisk;extensions => odbc,asterisk;meetme => mysql,general;queues => odbc,asterisk;queue_members => odbc,asterisk;musiconhold => mysql,general;queue_log => mysql,general;;; While most dynamic realtime engines are automatically used when defined in; this file, 'extensions', distinctively, is not.  To activate dynamic realtime; extensions, you must turn them on in each respective context within; extensions.conf with a switch statement.  The syntax is:;      switch => Realtime/[[db_context@]tablename]/<opts>; The only option available currently is the 'p' option, which disallows; extension pattern queries to the database.  If you have no patterns defined; in a particular context, this will save quite a bit of CPU time.  However,; note that using dynamic realtime extensions is not recommended anymore as a; best practice; instead, you should consider writing a static dialplan with; proper data abstraction via a tool like func_odbc.sippeers => mysql,general,sip_devices

3、修改配置文件res_config_mysql.conf，配置mysql数据库连接

[general]dbhost = 127.0.0.1dbname = callcenterdbuser = rootdbpass = rootdbport = 3306;dbsock = /var/lib/mysql/mysql.sock;dbcharset = latin1;requirements=warn ; or createclose or createchar

4、修改配置文件sip.conf，开启rtcachefriends=yes，使sip show peers命令能查看到realtime表中的配置数据

;----------------------------------------- REALTIME SUPPORT ------------------------; For additional information on ARA, the Asterisk Realtime Architecture,; please read https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration;rtcachefriends=yes; Cache realtime friends by adding them to the internal list; just like friends added from the config file only on a; as-needed basis? (yes|no)