<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>Hi Dilip,</div><div><br></div><div>I canot see any calls at all in your syslog entries. As a wild guess most probably your destination field is not formatted correctly, it should start with 00 to be matched by the standard destination lookup logic. </div></div><div><br></div><div>Can you paste the Radius accounting tickets for one OpenSER session (START, STOP, UPDATE radius tickets)? </div><div><br></div><div>You can find the radius tickets under /var/log/freeradius/radacct/*</div><div><br></div><div>Regards,</div><div>Adrian</div><div><br></div><div> <br><div><div>On Nov 17, 2008, at 1:25 PM, Dilip wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>hello Sir,<br>Actually i could not see the price in the CDRTool GUI.<br>I have configured it according to the rating document.but Still there is <br>not any calculation is start by cdrtool.<br>What may be the problem ???<br>I have paste here the syslog message...so please guide me.<br><br>Nov 17 06:50:01 cl-t041-080cl cdrtool[29397]: Unlock <br>asterisk_vm:asterisk_cdr<br>Nov 17 06:55:01 cl-t041-080cl cdrtool[29434]: Normalize datasource <br>ser_radius, database DB_CDRTool, table radacct<br>Nov 17 06:55:01 cl-t041-080cl cdrtool[29434]: Normalize lock id 12325 <br>aquired for ser_radius:radacct<br>Nov 17 06:55:01 cl-t041-080cl cdrtool[29434]: Normalize datasource <br>asterisk_vm, database DB_radius, table asterisk_cdr<br>Nov 17 06:55:01 cl-t041-080cl cdrtool[29434]: Normalize lock id 12325 <br>aquired for asterisk_vm:asterisk_cdr<br>Nov 17 06:55:01 cl-t041-080cl cdrtool[29434]: Unlock ser_radius:radacct<br>Nov 17 06:55:01 cl-t041-080cl cdrtool[29434]: Unlock <br>asterisk_vm:asterisk_cdr<br>Nov 17 07:00:01 cl-t041-080cl cdrtool[29471]: Normalize datasource <br>ser_radius, database DB_CDRTool, table radacct<br>Nov 17 07:00:01 cl-t041-080cl cdrtool[29471]: Normalize lock id 12344 <br>aquired for ser_radius:radacct<br>Nov 17 07:00:01 cl-t041-080cl cdrtool[29471]: Normalize datasource <br>asterisk_vm, database DB_radius, table asterisk_cdr<br>Nov 17 07:00:01 cl-t041-080cl cdrtool[29471]: Normalize lock id 12344 <br>aquired for asterisk_vm:asterisk_cdr<br>Nov 17 07:00:01 cl-t041-080cl cdrtool[29471]: Unlock ser_radius:radacct<br>Nov 17 07:00:01 cl-t041-080cl cdrtool[29471]: Unlock <br>asterisk_vm:asterisk_cdr<br>Nov 17 07:05:02 cl-t041-080cl cdrtool[29509]: Normalize datasource <br>ser_radius, database DB_CDRTool, table radacct<br>Nov 17 07:05:02 cl-t041-080cl cdrtool[29509]: Normalize lock id 12348 <br>aquired for ser_radius:radacct<br>Nov 17 07:05:02 cl-t041-080cl cdrtool[29509]: Normalize datasource <br>asterisk_vm, database DB_radius, table asterisk_cdr<br>Nov 17 07:05:02 cl-t041-080cl cdrtool[29509]: Normalize lock id 12348 <br>aquired for asterisk_vm:asterisk_cdr<br>Nov 17 07:05:02 cl-t041-080cl cdrtool[29509]: Unlock ser_radius:radacct<br>Nov 17 07:05:02 cl-t041-080cl cdrtool[29509]: Unlock <br>asterisk_vm:asterisk_cdr<br>Nov 17 07:08:39 cl-t041-080cl cdrtool[19924]: Normalize lock id 11823 <br>aquired for ser_radius:radacct<br>Nov 17 07:08:39 cl-t041-080cl cdrtool[19924]: Memory usage: 8.52MB, <br>memory limit: 16MB<br>Nov 17 07:08:39 cl-t041-080cl cdrtool[19924]: Loaded 3 profiles<br>Nov 17 07:08:39 cl-t041-080cl cdrtool[19924]: Loaded 0 ratesHistory<br>Nov 17 07:08:39 cl-t041-080cl cdrtool[19924]: Loaded 0 holidays<br>Nov 17 07:08:39 cl-t041-080cl cdrtool[19924]: Loaded 1 enumTlds<br>Nov 17 07:08:39 cl-t041-080cl cdrtool[19924]: Memory usage: 8.53MB, <br>memory limit: 16MB<br>Nov 17 07:08:39 cl-t041-080cl cdrtool[19924]: Normalization done in 0 s, <br>memory usage: 8.55 MB<br>Nov 17 07:08:40 cl-t041-080cl cdrtool[19924]: Unlock ser_radius:radacct<br><br>Please help me.<br>How to show the price in the CDRTool GUI.<br>I have import all the rating csv in the db.<br>below is my global.inc file of cdrtool.<br>Is there any mistake in the file.<br><br>#<br># 1. Change all hostnames and passwords according to the installation<br># 2. Copy this file to /etc/cdrtool/global.inc<br>#<br><br>###########################################<br># System and web paths<br><br>$CDRTool['tld'] = "/CDRTool";<br>$CDRTool['Path'] = "/var/www/CDRTool";<br>$_PHPLIB['libdir'] = $CDRTool['Path']. "/phplib/";<br>include($_PHPLIB["libdir"] . "prepend.php3");<br><br>###########################################<br># PHP Error reporting<br>$errorReporting = (E_ALL & ~E_NOTICE);<br>$errorReporting = 1; // comment this out to enable PHP warnings<br>error_reporting($errorReporting);<br><br>###########################################<br># Service provider information<br><br>$CDRTool['provider']['name'] = "Provider name";<br>$CDRTool['provider']['service'] = "SIP service";<br>$CDRTool['provider']['timezone'] = "Europe/Amsterdam";<br>$CDRTool['provider']['fromEmail'] = "<a href="mailto:support@example.com">support@example.com</a>";<br>$CDRTool['provider']['toEmail'] = "<a href="mailto:support@example.com">support@example.com</a>";<br>$CDRTool['provider']['sampleLoginSubscriber'] = "<a href="mailto:number@example.com">number@example.com</a>";<br>$CDRTool['provider']['sampleLoginDomain'] = "example.com";<br><br>###########################################<br># Rating engine settings<br>$RatingEngine=array("socketIP" => "1.2.3.4",<br> "socketPort" => "9024",<br> "CDRS_class" => "ser_radius",<br> "prepaid_lock" => true,<br> "log_delay" => 0.05,<br> "split_rating_table" => true, //false<br> "csv_delimiter" => ",",<br> "priceDenominator" => 10000, // e.g. 1 Eur = <br>10000 units<br> "priceDecimalDigits" => 4, // how many <br>digits to round the prices to<br> "minimumDurationCharged" => 0, // Only calls <br>greater than this duration will be charged<br> "durationPeriodRated" => 60, // the prices <br>from the rating table are calculated per this period<br> "trafficSizeRated" => 1024, // same as above <br>but for data traffic<br> "reportMissingRates" => 0, // send email <br>notifications if rates are missing from the ratingEngine<br> "minimumDuration" => 0, // minimum <br>duration to rate, if call duration is shorter the price is zero<br> "allow" => array ('67.'), // list <br>with local network clients allowed to connect<br> "MaxSessionTime" => 36000 // limit all <br>prepaid calls to maximum 10 hours<br> );<br><br>###########################################<br># Normalize engine settings<br>$CDRTool['normalize']['defaultCountryCode'] = "31";<br><br>###########################################<br># Anti-fraud settings<br># create group quota in OpenSER and deny calls to users in this group<br># $UserQuota["default"]["traffic"] = 5000; // MBytes<br>$UserQuota["default"]["cost"] = 1000; // Euro<br><br>###########################################<br># CDRTool datasources<br><br>class DB_CDRTool extends DB_Sql {<br> var $Host = "localhost";<br> var $Database = "cdrtool";<br> var $User = "root";<br> var $Password = "password";<br> var $Halt_On_Error ="yes";<br>}<br><br>class DB_Locker extends DB_Sql {<br> var $Host = "localhost";<br> var $Database = "cdrtool";<br> var $User = "root";<br> var $Password = "password";<br> var $Halt_On_Error ="yes";<br>}<br><br>class DB_radius extends DB_Sql {<br> var $Host = "localhost";<br> var $Database = "radius";<br> var $User = "root";<br> var $Password = "password";<br> var $Halt_On_Error ="no";<br>}<br><br>class DB_radius2 extends DB_Sql {<br> var $Host = "localhost";<br> var $Database = "radius";<br> var $User = "root";<br> var $Password = "password";<br> var $Halt_On_Error ="no";<br>}<br><br>class DB_subscribers extends DB_Sql {<br> var $Host = "sipdb";<br> var $Database = "openser";<br> var $User = "openser";<br> var $Password = "PASSWORD";<br> var $Halt_On_Error ="yes";<br>}<br><br>class DB_openser extends DB_Sql {<br> var $Host = "localhost";<br> var $Database = "openser";<br> var $User = "openser";<br> var $Password = "openserrw";<br> var $Halt_On_Error ="yes";<br>}<br><br>class DB_siptrace extends DB_Sql {<br> var $Host = "localhost";<br> var $Database = "openser";<br> var $User = "root";<br> var $Password = "password";<br> var $Halt_On_Error ="yes";<br>}<br><br>class DB_mediaproxy extends DB_Sql {<br> var $Host = "sipdb";<br> var $Database = "mediaproxy";<br> var $User = "mediaproxy";<br> var $Password = "PASSWORD";<br> var $Halt_On_Error ="yes";<br>}<br><br>$replicated_databases=array('cluster1'=>array(<br> "db1"=>array('ip' <br>=>'10.0.0.131',<br><br>'slave_of'=>'db-log2',<br> 'user' <br>=>'process',<br><br>'password'=>'password',<br><br>'replication_user' =>'replication',<br><br>'replication_password'=>'password',<br><br>'active_master' => true<br> ),<br> "db2"=>array('ip' <br>=>'10.0.0.132',<br><br>'slave_of'=>'db-log1',<br> 'user' <br>=>'process',<br><br>'password'=>'password',<br><br>'replication_user' =>'replication',<br><br>'replication_password'=>'password'<br> ) )<br> );<br><br>class DomainAuthLocal extends DomainAuth { // defined in <br>phplib/local.inc<br>}<br><br>class PageLayoutLocal extends PageLayout { // defined in <br>phplib/local.inc<br>}<br><br># To customize E164 normalization<br>class E164_custom extends E164 { // defined in library/cdr_lib.phtml<br>}<br># $CDRTool['normalize']['E164Class'] = "E164_custom";<br><br><br>$DATASOURCES=array(<br>"unknown"=>array(<br> "class" => "CDRS_unknown" // leave it here<br> ),<br>"ser_radius"=>array(<br> "name" => "OpenSER",<br> "class" => "CDRS_ser_radius",<br> #"table" => "radacct".date("Ym"),<br> "table" => "radacct",<br> "db_class" => <br>array("DB_radius2","DB_radius"), <br> "rating" => "1",<br> "normalizedField" => "Normalized",<br> #"UserQuotaClass" => "OpenSERQuota",<br> "AccountsDBClass" => "DB_openser",<br> "UserQuotaNotify" => "1",<br> "purgeCDRsAfter" => 120, // how many days to <br>keep the CDRs<br> "SIPProxies" => array("1.2.3.4" => <br>"node01", // friendly names in sip trace table<br> "10.0.0.2" => "node02",<br> ),<br> "intAccessCode" => "91", // <br>international acess code, numbers prefixed with this are considered <br>international destinations<br> "natAccessCode" => "1", // <br>international acess code, numbers prefixed with this are considered <br>national destinations<br> "domainTranslation" => <br>array( <br>"gw02.domain.com" => "pstn.domain.com" // translate realm ),<br> ),<br> "SourceIPRealmTranslation" => array(<br> "1.2.3.4" => <br>"gateway.example.com" // translate Realm for sessions originating from <br>IP address 10.0.0.1<br> ),<br> "db_class_siponline" => "DB_openser",<br> "mediaDispatcher" => "4.3.2.1", // where to get <br>the active media sessions from MediaProxy 2.0<br> "mediaServers" => <br>array( <br><br><br>"4.3.2.1" <br>) // where to get the active sessions from MediaRroxy 1.x<br><br> ),<br>"asterisk_vm" =>array("name" => "Voicemail server",<br> "class" => "CDRS_asterisk",<br> "table" => "asterisk_cdr",<br> "db_class" => "DB_radius",<br> "rating" => "1",<br> "normalizedField" => "Normalized",<br> "contexts" => array(<br><br>"SIP"=>array("WEBName"=>"OpenSER"),<br> ),<br> "traceInURL" => array(<br> "SIP"=>"ser_radius"<br> ),<br> "traceOutURL" => array(),<br> "purgeCDRsAfter" => 180 // how many days to keep <br>the CDRs<br> ),<br>"sip_trace" =>array(<br> "name" => "SIP trace",<br> "db_class" => "DB_siptrace",<br> "table" => "sip_trace",<br> "enableThor" => false,<br> "purgeRecordsAfter" => "7",<br> "invisible" => 1<br> ),<br>"media_trace" =>array(<br> "name" => "Media trace",<br> "db_class" => "DB_mediaproxy",<br> "enableThor" => false,<br> "invisible" => 1<br> )<br><br>);<br><br>// load CDRTool libraries<br>$CDRToolModules=array("openser","asterisk");<br><br>if ($_SERVER['REMOTE_ADDR']=="1.2.3.4") {<br> $verbose=1;<br>} else {<br> // prevent set of verbose via post/get<br> unset($verbose);<br>}<br><br><br>Please help me.<br>Regards,<br>Dilip<br><br><br><br><br><br><br>_______________________________________________<br>Users mailing list<br><a href="mailto: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></div></blockquote></div><br></div></body></html>