[asterisk-bugs] [Asterisk 0011880]: SIP username -> defaultuser confuses realtime system(s)

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=11880 
====================================================================== 
Reported By:                cabal95
Assigned To:                putnopvut
====================================================================== 
Project:                    Asterisk
Issue ID:                   11880
Category:                   Core-General
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     ready for testing
Asterisk Version:           1.6.0-beta1 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             01-30-2008 11:24 CST
Last Modified:              01-30-2008 16:58 CST
====================================================================== 
Summary:                    SIP username -> defaultuser confuses realtime
system(s)
Description: 
In 1.6.0 the SIP username field was renamed to defaultuser.  The sip.conf
file still works in a deprecated form as username is still allowed and will
give a warning.  Realtime systems (example the res_mysql in addons)
directly use the new field absolutely, which causes a MySQL error.

1- Realtime systems supported should provide a "deprecated" check to see
if the table is still using the username field instead of defaultuser and
then warn the user but continue to work (and internally translate
"defaultuser" into "username"), or

2- Provide suggested workarounds for people that cannot update their
tables immediately.  We have our production server use realtime SIP records
and our test server (now 1.6.0) using realtime SIP records from the same
database for call routing information.  My fix was to create an SQL VIEW
that translates the field names.

Number 1 would be preferable from a user standpoint, but I don't know
enough about the realtime system to know if that is even possible.  At the
very least the UPGRADE file should be updated to let users of realtime SIP
know that username will simply not work anymore, period.
====================================================================== 

---------------------------------------------------------------------- 
 cabal95 - 01-30-08 16:58  
---------------------------------------------------------------------- 
That looks like it works.  I was able to switch the extconfig.conf file to
use the "real" sip users table and it pulled it up fine that time, and also
printed the deprecated warning.  It printed twice, once for my phone and
once for a different phone (though the other phone was offline and
shouldn't have been connecting. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
01-30-08 16:58  cabal95        Note Added: 0081467                          
======================================================================