[asterisk-bugs] [Asterisk 0016315]: Useless MySQL queries when doing sip qualify

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16315 
====================================================================== 
Reported By:                speedy
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   16315
Category:                   Addons/res_config_mysql
Reproducibility:            always
Severity:                   trivial
Priority:                   normal
Status:                     acknowledged
Asterisk Version:           1.6.2.0-rc6 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-11-23 18:34 CST
Last Modified:              2009-11-23 18:38 CST
====================================================================== 
Summary:                    Useless MySQL queries when doing sip qualify
Description: 
Asterisk 1.6.2.0-rc6 with Asterisk-addons 1.6.2.0-rc2. SIP users/peers in
MySQL database with Asterisk realtime. One "type=friend" account with name
"snom" is configured in database table with "qualify=yes". Snom phone with
firmware 7.3.27 is configured with this account (on Identity 11). Every
time Asterisk does a sip qualify (60 seconds interval) there are useless
MySQL queries (empty result):
SELECT * FROM sip_user WHERE name = ''
SELECT * FROM sip_user WHERE name = '' AND host = 'dynamic'
SELECT * FROM sip_user WHERE name = ''
====================================================================== 

---------------------------------------------------------------------- 
 (0114186) speedy (reporter) - 2009-11-23 18:38
 https://issues.asterisk.org/view.php?id=16315#c114186 
---------------------------------------------------------------------- 
I added the Asterisk cli output with the sip traces. Asterisk is on
192.168.101.250 and the Snom phone is on 192.168.101.19. Please note the
"Contact" line in the response of the Snom phone. Maybe that is interesting
cause that should be "Contact: <sip:snom at 192..." and not "Contact:
<sip:16 at 192...". 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-11-23 18:38 speedy         Note Added: 0114186                          
======================================================================