[Freeswitch-users] Shared Line exprience with Polycom - how to get it to work

[Anthony Minessale]

you probably have debug-presence or debug-sla turned on in sofia.conf.xml
this causes the sql stmts to log on the error channel so they stand out .


On Fri, Nov 12, 2010 at 11:10 AM, Yehavi Bourvine
<yehavi.bourvine at gmail.com> wrote:
> 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 at 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 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
>
>



-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire

AIM: anthm
MSN:anthony_minessale at hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
googletalk:conf+888 at conference.freeswitch.org
pstn:+19193869900