[SR-Users] Playing with XCAP_SERVER and Postgresql

[Roberto Fichera]

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 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?

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 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:48:25 roberto /usr/sbin/kamailio[8520]: 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:48:25 roberto /usr/sbin/kamailio[8520]: 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:48:25 roberto /usr/sbin/kamailio[8520]: 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:48:25 roberto /usr/sbin/kamailio[8520]: INFO: presence [notify.c:1588]: NOTIFY sip:mattia at 192.168.2.92 via
sip:mattia at 192.168.2.50:5060;transport=udp;registering_acc=192_168_2_92 on behalf of sip:roberto at 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 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: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 at 192.168.2.92 via
sip:mattia at 192.168.2.50:5060;transport=udp;registering_acc=192_168_2_92 on behalf of sip:roberto at 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

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