[asterisk-bugs] [Asterisk 0013316]: Realtime registrations don't work after a sip reload

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=13316 
====================================================================== 
Reported By:                bcramer
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   13316
Category:                   Channels/chan_sip/DatabaseSupport
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     feedback
Asterisk Version:           SVN 
SVN Branch (only for SVN checkouts, not tarball releases):  1.4  
SVN Revision (number only!): 138258 
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             2008-08-15 22:00 CDT
Last Modified:              2008-08-17 23:22 CDT
====================================================================== 
Summary:                    Realtime registrations don't work after a sip reload
Description: 
Sip registrations get mixed up as the Nat'ed IP's get populated in the sip
status, then the status becomes UNKNOWN.  Shortly after the sip
registration completely disappears/expires:

sbc02*CLI> sip show peers
Name/username              Host            Dyn Nat ACL Port     Status    
Realtime  
6046309553      24.207.127.215   D   N      5060     OK (10 ms) Cached RT

blah  10.10.200.10     D   N      5060     OK (1 ms)            
2 sip peers [Monitored: 2 online, 0 offline Unmonitored: 0 online, 0
offline]

sbc02*CLI> sip reload
 Reloading SIP
  == Parsing '/etc/asterisk/sip.conf': Found

sbc02*CLI> sip show peers
Name/username              Host            Dyn Nat ACL Port     Status    
Realtime  
6046309553/6046309553      192.168.1.100    D   N      5060     UNKNOWN   
Cached RT 
blah  10.10.200.10     D   N      5060     OK (1 ms)            
2 sip peers [Monitored: 1 online, 1 offline Unmonitored: 0 online, 0
offline]

<couple minutes later>

sbc02*CLI> sip show peers
Name/username              Host            Dyn Nat ACL Port     Status    
Realtime  
vr01mcitosbc02mci/vr01mci  10.10.200.10     D   N      5060     OK (1 ms) 
          
1 sip peers [Monitored: 1 online, 0 offline Unmonitored: 0 online, 0
offline]



====================================================================== 

---------------------------------------------------------------------- 
 (0091504) bcramer (reporter) - 2008-08-17 23:22
 http://bugs.digium.com/view.php?id=13316#c91504 
---------------------------------------------------------------------- 
CREATE TABLE IF NOT EXISTS `sip_clients` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL default '',
  `accountcode` varchar(20) default NULL,
  `amaflags` varchar(13) default NULL,
  `callgroup` varchar(10) default NULL,
  `callerid` varchar(80) default NULL,
  `canreinvite` char(3) default 'yes',
  `context` varchar(80) default NULL,
  `defaultip` varchar(15) default NULL,
  `dtmfmode` varchar(7) default NULL,
  `fromuser` varchar(80) default NULL,
  `fromdomain` varchar(80) default NULL,
  `fullcontact` varchar(80) default NULL,
  `host` varchar(31) NOT NULL default '',
  `insecure` varchar(4) default NULL,
  `language` char(2) default NULL,
  `mailbox` varchar(50) default NULL,
  `md5secret` varchar(80) default NULL,
  `nat` varchar(5) NOT NULL default 'no',
  `deny` varchar(95) default NULL,
  `permit` varchar(95) default NULL,
  `mask` varchar(95) default NULL,
  `pickupgroup` varchar(10) default NULL,
  `port` varchar(5) default '',
  `qualify` char(3) default NULL,
  `restrictcid` char(1) default NULL,
  `rtptimeout` char(3) default NULL,
  `rtpholdtimeout` char(3) default NULL,
  `secret` varchar(80) default NULL,
  `type` varchar(6) NOT NULL default 'friend',
  `username` varchar(80) NOT NULL default '',
  `disallow` varchar(100) default 'all',
  `allow` varchar(100) default 'g729;speex;gsm;ulaw;alaw',
  `musiconhold` varchar(100) default NULL,
  `regserver` varchar(100) default NULL,
  `regseconds` int(11) default '0',
  `ipaddr` varchar(15) default '',
  `regexten` varchar(80) default '',
  `cancallforward` char(3) default 'yes',
  `setvar` varchar(100) default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=9
;

INSERT INTO `sip_clients` (`id`, `name`, `accountcode`, `amaflags`,
`callgroup`, `callerid`, `canreinvite`, `context`, `defaultip`, `dtmfmode`,
`fromuser`, `fromdomain`, `fullcontact`, `host`, `insecure`, `language`,
`mailbox`, `md5secret`, `nat`, `deny`, `permit`, `mask`, `pickupgroup`,
`port`, `qualify`, `restrictcid`, `rtptimeout`, `rtpholdtimeout`, `secret`,
`type`, `username`, `disallow`, `allow`, `musiconhold`, `regserver`,
`regseconds`, `ipaddr`, `regexten`, `cancallforward`, `setvar`) VALUES(7,
'6046309553', 'bcramer', '', '', 'Bryan', 'no', 'fromCLIENT', '', '', '',
'', '', 'dynamic', 'yes', '', '', '', 'yes', '', '', '', '', '', 'yes', '',
'', '', 'password', 'friend', '6046309553', 'all', 'ulaw', '', NULL, 300,
'', '', '', ''); 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2008-08-17 23:22 bcramer        Note Added: 0091504                          
======================================================================