[OpenSIPS-Users] [Spam] Re: Is it possible to record CDR's into clear text into the MySQL Database into the MySQL Database
Răzvan Crainea
razvan at opensips.org
Thu May 15 14:04:45 CEST 2014
Hi, Gordon!
Those are the default CDR values, you can't prevent them from being
stored. However, if you want extra values, you should use the db_extra
module parameter[1].
[1] http://www.opensips.org/html/docs/modules/1.12.x/acc#id295025
Best regards,
Razvan Crainea
OpenSIPS Core Developer
http://www.opensips-solutions.com
On 05/15/2014 02:36 PM, Gordon Sims wrote:
> 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.
>> -------------------------------------------------------------
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
More information about the Users
mailing list