<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
can you set the debug=5 in the config file, restart, do the same
scenario and send all the log messages. The error is printed by db
store result function, which is kind of strange considering that the
error message is related to a null constraint.<br>
<br>
Cheers,<br>
Daniel <br>
<br>
On 7/19/11 11:44 AM, Roberto Fichera wrote:
<blockquote cite="mid:4E25520F.2080508@tekno-soft.it" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
On 07/19/2011 11:36 AM, Daniel-Constantin Mierla wrote:
<blockquote cite="mid:4E255035.5060509@gmail.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
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
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 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 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 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>
</blockquote>
<br>
No! Actually I don't see anything else. I just started Kamailio
and than afterwards Jitsi, that's it!<br>
Please tell me if I've to do something in order to discover where
the problem is.<br>
<br>
<blockquote cite="mid:4E255035.5060509@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>
Kamailio Advanced Training, Oct 10-13, Berlin: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://asipto.com/u/kat">http://asipto.com/u/kat</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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<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>