[SR-Users] Kamailio presence server problem with PostgreSQL

[Roberto Fichera]

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 at 192.168.2.92"><dm:person
>> id="p3387"><rpid:activities/></dm:person><tuple
>> id="t8698"><status><basic>open</basic></status><contact>sip:roberto at 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!

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110721/0b5c8744/attachment-0001.htm>