<div dir="ltr"><div>Hello Peter,</div>
<div> </div>
<div> I don't see SQL errors here. Note that the [ERR] is the loglevel.</div>
<div>Is the database you gave at the db_name populated with data?</div>
<div> </div>
<div> Regards, __Yehavi:<br><br></div>
<div class="gmail_quote">2010/11/12 Peter Steinbach <span dir="ltr"><<a href="mailto:lists@telefaks.de">lists@telefaks.de</a>></span><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Thanks for the hint,<br><br>I set this to the "internal" profile, however this did not work. When<br>
Phone 1 is set to "on hold" I receive a number of SLA2 error messages<br>which belong to a database connection.<br>We have set up an odbc database connction which works for the internal<br>database in all other cases. Do we need special DB settings for this?<br>
I tried to execute the below embedded sql statements manually with the<br>same sql login and they all work without an error.<br><br>What can be the source of these errors?<br><br>============================================<br>
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:721 STATE SQL update<br>sip_dialogs set<br>call_info='appearance-index=1',call_info_state='alerting' where<br>hostname='<a href="http://mydomain.org/" target="_blank">mydomain.org</a>' and uuid='2d21424a-ee69-11df-94ab-3f32128609a9'<br>
2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:728 PROCESS PRESENCE EVENT<br>2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1925 PRES SQL select<br>
<div class="im">sip_from_user,sip_from_host,call_info,call_info_state,uuid from<br>sip_dialogs where hostname='<a href="http://mydomain.org/" target="_blank">mydomain.org</a>' and sip_from_user='4702' and<br>
sip_from_host='<a href="http://mydomain.org/" target="_blank">mydomain.org</a>'<br></div>2010-11-12 15:28:54.135087 [ERR] sofia_presence.c:1839 SLA2: 0<br>[sip_from_user]=[4702]<br></blockquote>
<div>...</div>
<div> </div></div></div>