[Home]

Summary:ASTERISK-16502: sip.conf register in realtime MySQL DB
Reporter:Jonas Kellens (jonaskellens)Labels:
Date Opened:2010-08-04 08:37:48Date Closed:2011-06-07 14:00:51
Priority:MajorRegression?No
Status:Closed/CompleteComponents:PBX/pbx_realtime
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:I want to have the register => statements in a realtime MySQL-database.

I have defined extconfig.conf :

sipusers => mysql,Asterisk,sip_buddies
sippeers => mysql,Asterisk,sip_buddies
sip.conf => mysql,Asterisk,ast_config

My sip.conf file has several parameters set in the [general]-section, but the registers and sip peers (these are also realtime).

I have defined a table ast_config like this :

id  1
cat_metric  0
var_metric  1
commented  0
filename  sip.conf
category  general
var_name  register
var_val  username:password@sip.provider.net

id  2
cat_metric  0
var_metric  2
commented  0
filename  sip.conf
category  general
var_name  register
var_val  username2:password2@sip.provider.net

When I issue a reload, the registrations go well :

asterisk*CLI> sip show registry
Host                            Username       Refresh State                Reg.Time                
sip.provider.net:5060            username1          165 Registered           Wed, 04 Aug 2010 15:19:11
sip.provider.net:5060               username2          105 Registered           Wed, 04 Aug 2010 15:19:11


However the CLI is flooded with these messages :

[Aug  4 15:20:03] WARNING[20234]: chan_sip.c:18187 build_peer: Qualify is incompatible with dynamic uncached realtime.  Please either turn rtcachefriends on or turn qualify off on peer 'user3'
[Aug  4 15:20:03] WARNING[20234]: chan_sip.c:18187 build_peer: Qualify is incompatible with dynamic uncached realtime.  Please either turn rtcachefriends on or turn qualify off on peer 'user4'
[Aug  4 15:20:03] WARNING[20234]: chan_sip.c:18187 build_peer: Qualify is incompatible with dynamic uncached realtime.  Please either turn rtcachefriends on or turn qualify off on peer 'user5'
[Aug  4 15:20:03] WARNING[20234]: chan_sip.c:18187 build_peer: Qualify is incompatible with dynamic uncached realtime.  Please either turn rtcachefriends on or turn qualify off on peer 'user2'
[Aug  4 15:20:03] WARNING[20234]: chan_sip.c:18187 build_peer: Qualify is incompatible with dynamic uncached realtime.  Please either turn rtcachefriends on or turn qualify off on peer 'user2'


In my sip.conf file I have :

rtcachefriends=yes             ; Cache realtime friends by adding them to the internal list
                               ; just like friends added from the config file only on a
                               ; as-needed basis? (yes|no)

;rtsavesysname=yes              ; Save systemname in realtime database at registration
                               ; Default= no

rtupdate=yes                   ; Send registry updates to database using realtime? (yes|no)
                               ; If set to yes, when a SIP UA registers successfully, the ip address,
                               ; the origination port, the registration period, and the username of
                               ; the UA will be set to database via realtime.
                               ; If not present, defaults to 'yes'. Note: realtime peers will
                               ; probably not function across reloads in the way that you expect, if
                               ; you turn this option off.


And on every peer in the realtime MySQL-database I have qualify on (and I would like to keep it that way)


Question: what is going wrong with the above implementation ?!
Comments:By: Paul Belanger (pabelanger) 2010-08-04 09:38:56

Thanks for your comments. This does not appear to be a bug report and we are closing it. We appreciate the difficulties you are facing, but it would make more sense to raise your question in the support tracker, http://www.asterisk.org/support