On 07/05/2011 11:23 AM, Daniel-Constantin Mierla wrote: > 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@192.168.2.92 >> Jul 5 10:36:36 roberto /usr/sbin/kamailio[8530]: ERROR: <script>: ===== >> xhttp: get sip:roberto@192.168.2.92 => >> /xcap-root/resource-lists/users/sip:roberto@192.168.2.92/index >> Jul 5 10:36:36 roberto /usr/sbin/kamailio[8531]: ERROR: <script>: ===== >> xhttp: pres-rules : sip:roberto@192.168.2.92 >> Jul 5 10:36:36 roberto /usr/sbin/kamailio[8531]: ERROR: <script>: ===== >> xhttp: get sip:roberto@192.168.2.92 => >> /xcap-root/pres-rules/users/sip:roberto@192.168.2.92/presrules >> Jul 5 10:36:36 roberto /usr/sbin/kamailio[8521]: INFO: presence >> [notify.c:1588]: NOTIFY sip:roberto@192.168.2.92 via >> sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92 on >> behalf of sip:mattia@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@192.168.2.92 via >> sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92 on >> behalf of sip:roberto@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?
Yes! I think they are related to sip presence. See below: 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[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 Jul 5 10:48:25 roberto /usr/sbin/kamailio[8520]: INFO: presence [notify.c:1588]: NOTIFY sip:roberto@192.168.2.92 via sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92 on behalf of sip:roberto@192.168.2.92 for event presence.winfo Jul 5 10:48:25 roberto /usr/sbin/kamailio[8520]: INFO: presence [notify.c:1588]: NOTIFY sip:roberto@192.168.2.92 via sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92 on behalf of sip:roberto@192.168.2.92 for event presence.winfo Jul 5 10:48:25 roberto /usr/sbin/kamailio[8520]: INFO: presence [notify.c:1588]: NOTIFY sip:roberto@192.168.2.92 via sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92 on behalf of sip:roberto@192.168.2.92 for event presence.winfo Jul 5 10:48:25 roberto /usr/sbin/kamailio[8520]: INFO: presence [notify.c:1588]: NOTIFY sip:roberto@192.168.2.92 via sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92 on behalf of sip:roberto@192.168.2.92 for event presence.winfo Jul 5 10:48:25 roberto /usr/sbin/kamailio[8520]: INFO: presence [notify.c:1588]: NOTIFY sip:mattia@192.168.2.92 via sip:mattia@192.168.2.50:5060;transport=udp;registering_acc=192_168_2_92 on behalf of sip:roberto@192.168.2.92 for event presence Jul 5 10:59:13 roberto /usr/sbin/kamailio[8520]: ERROR: db_postgres [km_dbase.c:427]: invalid query, execution aborted Jul 5 10:59:13 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:59:13 roberto /usr/sbin/kamailio[8520]: WARNING: db_postgres [km_dbase.c:473]: unexpected result returned Jul 5 10:59:13 roberto /usr/sbin/kamailio[8520]: INFO: presence [notify.c:1588]: NOTIFY sip:roberto@192.168.2.92 via sip:roberto@192.168.2.92:5090;transport=udp;registering_acc=192_168_2_92 on behalf of sip:mattia@192.168.2.92 for event presence Jul 5 10:59:35 roberto /usr/sbin/kamailio[8520]: ERROR: db_postgres [km_dbase.c:427]: invalid query, execution aborted Jul 5 10:59:35 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:59:35 roberto /usr/sbin/kamailio[8520]: WARNING: db_postgres [km_dbase.c:473]: unexpected result returned Jul 5 10:59:35 roberto /usr/sbin/kamailio[8520]: INFO: presence [notify.c:1588]: NOTIFY sip:mattia@192.168.2.92 via sip:mattia@192.168.2.50:5060;transport=udp;registering_acc=192_168_2_92 on behalf of sip:roberto@192.168.2.92 for event presence Jul 5 10:59:43 roberto /usr/sbin/kamailio[8520]: INFO: <core> [main.c:807]: INFO: signal 15 received > > Cheers, > Daniel > -- > Daniel-Constantin Mierla -- http://www.asipto.com > http://linkedin.com/in/miconda -- http://twitter.com/miconda
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
