[SR-Users] Entries in PUA List and RLS Watchers List

[Sangeeta Shah]

Can anyone provide any guidance on what the rls server_address and
outboundproxy params values should be set to when using the kamailio
server as a combined presence/rls/xcap server.

I am not sure why - but the code seems to be looping in the following
calls causing several hundreds rls_watchers and pua entries for the
same presentity:

Oct 23 10:33:34 RCS-Presence /usr/local/sbin/kamailio[26439]: DEBUG:
rls [notify.c:1036]: calling myself for rl_node
Oct 23 10:33:34 RCS-Presence /usr/local/sbin/kamailio[26440]: DEBUG:
pua [send_subscribe.c:674]: record for subscribe from
sip:8475551001 at 10.50.251.12 to sip:8475551001 at 10.50.251.12 inserted in
datatbase

Not sure if it's my configuration settings or the contents of the
resource-list xml.


Thanks,
Sangeeta

On Tue, Oct 23, 2012 at 10:35 AM, Sangeeta Shah <sangeeta.shah at gmail.com> wrote:
> Thanks for the response.
> I did drop the uniqueness on the expires_idx INDEX for the pua table.
>
> Now I see this error in the syslog:
> Oct 23 10:33:42 RCS-Presence /usr/local/sbin/kamailio[26439]: ERROR:
> db_mysql [km_dbase.c:122]: driver error on query: Duplicate entry
> '2ee709f03a582d75-26439 at 127.0.0.1-533cb9e91f4b999cf76861cbb9ed54e' for
> key 'pua_idx'
>
>
> Also, as I reported earlier as soon as my client connects to the
> server there are tons of entries for the same
> pres_uri in the pua and rls_watchers table.
>
> For instance:
> | 2386 | sip:8475551001 at 10.50.251.12 | 8475551001 | 10.50.251.12 |
> 8475551001       | 10.50.251.12   | presence |          |
> a6a1c5f60faecf035a1ae5b6e96e979a-fc8a |
> 533cb9e91f4b999cf76861cbb9ed54ed-ccda |
> 2ee709f03a582f8a-26438 at 127.0.0.1     |          0 |          10 |
> sip:10.50.251.12:5060                          |              |
> 1351013694 |      0 |        |       1 | udp:10.50.251.12:5060 |
> sip:10.50.251.12:5060 | 8475551001 | 10.50.251.12 |      -1 |
>
> | 2387 | sip:8475551001 at 10.50.251.12 | 8475551001 | 10.50.251.12 |
> 8475551001       | 10.50.251.12   | presence |          |
> a6a1c5f60faecf035a1ae5b6e96e979a-9fd1 |
> 533cb9e91f4b999cf76861cbb9ed54ed-0f88 |
> 2ee709f03a582f77-26441 at 127.0.0.1     |          0 |          10 |
> sip:10.50.251.12:5060                          |              |
> 1351013694 |      0 |        |       1 | udp:10.50.251.12:5060 |
> sip:10.50.251.12:5060 | 8475551001 | 10.50.251.12 |      16 |
>
> | 2388 | sip:8475551001 at 10.50.251.12 | 8475551001 | 10.50.251.12 |
> 8475551001       | 10.50.251.12   | presence |          |
> a6a1c5f60faecf035a1ae5b6e96e979a-12d0 |
> 533cb9e91f4b999cf76861cbb9ed54ed-c4da |
> 2ee709f03a582f70-26440 at 127.0.0.1     |          0 |          10 |
> sip:10.50.251.12:5060                          |              |
> 1351013694 |      0 |        |       1 | udp:10.50.251.12:5060 |
> sip:10.50.251.12:5060 | 8475551001 | 10.50.251.12 |       0 |
>
>
> This is what I have in my config file:
>
> # ------rls module params ------
> modparam("rls", "db_url", DBURL)
> modparam("rls", "db_mode", 2)
> modparam("rls", "integrated_xcap_server", 1)
> modparam("rls", "to_presence_code" ,10)
> modparam("rls", "server_address", "sip:rls@<kamailioip>:5060")
>
>
> #!endif
>
> and
> modparam("pua_reginfo", "default_domain", "ip")
> modparam("pua_reginfo", "server_address", "sip:reginfo@<kamailioip>")
> modparam("pua", "db_mode", 2)
>
> Is this correct? Am I missing something. Why are so many entries
> getting created in these two tables for the same presentity? I don't
> see any other errors in the syslog. I have Kamailio v 3.3.1
>
> Thanks,
> Sangeeta
>
> On Tue, Oct 23, 2012 at 12:44 AM, Juha Heinanen <jh at tutpro.com> wrote:
>> Sangeeta Shah writes:
>>
>>> Only error I see in the syslog:
>>> Oct 22 15:22:22 RCS-Presence /usr/local/sbin/kamailio[11745]: ERROR:
>>> db_mysql [km_dbase.c:122]: driver error on query: Duplicate entry
>>> '1350937406' for key 'expires_idx'
>>
>> if this comes from pua table, check that the index has been defined like
>> this:
>>
>> CREATE INDEX expires_idx ON pua (expires)
>>
>> i.e., the index should not be unique.  if i remember correctly, the
>> index was unique at some point, which it should not have been.
>>
>> -- juha
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
>
> --
> Sangeeta Shah



-- 
Sangeeta Shah