<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
On 7/19/11 10:41 AM, Roberto Fichera wrote:
<blockquote cite="mid:4E25431E.3060906@tekno-soft.it" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
Hi all,<br>
<br>
I've setup for testing purpose an xcap server with Kamailio v3.1.4
backed with a <br>
postgresql v8.4.8 all in 64bits versions. <br>
On that configuration, I'm getting the errors below and
consequently the presence doesn't <br>
correctly reports the status. Does anyone has the same problem?<br>
<br>
Best regards,<br>
Roberto Fichera.<br>
<br>
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2005]: INFO: pua_usrloc
[ul_publish.c:211]: should not send ul publish<br>
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2015]: ERROR:
<script>: ===== xhttp: xcap-caps : <null><br>
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2017]: 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 19 10:31:52 roberto /usr/sbin/kamailio[2017]: 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 class="moz-txt-link-freetext" href="sip:roberto@192.168.2.92/index">sip:roberto@192.168.2.92/index</a><br>
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2021]: 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 19 10:31:52 roberto /usr/sbin/kamailio[2021]: 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 class="moz-txt-link-freetext" href="sip:roberto@192.168.2.92/presrules">sip:roberto@192.168.2.92/presrules</a><br>
Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: ERROR: presence
[subscribe.c:711]: Missing or unsupported event header field value<br>
Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: ERROR: presence
[subscribe.c:714]: #011event= message-summary<br>
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2004]: 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>
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2005]: 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>
<b>Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: ERROR:
db_postgres [km_dbase.c:427]: invalid query, execution aborted<br>
Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: ERROR:
db_postgres [km_dbase.c:428]: driver error: PGRES_FATAL_ERROR,
ERROR: null value in column "sender" violates not-null
constraint#012</b><br>
<b>Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: WARNING:
db_postgres [km_dbase.c:473]: unexpected result returned</b><br>
</blockquote>
are there any other errors/warnings in syslog after this line
related to same message? It should show where in presence modules
the query was executed.<br>
<br>
Cheers,<br>
Daniel<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
Kamailio Advanced Training, Oct 10-13, Berlin: <a class="moz-txt-link-freetext" href="http://asipto.com/u/kat">http://asipto.com/u/kat</a>
<a class="moz-txt-link-freetext" href="http://linkedin.com/in/miconda">http://linkedin.com/in/miconda</a> -- <a class="moz-txt-link-freetext" href="http://twitter.com/miconda">http://twitter.com/miconda</a></pre>
</body>
</html>