[SR-Users] Kamailio and Oracle database

Daniel-Constantin Mierla miconda at gmail.com
Mon May 2 13:48:11 CEST 2016


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 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.
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160502/ca550c38/attachment.html>


More information about the sr-users mailing list