On 07/21/2011 05:10 PM, Roberto Fichera wrote:On 07/21/2011 05:00 PM, Roberto Fichera wrote:On 07/21/2011 01:55 PM, Klaus Darilion wrote: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=403ba772771545f4410ba4a5cf396125be353b12 http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=460fc8bf6ad5108ff3779c85ff150e4f5145b189I'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.
Mmmhhh! The sender still null, but after removing the not null constraint again
from the sender field, I just see another problem:
Jul 21 17:02:37 roberto /usr/sbin/kamailio[24781]: ERROR: presence [subscribe.c:711]: Missing or unsupported event header field value
Jul 21 17:02:37 roberto /usr/sbin/kamailio[24781]: ERROR: presence [subscribe.c:714]: #011event= message-summary
Jul 21 17:02:37 roberto /usr/sbin/kamailio[24780]: ERROR: db_postgres [km_dbase.c:427]: invalid query, execution aborted
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
so since the expires isn't present in the same query than the db trigger the
not null problem. New query is below:
ERROR: null value in column "expires" violates not-null constraint
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="sip:roberto@192.168.2.92"><dm:person id="p3387"><rpid:activities/></dm:person><tuple id="t8698"><status><basic>open</basic></status><contact>sip:roberto@192.168.2.92</contact><note>Online</note></tuple></presence>',1311260557)
My fault, I've used cutted the n_query_cols++; before the column expires in the source code.
Going to rebuild and testing again!