[SR-Users] Kamailio presence server problem with PostgreSQL

[Daniel-Constantin Mierla]

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.

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/20110719/76cd0469/attachment.htm>