21 Jul
2011
21 Jul
'11
11:39 a.m.
On 07/21/2011 05:30 PM, Roberto Fichera wrote:
On 07/21/2011 05:10 PM, Roberto Fichera wrote:
Ok! Now everything works fine!
Thanks!
On 07/21/2011 05:00 PM, Roberto Fichera wrote:
My fault, I've used cutted the n_query_cols++; before the column expires in the
source code.
Going to rebuild and testing again! On 07/21/2011 01:55 PM, Klaus Darilion wrote:
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)