<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 07/19/2011 11:10 PM, Daniel-Constantin Mierla wrote:
<blockquote cite="mid:4E25F2DB.3010608@gmail.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
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>
</blockquote>
<br>
Mmmhhh! debug=5 doesn't show anything as log messages, the log still
the same.<br>
Anyway if found the problem looking under PostgreSQL logs. As I can
see, the <br>
problem is under the query which basically doesn't uses the sender
field, see below:<br>
<br>
ERROR: null value in column "sender" violates not-null constraint<br>
STATEMENT: insert into presentity
(domain,username,event,etag,expires,body,received_time ) values
('192.168.2.92','roberto','presence','a.1311173612.4970.2.0',1311177224,'<?xml
version="1.0" encoding="UTF-8" standalone="no"?><presence
xmlns="urn:ietf:params:xml:ns:pidf"
xmlns:dm="urn:ietf:params:xml:ns:pidf:data-model"
xmlns:rpid="urn:ietf:params:xml:ns:pidf:rpid"
entity=<a class="moz-txt-link-rfc2396E" href="mailto:sip:roberto@192.168.2.92">"sip:roberto@192.168.2.92"</a>><dm:person
id="p3619"><rpid:activities/></dm:person><tuple
id="t9285"><status><basic>open</basic></status><contact><a class="moz-txt-link-abbreviated" href="mailto:sip:roberto@192.168.2.92">sip:roberto@192.168.2.92</a></contact><note>Online</note></tuple></presence>',1311173624)<br>
<br>
<blockquote cite="mid:4E25F2DB.3010608@gmail.com" type="cite"> <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 moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" 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 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>
</body>
</html>