Hello,


On 02/05/16 12:56, gmele wrote:
Hello,

your patched fixed the problem! Thx.
ok, thanks for testing and reporting the results.

Now, I'm able to go further in my tests with Oracle and found some problem
during the REGISTER:
The error is related to presence handling, not registration.

The octal code 012 corresponds to CR (end of line), which are present inside the xml document for presence.

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.

Cheers,
Daniel

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="sip:bob@ims-nagra.test" 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">sip:bob@ims-nagra.test</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: http://sip-router.1086192.n5.nabble.com/Kamailio-and-Oracle-database-tp147990p148025.html
Sent from the Users mailing list archive at Nabble.com.

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users


-- 
Daniel-Constantin Mierla
http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com