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

[Asterisk Bug Tracker]

The following issue has been ASSIGNED. 
====================================================================== 
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:                     confirmed
Target Version:             1.4.36
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:              
====================================================================== 
Date Submitted:             2010-06-24 06:42 CDT
Last Modified:              2010-07-26 15:55 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'
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-07-26 15:55 lmadsen        Asterisk Version         1.4.32 => SVN       
2010-07-26 15:55 lmadsen        Assigned To               => mnicholson      
2010-07-26 15:55 lmadsen        Target Version            => 1.4.36          
2010-07-26 15:55 lmadsen        Description Updated                          
2010-07-26 15:55 lmadsen        Additional Information Updated                  
 
======================================================================