<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 07/21/2011 05:30 PM, Roberto Fichera wrote:
<blockquote cite="mid:4E28460C.4090302@tekno-soft.it" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
On 07/21/2011 05:10 PM, Roberto Fichera wrote:
<blockquote cite="mid:4E284154.4080207@tekno-soft.it" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
On 07/21/2011 05:00 PM, Roberto Fichera wrote:
<blockquote cite="mid:4E283EF9.3010802@tekno-soft.it"
type="cite">
<pre wrap="">On 07/21/2011 01:55 PM, Klaus Darilion wrote:
</pre>
<blockquote type="cite">
<pre wrap=""><a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b39747e213e350609761d14583db3e689ad6fefc">http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b39747e213e350609761d14583db3e689ad6fefc</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=403ba772771545f4410ba4a5cf396125be353b12">http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=403ba772771545f4410ba4a5cf396125be353b12</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=460fc8bf6ad5108ff3779c85ff150e4f5145b189">http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=460fc8bf6ad5108ff3779c85ff150e4f5145b189</a>
</pre>
</blockquote>
<pre wrap="">I've applied all the listed patches than regenerated and installed
the rpms and set back to not null the sender constraint in the db.
After restarting kamailio I'm still getting the problem as before.</pre>
</blockquote>
<br>
Mmmhhh! The sender still null, but after removing the not null
constraint again<br>
from the sender field, I just see another problem:<br>
<br>
Jul 21 17:02:37 roberto /usr/sbin/kamailio[24781]: ERROR:
presence [subscribe.c:711]: Missing or unsupported event header
field value<br>
Jul 21 17:02:37 roberto /usr/sbin/kamailio[24781]: ERROR:
presence [subscribe.c:714]: #011event= message-summary<br>
Jul 21 17:02:37 roberto /usr/sbin/kamailio[24780]: ERROR:
db_postgres [km_dbase.c:427]: invalid query, execution aborted<br>
<b>Jul 21 17:02:37 roberto /usr/sbin/kamailio[24780]: ERROR:
db_postgres [km_dbase.c:428]: driver error: PGRES_FATAL_ERROR,
ERROR: null value in column "expires" violates not-null
constraint#012</b><br>
<br>
so since the expires isn't present in the same query than the db
trigger the <br>
not null problem. New query is below:<br>
<br>
ERROR: null value in column "expires" violates not-null
constraint<br>
STATEMENT: insert into presentity
(domain,username,event,etag,sender,body,received_time ) values
('192.168.2.92','roberto','presence','a.1311260173.24780.4.0','','<?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
moz-do-not-send="true" class="moz-txt-link-rfc2396E"
href="mailto:sip:roberto@192.168.2.92">"sip:roberto@192.168.2.92"</a>><dm:person
id="p3387"><rpid:activities/></dm:person><tuple
id="t8698"><status><basic>open</basic></status><contact><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></contact><note>Online</note></tuple></presence>',1311260557)<br>
</blockquote>
<br>
My fault, I've used cutted the n_query_cols++; before the column
expires in the source code.<br>
Going to rebuild and testing again!<br>
</blockquote>
<br>
Ok! Now everything works fine!<br>
<br>
Thanks!<br>
<br>
</body>
</html>