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" <raz...@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@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@10.0.119.253
<mailto:26A86646-D8FC11E3-9507C13F-D7186497@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@10.0.119.253
<mailto:sip%3A6309409512@10.0.119.253>>;tag=4BD8F748-1DEE#015#012To:
<sip:13096701121@10.0.119.61
<mailto:sip%3A13096701121@10.0.119.61>>;tag=as09912ec8#015#012Call-ID:
26A86646-D8FC11E3-9507C13F-D7186497@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@lists.opensips.org <mailto:Users@lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org <mailto:Users@lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@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@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
