<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
On 07/05/2011 11:23 AM, Daniel-Constantin Mierla wrote:
<blockquote cite="mid:4E12D81B.8000708@gmail.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Hello,<br>
<br>
On 7/5/11 10:45 AM, Roberto Fichera wrote:
<blockquote cite="mid:4E12CF3B.3020604@tekno-soft.it" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
Hi all in the List,<br>
<br>
I'm playing with the xcap_server using the jitsi client.
Kamailio is v3.1.4 and postgresql is v8.4.8 under<br>
Fedora 14 64bit. Basically I'm getting the error below.<br>
<br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8529]: ERROR:
<script>: ===== xhttp: xcap-caps : <null><br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8530]: ERROR:
<script>: ===== xhttp: resource-lists : <a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a><br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8530]: ERROR:
<script>: ===== xhttp: get <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a>
=> /xcap-root/resource-lists/users/<a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="sip:roberto@192.168.2.92/index">sip:roberto@192.168.2.92/index</a><br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8531]: ERROR:
<script>: ===== xhttp: pres-rules : <a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a><br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8531]: ERROR:
<script>: ===== xhttp: get <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a>
=> /xcap-root/pres-rules/users/<a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="sip:roberto@192.168.2.92/presrules">sip:roberto@192.168.2.92/presrules</a><br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8521]: INFO: presence
[notify.c:1588]: NOTIFY <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a>
via <a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92">sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92</a>
on behalf of <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:sip:mattia@192.168.2.92">sip:mattia@192.168.2.92</a>
for event presence<br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR:
presence [subscribe.c:711]: Missing or unsupported event header
field value<br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR:
presence [subscribe.c:714]: #011event= message-summary<br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8522]: INFO: presence
[notify.c:1588]: NOTIFY <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a>
via <a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92">sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92</a>
on behalf of <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a>
for event presence.winfo<br>
<b>Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR:
db_postgres [km_dbase.c:427]: invalid query, execution aborted<br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR:
db_postgres [km_dbase.c:428]: driver error: PGRES_FATAL_ERROR,
ERROR: null value in column "sender" violates not-null
constraint#012<br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: WARNING:
db_postgres [km_dbase.c:473]: unexpected result returned</b><br>
<br>
Any idea?<br>
</blockquote>
are there any other log messages printed by pid 8520? Are these
errors printed when doing some xcap operations or is related to
sip presence requests?<br>
</blockquote>
<br>
Yes! I think they are related to sip presence. See below:<br>
<br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR: presence
[subscribe.c:711]: Missing or unsupported event header field value<br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR: presence
[subscribe.c:714]: #011event= message-summary<br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR: db_postgres
[km_dbase.c:427]: invalid query, execution aborted<br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR: db_postgres
[km_dbase.c:428]: driver error: PGRES_FATAL_ERROR, ERROR: null
value in column "sender" violates not-null constraint#012<br>
Jul 5 10:36:36 roberto /usr/sbin/kamailio[8520]: WARNING:
db_postgres [km_dbase.c:473]: unexpected result returned<br>
Jul 5 10:48:25 roberto /usr/sbin/kamailio[8520]: INFO: presence
[notify.c:1588]: NOTIFY <a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a> via
<a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92">sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92</a>
on behalf of <a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a> for event presence.winfo<br>
Jul 5 10:48:25 roberto /usr/sbin/kamailio[8520]: INFO: presence
[notify.c:1588]: NOTIFY <a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a> via
<a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92">sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92</a>
on behalf of <a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a> for event presence.winfo<br>
Jul 5 10:48:25 roberto /usr/sbin/kamailio[8520]: INFO: presence
[notify.c:1588]: NOTIFY <a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a> via
<a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92">sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92</a>
on behalf of <a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a> for event presence.winfo<br>
Jul 5 10:48:25 roberto /usr/sbin/kamailio[8520]: INFO: presence
[notify.c:1588]: NOTIFY <a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a> via
<a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92">sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92</a>
on behalf of <a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a> for event presence.winfo<br>
Jul 5 10:48:25 roberto /usr/sbin/kamailio[8520]: INFO: presence
[notify.c:1588]: NOTIFY <a class="moz-txt-link-abbreviated" href="mailto:sip:mattia@192.168.2.92">sip:mattia@192.168.2.92</a> via
<a class="moz-txt-link-abbreviated" href="mailto:sip:mattia@192.168.2.50:5060;transport=udp;registering_acc=192_168_2_92">sip:mattia@192.168.2.50:5060;transport=udp;registering_acc=192_168_2_92</a>
on behalf of <a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a> for event presence<br>
Jul 5 10:59:13 roberto /usr/sbin/kamailio[8520]: ERROR: db_postgres
[km_dbase.c:427]: invalid query, execution aborted<br>
Jul 5 10:59:13 roberto /usr/sbin/kamailio[8520]: ERROR: db_postgres
[km_dbase.c:428]: driver error: PGRES_FATAL_ERROR, ERROR: null
value in column "sender" violates not-null constraint#012<br>
Jul 5 10:59:13 roberto /usr/sbin/kamailio[8520]: WARNING:
db_postgres [km_dbase.c:473]: unexpected result returned<br>
Jul 5 10:59:13 roberto /usr/sbin/kamailio[8520]: INFO: presence
[notify.c:1588]: NOTIFY <a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a> via
<a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92">sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92</a>
on behalf of <a class="moz-txt-link-abbreviated" href="mailto:sip:mattia@192.168.2.92">sip:mattia@192.168.2.92</a> for event presence<br>
Jul 5 10:59:35 roberto /usr/sbin/kamailio[8520]: ERROR: db_postgres
[km_dbase.c:427]: invalid query, execution aborted<br>
Jul 5 10:59:35 roberto /usr/sbin/kamailio[8520]: ERROR: db_postgres
[km_dbase.c:428]: driver error: PGRES_FATAL_ERROR, ERROR: null
value in column "sender" violates not-null constraint#012<br>
Jul 5 10:59:35 roberto /usr/sbin/kamailio[8520]: WARNING:
db_postgres [km_dbase.c:473]: unexpected result returned<br>
Jul 5 10:59:35 roberto /usr/sbin/kamailio[8520]: INFO: presence
[notify.c:1588]: NOTIFY <a class="moz-txt-link-abbreviated" href="mailto:sip:mattia@192.168.2.92">sip:mattia@192.168.2.92</a> via
<a class="moz-txt-link-abbreviated" href="mailto:sip:mattia@192.168.2.50:5060;transport=udp;registering_acc=192_168_2_92">sip:mattia@192.168.2.50:5060;transport=udp;registering_acc=192_168_2_92</a>
on behalf of <a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a> for event presence<br>
Jul 5 10:59:43 roberto /usr/sbin/kamailio[8520]: INFO: <core>
[main.c:807]: INFO: signal 15 received<br>
<br>
<blockquote cite="mid:4E12D81B.8000708@gmail.com" type="cite"> <br>
Cheers,<br>
Daniel<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://linkedin.com/in/miconda">http://linkedin.com/in/miconda</a> -- <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://twitter.com/miconda">http://twitter.com/miconda</a></pre>
</blockquote>
<br>
</body>
</html>