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=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=460fc8bf6ad5108ff3779c85ff150e4f5145b189 >>> 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!
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
