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 _______________________________________________ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel