Hello Yehavi,

we did some further investigation during the last days. We got a step further, but we are not finished yet.

What DOES work
What does NOT work
To answer your question:

We have set in the internal profile:
<param name="dbname" value="share_presence"/>
But do be honest; I have no clue where to find "share_presence".
We work with ODBC for the internal profile and I can see 2 tables
Both tables are not filled with any data during the SLA scenario.

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.

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.

Outbound Notify messges contain:
==========================
Notify Message1 to originating phone
Call-Info: <sip:mydomain.org>;appearance-index=*;appearance-state=idle.
Event: line-seize.

Notify Message2 to originating phone
Call-Info: <sip:mydomain.org>;appearance-index=1;appearance-state=alerting;appearance-uri="\"4700\" <sip:4700@mydomain.org>".
Call-Info: <sip:mydomain.org>;appearance-index=*;appearance-state=idle.
Event: call-info.

Notify Message3 to originating phone
Event: presence. (State: "Ring")

Notify Message4 to originating phone after answering the call
Event: presence. (State: Talk")

Notify Message5 to originating phone after answering the call
Call-Info: <sip:mydomain.org>;appearance-index=1;appearance-state=active;appearance-uri="\"Test-4700\"
...

For the incoing call to the SLA phones:
==========================

Notify Message1 to called SLA phone 1 after answering the call (before there as no notify during call setup)
Call-Info: <sip:mydomain.org>;appearance-index=*;appearance-state=idle.
Event: call-info

Notify Message2 to called phone 1
Event: presence. (State: "talk" for calling phone)


Notify Message1 to other SLA phone 2 after answering the call by phone 1 (before there as no notify during call setup)
Call-Info: <sip:mydomain.org>;appearance-index=*;appearance-state=idle.
Event: call-info.

That's all messages until hangup.

Any help and suggestions is appreciated


-- 
With kind regards
Peter Steinbach 

Telefaks Services GmbH
Theo-Geisel-Strasse 25
D 61250 Usingen, Germany
mailto:lists (att) telefaks.de
Internet: www.telefaks.de


Yehavi Bourvine schrieb:
Hello Peter,
 
  I don't see SQL errors here. Note that the [ERR] is the loglevel.
Is the database you gave at the db_name populated with data?
 
                Regards, __Yehavi:

2010/11/12 Peter Steinbach <lists@telefaks.de>
Thanks for the hint,

I set this to the "internal" profile, however this did not work. When
Phone 1 is set to "on hold" I receive a number of SLA2 error messages
which belong to a database connection.
We have set up an odbc database connction which works for the internal
database in all other cases. Do we need special DB settings for this?
I tried to execute the below embedded sql statements manually with the
same sql login and they all work without an error.

What can be the source of these errors?

============================================
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:721 STATE SQL update
sip_dialogs set
call_info='appearance-index=1',call_info_state='alerting' where
hostname='mydomain.org' and uuid='2d21424a-ee69-11df-94ab-3f32128609a9'
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:728 PROCESS PRESENCE EVENT
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1925 PRES SQL select
sip_from_user,sip_from_host,call_info,call_info_state,uuid from
sip_dialogs where hostname='mydomain.org' and sip_from_user='4702' and
sip_from_host='mydomain.org'
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1839 SLA2: 0
[sip_from_user]=[4702]
...
 

_______________________________________________
FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org