[SR-Users] Playing with XCAP_SERVER and Postgresql

Daniel-Constantin Mierla miconda at gmail.com
Tue Jul 5 11:23:39 CEST 2011


Hello,

On 7/5/11 10:45 AM, Roberto Fichera wrote:
> 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?
are there any other log messages printed by pid 8520? Are these errors 
printed when doing some xcap operations or is related to sip presence 
requests?

Cheers,
Daniel

-- 
Daniel-Constantin Mierla -- http://www.asipto.com
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/20110705/5e87d7b7/attachment-0001.htm>


More information about the sr-users mailing list