[asterisk-bugs] [Asterisk 0017551]: 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:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17551
Category:                   Channels/chan_sip/Registration
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
Asterisk Version:           1.4.32 
JIRA:                        
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-06-24 08:47 CDT
====================================================================== 
Summary:                    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'
====================================================================== 

---------------------------------------------------------------------- 
 (0123818) ricardolandim (reporter) - 2010-06-24 08:47
 https://issues.asterisk.org/view.php?id=17551#c123818 
---------------------------------------------------------------------- 
yes... the patch (comment username data):

--- chan_sip.c  2010-06-18 15:41:04.000000000 -0300
+++ chan_sip.c  2010-06-24 10:43:32.000000000 -0300
@@ -2543,11 +2543,11 @@
        if (fc)
                ast_update_realtime("sippeers", "name", peername,
"ipaddr", ipaddr,
                        "port", port, "regseconds", regseconds,
"useragent", useragent,
-                       "username", username, fc, fullcontact, syslabel,
sysname, NULL); /* note fc and syslabel _can_ be NULL */
+                       /*"username", username,*/ fc, fullcontact,
syslabel, sysname, NULL); /* note fc and syslabel _can_ be NULL */
        else
                ast_update_realtime("sippeers", "name", peername,
"ipaddr", ipaddr,
                        "port", port, "regseconds", regseconds,
"useragent", useragent,
-                       "username", username, syslabel, sysname, NULL); /*
note syslabel _can_ be NULL */
+                       /*"username", username,*/ syslabel, sysname,
NULL); /* note syslabel _can_ be NULL */
        if (seen_lastms) {
                /* We cannot do this in the same statement as above,
because the lack of
                 * this field could cause the whole statement to fail. */ 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-06-24 08:47 ricardolandim  Note Added: 0123818                          
======================================================================