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 _______________________________________________ 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