[asterisk-bugs] [Asterisk 0017941]: RealTime doesn't set regserver value in mysql

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=17941 
====================================================================== 
Reported By:                parisioa
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   17941
Category:                   Channels/chan_sip/Registration
Reproducibility:            have not tried
Severity:                   minor
Priority:                   normal
Status:                     new
Asterisk Version:           1.6.2.11 
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-09-01 17:50 CDT
Last Modified:              2010-09-01 19:13 CDT
====================================================================== 
Summary:                    RealTime doesn't set regserver value in mysql
Description: 
tested with both systemname and autosystemname on * 1.6.1.18 (on one
server) and 1.6.2.11 on two servers.

;systemname = rtel1 ; prefix uniqueid with a system name for global
uniqueness issues
autosystemname = yes ; automatically set systemname to hostname - uses
'localhost' on failure, or systemname if set


[general]
context=from-sip
bindport=5060
bindaddr=0.0.0.0
tcpbindaddr=0.0.0.0
tcpenable=yes
allowguest=no
rtcachefriends=yes
rtsavesysname=yes


here's the debug sql query showing it doesn't even try:
[Sep  1 15:44:48] DEBUG[28871] res_config_mysql.c: MySQL RealTime: Update
SQL: UPDATE sippeers SET ipaddr = '192.168.16.36', port = '5060',
regseconds = '1283381148', username = '1593', useragent = 'Aastra
57i/2.6.0.1008', lastms = '0', fullcontact =
'sip:1593 at 192.168.16.36:5060;transport=udp' WHERE name = '1593'


everything else appears to work.
====================================================================== 

---------------------------------------------------------------------- 
 (0126545) parisioa (reporter) - 2010-09-01 19:13
 https://issues.asterisk.org/view.php?id=17941#c126545 
---------------------------------------------------------------------- 
I don't even know how to program like this but i know enough to find the
right spot in the chan_sip using information from another bug report.  i
played with it a bit and identified the problem.

if (ast_strlen_zero(sysname))   /* No system name, disable this */
                sysname = NULL;

this always gets triggered in chan_sip.  This gets triggered whether it is
set to auto sys name, or a specified name.

I don't know how to fix the upstream failure of const char *sysname =
ast_config_AST_SYSTEM_NAME; so i'm hoping one of you guys can.

thanks! 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-09-01 19:13 parisioa       Note Added: 0126545                          
======================================================================