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-tp14799... 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