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

[Gordon Sims]

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
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>;tag=4BD8F748-1DEE#015#012To: <
sip:13096701121 at 10.0.119.61>;tag=as09912ec8#015#012Call-ID:
26A86646-D8FC11E3-9507C13F-D7186497 at 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

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
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140512/25e9150a/attachment.htm>