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