| Summary: | ASTERISK-15206: Useless MySQL queries when doing sip qualify | ||
| Reporter: | Gunnar Harms (speedy) | Labels: | |
| Date Opened: | 2009-11-23 18:34:58.000-0600 | Date Closed: | 2010-12-25 03:50:15.000-0600 |
| Priority: | Trivial | Regression? | No |
| Status: | Closed/Complete | Components: | Addons/res_config_mysql |
| Versions: | Frequency of Occurrence | ||
| Related Issues: | |||
| Environment: | Attachments: | ( 0) cli_output.txt | |
| 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 = '' ****** ADDITIONAL INFORMATION ****** (maybe) interesting settings in sip.conf: qualifyfreq=60 rtcachefriends=yes rtsavesysname=yes rtupdate=yes | ||
| Comments: | By: Leif Madsen (lmadsen) 2009-11-23 18:38:44.000-0600 Assigning this to Tilghman for review and possible fix for when he has spare time :) By: Gunnar Harms (speedy) 2009-11-23 18:38:58.000-0600 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@192..." and not "Contact: <sip:16@192...". By: Tilghman Lesher (tilghman) 2010-12-25 03:50:15.000-0600 This is normal behavior. No fix is necessary. | ||