[asterisk-dev] 1.6.2 beta: Realtime SIP and periodic database queries

Gunnar Schaller linux at nowin.de
Fri Nov 13 10:27:46 CST 2009


Hi,
I just installed Asterisk 1.6.2.0-rc5 and asterisk-addons-1.6.2.0-rc2.
Asterisk is configured to get SIP users from mysql database. I
inserted one user to the sippeers table (with qualify=yes - don't know
if that matter). In sip.conf I have

  rtcachefriends=yes
  rtsavesysname=yes
  rtupdate=yes

After Asterisk starts everything is fine. No periodic database queries
to the sippeers table. Now I register a phone to Asterisk. After that
every 60 seconds (seems to be the parameter qualifyfreq in sip.conf)
Asterisk queries the database: 

   SELECT * FROM ast_sip_user WHERE name = ''
   SELECT * FROM ast_sip_user WHERE name = '' AND host = 'dynamic'
   SELECT * FROM ast_sip_user WHERE name = ''

The result of all queries is empty cause there is no entry with empty
name. Can anybody explain these queries? Any functionality? Or is it a
bug?


Regards,
Gunnar Schaller




More information about the asterisk-dev mailing list