[OpenSIPS-Users] CDRTool CDR search display columns

Adrian Georgescu ag at ag-projects.com
Mon Jan 12 21:18:29 CET 2009


Hi Jeff,

Can you be more specific and tell me exactly what Permissions have you  
set in the web interface. There is nothing called Administrator.

Adrian


On Jan 12, 2009, at 9:02 PM, Jeff Pyle wrote:

> Adrian,
>
> Administrator privileges, and:
>
> "opensips_radius"=>array(
>                     "name"               => "OpenSIPS_fp1",
>                     "class"              => "CDRS_opensips",
>                     "db_class"           => array("DB_radius"),
>                     "table"              => "radacct".date("Ym"),
>                     "rateField"          => "Rate",
>                     "rating"             => "0",
>                     "E164_class"         => "E164_US",  // define a  
> custom class to determine the E164 for a telephone number
>                                                             // see  
> E164 classes as example in library/cdr_generic.php
>                     "priceField"         => "Price",
>                     "DestinationIdField" => "DestinationId",
>                     "normalizedField"    => "Normalized",
>                     "BillingPartyIdField"=> "UserName",
>                     "db_susbcribers"     => "DB_opensips",
>                     "domain_table"       => "domain",     // table  
> of db_susbcribers that holds domains served by the sip proxy
>                     "subscriber_table"   => "subscriber", // table  
> of db_susbcribers that holds susbcribers served by the sip proxy
>              //     "intAccessCode"      => "011",        //  
> international acess code, numbers prefixed with this are considered  
> international destinations
>              //     "natAccessCode"      => "1",          //  
> international acess code, numbers prefixed with this are considered  
> national destinations
>                     "sipTrace"           => "sip_trace",
>                     "mediaTrace"         => "media_trace",
>                     "UserQuotaClass"     => "OpenSIPSQuota",
>                     "UserQuotaNotify"    => "0",              //  
> send e-mail notifications when quota is exceeded
>                     "soapEngineId"       => '',
>                     "domainTranslation"  => array(
>                                                    
> "gw02.domain.com"      => "pstn.domain.com" // translate Realm
>                                                   ),
>                     "SourceIPRealmTranslation"  => array(
>                                                   "10.0.0.1"      =>  
> "gateway.example.com"  // translate Realm for sessions originating  
> from IP address 10.0.0.1
>                                                   ),
>                     "purgeCDRsAfter"     => 999,           // how  
> many days to keep old CDRs, valid only when Radius tables are not  
> atomatically rotated
>                     "db_registrar"       => "DB_opensips", //  
> opensips location database
>                     "enableThor"         => false,         // set to  
> true if using SIP Thor
>                     //"mediaSessions"      => "sipthor",     //  
> NGNPro engine id used by SIP Thor
>                     //"networkStatus"      => "sipthor",     //  
> NGNPro engine id used by SIP Thor
>                     "mediaDispatcher"    => "tcp:mediadispatcherhost: 
> 25061",    // Where to get the active media sessions from MediaProxy  
> 2.0
>                                                                        // Create 
>  /etc/cdrtool/mediaproxy.pem containing the certificate and private  
> key
>                     "mediaServers"       => array(
>                                                   "0.0.0.0"
>                                                   )  // where to get  
> the active sessions from MediaRroxy 1.x
>                     ),
>
> - Jeff
>
>
>
>
> On 1/12/09 2:50 PM, "Adrian Georgescu" <ag at ag-projects.com> wrote:
>
>> 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?
>>
>> Adrian
>>
>> On Jan 12, 2009, at 8:42 PM, Jeff Pyle wrote:
>>
>>> Hello,
>>>
>>>  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.
>>>
>>>  How might one get the display to have a blank column for Price,  
>>> or eliminate it altogether?
>>>
>>>
>>>  Regards,
>>>  Jeff
>>>
>>>   _______________________________________________
>>> 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/20090112/00b33058/attachment-0001.htm 


More information about the Users mailing list