On 17 Oct 2018, at 23:33, Bogdan-Andrei Iancu wrote: > Hi Dan, > > What I failed so far was to reproduced it in a controlled environment. Do you > have a setup, special cfg + SIP UAC , instructions to reproduce this issue ?
I use Blink as the client. I see this every time the proxy receives a PUBLISH request: Oct 19 19:29:55 node15 ./opensips[23510]: [CONFIG] PUBLISH for presence sip:[email protected] origin 86.120.12.1 64:41062 from sip:[email protected] to sip:[email protected] (243988a9-511e-4108-8950-5ab6edf82c3c) Oct 19 19:29:55 node15 ./opensips[23510]: CRITICAL:db_mysql:wrapper_single_mysql_real_query: driver error (1062): Du plicate entry 'dan-test.sip2sip.info-presence-a.1539700118.23510.517.1' for key 'presentity_idx' Oct 19 19:29:55 node15 ./opensips[23510]: ERROR:core:db_do_update: error while submitting query Oct 19 19:29:55 node15 ./opensips[23510]: ERROR:presence:update_presentity: updating published info in database Oct 19 19:29:55 node15 ./opensips[23510]: ERROR:presence:handle_publish: when updating presentity or this: Oct 19 19:29:55 node15 ./opensips[23508]: [CONFIG] PUBLISH for presence sip:[email protected] origin 86.120.12.1 64:39673 from sip:[email protected] to sip:[email protected] (cc4704d0-a5e7-4c78-89ae-4c31b6cb6246) Oct 19 19:29:55 node15 ./opensips[23508]: INFO:presence:update_presentity: *** found in db but not in htable [a.1539 700118.23508.2291.0] Below is the relevant part of my configuration (I included all the presence related modules I load and their configuration as they may be relevant): # The address on which OpenSIPS will listen define(`SERVER_IP', esyscmd(`echo -n $(hostname -i)')) define(`SERVER_UDP_PORT', `5060') define(`SERVER_TCP_PORT', `5060') define(`SERVER_TLS_PORT', `5061') # The server contact address define(`SERVER_ADDRESS', `ifelse(SERVER_UDP_PORT, `5060', `SERVER_IP', `SERVER_IP:SERVER_UDP_PORT')') # Contact used by the presence server define(`PRESENCE_SERVER_ADDRESS', `sip:presence@SERVER_ADDRESS') # Contact used by the resource list server define(`RLS_SERVER_ADDRESS', `sip:rls@SERVER_ADDRESS') loadmodule "presence.so" loadmodule "xcap.so" loadmodule "presence_xml.so" loadmodule "presence_mwi.so" loadmodule "pua.so" loadmodule "pua_mi.so" loadmodule "rls.so" loadmodule "presence_xcapdiff.so" modparam("presence", "db_url", "MySQL_URI") modparam("presence", "server_address", "PRESENCE_SERVER_ADDRESS") modparam("presence", "fallback2db", 1) modparam("presence", "clean_period", 30) modparam("presence", "notify_offline_body", 0) modparam("presence_xml", "pres_rules_auid", "org.openmobilealliance.pres-rules") modparam("presence_xml", "force_active", 0) modparam("presence_xml", "pidf_manipulation", 1) modparam("presence_xml", "generate_offline_body", 0) modparam("pua", "db_url", "MySQL_URI") modparam("xcap", "db_url", "MySQL_URI") modparam("xcap", "integrated_xcap_server", 1) modparam("rls", "server_address", "RLS_SERVER_ADDRESS") modparam("rls", "to_presence_code", 5) modparam("rls", "waitn_time", 10) route { if ($rm == "PUBLISH") { if (is_from_local()) { if (!proxy_authorize("", "SUBSCRIBER_TABLE")) { proxy_challenge("", "0"); return; } else if ($au != $fU) { sl_send_reply("403", "Username!=From not allowed ($au!=$fU)"); return; } if ($rd == "") { $rd = $fd; } if (avp_check("$hdr(Event)", "fm/presence*/i") && ($au != $rU || $ar != $rd)) { sl_send_reply("403", "Publishing $hdr(Event) events for others is forbidden"); return; } # Hide auth credentials to downstream routers consume_credentials(); } else { sl_send_reply("403", "PUBLISH forbidden for outside domains"); return; } if (t_newtran()) { handle_publish(); } else { sl_reply_error(); } exit; } } -- Dan _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
