CDRTool version 6.8.0

CDRTool version 6.8.0 has been released. The software contains bug fixes and new features related to partitioning of data for multiple resellers.

You must read and apply the change log carefully to migrate from an older version, in particular the changes from setup/mysql/alter_tables.mysql


cdrtool (6.8.0) unstable; urgency=low

  • Added reseller fields to all database tables to allow different login accounts to access their own data based on the account impersonate field
  • Allow import of CSV files from subdirectories (read updated 'Data partitioning for multiple resellers' section from RATING.txt)
  • Added prepaid_history table to rating table web management
  • Added increment and min_duration for each rate entry
  • Removed gateway, domain and subscriber columns from billing_profiles table
  • Removed gateway, domain and subscriber columns from billing_rates table
  • Removed gateway, domain and subscriber columns from billing_rates_history table
  • Updated CSV format for all rating tables to support the above changes, see setup/csv for updated examples of CSV files or export your live data from CDRTool rating tables page to see the new fields
  • Removed obsolete prepaid.call_lock and prepaid.call_in_progress columns
  • Removed obsolete customers.country_code column
  • Removed obsolete tables ratesNGN and profilesNGN
  • Renamed colummn prepaid_history.number with prepaid_history.description
  • Show SIP trace also in text only format
  • Do not log zero priced calls in prepaid_history table
  • Improved SIP prepaid provisioning screens
  • Skip math calculation for some rating tables
  • Added export balance history from SIP prepaid page
  • Updated ngnpro client to work with server version 4.1.1
  • Make stronger random passwords for SIP accounts
  • Improved NGNPro LCR functionality
  • Added scripts/OpenSIPS/notifyLastSessions.php to send email notifications containing the last sessions recived in the last 24 hours. You must set notifyLastSessions per data source to tru to enable this feature and put the susbcriber into missed_calls group
  • You must apply the changes from setup/mysql/alter_tables.mysql
  • You must add an integer `reseller_id` column to opensips.trusted and opensips.domain tables
  • Changed column prepaid_cards.value to decimal
  • Droped unused columns from prepaid table
  • Added a script to test the speed of the rating engine

For more information visit