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

[Tilghman Lesher]

On Friday 13 November 2009 10:27:46 Gunnar Schaller wrote:
> 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?

To verify either way, we'd need to see the progress of 'sip set debug on' in
line with when the queries are performed.  It may be that this particular
SIP client is responding in a non-typical way, and we'd need to determine
the correct way to fix that.

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org