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@10.50.251.12 to sip:8475551001@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.s...@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@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@10.50.251.12 | 8475551001 | 10.50.251.12 | > 8475551001 | 10.50.251.12 | presence | | > a6a1c5f60faecf035a1ae5b6e96e979a-fc8a | > 533cb9e91f4b999cf76861cbb9ed54ed-ccda | > 2ee709f03a582f8a-26438@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@10.50.251.12 | 8475551001 | 10.50.251.12 | > 8475551001 | 10.50.251.12 | presence | | > a6a1c5f60faecf035a1ae5b6e96e979a-9fd1 | > 533cb9e91f4b999cf76861cbb9ed54ed-0f88 | > 2ee709f03a582f77-26441@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@10.50.251.12 | 8475551001 | 10.50.251.12 | > 8475551001 | 10.50.251.12 | presence | | > a6a1c5f60faecf035a1ae5b6e96e979a-12d0 | > 533cb9e91f4b999cf76861cbb9ed54ed-c4da | > 2ee709f03a582f70-26440@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 <j...@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@lists.sip-router.org >> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > > > > -- > Sangeeta Shah -- Sangeeta Shah _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users