[Freeswitch-users] Shared Line exprience with Polycom - how to get it to work
Peter Steinbach
lists at telefaks.de
Fri Nov 12 07:16:29 PST 2010
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]
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1839 SLA2: 1
[sip_from_host]=[mydomain.org]
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1839 SLA2: 2
[call_info]=[appearance-index=1]
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1839 SLA2: 3
[call_info_state]=[seized]
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1839 SLA2: 4 [uuid]=[]
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1839 SLA2: 0
[sip_from_user]=[4702]
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1839 SLA2: 1
[sip_from_host]=[mydomain.org]
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1839 SLA2: 2
[call_info]=[appearance-index=1]
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1839 SLA2: 3
[call_info_state]=[alerting]
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1839 SLA2: 4
[uuid]=[2d21424a-ee69-11df-94ab-3f32128609a9]
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1946 PRES SQL select
call_id,expires,sub_to_user,sub_to_host,event from sip_subscriptions
where expires > -1 and hostname='mydomain.org' and sub_to_user='4702'
and sub_to_host='mydomain.org' and (event='call-info' or event='line-seize')
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 0
[call_id]=[bc32fbfd-4b66fb94-4b2aeeef at xxx.xxx.xxx.198]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 1
[expires]=[1289572193]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 2
[sub_to_user]=[4702]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 3
[sub_to_host]=[mydomain.org]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 4
[event]=[line-seize]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 0
[call_id]=[f65cf80e-7c279841-ff71ea48 at xxx.xxx.xxx.198]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 1
[expires]=[1289577607]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 2
[sub_to_user]=[4702]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 3
[sub_to_host]=[mydomain.org]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 4
[event]=[call-info]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 0
[call_id]=[f65cf80e-7c279841-ff71ea48 at xxx.xxx.xxx.194]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 1
[expires]=[1289577611]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 2
[sub_to_user]=[4702]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 3
[sub_to_host]=[mydomain.org]
2010-11-12 15:28:54.136194 [ERR] sofia_presence.c:1773 SLA3: 4
[event]=[call-info]
--
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:
> Hi Peter,
>
> 1. Set also the following parameters:
> <param name="dbname" value="share_presence"/>
> <param name="presence-hosts" value="$${domain}"/>
> 2. At the phone do NOT set the third party name.
>
> You can also have a look at
> http://wiki.freeswitch.org/wiki/Polycom_configuration
>
> regards, __Yehavi:
>
> 2010/11/10 Peter Steinbach <lists at telefaks.de <mailto:lists at telefaks.de>>
>
> Hello,
>
> we followed the advices in
> http://wiki.freeswitch.org/wiki/Shared_Line_Appearance
> and set
> <param name="manage-shared-appearance" value="true"/>
> in the internal profile. Also presence handling is enabled.
>
> In the Polycom phone settings we set
> reg.1.type="shared"
> reg.1.bargeInEnabled="1"
> reg.1.callsPerLineKey="1"
> according to the wiki and the Polycom documentation
>
> In phone1.cfg we set
> divert.1.sharedDisabled="0"
>
> and in sip.cfg we set
> call.shared.disableDivert="1"
> reg.1.bargeInEnabled="1"
>
> When we call the destination number,
> - both phones ring
> - we pick up one phone
> - other phone stops ringing
> - we press "hold" on the active phone
> - nothings happens to the other phone
>
> Are we doing something wrong here? We work with Polycom FW 3.2.3 and
> Freeswitch GIT compiled last friday.
>
> Strange is, that Freeswitch shows a number of error messages
> related to
> SQL (we use ODBC), although all SQL statements are valid and can be
> sucessfully executed on the MySQL CLI. Also we do see records in
> sip_dialogs but not a single record in sip_presence.
>
> Any hints? What did you do to get this working?
>
> Here are the error messages from freeswitch.log
> ==================================
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:721 STATE SQL update
> sip_dialogs set call_info='appearance-index=1',call_info_state='idle'
> where hostname='mydomain.org <http://mydomain.org/>' and
> uuid='d80df99a-ece4-11df-ab6f-f761d81a6b8a'
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:728 PROCESS
> PRESENCE EVENT
> 2010-11-10 17:09:13.329549 [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 <http://mydomain.org/>'
> and sip_from_user='4702' and
> sip_from_host='mydomain.org <http://mydomain.org/>'
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:1946 PRES SQL select
> call_id,expires,sub_to_user,sub_to_host,event from sip_subscriptions
> where expires > -1 and hostname='mydomain.org
> <http://mydomain.org/>' and sub_to_user='4702'
> and sub_to_host='mydomain.org <http://mydomain.org/>' and
> (event='call-info' or event='line-seize')
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:1773 SLA3: 0
> [call_id]=[a1859461-5362d6a6-c25a8bff at 172.xx.xx.xx]
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:1773 SLA3: 1
> [expires]=[1289412326]
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:1773 SLA3: 2
> [sub_to_user]=[4702]
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:1773 SLA3: 3
> [sub_to_host]=[mydomain.org <http://mydomain.org/>]
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:1773 SLA3: 4
> [event]=[call-info]
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:1773 SLA3: 0
> [call_id]=[536c87c6-b366418f-2260bca4 at 172.21.20.194
> <mailto:536c87c6-b366418f-2260bca4 at 172.21.20.194>]
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:1773 SLA3: 1
> [expires]=[1289412332]
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:1773 SLA3: 2
> [sub_to_user]=[4702]
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:1773 SLA3: 3
> [sub_to_host]=[mydomain.org <http://mydomain.org/>]
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:1773 SLA3: 4
> [event]=[call-info]
> 2010-11-10 17:09:13.329549 [ERR] sofia_presence.c:1961 CLEAR SQL
> delete
> from sip_dialogs where sip_from_user='4702' and
> sip_from_host='mydomain.org <http://mydomain.org/>' and
> call_info_state='seized'
> 2010-11-10 17:09:13.330530 [ERR] sofia_presence.c:721 STATE SQL update
> sip_dialogs set call_info='appearance-index=1',call_info_state='idle'
> where hostname='mydomain.org <http://mydomain.org/>' and
> uuid='d80df99a-ece4-11df-ab6f-f761d81a6b8a'
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:728 PROCESS
> PRESENCE EVENT
> 2010-11-10 17:09:13.331511 [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 <http://mydomain.org/>'
> and sip_from_user='4702' and
> sip_from_host='mydomain.org <http://mydomain.org/>'
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:1946 PRES SQL select
> call_id,expires,sub_to_user,sub_to_host,event from sip_subscriptions
> where expires > -1 and hostname='mydomain.org
> <http://mydomain.org/>' and sub_to_user='4702'
> and sub_to_host='mydomain.org <http://mydomain.org/>' and
> (event='call-info' or event='line-seize')
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:1773 SLA3: 0
> [call_id]=[a1859461-5362d6a6-c25a8bff at 172.xx.xx.xx]
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:1773 SLA3: 1
> [expires]=[1289412326]
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:1773 SLA3: 2
> [sub_to_user]=[4702]
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:1773 SLA3: 3
> [sub_to_host]=[mydomain.org <http://mydomain.org/>]
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:1773 SLA3: 4
> [event]=[call-info]
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:1773 SLA3: 0
> [call_id]=[536c87c6-b366418f-2260bca4 at 172.21.20.194
> <mailto:536c87c6-b366418f-2260bca4 at 172.21.20.194>]
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:1773 SLA3: 1
> [expires]=[1289412332]
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:1773 SLA3: 2
> [sub_to_user]=[4702]
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:1773 SLA3: 3
> [sub_to_host]=[mydomain.org <http://mydomain.org/>]
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:1773 SLA3: 4
> [event]=[call-info]
> 2010-11-10 17:09:13.331511 [ERR] sofia_presence.c:1961 CLEAR SQL
> delete
> from sip_dialogs where sip_from_user='4702' and
> sip_from_host='mydomain.org <http://mydomain.org/>' and
> call_info_state='seized'
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:721 STATE SQL update
> sip_dialogs set call_info='appearance-index=1',call_info_state='idle'
> where hostname='mydomain.org <http://mydomain.org/>' and
> uuid='d80df99a-ece4-11df-ab6f-f761d81a6b8a'
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:728 PROCESS
> PRESENCE EVENT
> 2010-11-10 17:09:13.332492 [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 <http://mydomain.org/>'
> and sip_from_user='4702' and
> sip_from_host='mydomain.org <http://mydomain.org/>'
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:1946 PRES SQL select
> call_id,expires,sub_to_user,sub_to_host,event from sip_subscriptions
> where expires > -1 and hostname='mydomain.org
> <http://mydomain.org/>' and sub_to_user='4702'
> and sub_to_host='mydomain.org <http://mydomain.org/>' and
> (event='call-info' or event='line-seize')
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:1773 SLA3: 0
> [call_id]=[a1859461-5362d6a6-c25a8bff at 172.xx.xx.xx]
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:1773 SLA3: 1
> [expires]=[1289412326]
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:1773 SLA3: 2
> [sub_to_user]=[4702]
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:1773 SLA3: 3
> [sub_to_host]=[mydomain.org <http://mydomain.org/>]
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:1773 SLA3: 4
> [event]=[call-info]
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:1773 SLA3: 0
> [call_id]=[536c87c6-b366418f-2260bca4 at 172.21.20.194
> <mailto:536c87c6-b366418f-2260bca4 at 172.21.20.194>]
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:1773 SLA3: 1
> [expires]=[1289412332]
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:1773 SLA3: 2
> [sub_to_user]=[4702]
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:1773 SLA3: 3
> [sub_to_host]=[mydomain.org <http://mydomain.org/>]
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:1773 SLA3: 4
> [event]=[call-info]
> 2010-11-10 17:09:13.332492 [ERR] sofia_presence.c:1961 CLEAR SQL
> delete
> from sip_dialogs where sip_from_user='4702' and
> sip_from_host='mydomain.org <http://mydomain.org/>' and
> call_info_state='seized'
>
> --
> With kind regards
> Peter Steinbach
>
> Telefaks Services GmbH
> Theo-Geisel-Strasse 25
> D 61250 Usingen, Germany
> mailto:lists at telefaks.de <mailto:lists at telefaks.de>
> Internet: www.telefaks.de <http://www.telefaks.de/>
>
>
>
> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> <mailto:FreeSWITCH-users at lists.freeswitch.org>
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org <http://www.freeswitch.org/>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
More information about the FreeSWITCH-users
mailing list