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

[Asterisk Bug Tracker]

The following issue has been CLOSED 
====================================================================== 
https://issues.asterisk.org/view.php?id=16315 
====================================================================== 
Reported By:                speedy
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   16315
Category:                   Addons/res_config_mysql
Reproducibility:            always
Severity:                   trivial
Priority:                   normal
Status:                     closed
Asterisk Version:           SVN 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
Resolution:                 not fixable
Fixed in Version:           
====================================================================== 
Date Submitted:             2009-11-23 18:34 CST
Last Modified:              2010-12-25 03:50 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 = ''
====================================================================== 

---------------------------------------------------------------------- 
 (0129964) tilghman (manager) - 2010-12-25 03:50
 https://issues.asterisk.org/view.php?id=16315#c129964 
---------------------------------------------------------------------- 
This is normal behavior.  No fix is necessary. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-12-25 03:50 tilghman       Asterisk Version         1.6.2.0-rc6 => SVN  
2010-12-25 03:50 tilghman       Note Added: 0129964                          
2010-12-25 03:50 tilghman       Status                   acknowledged => closed
2010-12-25 03:50 tilghman       Resolution               open => not fixable 
======================================================================