<HTML>
<HEAD>
<TITLE>Re: [OpenSIPS-Users] CDRTool CDR search display columns</TITLE>
</HEAD>
<BODY>
<FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>Adrian,<BR>
<BR>
Administrator privileges, and:<BR>
<BR>
</SPAN></FONT><FONT SIZE="2"><FONT FACE="Lucida Console"><SPAN STYLE='font-size:8pt'>"opensips_radius"=>array(<BR>
"name" => "OpenSIPS_fp1",<BR>
"class" => "CDRS_opensips",<BR>
"db_class" => array("DB_radius"),<BR>
"table" => "radacct".date("Ym"),<BR>
"rateField" => "Rate",<BR>
"rating" => "0",<BR>
"E164_class" => "E164_US", // define a custom class to determine the E164 for a telephone number<BR>
// see E164 classes as example in library/cdr_generic.php<BR>
"priceField" => "Price",<BR>
"DestinationIdField" => "DestinationId",<BR>
"normalizedField" => "Normalized",<BR>
"BillingPartyIdField"=> "UserName",<BR>
"db_susbcribers" => "DB_opensips",<BR>
"domain_table" => "domain", // table of db_susbcribers that holds domains served by the sip proxy<BR>
"subscriber_table" => "subscriber", // table of db_susbcribers that holds susbcribers served by the sip proxy<BR>
// "intAccessCode" => "011", // international acess code, numbers prefixed with this are considered international destinations<BR>
// "natAccessCode" => "1", // international acess code, numbers prefixed with this are considered national destinations<BR>
"sipTrace" => "sip_trace",<BR>
"mediaTrace" => "media_trace",<BR>
"UserQuotaClass" => "OpenSIPSQuota",<BR>
"UserQuotaNotify" => "0", // send e-mail notifications when quota is exceeded<BR>
"soapEngineId" => '',<BR>
"domainTranslation" => array(<BR>
"gw02.domain.com" => "pstn.domain.com" // translate Realm<BR>
),<BR>
"SourceIPRealmTranslation" => array(<BR>
"10.0.0.1" => "gateway.example.com" // translate Realm for sessions originating from IP address 10.0.0.1<BR>
),<BR>
"purgeCDRsAfter" => 999, // how many days to keep old CDRs, valid only when Radius tables are not atomatically rotated<BR>
"db_registrar" => "DB_opensips", // opensips location database<BR>
"enableThor" => false, // set to true if using SIP Thor<BR>
//"mediaSessions" => "sipthor", // NGNPro engine id used by SIP Thor<BR>
//"networkStatus" => "sipthor", // NGNPro engine id used by SIP Thor<BR>
"mediaDispatcher" => "tcp:mediadispatcherhost:25061", // Where to get the active media sessions from MediaProxy 2.0<BR>
// Create /etc/cdrtool/mediaproxy.pem containing the certificate and private key<BR>
"mediaServers" => array(<BR>
"0.0.0.0"<BR>
) // where to get the active sessions from MediaRroxy 1.x<BR>
),<BR>
</SPAN></FONT></FONT><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><BR>
- Jeff<BR>
<BR>
<BR>
<BR>
<BR>
On 1/12/09 2:50 PM, "Adrian Georgescu" <<a href="ag@ag-projects.com">ag@ag-projects.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'>This is obviously a bug. Can you tell me what Permissions you have set for the account you login with and what settings you have in global.inc for your OpenSIPS data source?<BR>
<BR>
Adrian<BR>
<BR>
On Jan 12, 2009, at 8:42 PM, Jeff Pyle wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'> Hello,<BR>
<BR>
When we search for CDRs in CDRTool 6.7.1, it appears the Price column is being skipped. We have a correct value for Dur, but the KBIn value shows up in the Price column, KBOut under KBIn, Status shows up under KBOut, Codecs under Status, and the Codec column is empty. Expanding the entry shows “Free call” under rating information. That makes sense as have no rating information configured.<BR>
<BR>
How might one get the display to have a blank column for Price, or eliminate it altogether?<BR>
<BR>
<BR>
Regards,<BR>
Jeff<BR>
<BR>
_______________________________________________<BR>
Users mailing list<BR>
<a href="Users@lists.opensips.org">Users@lists.opensips.org</a><BR>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:10pt'><BR>
<BR>
</SPAN></FONT></BLOCKQUOTE>
</BODY>
</HTML>