20 Jul
2011
20 Jul
'11
11 a.m.
On 07/19/2011 11:10 PM, Daniel-Constantin Mierla wrote:
Hello,
can you set the debug=5 in the config file, restart, do the same scenario and send all
the log messages. The error is
printed by db store result function, which is kind of strange considering that the error
message is related to a null
constraint.
Mmmhhh! debug=5 doesn't show anything as log messages, the log still the same.
Anyway if found the problem looking under PostgreSQL logs. As I can see, the
problem is under the query which basically doesn't uses the sender field, see below:
ERROR: null value in column "sender" violates not-null constraint
STATEMENT: insert into presentity (domain,username,event,etag,expires,body,received_time
) values
('192.168.2.92','roberto','presence','a.1311173612.4970.2.0',1311177224,'<?xml
version="1.0" encoding="UTF-8"
standalone="no"?><presence xmlns="urn:ietf:params:xml:ns:pidf"
xmlns:dm="urn:ietf:params:xml:ns:pidf:data-model"
xmlns:rpid="urn:ietf:params:xml:ns:pidf:rpid"
entity="sip:roberto@192.168.2.92"><dm:person
id="p3619"><rpid:activities/></dm:person><tuple
id="t9285"><status><basic>open</basic></status><contact>sip:roberto@192.168.2.92</contact><note>Online</note></tuple></presence>',1311173624)
Cheers,
Daniel
On 7/19/11 11:44 AM, Roberto Fichera wrote:
On 07/19/2011 11:36 AM, Daniel-Constantin Mierla
wrote:
--
Daniel-Constantin Mierla -- http://www.asipto.com
Kamailio Advanced Training, Oct 10-13, Berlin: http://asipto.com/u/kat
http://linkedin.com/in/miconda -- http://twitter.com/miconda Hello,
On 7/19/11 10:41 AM, Roberto Fichera wrote:
No! Actually I don't see anything else. I just started Kamailio and than afterwards
Jitsi, that's it!
Please tell me if I've to do something in order to discover where the problem is.
Hi all,
I've setup for testing purpose an xcap server with Kamailio v3.1.4 backed with a
postgresql v8.4.8 all in 64bits versions.
On that configuration, I'm getting the errors below and consequently the presence
doesn't
correctly reports the status. Does anyone has the same problem?
Best regards,
Roberto Fichera.
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2005]: INFO: pua_usrloc [ul_publish.c:211]:
should not send ul publish
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2015]: ERROR: <script>: ===== xhttp:
xcap-caps : <null>
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2017]: ERROR: <script>: ===== xhttp:
resource-lists :
sip:roberto@192.168.2.92
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2017]: ERROR: <script>: ===== xhttp: get
sip:roberto@192.168.2.92 =>
/xcap-root/resource-lists/users/sip:roberto@192.168.2.92/index
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2021]: ERROR: <script>: ===== xhttp:
pres-rules : sip:roberto@192.168.2.92
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2021]: ERROR: <script>: ===== xhttp: get
sip:roberto@192.168.2.92 =>
/xcap-root/pres-rules/users/sip:roberto@192.168.2.92/presrules
Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: ERROR: presence [subscribe.c:711]:
Missing or unsupported event
header field value
Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: ERROR: presence [subscribe.c:714]:
#011event= message-summary
Jul 19 10:31:52 roberto /usr/sbin/kamailio[2004]: 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 19 10:31:52 roberto /usr/sbin/kamailio[2005]: 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 19 10:31:52 roberto /usr/sbin/kamailio[1999]: ERROR: db_postgres [km_dbase.c:427]:
invalid query, execution
aborted
Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: ERROR: db_postgres [km_dbase.c:428]:
driver error:
PGRES_FATAL_ERROR, ERROR: null value in column "sender" violates not-null
constraint#012*
*Jul 19 10:31:52 roberto /usr/sbin/kamailio[1999]: WARNING: db_postgres [km_dbase.c:473]:
unexpected result returned*
are there any other errors/warnings in syslog after
this line related to same message? It should show where in
presence modules the query was executed.
Cheers,
Daniel
--
Daniel-Constantin Mierla -- http://www.asipto.com
Kamailio Advanced Training, Oct 10-13, Berlin: http://asipto.com/u/kat
http://linkedin.com/in/miconda -- http://twitter.com/miconda
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users