[SR-Users] Kamailio presence server problem with PostgreSQL

Roberto Fichera kernel at tekno-soft.it
Tue Jul 19 10:41:02 CEST 2011


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*

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


More information about the sr-users mailing list