No subject
Fri Jun 3 15:33:31 CEST 2011
mandatory hence it could be generated by a machine - whose
identity/location is not needed.
Regards,
Marius
------------------------------------------------------------------------
*From:* Daniel-Constantine Mierla <a class="moz-txt-link-rfc2396E" href="mailto:miconda at gmail.com"><miconda at gmail.com></a>
*To:* SIP Router - Kamailio (OpenSER) and SIP Express Router (SER)
-Users Mailing List <a class="moz-txt-link-rfc2396E" href="mailto:sr-users at lists.sip-router.org"><sr-users at lists.sip-router.org></a>
*Cc:* SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) -
UsersMailing List <a class="moz-txt-link-rfc2396E" href="mailto:sr-users at lists.sip-router.org"><sr-users at lists.sip-router.org></a>
*Sent:* Wednesday, July 20, 2011 6:53 PM
*Subject:* Re: [SR-Users] Kamailio presence server problem with
PostgreSQL
Hello,
Thanks for troubleshooting further. What intrigues me is that the
error message from syslog is printed from store result function,
which is used after doing a select query. So something else might
have to be reviewed as well.
Anyhow, missing sender value should be checked, since it is a
constraint for non-null. Interesting it was not risen with mysql.
Cheers,
Daniel
On Jul 20, 2011, at 5:46 PM, Roberto Fichera <<a class="moz-txt-link-abbreviated" href="mailto:kernel at tekno-soft.it">kernel at tekno-soft.it</a>
<a class="moz-txt-link-rfc2396E" href="mailto:kernel at tekno-soft.it"><mailto:kernel at tekno-soft.it></a>> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On 07/20/2011 05:34 PM, Roberto Fichera wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On 07/20/2011 05:18 PM, Klaus Darilion wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Am 20.07.2011 17:00, schrieb Roberto Fichera:
</pre>
<blockquote type="cite">
<pre wrap="">ERROR: null value in column "sender" violates not-null constraint
STATEMENT: insert into presentity
(domain,username,event,etag,expires,body,received_time ) values
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">('192.168.2.92','roberto','presence','a.1311173612.4970.2.0',1311177224,'<?xml
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">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=<a class="moz-txt-link-rfc2396E" href="mailto:sip:roberto at 192.168.2.92">"sip:roberto at 192.168.2.92"</a>><dm:person
id="p3619"><rpid:activities/></dm:person><tuple
</pre>
</blockquote>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">id="t9285"><status><basic>open</basic></status><contact><a class="moz-txt-link-abbreviated" href="mailto:sip:roberto at 192.168.2.92">sip:roberto at 192.168.2.92</a></contact><note>Online</note></tuple></presence>',1311173624)
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">Seems like the statement does not insert the "sender" although it is
mandatory. If "sender" is really mandatory, then it seems the
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">statement
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">is buggy.
</pre>
</blockquote>
<pre wrap="">how does look the corresponding presentity mysql table, does it
</pre>
</blockquote>
</blockquote>
<pre wrap="">has the same
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">constraint or not?
</pre>
</blockquote>
<pre wrap="">Anyway I can confirm that removing the constraint the problem
of presence backed by postgresql seems solved.
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">regards
Klaus
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">mailing list
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap=""><a class="moz-txt-link-abbreviated" href="mailto:sr-users at lists.sip-router.org">sr-users at lists.sip-router.org</a> <a class="moz-txt-link-rfc2396E" href="mailto:sr-users at lists.sip-router.org"><mailto:sr-users at lists.sip-router.org></a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
</pre>
</blockquote>
</blockquote>
<pre wrap="">list
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap=""><a class="moz-txt-link-abbreviated" href="mailto:sr-users at lists.sip-router.org">sr-users at lists.sip-router.org</a> <a class="moz-txt-link-rfc2396E" href="mailto:sr-users at lists.sip-router.org"><mailto:sr-users at lists.sip-router.org></a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users at lists.sip-router.org">sr-users at lists.sip-router.org</a> <a class="moz-txt-link-rfc2396E" href="mailto:sr-users at lists.sip-router.org"><mailto:sr-users at lists.sip-router.org></a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users at lists.sip-router.org">sr-users at lists.sip-router.org</a> <a class="moz-txt-link-rfc2396E" href="mailto:sr-users at lists.sip-router.org"><mailto:sr-users at lists.sip-router.org></a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users at lists.sip-router.org">sr-users at lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre wrap="">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
Kamailio Advanced Training, Oct 10-13, Berlin: <a class="moz-txt-link-freetext" href="http://asipto.com/u/kat">http://asipto.com/u/kat</a>
<a class="moz-txt-link-freetext" href="http://linkedin.com/in/miconda">http://linkedin.com/in/miconda</a> -- <a class="moz-txt-link-freetext" href="http://twitter.com/miconda">http://twitter.com/miconda</a>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users at lists.sip-router.org">sr-users at lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users at lists.sip-router.org">sr-users at lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users at lists.sip-router.org">sr-users at lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users at lists.sip-router.org">sr-users at lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
</body>
</html>
--------------010100070407070903000403--
More information about the sr-users
mailing list