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]
...