No subject


Thu Jan 29 11:41:19 CET 2009


messages body, only rlmi parts are provided.

In fact it seems rls_handle_subscribe has issues when trying to send
Subscribes to Presence on behalf of rls. I have systematically errors
"presence:get_stored_info: record not found in hash_table" and sometimes
"Duplicate entry 'sip:alice-list at promethee.test.com-cbb99ea81711c30ed9c0edf6'
for key 2"

Typically:
Apr 26 13:45:57 [20047] ERROR:db_mysql:db_mysql_do_prepared_query: driver
error: Duplicate entry
'sip:alice-list at promethee.test.com-cbb99ea81711c30ed9c0edf6' for key 2
Apr 26 13:45:57 [20047] ERROR:presence:update_db_subs: unsuccessful sql
insert
Apr 26 13:46:01 [20045] ERROR:presence:get_stored_info: record not found in
hash_table
Apr 26 13:46:01 [20045] ERROR:presence:handle_subscribe: getting stored info
Apr 26 13:46:11 [20045] ERROR:presence:get_stored_info: record not found in
hash_table
Apr 26 13:46:11 [20045] ERROR:presence:handle_subscribe: getting stored info
Apr 26 13:46:21 [20045] ERROR:presence:get_stored_info: record not found in
hash_table
Apr 26 13:46:21 [20045] ERROR:presence:handle_subscribe: getting stored info
Apr 26 14:25:40 [20586] ERROR:presence:get_stored_info: record not found in
hash_table
Apr 26 14:25:40 [20586] ERROR:presence:handle_subscribe: getting stored info
Apr 26 14:25:45 [20586] ERROR:presence:get_stored_info: record not found in
hash_table
Apr 26 14:25:45 [20586] ERROR:presence:handle_subscribe: getting stored info
Apr 26 14:25:50 [20586] ERROR:presence:get_stored_info: record not found in
hash_table
Apr 26 14:25:50 [20586] ERROR:presence:handle_subscribe: getting stored info
Apr 26 14:25:55 [20586] ERROR:presence:get_stored_info: record not found in
hash_table
Apr 26 14:25:55 [20586] ERROR:presence:handle_subscribe: getting stored info
Apr 26 14:26:05 [20586] ERROR:presence:get_stored_info: record not found in
hash_table
Apr 26 14:26:05 [20586] ERROR:presence:handle_subscribe: getting stored info
Apr 26 14:26:09 [20586] ERROR:presence:get_stored_info: record not found in
hash_table
Apr 26 14:26:09 [20586] ERROR:presence:handle_subscribe: getting stored info

My main settings for presence and rls modules are:

modparam("presence|presence_xml",
"db_url","mysql://opensips:opensipsrw@localhost/opensips")
modparam("presence", "server_address", "sip:pres at 10.62.0.155:5060")
modparam("presence", "clean_period",  30)
modparam("presence_xml", "integrated_xcap_server", 1)

modparam("pua", "db_url", "mysql://opensips:opensipsrw@localhost/opensips")

