Всем привет! Почему-то не заполняется таблица с сип-пользователями.
Parsing '/etc/asterisk/asterisk.conf': == Found == Parsing '/etc/asterisk/extconfig.conf': == Found == Binding sippeers to mysql/general/sip_devices == Binding sipusers to mysql/general/sip_devices
extconfig.conf
[settings] sippeers => mysql,general,sip_devices sipusers => mysql,general,sip_devices
res_mysql.conf
[general] dbhost = 127.0.0.1 dbname = asterisk dbuser = root dbpass = dbport = 3306
Создавал таблицу следующими командами:
CREATE TABLE `sip_devices` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(80) NOT NULL DEFAULT '', `context` varchar(80) DEFAULT NULL, `callingpres` enum('allowed_not_screened','allowed_passed_screen','allowed_failed_screen','allowed','prohib_not_screened','prohib_passed_screen','prohib_failed_screen','prohib','unavailable') DEFAULT 'allowed_not_screened', `deny` varchar(95) DEFAULT NULL, `permit` varchar(95) DEFAULT NULL, `secret` varchar(80) DEFAULT NULL, `md5secret` varchar(80) DEFAULT NULL, `remotesecret` varchar(250) DEFAULT NULL, `transport` enum('tcp','udp','tcp,udp') DEFAULT NULL, `host` varchar(31) NOT NULL DEFAULT '', `nat` varchar(5) NOT NULL DEFAULT 'no', `type` enum('user','peer','friend') NOT NULL DEFAULT 'friend', `accountcode` varchar(20) DEFAULT NULL, `amaflags` varchar(13) DEFAULT NULL, `callgroup` varchar(10) DEFAULT NULL, `callerid` varchar(80) DEFAULT NULL, `defaultip` varchar(15) DEFAULT NULL, `dtmfmode` varchar(7) DEFAULT NULL, `fromuser` varchar(80) DEFAULT NULL, `fromdomain` varchar(80) DEFAULT NULL, `insecure` varchar(4) DEFAULT NULL, `language` char(2) DEFAULT NULL, `mailbox` varchar(50) DEFAULT NULL, `pickupgroup` varchar(10) DEFAULT NULL, `qualify` char(3) DEFAULT NULL, `regexten` varchar(80) DEFAULT NULL, `rtptimeout` char(3) DEFAULT NULL, `rtpholdtimeout` char(3) DEFAULT NULL, `setvar` varchar(100) DEFAULT NULL, `disallow` varchar(100) DEFAULT 'all', `allow` varchar(100) DEFAULT 'g729;ilbc;gsm;ulaw;alaw', `fullcontact` varchar(80) NOT NULL DEFAULT '', `ipaddr` varchar(15) NOT NULL DEFAULT '', `port` mediumint(5) unsigned NOT NULL DEFAULT '0', `username` varchar(80) NOT NULL DEFAULT '', `defaultuser` varchar(80) NOT NULL DEFAULT '', `subscribecontext` varchar(80) DEFAULT NULL, `directmedia` enum('yes','no') DEFAULT NULL, `trustrpid` enum('yes','no') DEFAULT NULL, `sendrpid` enum('yes','no') DEFAULT NULL, `progressinband` enum('never','yes','no') DEFAULT NULL, `promiscredir` enum('yes','no') DEFAULT NULL, `useclientcode` enum('yes','no') DEFAULT NULL, `callcounter` enum('yes','no') DEFAULT NULL, `busylevel` int(10) unsigned DEFAULT NULL, `allowoverlap` enum('yes','no') DEFAULT 'yes', `allowsubscribe` enum('yes','no') DEFAULT 'yes', `allowtransfer` enum('yes','no') DEFAULT 'yes', `ignoresdpversion` enum('yes','no') DEFAULT 'no', `template` varchar(100) DEFAULT NULL, `videosupport` enum('yes','no','always') DEFAULT 'no', `maxcallbitrate` int(10) unsigned DEFAULT NULL, `rfc2833compensate` enum('yes','no') DEFAULT 'yes', `session-timers` enum('originate','accept','refuse') DEFAULT 'accept', `session-expires` int(5) unsigned DEFAULT '1800', `session-minse` int(5) unsigned DEFAULT '90', `session-refresher` enum('uac','uas') DEFAULT 'uas', `t38pt_usertpsource` enum('yes','no') DEFAULT NULL, `outboundproxy` varchar(250) DEFAULT NULL, `callbackextension` varchar(250) DEFAULT NULL, `registertrying` enum('yes','no') DEFAULT 'yes', `timert1` int(5) unsigned DEFAULT '500', `timerb` int(8) unsigned DEFAULT NULL, `qualifyfreq` int(5) unsigned DEFAULT '120', `contactpermit` varchar(250) DEFAULT NULL, `contactdeny` varchar(250) DEFAULT NULL, `lastms` int(11) NOT NULL, `regserver` varchar(100) NOT NULL DEFAULT '', `regseconds` int(11) NOT NULL DEFAULT '0', `useragent` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `name_2` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
realtime mysql status
general connected to asterisk@127.0.0.1, port 3306 with username root for 4 minutes.
В итоге получается пустая таблица.
