[SR-Users] Kamailio presence server problem with PostgreSQL

[Daniel-Constantin Mierla]

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.

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/4d8ef37f/attachment.htm>