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