20 Jul
2011
20 Jul
'11
11:53 a.m.
Hello,
Thanks for troubleshooting further. What intrigues me is that the error message from
syslog is printed from store result function, which is used after doing a select query. So
something else might have to be reviewed as well.
Anyhow, missing sender value should be checked, since it is a constraint for non-null.
Interesting it was not risen with mysql.
Cheers,
Daniel
On Jul 20, 2011, at 5:46 PM, Roberto Fichera <kernel(a)tekno-soft.it> wrote:
On 07/20/2011 05:34 PM, Roberto Fichera wrote:
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
On 07/20/2011 05:18 PM, Klaus Darilion wrote:
Anyway I can confirm that removing the constraint the problem
of presence backed by postgresql seems solved.
Am 20.07.2011 17:00, schrieb Roberto Fichera:
how does look the corresponding presentity mysql table, does it has the
same
constraint or not? ERROR: null value in column "sender"
violates not-null constraint
STATEMENT: insert into presentity
(domain,username,event,etag,expires,body,received_time ) values
('192.168.2.92','roberto','presence','a.1311173612.4970.2.0',1311177224,'<?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="p3619"><rpid:activities/></dm:person><tuple
id="t9285"><status><basic>open</basic></status><contact>sip:roberto@192.168.2.92</contact><note>Online</note></tuple></presence>',1311173624)
Seems like the statement does not insert the "sender" although it is
mandatory. If "sender" is really mandatory, then it seems the statement
is buggy. regards
Klaus
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users