<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hello Yehavi,<br>
<br>
we did some further investigation during the last days. We got a step
further, but we are not finished yet.<br>
<br>
What DOES work<br>
<ul>
<li>BLF works generally on both phones</li>
<li>SLA works when SLA phones inititiate a call to another phone: We
can switch between the phones with "hold".</li>
</ul>
What does NOT work<br>
<ul>
<li>when SLA phones receive a call, both can take the call but cannot
share the line, even the BLF lamp is off</li>
</ul>
To answer your question:<br>
<br>
We have set in the internal profile:<br>
<param name="dbname" value="share_presence"/><br>
But do be honest; I have no clue where to find "share_presence". <br>
We work with ODBC for the internal profile and I can see 2 tables<br>
<ul>
<li>sip_shared_appearance_dialogs</li>
<li>sip_shared_appearance_subscriptions</li>
</ul>
Both tables are not filled with any data during the SLA scenario.<br>
<br>
I also grepped for "share_presence" in the files in
/usr/local/freeswitch/db , but there is no "share_presence" entry in
any of the files.<br>
<br>
By SIP tracing the NOTIFY messages between phones an Freeswitch we have
different behaviour in an outbound SLA und inbound SLA scenario. In the
inbound secanrio we have no messages with "appearance-state=active" nor
"appearance-state=alerting" to any phone. In the outbound scenario we
do have.<br>
<br>
Outbound Notify messges contain:<br>
==========================<br>
Notify Message1 to originating phone<br>
Call-Info:
<a class="moz-txt-link-rfc2396E" href="sip:mydomain.org"><sip:mydomain.org></a>;appearance-index=*;appearance-state=idle.<br>
Event: line-seize.<br>
<br>
Notify Message2 to originating phone<br>
Call-Info:
<a class="moz-txt-link-rfc2396E" href="sip:mydomain.org"><sip:mydomain.org></a>;appearance-index=1;appearance-state=alerting;appearance-uri="\"4700\"
<a class="moz-txt-link-rfc2396E" href="sip:4700@mydomain.org"><sip:4700@mydomain.org></a>".<br>
Call-Info:
<a class="moz-txt-link-rfc2396E" href="sip:mydomain.org"><sip:mydomain.org></a>;appearance-index=*;appearance-state=idle.<br>
Event: call-info.<br>
<br>
Notify Message3 to originating phone<br>
Event: presence. (State: "Ring")<br>
<br>
Notify Message4 to originating phone after answering the call<br>
Event: presence. (State: Talk")<br>
<br>
Notify Message5 to originating phone after answering the call<br>
Call-Info:
<a class="moz-txt-link-rfc2396E" href="sip:mydomain.org"><sip:mydomain.org></a>;appearance-index=1;appearance-state=active;appearance-uri="\"Test-4700\"<br>
...<br>
<br>
For the incoing call to the SLA phones:<br>
==========================<br>
<br>
Notify Message1 to called SLA phone 1 after answering the call (before
there as no notify during call setup)<br>
Call-Info:
<a class="moz-txt-link-rfc2396E" href="sip:mydomain.org"><sip:mydomain.org></a>;appearance-index=*;appearance-state=idle.<br>
Event: call-info<br>
<br>
Notify Message2 to called phone 1<br>
Event: presence. (State: "talk" for calling phone)<br>
<br>
<br>
Notify Message1 to other SLA phone 2 after answering the call by phone
1 (before there as no notify during call setup)<br>
Call-Info:
<a class="moz-txt-link-rfc2396E" href="sip:mydomain.org"><sip:mydomain.org></a>;appearance-index=*;appearance-state=idle.<br>
Event: call-info.<br>
<br>
That's all messages until hangup.<br>
<br>
Any help and suggestions is appreciated<br>
<br>
<br>
<pre class="moz-signature" cols="72">--
With kind regards
Peter Steinbach
Telefaks Services GmbH
Theo-Geisel-Strasse 25
D 61250 Usingen, Germany
<a class="moz-txt-link-freetext" href="mailto:lists">mailto:lists</a> (att) telefaks.de
Internet: <a class="moz-txt-link-abbreviated" href="http://www.telefaks.de">www.telefaks.de</a>
</pre>
<br>
<br>
Yehavi Bourvine schrieb:
<blockquote
cite="mid:AANLkTikMzgh6Uki7aZsfT37a6qH8oWhcZHzZ6k4c+eGg@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Hello Peter,</div>
<div> </div>
<div> I don't see SQL errors here. Note that the [ERR] is the
loglevel.</div>
<div>Is the database you gave at the db_name populated with data?</div>
<div> </div>
<div> Regards, __Yehavi:<br>
<br>
</div>
<div class="gmail_quote">2010/11/12 Peter Steinbach <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:lists@telefaks.de">lists@telefaks.de</a>></span><br>
<blockquote
style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;"
class="gmail_quote">Thanks for the hint,<br>
<br>
I set this to the "internal" profile, however this did not work. When<br>
Phone 1 is set to "on hold" I receive a number of SLA2 error messages<br>
which belong to a database connection.<br>
We have set up an odbc database connction which works for the internal<br>
database in all other cases. Do we need special DB settings for this?<br>
I tried to execute the below embedded sql statements manually with the<br>
same sql login and they all work without an error.<br>
<br>
What can be the source of these errors?<br>
<br>
============================================<br>
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:721 STATE SQL update<br>
sip_dialogs set<br>
call_info='appearance-index=1',call_info_state='alerting' where<br>
hostname='<a moz-do-not-send="true" href="http://mydomain.org/"
target="_blank">mydomain.org</a>' and
uuid='2d21424a-ee69-11df-94ab-3f32128609a9'<br>
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:728 PROCESS PRESENCE
EVENT<br>
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1925 PRES SQL select<br>
<div class="im">sip_from_user,sip_from_host,call_info,call_info_state,uuid
from<br>
sip_dialogs where hostname='<a moz-do-not-send="true"
href="http://mydomain.org/" target="_blank">mydomain.org</a>' and
sip_from_user='4702' and<br>
sip_from_host='<a moz-do-not-send="true" href="http://mydomain.org/"
target="_blank">mydomain.org</a>'<br>
</div>
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1839 SLA2: 0<br>
[sip_from_user]=[4702]<br>
</blockquote>
<div>...</div>
<div> </div>
</div>
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">
</pre>
</body>
</html>