[SR-Users] Kamailio presence server problem with PostgreSQL

[Roberto Fichera]

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

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