[OpenSIPS-Users] new CDRTool release 7.0.0

[Adrian Georgescu]

Changelog:

cdrtool (7.0.0) unstable; urgency=low

    * You must update Freeradius configuration with sql.conf and  
reload the
      radius_accounting.proc in the radius database depending on your  
setup
    * You must apply the database changes from setup/mysql/ 
alter_tables.mysql
    * CSV file import formats have been adjusted, to see the current  
format
      export the rating files to CSV after applying the database changes
    * The increment and min_duration fields have been moved from
      billing_rates and billing_customers to the destinations table

    [ CDR Storage ]

    * Added FromHeader radius attribute
    * Added UserAgent radius attribute
    * Added SIP-Application-Type radius attribute
    * If freeradius-xs package from AG Projects is used you must  
upgrade to
      the latest Freeradius-XS 1.1.7-4

   [ WEB Output]

   * Added Genexis, Arris_TM722b and Webstar SIP UA images
   * Show application type (audio, video, chat, message, file-transfer)
   * Improved parsing of User-Agent and Server headers in SIP trace
   * Print hostnames instead of IP address in SIP trace table header
     the hostnames can be set per datasource, see sample configuration  
file
   * Show Destination names when grouping the CDRs by destination id
   * Manage the number of maximum parallel sessions for each prepaid  
account

   [ Rating Engine ]

   * Added increment, min_duration, max_duration, max_price for each
     destination, the usage of these fields is described in RATING.txt
   * Removed increment, min_duration from billing_customers
   * Removed increment, min_duration from billing_rates
   * Removed increment, min_duration from billing_rates_history
   * Added max_sessions column to prepaid table
   * Added note in INSTALL.txt about creating the trusted peer table
   * Fixed billing tables indexes to contain the reseller_id column
   * Added normalization for SIP MESSAGE method
   * Added max_price and max_duration for each destination
   * Improved rating engine logging
   * Added note in documentation about setting the impersonate field  
to 0.0
   * Clean-up the start procedure of the rating engine
   * Return false if a mysql failure occurs during query in prepaid  
table
     instead of the mysql error text
   * Check the sanity of imported columns from CSV files
   * Log in syslog when loading broken destinations from the  
destination table
   * Log in syslog and e-mail the missing rates and destinations
   * Implement max_sessions for prepaid calls, default is one session
   * Fixed MySQL reconnection errors that could lead to engine shutdown
   * Check IP and port number before starting rating engine

   [ NGNPro Client ]

   * NGNPro server 4.1.11 or later is required
   * Use admin credentials when update customers in administrator panels
   * Deactivate PSTN rights if is the first payment
   * Fixed init of quota for accounts in SIP Thor backend
   * Display results of multiple actions on SIP accounts
   * Added change_privacy_access_number, check_privacy_access_number,
     reject_anonymous_access_number
   * Check if reseller is allowed to perform prepaid changes
   * Added Blink enrollment
   * Added Credit Card transactions
   * Added translation files for SIP settings page
   * Add prepaid users to group prepaid
   * Added emergency_regions per engine
   * Added forwarding access codes per engine

The software can be downloaded as a tar archive from:

http://download.ag-projects.com/CDRTool/

For those running Debian unstable there is an official public  
repository. To use it, add
these lines in /etc/apt/sources.list

# AG Projects software
deb     http://ag-projects.com/debian unstable main
deb-src http://ag-projects.com/debian unstable main

Install the AG Projects debian software signing key:

wget http://download.ag-projects.com/agp-debian-gpg.key
apt-key add agp-debian-gpg.key

After that, run:

sudo apt-get update
sudo apt-get install cdrtool

Regards,
Adrian