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

[Asterisk Bug Tracker]

The following issue has been ASSIGNED. 
====================================================================== 
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 = ''
====================================================================== 

---------------------------------------------------------------------- 
 (0114185) lmadsen (administrator) - 2009-11-23 18:38
 https://issues.asterisk.org/view.php?id=16315#c114185 
---------------------------------------------------------------------- 
Assigning this to Tilghman for review and possible fix for when he has
spare time :) 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-11-23 18:38 lmadsen        Note Added: 0114185                          
2009-11-23 18:38 lmadsen        Assigned To               => tilghman        
======================================================================