[SR-Users] Kamailio presence server problem with PostgreSQL

[Roberto Fichera]

On 07/19/2011 11:10 PM, Daniel-Constantin Mierla wrote:
> Hello,
>
> can you set the debug=5 in the config file, restart, do the same scenario and send all the log messages. The error is
> printed by db store result function, which is kind of strange considering that the error message is related to a null
> constraint.

Mmmhhh! debug=5 doesn't show anything as log messages, the log still the same.
Anyway if found the problem looking under PostgreSQL logs. As I can see, the
problem is under the query which basically doesn't uses the sender field, see below:

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 at 192.168.2.92"><dm:person
id="p3619"><rpid:activities/></dm:person><tuple
id="t9285"><status><basic>open</basic></status><contact>sip:roberto at 192.168.2.92</contact><note>Online</note></tuple></presence>',1311173624)

>
> Cheers,
> Daniel
>
> On 7/19/11 11:44 AM, Roberto Fichera wrote:
>> On 07/19/2011 11:36 AM, Daniel-Constantin Mierla wrote:
>>> Hello,
>>>
>>> On 7/19/11 10:41 AM, Roberto Fichera wrote:
>>>> Hi all,
>>>>
>>>> I've setup for testing purpose an xcap server with Kamailio v3.1.4 backed with a
>>>> postgresql v8.4.8 all in 64bits versions.
>>>> On that configuration, I'm getting the errors below and consequently the presence doesn't
>>>> correctly reports the status. Does anyone has the same problem?
>>>>
>>>> Best regards,
>>>> Roberto Fichera.
>>>>
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[2005]: INFO: pua_usrloc [ul_publish.c:211]: should not send ul publish
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[2015]: ERROR: <script>: ===== xhttp: xcap-caps : <null>
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[2017]: ERROR: <script>: ===== xhttp: resource-lists :
>>>> sip:roberto at 192.168.2.92
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[2017]: ERROR: <script>: ===== xhttp: get sip:roberto at 192.168.2.92 =>
>>>> /xcap-root/resource-lists/users/sip:roberto at 192.168.2.92/index
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[2021]: ERROR: <script>: ===== xhttp: pres-rules : sip:roberto at 192.168.2.92
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[2021]: ERROR: <script>: ===== xhttp: get sip:roberto at 192.168.2.92 =>
>>>> /xcap-root/pres-rules/users/sip:roberto at 192.168.2.92/presrules
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: ERROR: presence [subscribe.c:711]: Missing or unsupported event
>>>> header field value
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: ERROR: presence [subscribe.c:714]: #011event= message-summary
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[2004]: INFO: presence [notify.c:1588]: NOTIFY sip:roberto at 192.168.2.92
>>>> via sip:roberto at 192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92 on behalf of sip:roberto at 192.168.2.92
>>>> for event presence.winfo
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[2005]: INFO: presence [notify.c:1588]: NOTIFY sip:roberto at 192.168.2.92
>>>> via sip:roberto at 192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92 on behalf of sip:mattia at 192.168.2.92
>>>> for event presence
>>>> *Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: ERROR: db_postgres [km_dbase.c:427]: invalid query, execution
>>>> aborted
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: ERROR: db_postgres [km_dbase.c:428]: driver error:
>>>> PGRES_FATAL_ERROR, ERROR:  null value in column "sender" violates not-null constraint#012*
>>>> *Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: WARNING: db_postgres [km_dbase.c:473]: unexpected result returned*
>>> are there any other errors/warnings in syslog after this line related to same message? It should show where in
>>> presence modules the query was executed.
>>
>> No! Actually I don't see anything else. I just started Kamailio and than afterwards Jitsi, that's it!
>> Please tell me if I've to do something in order to discover where the problem is.
>>
>>>
>>> Cheers,
>>> Daniel
>>> -- 
>>> Daniel-Constantin Mierla -- http://www.asipto.com
>>> Kamailio Advanced Training, Oct 10-13, Berlin: http://asipto.com/u/kat
>>> http://linkedin.com/in/miconda -- http://twitter.com/miconda
>>
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
> -- 
> Daniel-Constantin Mierla -- http://www.asipto.com
> Kamailio Advanced Training, Oct 10-13, Berlin: http://asipto.com/u/kat
> http://linkedin.com/in/miconda -- http://twitter.com/miconda

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20110720/7174ea4b/attachment.htm>