# -- rls parameters --
modparam("rls","db_url", "mysql://opensips:opensipsrw@localhost/opensips")
modparam("rls", "server_address", "sip:rls at 10.62.0.155:5060")
modparam("rls", "integrated_xcap_server", 1)
modparam("rls", "xcap_root","http://promethee.test.com:8888/xcap-root" )
modparam("rls", "presence_server", "sip:pres at 10.62.0.155:5060")
modparam("rls", "to_presence_code", 10)
modparam("xcap_client","periodical_query",1)
modparam("xcap_client","query_period",10)
modparam("xcap_client","db_url", "mysql://opensips:opensipsrw@localhost
/opensips")

I can send you the routing rules if neeeded.

Could you please help us?

Many thanks

Andrew

--0016e65b5dd678a22204852304ac
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,<br><br>First of all we would like to thank the whole opensips team. For=
 testing our client, we are mainly interested in the presence and rls topic=
s and found that a pretty good set of features is available right now, so t=
hanks for your job.<br>
<br>During our tests we encountered an issue running opensips 1.6 in rls-se=
rver mode (simple presence works fine). It seems to us it is just a configu=
ration issue or a bug in the routing rules, but we can&#39;t find out it.<b=
r>
<br>From the client point of view I cannot succeed in receiving presence No=
tify messages body, only rlmi parts are provided.<br><br>In fact it seems r=
ls_handle_subscribe has issues when trying to send Subscribes to Presence o=
n behalf of rls. I have systematically errors &quot;presence:get_stored_inf=
o: record not found in hash_table&quot; and sometimes &quot;Duplicate entry=
=20
&#39;sip:alice-list at promethee.test.com-cbb99ea81711c30ed9c0edf6&#39; for=20
key 2&quot;<br><br>Typically:<br>Apr 26 13:45:57 [20047] ERROR:db_mysql:db_=
mysql_do_prepared_query: driver error: Duplicate entry &#39;sip:alice-list@=
promethee.test.com-cbb99ea81711c30ed9c0edf6&#39; for key 2<br>Apr 26 13:45:=
57 [20047] ERROR:presence:update_db_subs: unsuccessful sql insert<br>
Apr 26 13:46:01 [20045] ERROR:presence:get_stored_info: record not found in=
 hash_table<br>Apr 26 13:46:01 [20045] ERROR:presence:handle_subscribe: get=
ting stored info<br>Apr 26 13:46:11 [20045] ERROR:presence:get_stored_info:=
 record not found in hash_table<br>
Apr 26 13:46:11 [20045] ERROR:presence:handle_subscribe: getting stored inf=
o<br>Apr 26 13:46:21 [20045] ERROR:presence:get_stored_info: record not fou=
nd in hash_table<br>Apr 26 13:46:21 [20045] ERROR:presence:handle_subscribe=
: getting stored info<br>
Apr 26 14:25:40 [20586] ERROR:presence:get_stored_info: record not found in=
 hash_table<br>Apr 26 14:25:40 [20586] ERROR:presence:handle_subscribe: get=
ting stored info<br>Apr 26 14:25:45 [20586] ERROR:presence:get_stored_info:=
 record not found in hash_table<br>
Apr 26 14:25:45 [20586] ERROR:presence:handle_subscribe: getting stored inf=
o<br>Apr 26 14:25:50 [20586] ERROR:presence:get_stored_info: record not fou=
nd in hash_table<br>Apr 26 14:25:50 [20586] ERROR:presence:handle_subscribe=
: getting stored info<br>
Apr 26 14:25:55 [20586] ERROR:presence:get_stored_info: record not found in=
 hash_table<br>Apr 26 14:25:55 [20586] ERROR:presence:handle_subscribe: get=
ting stored info<br>Apr 26 14:26:05 [20586] ERROR:presence:get_stored_info:=
 record not found in hash_table<br>
Apr 26 14:26:05 [20586] ERROR:presence:handle_subscribe: getting stored inf=
o<br>Apr 26 14:26:09 [20586] ERROR:presence:get_stored_info: record not fou=
nd in hash_table<br>Apr 26 14:26:09 [20586] ERROR:presence:handle_subscribe=
: getting stored info<br>
<br>My main settings for presence and rls modules are:<br><br>modparam(&quo=
t;presence|presence_xml&quot;, &quot;db_url&quot;,&quot;mysql://opensips:op=
ensipsrw at localhost/opensips&quot;)<br>modparam(&quot;presence&quot;, &quot;=
server_address&quot;, &quot;<a href=3D"http://sip:pres@10.62.0.155:5060">si=
p:pres at 10.62.0.155:5060</a>&quot;)<br>
modparam(&quot;presence&quot;, &quot;clean_period&quot;,=A0 30)<br>modparam=
(&quot;presence_xml&quot;, &quot;integrated_xcap_server&quot;, 1)<br><br>mo=
dparam(&quot;pua&quot;, &quot;db_url&quot;, &quot;mysql://opensips:opensips=
rw at localhost/opensips&quot;)<br>
<br># -- rls parameters --<br>modparam(&quot;rls&quot;,&quot;db_url&quot;, =
&quot;mysql://opensips:opensipsrw@localhost/opensips&quot;)<br>modparam(&qu=
ot;rls&quot;, &quot;server_address&quot;, &quot;<a href=3D"http://sip:rls@1=
0.62.0.155:5060">sip:rls at 10.62.0.155:5060</a>&quot;)<br>
modparam(&quot;rls&quot;, &quot;integrated_xcap_server&quot;, 1)<br>modpara=
m(&quot;rls&quot;, &quot;xcap_root&quot;,&quot;<a href=3D"http://promethee.=
test.com:8888/xcap-root">http://promethee.test.com:8888/xcap-root</a>&quot;=
 )<br>
modparam(&quot;rls&quot;, &quot;presence_server&quot;, &quot;<a href=3D"htt=
p://sip:pres@10.62.0.155:5060">sip:pres at 10.62.0.155:5060</a>&quot;)<br>modp=
aram(&quot;rls&quot;, &quot;to_presence_code&quot;, 10)<br>modparam(&quot;x=
cap_client&quot;,&quot;periodical_query&quot;,1)<br>
modparam(&quot;xcap_client&quot;,&quot;query_period&quot;,10)<br>modparam(&=
quot;xcap_client&quot;,&quot;db_url&quot;, &quot;mysql://opensips:opensipsr=
w at localhost/opensips&quot;)<br><br>I can send you the routing rules if neee=
ded.<br>
<br>Could you please help us? <br><br>Many thanks<br><br>Andrew<br>

--0016e65b5dd678a22204852304ac--



More information about the Users mailing list