[SR-Users] Kamailio and Oracle database

[gmele]

Hello,

your patched fixed the problem! Thx.

Now, I'm able to go further in my tests with Oracle and found some problem
during the REGISTER:

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