<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello,<br>
</p>
<br>
<div class="moz-cite-prefix">On 02/05/16 12:56, gmele wrote:<br>
</div>
<blockquote cite="mid:1462186564344-148025.post@n5.nabble.com"
type="cite">
<pre wrap="">Hello,
your patched fixed the problem! Thx.</pre>
</blockquote>
ok, thanks for testing and reporting the results.<br>
<blockquote cite="mid:1462186564344-148025.post@n5.nabble.com"
type="cite">
<pre wrap="">
Now, I'm able to go further in my tests with Oracle and found some problem
during the REGISTER:</pre>
</blockquote>
The error is related to presence handling, not registration.<br>
<br>
The octal code 012 corresponds to CR (end of line), which are
present inside the xml document for presence.<br>
<br>
Do you know if oracle has issues or needs special format for
handling the octal codes? Kamailio should not do anything special in
this case, just takes the body from the sip message and tries to
insert it into database.<br>
<br>
Cheers,<br>
Daniel<br>
<blockquote cite="mid:1462186564344-148025.post@n5.nabble.com"
type="cite">
<pre wrap="">
May 2 12:42:50 newvm1 /usr/sbin/kamailio[554]: INFO: ims_auth
[authorize.c:893]: authenticate(): UE said: 952ef9a21b01989f1b7000625f040e44
and we expect 952ef9a21b01989f1b7000625f040e44 ha1
38004f7e01b9786648a50dbf46bde6a6 (REGISTER)
May 2 12:42:50 newvm1 /usr/sbin/kamailio[555]: ERROR: db_unixodbc
[dbase.c:133]: db_unixodbc_submit_query(): rv=-1. Query= insert into
presentity
(domain,username,event,etag,sender,body,received_time,priority,expires )
values
('ims-nagra.test','giovanni.mele','presence','a.1462183170.555.1.0','','<?xml
version="1.0" encoding="UTF-8"?>*#012*<presence
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="sip:bob@ims-nagra.test">"sip:bob@ims-nagra.test"</a> xmlns="urn:ietf:params:xml:ns:pidf">*#012*
<tuple id="opt-d6">*#012* <status>*#012* <basic>open</basic>*#012*
</status>*#012* <contact
priority="0.8"><a class="moz-txt-link-freetext" href="sip:bob@ims-nagra.test">sip:bob@ims-nagra.test</a></contact>*#012*
<timestamp>2016-05-02T10:42:30Z</timestamp>*#012*</tuple>*#012*</presence>*#012*',1462185770,0,1462189370)
May 2 12:42:50 newvm1 /usr/sbin/kamailio[555]: ERROR: db_unixodbc
[connection.c:220]: db_unixodbc_extract_error():
unixodbc:SQLExecDirect=HY000:1:1465:[Oracle][ODBC][Ora]ORA-01465: invalid
hex number*#012*
May 2 12:42:50 newvm1 /usr/sbin/kamailio[555]: ERROR: <core>
[db_query.c:235]: db_do_insert_cmd(): error while submitting query
What is this hex number *#12* in the insert query?
Thx
Giovanni
--
View this message in context: <a class="moz-txt-link-freetext" href="http://sip-router.1086192.n5.nabble.com/Kamailio-and-Oracle-database-tp147990p148025.html">http://sip-router.1086192.n5.nabble.com/Kamailio-and-Oracle-database-tp147990p148025.html</a>
Sent from the Users mailing list archive at Nabble.com.
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@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>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>