[OpenSIPS-Users] Is it possible to record CDR's into clear text into the MySQL Database

[Răzvan Crainea]

Hi, Gordon!

Actually this CDR is not encrypted, the data is taken plain text from 
the message. Here is the interpretation of a few fields:

26A86646-D8FC11E3-9507C13F-D7186497 at 10.0.119.253 - callid
4BD8F748-1DEE - from tag
as09912ec8 - to tag

Best regards,

Razvan Crainea
OpenSIPS Core Developer
http://www.opensips-solutions.com

On 05/12/2014 02:53 PM, Gordon Sims wrote:
> Hello Razvan,
>
> I thought that the encryption would have happened by default for
> security reasons, but thought it could have been disabled.  The record
> below shows the encryption:
>
> 13331862014-05-12
> 01:01:49826A86646-D8FC11E3-9507C13F-D7186497 at 10.0.119.253
> <mailto:26A86646-D8FC11E3-9507C13F-D7186497 at 10.0.119.253>4BD8F748-1DEEas09912ec82014-05-12
> 06:03:55
>
> Here is the debug that I caught from
>
> May 12 01:01:57 NXSVG0AA1 /usr/local/opensips_proxy/sbin/opensips[5505]:
> DBG:core:build_res_buf_from_sip_res: copied size: orig:102, new: 16,
> rest: 412 msg=#012SIP/2.0 200 OK#015#012Via: SIP/2.0/UDP
> 10.0.119.253:5060;branch=z9hG4bK261710#015#012From: "6309409512"
> <sip:6309409512 at 10.0.119.253
> <mailto:sip%3A6309409512 at 10.0.119.253>>;tag=4BD8F748-1DEE#015#012To:
> <sip:13096701121 at 10.0.119.61
> <mailto:sip%3A13096701121 at 10.0.119.61>>;tag=as09912ec8#015#012Call-ID:
> 26A86646-D8FC11E3-9507C13F-D7186497 at 10.0.119.253#015#012CSeq
> <http://26A86646-D8FC11E3-9507C13F-D7186497@10.0.119.253#015#012CSeq>:
> 102 BYE#015#012Server: FPBX-2.11.0(1.8.25.0)#015#012Allow: INVITE, ACK,
> CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO,
> PUBLISH#015#012Supported: replaces, timer#015#012Content-Length:
> 0#015#012#015#012
>
>
> So the numbers are there, but, not sure why its recording the Call-ID in
> the matter that it is.
>
> Please let me know if there is anything else that should be looked at.
>
> Thanks,
>
> Gordon
>
> Hi, Gordon!
>
> CDRs are never stored encrypted in the database. Can you send an example
> of such record?
>
> Best regards,
>
> Razvan Crainea
> OpenSIPS Core Developer
> http://www.opensips-solutions.com <http://www.opensips-solutions.com/>
>
> On 05/09/2014 03:05 PM, Gordon Sims wrote:
>
>     I'm fairly new to Opensips, and have been trying out different routing
>     engines to see which one will work best.  I do like the performance of
>     this application and the ability to use an external MySQL server to host
>     the data.  However I've noticed that the CDR Records are all recorded
>     being encrypted into the database.  I've followed the instructions from
>     the documents for 1.11 and am possibly overlooking something very simple
>     in my config file to change how the CDR's are recorded into the
>     database.  Looking to be pointed in the right direction or smacked
>     upside the head.
>
>     Thanks in advance,
>
>     Gordon
>
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>