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