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

Gordon Sims gsims94 at gmail.com
Thu May 15 13:36:51 CEST 2014


Thank you Razvan for the clarification,

So it appears to be pulling data from somewhere that I do not want to
record.  I presume that there should be a setting or definition in the
opensips.cfg file that would tell it where to pull the proper data from.

Here is a snippet of mine:

#### ACCounting module
loadmodule "acc.so"
/* what special events should be accounted ? */
modparam("acc", "early_media", 0)
modparam("acc", "report_cancels", 0)
/* by default we do not adjust the direct of the sequential requests.
   if you enable this parameter, be sure the enable "append_fromtag"
   in "rr" module */
modparam("acc", "detect_direction", 0)
modparam("acc", "cdr_flag", "ACC_CDR")
modparam("acc", "failed_transaction_flag", "ACC_FAILED")
/* account triggers (flags) */
modparam("acc", "db_flag", "ACC_DO")
modparam("acc", "db_table_acc", "acc")
modparam("acc", "db_missed_flag", "ACC_MISSED")
modparam("acc", "db_table_missed_calls", "missed_calls")
modparam("acc", "acc_from_tag_column", "from_tag")
modparam("acc", "db_url",
        "mysql://randomuser:p4sSw0rd@10.0.9.23/sip_gate") # CUSTOMIZE ME



route{

        if (method == "INVITE") {
                create_dialog();
                setflag(ACC_CDR);
                setflag(ACC_DO); # do accounting ...
                record_route();
                xlog("INBOUND CALL,$dd,$ru,$ci,$fn,$fu");
                route(10);
                exit;

I guess the question would be, is there any documentation on how to modify
what is sent over to the MySQL database?

Thanks again,

Gordon



On 5/15/14, 4:20 AM, "Răzvan Crainea" <razvan at opensips.org> wrote:

>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-1DEEas0
>>9912ec82014-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
>>
>
>_______________________________________________
>Users mailing list
>Users at lists.opensips.org
>http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>-------------------------------------------------------------
>This email was processed through Nexepe Spam filter to filter junk
>messages.
>If you feel this message has been tagged incorrectly, you can
>change its category by clicking the link below.
>Click here 
>http://10.0.9.41:5272/FrontController?operation=mbeu&f=00001_238_20140515_
>35928.eml&chkBayesian=1&pr=1&mt=0&ma=g to mark email as good.
>-------------------------------------------------------------





More information about the Users mailing list