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@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)
>
> 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@192.168.2.92
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[2017]: ERROR: <script>: =====
>>>> xhttp: get sip:roberto@192.168.2.92 =>
>>>> /xcap-root/resource-lists/users/sip:roberto@192.168.2.92/index
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[2021]: ERROR: <script>: =====
>>>> xhttp: pres-rules : sip:roberto@192.168.2.92
>>>> Jul 19 10:31:52 roberto /usr/sbin/kamailio[2021]: ERROR: <script>: =====
>>>> xhttp: get sip:roberto@192.168.2.92 =>
>>>> /xcap-root/pres-rules/users/sip:roberto@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@192.168.2.92
>>>> via
>>>> sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92
>>>> on behalf of sip:roberto@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@192.168.2.92
>>>> via
>>>> sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92
>>>> on behalf of sip:mattia@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@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
_______________________________________________
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
