On 07/21/2011 05:30 PM, Roberto Fichera wrote:
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=b39747e2...
http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=403ba772...
http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=460fc8bf...
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.
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!
Ok! Now everything works fine!
Thanks!