Re: [SR-Users] Kamailio and Oracle database

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@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-tp1479… Sent from the Users mailing list archive at Nabble.com. _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users(a)lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users