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@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@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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900