[asterisk-bugs] [Asterisk 0017551]: [patch] Realtime erase username when Unavailable

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17551 
====================================================================== 
Reported By:                ricardolandim
Assigned To:                mnicholson
====================================================================== 
Project:                    Asterisk
Issue ID:                   17551
Category:                   Channels/chan_sip/Registration
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     closed
Target Version:             1.4.37
Asterisk Version:           SVN 
JIRA:                       SWP-1790 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
Resolution:                 fixed
Fixed in Version:           
====================================================================== 
Date Submitted:             2010-06-24 06:42 CDT
Last Modified:              2010-09-14 14:29 CDT
====================================================================== 
Summary:                    [patch] Realtime erase username when Unavailable
Description: 
When an extension sip become unavailable, the realtime clears the username
within the database. Logs below:

res_config_mysql.c: MySQL RealTime: Update SQL: UPDATE sip SET fullcontact
= '', ipaddr = '', port = '', regseconds = '0', username = '', regserver =
'' WHERE name = '341400'

The right would be (without username column):

res_config_mysql.c: MySQL RealTime: Update SQL: UPDATE sip SET fullcontact
= '', ipaddr = '', port = '', regseconds = '0', regserver = '' WHERE name =
'341400'
====================================================================== 

---------------------------------------------------------------------- 
 (0126948) svnbot (reporter) - 2010-09-14 14:29
 https://issues.asterisk.org/view.php?id=17551#c126948 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 286759

_U  trunk/
U   trunk/channels/chan_sip.c

------------------------------------------------------------------------
r286759 | mnicholson | 2010-09-14 14:29:44 -0500 (Tue, 14 Sep 2010) | 34
lines

Merged revisions 286758 via svnmerge from 
https://origsvn.digium.com/svn/asterisk/branches/1.8

................
  r286758 | mnicholson | 2010-09-14 14:28:38 -0500 (Tue, 14 Sep 2010) | 27
lines
  
  Merged revisions 286757 via svnmerge from 
  https://origsvn.digium.com/svn/asterisk/branches/1.6.2
  
  ................
    r286757 | mnicholson | 2010-09-14 14:27:28 -0500 (Tue, 14 Sep 2010) |
20 lines
    
    Merged revisions 286756 via svnmerge from 
    https://origsvn.digium.com/svn/asterisk/branches/1.4
    
    ........
      r286756 | mnicholson | 2010-09-14 14:26:18 -0500 (Tue, 14 Sep 2010)
| 13 lines
      
      Don't clear the username from a realtime database when a
registration expires.
      
      Non-realtime chan_sip does not clear the username from memory when a
registration expiries so realtime probably shouldn't either.
      
      (closes issue https://issues.asterisk.org/view.php?id=17551)
      Reported by: ricardolandim
      Patches:
            reg-expiry-username-1.4-fix1.diff uploaded by mnicholson
(license 96)
            reg-expiry-username-1.6.2-fix1.diff uploaded by mnicholson
(license 96)
            reg-expiry-username-1.8-fix1.diff uploaded by mnicholson
(license 96)
            reg-expiry-username-trunk-fix1.diff uploaded by mnicholson
(license 96)
      Tested by: ricardolandim, mnicholson
    ........
  ................
................

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=286759 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-09-14 14:29 svnbot         Checkin                                      
2010-09-14 14:29 svnbot         Note Added: 0126948                          
======================================================================