cdrtool (5.3.0) unstable; urgency=low * Renamed OpenSER radius table Framed-Protocol to ENUMtld to accomodate discounts based on ENUM top level domain. This functionality requires changes to the database structures and reconfigure several components: 1. Setup OpenSER to log a new Radius attribute ENUM-TLD: modparam("acc", "radius_extra", "Sip-RPid=$avp(s:rpid); \ ... ENUM-TLD=$avp(s:enum_tld)") if (enum_query("e164.arpa.")) { xlog("L_INFO", "Found E2U+sip address in e164.arpa: $ru"); avp_delete("$avp(s:enum_tld)/g"); avp_write("e164.arpa", "$avp(s:enum_tld)"); } 2. update OpenSER radius dictionary with: ATTRIBUTE ENUM-TLD 232 string 3. reload the SQL stored procedures into the radius database from: setup/radius/OpenSER/radius_accounting.proc 4. update Freeradius OpenSER dictionary with: ATTRIBUTE ENUM-TLD 232 string 5. update Freeradius configuration with the new configuration from: setup/radius/OpenSER/radius_accounting.conf 6. restart Feeradius server 7. rename the column FramedProtocol to ENUMtld in all radiusYYYYMMDD tables. This operation can take a long time to complete depending on the number of records in the table. During this modification no accounting records can be written to the table. When using table auto-rotation with SQL stored procedures, it is best to apply these changes in the first day of the month imediately after the table rotation moment. alter table radacctYYYMMDD change column FramedProtocol ENUMtld varchar(64) not NULL; 8. apply the changes from setup/mysql/alter_tables.mysql * Removed unused SOAP directory * Better organize NGNPro client provisioning library * Added ENUM tld management in the Rating page -- Adrian Georgescu Wed, 19 Sep 2007 14:23:05 +0200 cdrtool (5.2.6) unstable; urgency=low * Log in syslog the duration of reloading of the rating tables and of the sip accounts into memcacche -- Adrian Georgescu Tue, 04 Sep 2007 19:06:31 +0200 cdrtool (5.2.5) unstable; urgency=low * Replaced multiple SOAP definitions from global.inc with a pointer to an entry from the $soapEngines defined in soap_engines.inc * Fixed read of HTTP vars in sip trace, public traces are now visible when global vars are turned off -- Adrian Georgescu Mon, 03 Sep 2007 12:13:57 +0200 cdrtool (5.2.4) unstable; urgency=low * Skip billing_rates.trafficRate absent from csv import * Update rating documentation * Added link to FreeRADIUS-CDRTool by Dan-Cristian Bogos * Fixed sip trace purging * Fix for virtualhost allowing .htaccess customization for cdrtool -- Adrian Georgescu Tue, 21 Aug 2007 10:02:49 +0200 cdrtool (5.2.3) unstable; urgency=low * Allow usernames without domain part in quota check * Added publish of SIP domain statistics using SIP SIMPLE -- Adrian Georgescu Tue, 31 Jul 2007 13:14:43 +0200 cdrtool (5.2.2) unstable; urgency=low * Added SIP trace for SIP Thor datasource -- Adrian Georgescu Thu, 19 Jul 2007 11:53:24 +0200 cdrtool (5.2.1) unstable; urgency=low * Synced UPDATE queries for current and older month (in SQL stored procedures) (you must apply changes from setup/mysql/alter_tables.mysql) -- Adrian Georgescu Tue, 03 Jul 2007 17:25:52 +0200 cdrtool (5.2.0) unstable; urgency=low * Eliminate the race condition that appears when normalization process is performed between the time radius database is updated when a BYE arrives and the MediaProxy updates the same radius record. -- Adrian Georgescu Tue, 03 Jul 2007 14:51:40 +0200 cdrtool (5.1.9) unstable; urgency=low * Removed print of sql query -- Adrian Georgescu Thu, 28 Jun 2007 18:26:27 +0200 cdrtool (5.1.8) unstable; urgency=low * Fixed saving the agreement with license page -- Adrian Georgescu Thu, 28 Jun 2007 10:21:39 +0200 cdrtool (5.1.7) unstable; urgency=low * Added SOAP/XML management for LCR * Save when the user agrees with the usage license to avoid display the license agreement at each login -- Adrian Georgescu Sun, 24 Jun 2007 13:16:32 +0200 cdrtool (5.1.6) unstable; urgency=low * Fixed calculus of historical rates when rate is found in alternative profile -- Adrian Georgescu Tue, 19 Jun 2007 09:35:39 +0200 cdrtool (5.1.5) unstable; urgency=low * Hide price when grouping results for login accounts without showPrice right -- Adrian Georgescu Thu, 07 Jun 2007 10:01:32 +0200 cdrtool (5.1.4) unstable; urgency=low * Fixed a typo in cdrlib.phtml -- Adrian Georgescu Mon, 14 May 2007 08:47:24 +0200 cdrtool (5.1.3) unstable; urgency=low * Fixed pagination of exported records -- Adrian Georgescu Wed, 2 May 2007 12:30:27 +0200 cdrtool (5.1.2) unstable; urgency=low * Show status of multiple mysql clusters Must migrate global.inc setting $CDRTool['replicated_databases'] to $CDRTool['mysql_clusters'] See setup/global.inc.in for example -- Adrian Georgescu Tue, 1 May 2007 10:16:37 +0200 cdrtool (5.1.1) unstable; urgency=low * Updated sample data for rating tables * Updated mysql schema * Fixed bug in csv import script -- Adrian Georgescu Sun, 29 Apr 2007 11:35:09 +0200 cdrtool (5.1.0) unstable; urgency=low * Added historical rating engine, requires changes in database structure (you must apply changes from setup/mysql/alter_tables.mysql) * Must add in global.inc "AccountsDBClass" => "DB_ser" for each SER data-source, there is no default anymore * Added a sample provisioning interface (MSP only) * Added function to obfuscate caller Ids, this changes the login rights The login accounts rights must be updated in the Accounts page * Added capability to do accounting for SIP URIs (e.g. paid helpdesk) * Improved compatibility with Firefox in media sesessions screen * Added rights for login accounts to show pricing and caller id * Removed unused NGN rating (billing_customers table has been modified, please update your CSV file import tools) * Modify index of rates tables to accomodate multiple applications (you must apply changes from setup/mysql/alter_tables.mysql) * Default application set to 'audio', application field is now mandatory when importing rates CSV files * Added SIP Thor enable per data-source * Use separate name spaces for memcache keys per data source * Allow quota checks for multiple OpenSER data-sources * Show memory usage in syslog * Print sql errors in syslog -- Adrian Georgescu Sun, 15 Apr 2007 10:19:07 +0200 cdrtool (5.0.10) unstable; urgency=low * Fixed reload of prepaid accounts from rating page to reload only the prepaid account that has changed (when PHP register_globals if off) * Fixed logging in prepaid history table -- Adrian Georgescu Wed, 31 Jan 2007 17:04:48 +0100 cdrtool (5.0.9) unstable; urgency=low * Added /var/www/CDRTool/scripts/replicationStatus.php script to easily check the database replication process Add to global.inc $CDRTool['replicated_databases']=array('DB1','DB2'); and defined DB1 and DB2 connections to the mysql databases that replicate to each other. The connections must use the same IP addresses and usernames used during the setup of the replication process -- Adrian Georgescu Sat, 20 Jan 2007 16:14:09 +0100 cdrtool (5.0.8) unstable; urgency=low * Enable failover between CDR databases for normalization process db_class can be an array with database connection classes * Removed db_class_readonly from global.inc -- Adrian Georgescu Sat, 20 Jan 2007 12:03:19 +0100 cdrtool (5.0.7) unstable; urgency=low * Fixed version to be compliant with debian native version numbering -- Adrian Georgescu Wed, 10 Jan 2007 13:54:33 +0100 cdrtool (5.0-6) unstable; urgency=low * Avoid unnecessary sql OR clause in CDR search that caused slow queries -- Adrian Georgescu Mon, 8 Jan 2007 08:37:02 +0100 cdrtool (5.0-5) unstable; urgency=low * Fixed determination of previous year in update_raddact_record_mediaproxy Consolidate SET statements to minimize binary log entries. Fixed bug in update_raddact_record_mediaproxy, the record values were reset after execution of update on the first table causing failure to update the previous table. setup/radius/OpenSER/radius_accounting.proc must be reloaded into the MySQL server: mysql -u root -p -h sipdb radius < setup/radius/OpenSER/radius_accounting.proc * Use same CDR structure for MaxSessionTime and DebitBalance * Change logging for prepaid actions to fit one line * Normalize tries previous month if no record has been updated * Mention how to see prepaid account status * Updated rating docs * Moved E164 class to phplib/local.inc * Show accounts with quota that exceeded a certain treshold scripts/SER/quotaShowAccounts.php treshhold * Added documentation for the Quota system (doc/QuotaSystem.txt) * Use normalization lock per table using GET_LOCK() server function http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html This provided faster web response when multiple clients access the interface * Fixed confirmation for delete operations in rating tables when global vars are turned off in php.ini -- Adrian Georgescu Thu, 4 Jan 2007 15:32:52 +0100 cdrtool (5.0-4) unstable; urgency=low * Better logging of prepaid calls in progress * Added reloadPrepaidAccounts function to avoid reload of all rating tables when only one prepaid account has changed * Updated rating documentation * Corrected some lintian errors for debian packaging -- Adrian Georgescu Wed, 27 Dec 2006 11:53:09 +0100 cdrtool (5.0-3) unstable; urgency=low * Fixed re-normalization of calls in previous monthly tables * Fixed cached storage after re-normalize calls for previous months * Clean ups in import csv files functions -- Adrian Georgescu Thu, 21 Dec 2006 12:45:13 +0100 cdrtool (5.0-2) unstable; urgency=low * The Import script for the rating files automatically detects if a file has been previously imported and skips it * Hide non-existent radius tables from datasource selection * Fixed indexes of rating tables (see alter_tables.mysql) * Fixed errors present in CSV import functions * Added Country_code per customer, can be used within normalization class -- Adrian Georgescu Thu, 21 Dec 2006 12:37:31 +0100 cdrtool (5.0-1) unstable; urgency=low * Added scripts to display quota usage and settings * Avoid duplicate tables in data source selection -- Adrian Georgescu Mon, 18 Dec 2006 16:51:08 +0100 cdrtool (5.0) unstable; urgency=low * Added support for MediaProxy accounting using Radius. Upgrade to mediaproxy version >=1.8.0 is required to use this feature * Added MySQL stored procedure for auto-rotation of radacct table using radacctYYYMM table name format. This avoids manual purging of accounting tables and the need for optimization of indexes, which can lock database tables for writing and cause downtime. Requires modification of sql.conf based on setup/radius/OpenSER/radius_accounting.conf, recompilation of Freeradius server with CLIENT_MULTI_RESULTS flag enabled for mysql connections and mediaproxy >= 1.8.0. See the documentation from setup/radius/OpenSER/radius_accounting.proc for more information * Added new patch for freeradius setup/radius/freeradius/freeradius.patch * Replaced the E164Format function with a customizable class from global.inc: $CDRTool['normalize']['E164Class'] that default instantiates E164_Europe. See E164_Europe or E164_US in cdrlib.phtml for examples of how to customize the behaviour of the normalization function * Remove unused settings from global.inc: CountryNumberLength, EnableSIPOnline, MinPstnNumLen, RotateThisMonth, RotateTables, normalize0SecCalls and memcache (only if the OS is Debian, which reads it from /etc/default/cdrtool) * Set many defaults in the code to avoid explicit definitions in global.inc * Default pagination is now 15 records, which better fits one 1024/768 screen * Allow OpenSER subscriber login in CDRTool based on ha1 encrypted passwords * Corrected the disposition mysql field in the Asterisk cdr table * Added invisible property for datasources in global.inc, useful to hide it from web elements like sip_trace datasource that cannot be directly accessed * Fixed media sessions statistics, IP traffic must be multiplied by two when both SIP UAs are outside the MediaProxy network * Fixed rating bug when either increment and minduration = 1 * Fixed pid file name of ratingEngine in /etc/init.d/cdrtool * Updated term and conditions page displayed after login * Log when quota has been exceeded * Fixed logging of normalized totals * More clear syslog logging statements * Update rotate table logic -- Adrian Georgescu Thu, 14 Dec 2006 20:33:26 +0100 cdrtool (4.8) unstable; urgency=low * Log updates of rating tables * Better display of log entries * Log access to Registrar, Media and Usage pages * Show the name of data sources in Log page * Fixed display of timezone in all main menu items * CDRTool version number points to the changelog * It is possible to mark individual sip traces as public -- Adrian Georgescu Mon, 27 Nov 2006 16:23:59 +0100 cdrtool (4.7-8) unstable; urgency=low * Show cached usage only if showUsageFromCache is set in global.inc * Fixed relative link to style.css in login screen * Show friendly names for SIP Proxy machines in sip trace (see setup/global.inc.in) * Fixed filtering of media sessions for login accounts with domain filter * Added arrows to indicate SIP trace packet direction * Show small SIP UA images for incomming messages in SIP trace * Adjust trace to src/dst siptrace module fixes in OpenSER >= 1.1 -- Adrian Georgescu Sat, 25 Nov 2006 12:44:55 +0100 cdrtool (4.7-7) unstable; urgency=low * Write sql trace in daily tables (changed sql.conf in freeradius configuration) * Display platform total usage in OpenSER datasource (from cache) * Show transport protocol in SIP online * Fixed show domain details in sip online * Filter statistics depending on CDRTool login rights * Add links to statistrics screen from main menu * removed /var/www/CDRTool/scripts/generateHTMLUsageIndexFile.php /var/www/CDRTool/status/usage/index.phtml is generated on the fly * Fixed relative link to style.css -- Adrian Georgescu Sun, 19 Nov 2006 13:41:15 +0100 cdrtool (4.7-6) unstable; urgency=low * Log the real SIP-Proxy-IP in radacct in place of NAS-IP-Address. Requires update of Freeradius server configuration (sql.conf and dictionary.ser) and OpenSER configuration * Added per customer settings to specify the minimum charged duration and time increments. For example it is possible to charge a minimum of 30 seconds and round up the duration to every next 10 seconds. Requires two new columns in billing_customers table (see alter_tables.mysql) * Fixed bugs in quotaCheck process, added quotaCompare.php script to check sync problems between the CDR usage and cached usage, removed cache for inbound traffic usage * Added new SIP UA pictures (Nokia, Scientific-Atlanta Webstar, Ekiga) * Fixed errors in building statistics for online totals * Authorized access to the Usage web page. /var/www/CDRTool/status/usage/index.html must be deleted /var/www/CDRTool/status/usage/index.phtml must be generated using /var/www/CDRTool/scripts/generateHTMLUsageIndexFile.php script * Show memcache capacity usage -- Adrian Georgescu Thu, 16 Nov 2006 19:49:50 +0100 cdrtool (4.7-5) unstable; urgency=low * Fixed Reload of rating tables * Show SIP Proxy IP in CDR results screen * Fixed quota reset -- Adrian Georgescu Wed, 1 Nov 2006 14:27:28 +0100 cdrtool (4.7-4) unstable; urgency=low * Fixed debian package deps to install by default php5-memcache * Allow login passwords greater than 10 characters * Minor HTML changes in OpenSER CDR display * Comment out double definitions present in freeradius server * Enabled SSL in example virtual host * Adjust maximum size of network traffic generated by MediaProxy * Consolidate media statistics per caller domain and add totals * Added 2 new settings to global.inc to filter zones for statistics -- Adrian Georgescu Tue, 31 Oct 2006 12:12:59 +0100 cdrtool (4.7-3) unstable; urgency=low * Increased default memcache and php memory to 128MB * Fixed statistics to work with domains that have no online users * Corrected wrong example of memcache location in sample configuration file * Added style.css file to debian package -- Adrian Georgescu Thu, 26 Oct 2006 12:20:57 +0200 cdrtool (4.7-2) unstable; urgency=low * Added monthly usage caches for SIP domains and platform total in and out * Improved display of SIP traces * Added new screenshots * Removed _darcs directory from the debian package * Use DB_ser database class if DB_online not defined * Add checks to mysql database creation script * Log balance updates from the web in prepaid_history table -- Adrian Georgescu Sun, 22 Oct 2006 14:57:35 +0200 cdrtool (4.7-1) unstable; urgency=low * Renamed database class used by quota check system * Updated rating documentation -- Adrian Georgescu Wed, 11 Oct 2006 09:27:28 +0200 cdrtool (4.7-0) unstable; urgency=low * Improved the speed of normalization and quota processes with a factor > 10 This requires the installation of a memcache server and setup of global.inc to point to the memcache server (default is 127.0.0.1:11212) * Added memcache to cdrtool startup script and /etc/default/cdrtool * A new database table cdrtool.memcache has been created to store data in mysql when a memcache server is not available (see setup/mysql/alter_tables.mysql) * Added graphical statistics for SIP online subscriber and MediaProxy usage Added a new cron script scripts/buildStatistics.php * Hide Sendmail button if CDR query has no description * Quota checks is now much faster by reusing incremental learned data * Cache SIP subscribers and domains into memcache * Cache destinations into memcache * Calls can be rated if the duration is greater than a minimum duration -- Adrian Georgescu Fri, 29 Sep 2006 18:18:58 +0200 cdrtool (4.6-9) unstable; urgency=low * Added note about the dependency on the PHP SOAP library in doc/INSTALL.txt -- Adrian Georgescu Tue, 19 Sep 2006 22:42:21 +0200 cdrtool (4.6-8) unstable; urgency=low * Fixed variable names in phplib to avoid the need for registering global variables in php.ini * Tested CDRTool successfully against apache2/php5 * Create CDRTool/local/images directory during installation * Remove sample apache configuration, is available in apache2 * Updated apache 2 virtual host definition -- Adrian Georgescu Sun, 3 Sep 2006 12:26:56 +0200 cdrtool (4.6-7) unstable; urgency=low * Update sample configuration for new installations * Update documentation of rating engine * Perform speeds test for the postpaid and prepaid applications (results are available in the rating engine documentation) * Removed Event-Timestamp from dictionary.ser, it is present now in freeradius standard distribution * Simplify default configuration * Remove unused declaration of table_missed * Replaced $cdr with $this->cdrtool and removed it from global.inc * Allocate more memory at start time from phplib -- Adrian Georgescu Fri, 25 Aug 2006 14:01:21 +0200 cdrtool (4.6-6) unstable; urgency=low * Migrate from CVS to darcs version control * Set executable flag for php scripts after installation * Hide _darcs directory in apache * Log the loading of prepaid accounts during start-up -- Adrian Georgescu Thu, 10 Aug 2006 15:57:20 +0200 cdrtool (4.6-5) unstable; urgency=low * Fixed search in query logs by string -- Adrian Georgescu Tue, 8 Aug 2006 12:14:17 +0200 cdrtool (4.6-4) unstable; urgency=low * Added script to reload rating engine scripts/reloadRatingTables.php * cdrtool init.d script can reload the rating engine * Added sample configuration for monit in setup/monit/monitrc * Update description of 488 code -- Adrian Georgescu Mon, 7 Aug 2006 10:49:19 +0200 cdrtool (4.6-3) unstable; urgency=low * Properly put ratingEngine in background releasing the terminal -- Adrian Georgescu Sun, 06 Aug 2006 18:05:05 +0200 cdrtool (4.6-2) unstable; urgency=low * debian packaging improvements -- Adrian Georgescu Sun, 06 Aug 2006 17:12:05 +0200 cdrtool (4.6-1) unstable; urgency=low * Created CDRTool debian package * Added filter for listing the query log, users with admin right may select and edit all queries * Added a new index in the log table (see setup/mysql/alter_tables.mysql) -- Adrian Georgescu Sat, 5 Aug 2006 11:17:56 +0200