[SR-Users] Playing with XCAP_SERVER and Postgresql

[Roberto Fichera]

Hi all in the List,

I'm playing with the xcap_server using the jitsi client. Kamailio is v3.1.4 and postgresql is v8.4.8 under
Fedora 14 64bit. Basically I'm getting the error below.

Jul  5 10:36:36 roberto /usr/sbin/kamailio[8529]: ERROR: <script>: ===== xhttp: xcap-caps : <null>
Jul  5 10:36:36 roberto /usr/sbin/kamailio[8530]: ERROR: <script>: ===== xhttp: resource-lists : sip:roberto at 192.168.2.92
Jul  5 10:36:36 roberto /usr/sbin/kamailio[8530]: 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  5 10:36:36 roberto /usr/sbin/kamailio[8531]: ERROR: <script>: ===== xhttp: pres-rules : sip:roberto at 192.168.2.92
Jul  5 10:36:36 roberto /usr/sbin/kamailio[8531]: 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  5 10:36:36 roberto /usr/sbin/kamailio[8521]: 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  5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR: presence [subscribe.c:711]: Missing or unsupported event header
field value
Jul  5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR: presence [subscribe.c:714]: #011event= message-summary
Jul  5 10:36:36 roberto /usr/sbin/kamailio[8522]: 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  5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR: db_postgres [km_dbase.c:427]: invalid query, execution aborted
Jul  5 10:36:36 roberto /usr/sbin/kamailio[8520]: ERROR: db_postgres [km_dbase.c:428]: driver error: PGRES_FATAL_ERROR,
ERROR:  null value in column "sender" violates not-null constraint#012
Jul  5 10:36:36 roberto /usr/sbin/kamailio[8520]: WARNING: db_postgres [km_dbase.c:473]: unexpected result returned*

Any idea?

Best regards,
Roberto Fichera.

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