cdrtool (9.4.0) unstable; urgency=low * Added more logging * Updated default apache config [ Web Interface ] * Added more UA images * Support retina images * Fixed group by month * Fixed Asterisk CDR search * Replaced MRTG graphs with Flotr-2 graphs * Reworked media sessions screen * Reworked Provisioning Stats using d3 and flotr-2 * Disabled autocomplete in more fields [ NGNPro Client ] * Added setting to skip download tab * Fixed pasword reset and reminders for php 5.4 * Fixed adding TXT records * Changed city and sate to UTF-8 [ Rating ] * Fixed finding only 1 profile in rating instead of multiple -- Tijmen de Mes Mon, 19 Oct 2015 11:29:41 +0200 cdrtool (9.3.0) unstable; urgency=low * Added initial PHP 5.4 compatibility [ Web Interface ] * Changed domain field in CDR search to match wildcards * Escape customer data to prevent HTML input * Removed Non exsiting status code * Only display Yubikey if the library is installed * Prevent SQL injection against session * Added ip based ACL for login accounts * Fixed spam detection in login [ NGNPro Client ] * Fixed trace links in accounts * Fixed data in provisioning graphs * Changed default SOAP port order * Updated customer interface * Fixed disabling extra groups * Prevent changing zones for ENUM ranges * Updated Thor-network diagram * Added option to allow none local dns zones in provisioning * Added more logging for provisioning requests * Added email on sip account changes [ Rating ] * Changed PSTN destination selection to work only for numbers * Added index to quota_usage to get more speed -- Tijmen de Mes Thu, 20 Nov 2014 14:06:52 +0100 cdrtool (9.2.0) unstable; urgency=low [ Web Interface ] * Updated to font awesome 3 * Added yubikey support for CDRTool accounts * Fixed various minor layout issues * Updated languages * Added some endpoint imagaes * Fixed subscriber CDR view * Fixed searches for username and from uri [ Normalization ] * Reworked mysql connectors to skip 'ping' * Change normalizing process to run in batches of 1k records * Skip quota update if normalizing previous month * Optimze some functions for speed * Changed custom CSV writter to new formats * Added index to billing_customers: [ NGNPro client ] * Fixed siptrace links in account history * Added provisioning statistics * Added account delete possibility * Added password reset possibility [ Rating ] * Added the concept of 'subtypes' for applications. -- Tijmen de Mes Tue, 08 Apr 2014 12:27:41 +0200 cdrtool (9.1.1) unstable; urgency=low [ Web Interface ] * Updated subscriber CDR view to bootstrap -- Tijmen de Mes Mon, 18 Mar 2013 11:43:33 +0100 cdrtool (9.1) unstable; urgency=low [ Web Interface ] * Reworked network overview for MSP platform * Fixed notification of missed calls * Changed SIP login page to use bootstrap * Fixed various minor layout issues * Fixed login from sip accounts with encrypted passwords * Fixed currency display * Replaced date/time selection with date-/timepicker * Added examples to ACL/Owner and PSTN call limit in sip settings page [ Rating Engine ] * Fixed import logic * Added option to skip usage stats per datasource * Improved logging * Changed included radius config to use client generated Event-Timestamp instead of radius server generated timestamp * Fixed various queries for searching calls [ NGNPro client ] * Improved logging * Updated DNS templates * Added import/export for sip domains * Added import/export for DNS zones * Fixed sending multiple passwords reminders * Fixed enrollment bugs * Update example emails -- Tijmen de Mes Fri, 15 Mar 2013 10:36:35 +0100 cdrtool (9.0.1) unstable; urgency=low [ Rating Engine ] * Added rating based on SIP destination domain [ Web Interface ] * Fixed row display in search table for Firefox * Changed shadow in bootstrap white menubar * Updated bootstrap menubar * Added white navbar to boostrap * Added sip2sip dns records template [ NGNPro client ] * Added posibility for removal of chat_replication journal entries * Fixed sip domain auth checks at login * Update language translations * Removed comments causing xgettext to not read entire file * Fixed login error position * Fixed displaying multiple datasources in network overview * Updated bootstrap to include table warning * Changed customer logo display height in menu * Set default sip proxy from soap engine settings -- Adrian Georgescu Mon, 10 Dec 2012 11:20:08 +0100 cdrtool (9.0.0) unstable; urgency=low [ Rating Engine ] * Quote sql statements in rating engine * Adjusted radius procedure to not update media info from mediaproxy * Fixes in MaxRate CSV writter [ Web Interface ] * Refactored HTML layout using bootstrap project * Quote sql statements in authentication * Added Jingle Me icons * Fixed export balance link * Fixed updating accounts with empty passwords [ NGNPro client ] * Fixed sip client enrollment errors * Added timezone and language to enrollment * Fixed email template functions * Fixed sending registration email to billing email address * Fixed owner in sip settings page * Moved SOAP error from local lib to syslog * Updated password reminder function * Quote sql statements in cc processing * Update sipo client page translations -- Adrian Georgescu Tue, 09 Oct 2012 15:03:55 +0200 cdrtool (8.4.0) unstable; urgency=low [ Rating Engine ] * Fixed admin password hash in install file * Fixed daily quota check and variable name. Contributed by Brian Chamberlain * Fixed getting sip traces * Hide renormalize checkbox if web page normalization is disabled * Added disconnect code to normalize init and added calls with 0 duration(200 OK) to MaxRate CSV * Use default number when RPID contains letters for MaxRate * Fixed CDRwritter MaxRate flow names * Added setting to skip normalize on web page load * Fixed writing to the same file in CSVWritter/Normalize process * Updated time in radius procedure and formatted code better [ NGNPro client ] * Added storage for client journals * Added get and put journal for clients API calls * Fixed on-net display for resellers * Refactor get history api * Fixed get calls functions * Fixed decoding of audio types in history panel * Fixed settings ttl for DNS record templates * Fixed quoting sql query [ Web Interface ] * Update SIP DNS record template * Print help for NAPTR record edit form * Fixed subscriber login * Fixed AP 'country' by rewriting to N/A * Fixed time addition after media update and formatted some code -- Adrian Georgescu Mon, 18 Jun 2012 11:43:36 +0200 cdrtool (8.3.0) unstable; urgency=low [ Rating Engine ] * Fixed populating domain field in prepaid queries * Fixed escaping of destination names * Changed SipRPID field to be saved decoded * Fixed on-net rating for divert-on-net and on-net-divert-on-net * Fixed fallback to default destinations * Fixed rating calculation when crossing spans * Several MaxRate additions and fixes [ NGNPro client ] * Fixed changing diplay name when logged in as customer * Fixed login_type when accessing sip settings page as customer/reseller * Hide pstn related settings if PSTN access is not granted * Added CallerID support to email templates * Fixed UK country in CC processor * Fixed showing Blocked option [ Web Interface ] * Change CDR column header * Added image for CISCO spa303 phone * Added jitsi sip ua logo * Added qutecom sip ua logo * Added MD5 password hashing support * Fixed loginform to be able to use the JS -- Adrian Georgescu Thu, 19 Apr 2012 11:09:43 +0200 cdrtool (8.2.5) unstable; urgency=low * Added rate-on-net capability * Append flow to extra field in csv for MaxRate * Added CallerID support to SIP email templates * Added additional scenarios for MaxRate -- Adrian Georgescu Wed, 22 Feb 2012 09:30:45 +0100 cdrtool (8.2.4) unstable; urgency=low [ NGNPro client ] * Fixed call limit in enum generator page * Added timezone lookup * Added geoip lookup to sip enrollment * Urlencode link to settings page -- Adrian Georgescu Wed, 04 Jan 2012 11:09:03 +0100 cdrtool (8.2.3) unstable; urgency=low [ Rating Engine ] * Save decoded value of radius username in database * Fixed showing incoming calls when logged in as user account * Added gigaset and csipsimple logos [ NGNPro client ] * Do not set preferences if the account is not really blocked * Show invoice link in card purchase email notifications * Fix selection by flow * Improve description of aliases * Use soap engine default values for call limit and ip access list -- Adrian Georgescu Fri, 11 Nov 2011 10:34:27 +0100 cdrtool (8.2.2) unstable; urgency=low [ NGNPro client ] * Fixed setting pstn and prepaid for ENUM generator SIP accounts * Change ENUM generator table title * Open enum generator results in the same page * Change html link to ENUM generator -- Adrian Georgescu Tue, 11 Oct 2011 10:57:05 +0200 cdrtool (8.2.1) unstable; urgency=low [ NGNPro client ] * Requires NGNPro server 4.3.0 * Added search by group to SIP accounts port * Added IP access list management per subscriber * Adapted Trusted peers to changes in permissions module * Fixed passing reseller and customer to soap credentials * Use proper soap credentials when accessing rating port * Show SIP account call limit instead of groups * Fixed sip account wildcards in delete URL * Updated translations * Fixed saving PSTN max calls limit * Removed compatibility with NGNPro version 1 * Allow setting global show_barring_tab -- Adrian Georgescu Sun, 09 Oct 2011 10:55:27 +0200 cdrtool (8.2.0) unstable; urgency=low [ Rating Engine ] * Fixed selecting calls with no price * Fixed normalizing the flow column * Added destinations.region field to documentation * Removed define_syslog_variables() for php 5.3 [ Web Interface ] * Added search and group by call flow * Fixed search and group by an empty field * Fixed searching for an empty billing party * Fixed fieldname time_stamp for text export SIP trace on MSP * Hide media graph if there are no streams * Added search option for calls with no media [ NGNPro client ] * Added PSTN call limit, requires NGNPro 4.2.0 * Fixed initializing soap engine * Mail web_password if set instead of SIP account password * Check web_passsword if set in user profile * Added separate password to login to the web page * Use web password in digest authentication * Fixed check of array of customer properties * Enable credit check by default -- Adrian Georgescu Wed, 14 Sep 2011 13:31:01 +0200 cdrtool (8.1.2) unstable; urgency=low [ Rating Engine ] * Fixed prepaid engine bug that appeared under certain load conditions * Fixed inclusion of missing patches for PHP 5.3.3 compatibility * Fixed detection of reseller id for trusted peers * Fixed rate calculation when minimum charge duration is set [ NGNPro client ] * Replaced tabs with spaces in some files * Rollback Fixed hiding html output when making ngnpro request -- Adrian Georgescu Thu, 16 Jun 2011 09:57:31 +0200 cdrtool (8.1.1) unstable; urgency=low * Fixed link to individual calls when group by canonical uri * Fixed export for OpenSIPS CDRs to csv file -- Adrian Georgescu Fri, 10 Jun 2011 12:04:58 +0200 cdrtool (8.1.0) unstable; urgency=low [ Rating Engine ] * Added microseconds accuracy for datetime storage columns See setup/radius/OpenSIPS/now_usec.readme * Skip printing data source names that are not going to be normalized * Removed pass by reference statements incompatible with PHP 5.3.3 * Added code 476 to SIP response codes [ NGNPro client ] * Fixed setting reseller in sip settings page * Refactored card processor to support refunds * Hide payment page if account is blocked * Added refund functionality to credit tab in sip settings page * Added refundPayment function in paypal processor * Improved validation of CC payments * Fixed hiding html output when making ngnpro request * Update readme about microseconds accuracy * Added display_name to Blink download applet -- Adrian Georgescu Mon, 09 May 2011 08:58:08 +0200 cdrtool (8.0.19) unstable; urgency=low * Increased quota usage when billing party is local -- Adrian Georgescu Mon, 11 Apr 2011 12:18:02 +0200 cdrtool (8.0.18) unstable; urgency=low * Fixed mysql re-connections for PHP 5.3 * Fixed TLS connections to media-dispatcher for PHP 5.3 * Trim spaces when loading destinations from database * Minor NGNPro client changes -- Adrian Georgescu Tue, 05 Apr 2011 13:45:02 +0200 cdrtool (8.0.17) unstable; urgency=low * Display Contact address in sip trace page * Check maximum credit transactions per day -- Adrian Georgescu Thu, 17 Mar 2011 14:41:47 +0100 cdrtool (8.0.16) unstable; urgency=low * Mention skipNormalize variable in sample config file [ NGNPro Client ] * Allow definition of custom groups for SIP accounts -- Adrian Georgescu Thu, 10 Mar 2011 10:47:56 +0100 cdrtool (8.0.15) unstable; urgency=low * Fixed compatibility with PHP 5.3 * Work-around for misterious missing <> brackets from the soap result on some systems -- Adrian Georgescu Mon, 14 Feb 2011 16:47:47 +0100 cdrtool (8.0.14) unstable; urgency=low * Added domain translations in normalize function * Added URI translations for CDRwritter -- Adrian Georgescu Thu, 10 Feb 2011 16:07:30 +0100 cdrtool (8.0.13) unstable; urgency=low * Fixed closing some html tags -- Adrian Georgescu Thu, 13 Jan 2011 11:40:31 +0100 cdrtool (8.0.12) unstable; urgency=low * Fixed division by zero when duration is 0 in media sessions * Fixed warning in network topology view when role attributes are not an array * Revert wrong fix for CSV writter netflow determination -- Adrian Georgescu Mon, 10 Jan 2011 14:39:07 +0100 cdrtool (8.0.11) unstable; urgency=low [ Rating Engine ] * Fixed netflow determination for CDR writter * Fixed wrong diverter for CDR writter in 4.2.4 [ NGNPro Client ] * Fixed VAT calculation for prepaid credit * Do not provision server addresses anymore -- Adrian Georgescu Mon, 20 Dec 2010 23:16:34 +0100 cdrtool (8.0.10) unstable; urgency=low * Fixed bug when appending line in CSV writter -- Adrian Georgescu Fri, 10 Dec 2010 12:08:57 +0100 cdrtool (8.0.9) unstable; urgency=low [ Rating Engine ] * Added CSV writter scenarios for on-net-diverted-off-net and on-net-diverted-on-net * Added a RPID cache in CSV writter to minimize number of queries [ NGNPro Client ] * Update translations -- Adrian Georgescu Tue, 30 Nov 2010 16:40:51 +0100 cdrtool (8.0.8) unstable; urgency=low [ Rating Engine ] * Fixes in CSV writter * Updated sample csv files [ WEB interface] * Display rejected streams in red in SIP trace * Fixed display of media information in SIP trace * Update translations [ NGNPro Client ] * Added $CDRTool['ngnpro_reseller_engine'] setting in global.inc * Fixed checks of SOAP credentials in provisioning page * Remove unused MSN and Yahoo account settings code * Update payments display * Update enrollment to not return server addresses * Added DID manager prototype * Fixed adding subacconut in Customer section -- Adrian Georgescu Tue, 23 Nov 2010 11:42:07 +0100 cdrtool (8.0.7) unstable; urgency=low * Fixed replacing dot in regex when querying generateMrtgData * Updated timezones files to reflect system timezones better * Use localtime in date printed in email notifications for last calls * Update login panel text * Replace CDRTool logo with a transparent one * Added Siemens Gigaset * Added Teles gateway icon -- Adrian Georgescu Fri, 05 Nov 2010 13:29:41 +0100 cdrtool (8.0.6) unstable; urgency=low [ Rating Engine ] * Speedup the process of reloading destinations * Added skip_prefixes to CSV writter * Fixed filter by date and customer in various tables [ WEB interface] * Fixed description field in grouped by destination_id view * Update transparency of some UA icons * Added icons for Ipkall, Nimbuzz and SIP Communicator [ NGNPro Client ] * Fixed login credentials for NGNPro requests when logged in as customer level * Fixed missing enum lookup when showing forwarding tab -- Adrian Georgescu Wed, 06 Oct 2010 09:34:12 +0200 cdrtool (8.0.5) unstable; urgency=low [ Rating Engine ] * CSV writter fixes [ SIP client page ] * Update sample enrollment settings * Do not set account passport if TLS settings are missing from enrollment * Added settings for missed_calls via email * Html changes in missed calls email notification * Fixed cvv number check -- Adrian Georgescu Thu, 09 Sep 2010 14:10:19 +0200 cdrtool (8.0.4) unstable; urgency=low * More logic fixes in CSV writter -- Adrian Georgescu Thu, 26 Aug 2010 13:00:32 +0200 cdrtool (8.0.3) unstable; urgency=low [ Rating Engine ] * Fixed mailing of broken rates * CSV writter updates [ SIP client page ] * Return mdns account created during enrollment * Use owner if provided by enrollment * Change default credits for free accounts * Detect os from browser when presenting download page for Blink * Show quota usage when logged in as subscriber * Moved render_download_applet from Enrollment to SIP settings * Added configuration for msrp relay * Added Support tab * Added configuration for blink_settings_page -- Adrian Georgescu Mon, 23 Aug 2010 10:25:44 +0200 cdrtool (8.0.2) unstable; urgency=low * Fixed import of region field from destinations csv * Fixed check of IP address value -- Adrian Georgescu Fri, 30 Jul 2010 10:24:11 +0200 cdrtool (8.0.1) unstable; urgency=low [ Rating Engine ] * Fixed import of destinations csv file [ NGNPro Client ] * Added back realm used for digest authentication from Blink cocoa * Do not print a link to SIP Thor when page is embedded in a SIP client * Set quota to zero earlier when account is fetched * Added security for the digest algorith used for SIP settings page * Added settings to append domain to xcap_root * Removed diversions to voicemail after vm account has been deleted * Improved return of errors in json delivered back to enrollment clients * Added control to toggle display of some abs in sip settings page -- Adrian Georgescu Thu, 29 Jul 2010 18:02:36 +0200 cdrtool (8.0.0) unstable; urgency=low [ Rating Engine ] * Fixed deblocking of users blocked by quota system * Apply the database changes from setup/mysql/alter_tables.mysql * Added support to debit balance for SMS * Separate calculate functions for Audio and SMS * Added import function for billing discounts * Added discounts per customer per destination * Added increment and min_duration per customer * Added daily_quota per data source setting and check quota usage based on it * Enlarged the login column in log table * Set daily_quota for new installations to 10% * Init the quota usage for today to 0 after quota reset * Improve syslog message for maxsessiontime * Use Subscriber instead of Account in rating tables display for consistency * Added discounts to the list of csv files to import * Rename profile name variables to match weekday and weekend * Added storage for daily quota * Log to syslog the result of maxsessiontime even if call is unlimited * Use sms or audio rate calculation depending on CDR type during normalization [ NGNPro Client ] * Hide Prepaid Card form for embedded clients * Define groups for enrollment of sip account in configuration * Use sender email when asking for cc payments [ WEB Output ] * Trim RPID for whitespaces * Renamed applicationType to application and fixed display of streams information * Improved look and feel of main menu * Fixed broken main css * Added MediaInfo selection box and beautify code a bit * Fixed display of gateways in delete rules screen * Improved documentation * Improved display of media trace stream sequence * Refactor rating engine to use Region to group destinations * Update Blink logo -- Adrian Georgescu Mon, 19 Jul 2010 14:33:50 +0200 cdrtool (7.1.1) unstable; urgency=low * Hide duration from quota table [ Normalization ] * Save call flow in radius table * Fixed call flow detection [ NGNPro Client ] * Apply the database changes from setup/mysql/alter_tables.mysql * Update translations * Improve sip settings payments tab * Fixed enrollment username checks * Fixed display of soap error * Fixed CC length check * Added identity checks for CC payments -- Adrian Georgescu Mon, 29 Mar 2010 11:33:55 +0200 cdrtool (7.1.0) unstable; urgency=low * Added support for ICE negotiation (requires MediaProxy >=2.4.0) You must update Freeradius configuration with sql.conf and reload the stored procedures file radius_accounting.proc in the radius database * Insert/update sql queries in Freeradius sql.conf have been deprecated in favour of the stored procedure * Added EPC2203 user agent -- Adrian Georgescu Mon, 22 Feb 2010 11:35:28 +0100 cdrtool (7.0.2) unstable; urgency=low [ WEB Output ] * Added Android user agent picture [ Normalization ] * Check if callee is local * Added /var/spool/cdrtool/normalize to debian directories * Added preliminary support for writing normalized CDRs to a file [ Rating Engine ] * Limit the number of simultaneous calls only if they have cost * Fixed test procedure call in documentation [ NGNPro Client ] * Added settings_url to the enrollment procedure * Check timezone provided by SIP device during enrollment * Set default account type for new sip accounts to prepaid * Fixed selecting Contact groups in Accept tab -- Adrian Georgescu Sun, 24 Jan 2010 22:16:13 +0100 cdrtool (7.0.1) unstable; urgency=low * Added rounded corners for mozilla browsers * Added sms rigts for resellers and subscribers * Use text type in place of select for no-answer timeout * Fixed test stored procedure calls * Fixed bugs in enrollment for sip accounts -- Adrian Georgescu Tue, 12 Jan 2010 09:38:24 +0100 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 * 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 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 -- Adrian Georgescu Thu, 17 Dec 2009 11:26:40 +0100 cdrtool (6.9.9) unstable; urgency=low * Added database keepalive features to workaround the 2006 mysql error * Add description for how to customize cdrtool classes * Added Fring UA images * Added example in config about subclassing opensips class * Replace geolocation lookup code with a function * Hide Dialable URI if contains wildcards * Hide barring tab and display more balance history entries * Added comment about purpose of sip_ files * Added sip enrollment * Added sip settings pages using digest and x509 auth * Improved look and feel of SIP settings page * Fixed overwriting of DNS record type * Fixed display of geolocation in sip devices list * Print home node unknown if lookup fails * Use only first name when composing email notifications * Save owner with DNS fancy records * Fixed pstn rule selection box -- Adrian Georgescu Mon, 09 Nov 2009 13:29:09 +0100 cdrtool (6.9.8) unstable; urgency=low * Use the debian provided geoip database and library. See docs/Install.txt for notes related to obtaining city level information * Fixed pstn gateway rule selection box * Added instructions for how to subclass the generic CDRS_opensips class in global.inc.complex.sample * Fixed no-answer timeout -- Adrian Georgescu Wed, 21 Oct 2009 14:24:01 +0200 cdrtool (6.9.7) unstable; urgency=low * Added geoip.dat to debian package -- Adrian Georgescu Wed, 14 Oct 2009 16:14:10 +0200 cdrtool (6.9.6) unstable; urgency=low * Improved SIP settings page * Renamed quota reset to quota deblock * Show ENUM range selection in numbers * Save email address used for SIP account registration * Fix display of SIP prepaid balance * Use fixed public contact from NGPro * Added more functions to the sip API * Remove adressbook export * Move geoip.dat in main directory * Added instructions for requesting client certificate * Added sip enrollment and sip settings using X.509 * Rename variables and function names * Added links to export of client certificate in info tab * Moved Reject to Accept tab * Added Diversion tab * Removed Diversions from main settings page * Added Enrollment configuration template * Added more one shot functions for SIP account information * Moved user interface to renderUI library * Refactor sip_settings to handle X.509 client certificates * Renamed some variables for clarity -- Adrian Georgescu Tue, 13 Oct 2009 23:14:08 +0200 cdrtool (6.9.5) unstable; urgency=low * Normalize.php script can chose a differet month * Allow argument to normalize.php script to chose a different month * Allow set of enum_generator for a reseller depending on ngnpro engine * Fix typo in sip_settings.php page -- Adrian Georgescu Wed, 16 Sep 2009 15:36:32 +0200 cdrtool (6.9.4) unstable; urgency=low * Allow argument to normalize.php script to chose a differet month -- Adrian Georgescu Thu, 10 Sep 2009 11:39:00 +0200 cdrtool (6.9.3) unstable; urgency=low * Fixed insert into prepaid table * Fixed url in PSTN gateways * Fixed column name in sip_trace table when purging * Fixed encoding of html links to sip and media trace * Fixed building statistics with online devices in OpenSIPS datasource -- Adrian Georgescu Sun, 06 Sep 2009 19:16:41 +0200 cdrtool (6.9.2) unstable; urgency=low * Added labbels for all SIP Thor network entities -- Adrian Georgescu Sat, 29 Aug 2009 10:07:18 +0200 cdrtool (6.9.1) unstable; urgency=low * Added labbels for SIP Thor nodes * Updated freeradius pacthes from Norman Brandinger * Export X509 certificate associated with the SIP account -- Adrian Georgescu Wed, 19 Aug 2009 16:13:21 +0200 cdrtool (6.9.0) unstable; urgency=low * Display geographic location using geo ip * Fixed variable names that did not match the config * Fixed logging of imported rows from csv files * Created two standard profiles (OpenSIPS and SipThor) for subscriber login, see class DomainAuthLocal extends OpenSIPS_DomainAuth in global.inc * Fixed export of CSV with prepaid history * Hide called address in missed session list * Refactored PSTN provisioning, NGNPro >= 4.1.5 is required * Show timezone in SIP accounts list * Display prepaid balance in SIP accounts list * Do not change quota when toggle the prepaid flag * Specify a default timezone per engine * Cache returns from lookup sip_proxy from Thor network -- Adrian Georgescu Wed, 15 Jul 2009 23:45:32 +0200 cdrtool (6.8.1) unstable; urgency=low * Do not send emails if no missed calls * Fixed search by username * Fixed import of billing_profiles * Notify also diverted sessions * Fix display of CDRs when logged in as SIP account, also show incoming calls -- Adrian Georgescu Thu, 18 Jun 2009 08:49:20 +0200 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 -- Adrian Georgescu Sun, 24 May 2009 17:31:15 +0200 cdrtool (6.7.8) unstable; urgency=low * Updated NGNPro client to work with server version 4.1.0 * Added functions for managing gateway rules * Fixed LCR provisioning bugs * Fixed gateway links from Carriers page * Make stronger random passwords for SIP accounts -- Adrian Georgescu Mon, 20 Apr 2009 11:53:33 +0200 cdrtool (6.7.7) unstable; urgency=low * Fixed missing ENUMtld and Gateway in ShowPrice function -- Adrian Georgescu Wed, 08 Apr 2009 23:08:45 +0200 cdrtool (6.7.6) unstable; urgency=low * Removed obsolete prepaid_lock feature * Apply the changes from setup/mysql/alter_tables.mysql * Floor the call duration to make the prepaid DebitBalance use the same duration as ShowPrice used by normalization process -- Adrian Georgescu Sat, 04 Apr 2009 16:31:21 +0200 cdrtool (6.7.5) unstable; urgency=low * Fixed display of rating info -- Adrian Georgescu Thu, 26 Mar 2009 14:31:06 +0100 cdrtool (6.7.4) unstable; urgency=low * Fixed reload of rating engine (thanks to Dan Bogos) -- Adrian Georgescu Mon, 16 Mar 2009 18:49:11 +0100 cdrtool (6.7.3) unstable; urgency=low * Logging text improvements * Fixed bug with accessing $perm object when is not defined * Removed cached destinations on engine startup * Update Radius patches from Norm Brandinger norm@goes.com * Allow end-users to see more CDR details * Move ip address of sip proxy a bit to the left * Add sip_proxy to the statistics array even if no accounts are online * Added php5-gd to dependencies * Disable unnecessary mysql queries when quota is disabled * Better html text in sip login page * Added info about radius clients.conf (patch from aseques@gmail.com) * Removed pacth already applied to freeradius main tree * HTML changes in provisioning screens * Added information about how to generate debian package * Correct mysql upgrade queries -- Adrian Georgescu Sat, 14 Mar 2009 23:50:44 +0100 cdrtool (6.7.2) unstable; urgency=low * Fixed number of columns in cdr when rating is disabled * Improve installation and rating documentation * Print errors when configuration items are missing from global.inc * Clean up call search page * Removed MediaProxy 1.0 sessions * Renamed in global.inc SourceIPRealmTranslation to domainTranslation_SourceIP * Print stream duration instead of stop time in media trace * Display a limited view of network topology for non-admin accounts * Fix login name used for logging [ NGNPro related changes ] * Added screen for sip login reminder * Added section about login account setup * Improve download instructions * Added falback billing profiles in sip settings page * Added vcard function * Do not use reseller in the sip settings page link if account belongs to another reseller. * Added https key mapping * Display both sip_proxy and media_relay roles in SIP Thor circle -- Adrian Georgescu Sun, 18 Jan 2009 13:11:58 +0100 cdrtool (6.7.1) unstable; urgency=low * Simplified the sample configuration file global.inc.simple.sample * Improved installation documentation -- Adrian Georgescu Fri, 19 Dec 2008 09:51:13 +0100 cdrtool (6.7.0) unstable; urgency=low * Migrated to OpenSIPS, this version is incompatible with OpenSER, do not upgrade to this version if you still use OpenSER * Added support for Call Control prepaid application from http://download.ag-projects.com/CallControl * Normalize the duration of prepaid CDRs to match the duration calculated by Call Control, this avoids price missmatch between debit price and the price calculated during normalization * Updated OpenSIPS radius dictionary * Updated Freeradius server setup procedure wiht OpenSIPS and MediaProry dictionaries * Added checks for values in rating tables changed from the web page * Improved retrieval and display of SIP traces from OpenSIPS * Improved retrieval and display of Media traces from MediaProxy * Reset the imported records counter before importing each csv file * Added new fields in billing_rates connectCostIn and durationRateIn to store the purchased price, the rating info now contains two prices for each call. The CSV format of rating table has been changed to support provisioning of purchased prices. Updated sample csv file for billing_rates. * Improved rating documentationin general * Moved E164 class to cdr_generic.php and allow specification of which E164 class should be used for each datasource * Updated sample configuration files in setup/global.inc.*.sample * Added new columns to prepaid_history to store information about sessions that lead to debit balance * Log duration of prepaid sessions in prepaid_history table * Removed unused trafficRate from the rating engine and mysql tables * Added CallerId to SIP accounts in ENUM generator * Added support for new LCR engine from NGNPro4 * Removed one empty column from ENUM records that had no mappings * Added domain column to the prepaid table * To upgrade you must apply the changes from doc/Upgrade.txt and setup/mysql/alter_tables.mysql -- Adrian Georgescu Wed, 17 Dec 2008 14:13:54 +0100 cdrtool (6.6.10) unstable; urgency=low * Added Force=1 parameter to DebitBalance(), see PREPAID.txt for more info * Return none when destination id cannot be found (unlimited max session time) * More consistent return codes and logging messages for prepaid calls * Improve prepaid documentation -- Adrian Georgescu Sat, 04 Oct 2008 12:36:04 +0200 cdrtool (6.6.9) unstable; urgency=low * Purge old entries from prepaid_history table * Fixed wrong return to call control engine becuase sessionDoesNotExist variable was not initialized properly at each request * Print the call id in the syslog when calculating rate -- Adrian Georgescu Wed, 01 Oct 2008 00:11:35 +0200 cdrtool (6.6.8) unstable; urgency=low * Log debit balance to prepaid_history table -- Adrian Georgescu Tue, 30 Sep 2008 05:19:58 +0200 cdrtool (6.6.7) unstable; urgency=low * Do not debit balance for inexistent prepaid sessions -- Adrian Georgescu Sun, 28 Sep 2008 00:20:09 +0200 cdrtool (6.6.5) unstable; urgency=low * Fixed purging of expired prepaid sessions -- Adrian Georgescu Fri, 26 Sep 2008 19:01:49 +0200 cdrtool (6.6.4) unstable; urgency=low * Added links to Prepaid calls and quota in the main menu * Fixed showFooter() when exporting csv files from rating page * Fixed prepaid table mysql schema -- Adrian Georgescu Sun, 21 Sep 2008 01:39:00 +0200 cdrtool (6.6.3) unstable; urgency=low * Cache rate values from billing_rates table during MaxSessionTime to avoid mysql queries for the same values -- Adrian Georgescu Fri, 12 Sep 2008 18:27:15 +0200 cdrtool (6.6.2) unstable; urgency=low * Fixed concurrent prepaid calls handling -- Adrian Georgescu Tue, 09 Sep 2008 18:50:05 +0200 cdrtool (6.6.1) unstable; urgency=low * Fixed update of existing prepaid session * Return error text for maxsessiontime and debitbalance * Callid in maxsessiontime and debitbalance is mandatory * Preserve search criteria after delete sip account * Better logs for prepaid calls -- Adrian Georgescu Tue, 09 Sep 2008 11:20:24 +0200 cdrtool (6.6.0) unstable; urgency=low * Allow simultaneous calls for prepaid accounts, see the Simultaneous prepaid calls section in doc/PREPAID.txt * Added pseudo code examples for call control engine * Apply the changes from setup/mysql/alter_tables.mysql * Added interface to kill ongoing sessions in Prepaid page -- Adrian Georgescu Mon, 08 Sep 2008 13:37:20 +0200 cdrtool (6.5.8) unstable; urgency=low * Fixed wsdl for deleteGatewayGroup function -- Adrian Georgescu Sun, 31 Aug 2008 17:19:06 +0200 cdrtool (6.5.7) unstable; urgency=low * Check custom properties for customer port before loading * Added defaultDomain filter to sample ngnpro_engines.inc * Better error logging when rating tables are incorrectly provisioned * Show XCAP root in sip settings email notification * Fixed duplicate ENUM number is sip settings page -- Adrian Georgescu Thu, 28 Aug 2008 14:36:45 +0200 cdrtool (6.5.6) unstable; urgency=low * Updated normalize logic for the case where the session received a broken BYE that did not generate a STOP while MediaProxy generated an UPDATE -- Adrian Georgescu Fri, 22 Aug 2008 17:07:51 +0200 cdrtool (6.5.5) unstable; urgency=low * Fixed bug that allowed for some CDRs to remain in 'in progress' state. by setting ConnectInfo_stop explicitly to '' empty string. You must update radius configuration with sql.conf or reload the radius_accounting.proc in the radius database depending on your setup * Search by un-normalized calls with duration * Do not normalized calls in the web if more than 500 un-normalized calls. * Fixed sample config files * Better error printing when connection to databases fail * Print error when cannot connect to radius primary or secondary database * Fixed log of database class used for normalization -- Adrian Georgescu Thu, 21 Aug 2008 10:05:55 +0200 cdrtool (6.5.4) unstable; urgency=low * Fixed save and retrieve of sip proxy server when add DNS records for sip * Fixed wrong password reset because of web browsers that cache password fields * Preserve sip account quota value when toggling access to pstn * Added group by Canonical URI in CDR search screen * Fixed name of group used for blocking accounts (blocked instead of block) * Removed unused siplewire functionality -- Adrian Georgescu Thu, 14 Aug 2008 12:06:06 +0200 cdrtool (6.5.3) unstable; urgency=low * Log id of inserted record into rating tables * Fixed broken links between group by SIP Proxy and search calls * Show quota reset even if not blocked * The soap server returns the object created for all add() functions * Added DNS complex records for sip, msrp, xmpp, thor * Added NGNPro fancy records management (email and url forwarding) * Added currency setting per soap engine and reseller * Many bug fixes in dns management port * Detect reseller zero in sip settings page * Show progress of loading quota * Added management for extra groups in Sip settings -- Adrian Georgescu Mon, 21 Jul 2008 15:34:44 +0200 cdrtool (6.5.2) unstable; urgency=low * Fixed name of OpenSERQuota class in global.inc sample files * Fixed MySQL 2006 error for ReloadQuota function * Added NGNPro DNS port * Fixed required phone_images.php in sip settings page * Fixed REMOTE_ADDR variable * Fixed path of logo images * Show method used for blocking accounts by quota (db/soap) -- Adrian Georgescu Sun, 06 Jul 2008 19:53:59 +0200 cdrtool (6.5.1) unstable; urgency=low * Added support for MediaProxy 2.0 accounting * Added prepaid card generator in Rating section * Rewrite ratingEngine daemon to be non blocking * Added IP access list to the ratingEngine $RatingEngine['allow'] * Added new setting in global.inc called 'mediaDispatcher' to point to the media dispatcher of MediaProxy 2, used to display media sessions * Added ShowClients command to rating engine * Removed support for php4 * Fixed error related to MySQL gone away (2006) * Support prepaid calls to work with increment and min_duration settings * Added web links between sip trace and media trace pages * Fixed ShowPrice rating engine command * Added /etc/cdrtool config directory Move CDRTool/local to /etc/cdrtool/local * Moved all library *_lib.phtml files to library/*.php * Changed csv import directory from /var/www/CDRTool/csv to /var/spool/cdrtool * Document split_rating_table feature in Rating.txt * Gateway attribute is now mandatory for MaxSessionTime and DebitBalance commands * Fixed update of Enum number selections * Moved setting $servers from status/config/media_servers.php to global.inc in each data source as 'mediaServers' * Default for split_rating_table is false (global.inc) * Added change password for sip accounts selection * Lowercase the email addresses and sip usernames * Update cron job, moved env LANG=C into php script * No mysql changes * After upgrading the software to this version run these actions: sudo mv /var/www/CDRTool/global.inc /etc/cdrtool/ sudo mv /var/www/CDRTool/provisioning/ngnpro_engines.inc /etc/cdrtool/ sudo rm -r /var/www/CDRTool/provisioning sudo mv /var/www/CDRTool/local/images/* /var/www/CDRTool/images/ sudo mv /var/www/CDRTool/local /etc/cdrtool/ sudo rm -r /etc/cdrtool/local/images Edit /etc/cdrtool/global.inc and replace ser with openser in the line: $CDRToolModules=array("ser","asterisk","rating"); and remove rating from it, example: $CDRToolModules=array("openser","asterisk"); Set "UserQuotaClass"=> "OpenSERQuota" in global.inc (it was SERQuota) Copy the value of $servers from /var/www/CDRTool/status/config/media_servers.php to /etc/cdrtool/global.inc $DATASOURCES['ser_radius']['mediaServers'] sudo rm -r /var/www/CDRTool/status/config Add "db_class_siponline" => "DB_openser" to ser radius data source Remove memcache from monit configuration -- Adrian Georgescu Sun, 29 Jun 2008 15:16:11 +0200 cdrtool (6.5.0) unstable; urgency=low * Completely removed memcache * Fixed update of rating history records from cvs files * Fixed pattern matching for cvs files containing rates_history * Update filename convention for rating csv files * Improve prepaid documentation * Improved Web comments in sip settings page * Anonymise prepaid balance update log * Hide billing profiles for non-resellers * Many fixes in the way various sip settings can be changed when logged in as subscriber customer or reseller * Added service sip to prepaid generator * Fixed customer properties update * Fixed update of sip properties * Added anonymous access number * Leave control to deblock user blocked by quota * Reset quota if account becomes prepaid * Added logic to change PSTN settings only if allowed by customer properties * Display previously blocked users in quota notification * Fixed sip trace hop to other node by passing totag * Only destination table requires reload after changing data in rating tables * Do not cache prepaid balance, use mysql instead * Return error when maxsessiontime command of rating engine encounters one * Do not require reload after update of prepaid table * display to and from tags, hide enum tld if none * Removed unused functions and show in trace the msg size * Toggle prepaid without using groups * Removed EnableNetworkRating setting from global.inc * No mysql changes -- Adrian Georgescu Fri, 23 May 2008 10:06:51 +0200 cdrtool (6.4.1) unstable; urgency=low * Fixed trace ip:port when SDP has lines in reverse order * Show sip trace in web window title * Find if an IP is Thor node by querying the network * Log quota value * Added totag to getTrace * Renamed soap function getTrace to getSipTrace * Added toTag to getTrace from SIPThor * Added readonly rights for login accounts to deny changes to rates or re-normalization process * Move in global.inc $CDRTool['rating']['reportMissingRates'] to $RatingEngine['reportMissingRates'] * Removed unused library * Show home node if not logged in as subscriber * Removed Prio field not used by PDNS * Show Owner field in search form for SIP and ENUM records -- Adrian Georgescu Sun, 06 Apr 2008 12:04:30 +0200 cdrtool (6.4.0) unstable; urgency=high * Refactor quota system to work with millions of sip accounts * Removed memcache usage for quota * Fixed voicemail divert setting * Separate unblock quota from init quota operation Added domain and notified columns to quota_usage Show quota_usage table in rating section * Fixed syncronization of quota and blocked by quota * Use normalized lock during init of quota to avoid race conditions * Added quota_usage table Must apply mysql changes from setup/mysql/alter_tables.mysql * Allow for empty prefixes in PSTN routes * Fixes in update of impersonate field -- Adrian Georgescu Mon, 24 Mar 2008 19:32:57 +0100 cdrtool (6.3.2) unstable; urgency=low * Log for how many account the CDRs are loaded to rebuild the quota count -- Adrian Georgescu Thu, 20 Mar 2008 11:30:06 +0100 cdrtool (6.3.1) unstable; urgency=low * Filter CDRs for local domains when init quota counters * A subaccount cannot change his own impersonate field * Replaced _serialize function with previos pear soap version to fix empty array reprezentation -- Adrian Georgescu Wed, 19 Mar 2008 14:22:26 +0100 cdrtool (6.3.0) unstable; urgency=low * Boost the speed of the rating engine from 100% to 1000% depending on the complexity of the rating tables * Fixed set of delimiter from global.inc setting when exporting csv files * Added GetEntityProfiles command to rating engine * Return json encoded for GetPrepaidHistory * Added script to create partial billing_rates tables * Moved $CDRTool['rating'] settings to $RatingEngine in global.inc * Added $RatingEngine['split_rating_table'] option to query rating data in multiple tables, each table name is autogenerated from the billing_rates.name field * Fixed set of timeout for each SOAP connection * Adjust some column lengths Must apply setup/mysql/alter_tables.mysql -- Adrian Georgescu Sat, 08 Mar 2008 15:56:12 +0100 cdrtool (6.2.3) unstable; urgency=low * Print information about the normalize lock in syslog and to stdout * Log if rating engine takes more time to complete. Must set $RatingEngine['log_delay'] to a value in micro seconds in global.inc and restart ratingEngine * Small html changes in sip settings page * Renamed RatingEngine object to differ from the same setting name from global.inc -- Adrian Georgescu Sat, 01 Mar 2008 13:09:09 +0100 cdrtool (6.2.2) unstable; urgency=low * Added setting in global.inc $RatingEngine['prepaid_lock'] to enable multiple parallel calls using the same prepaid account, this is done by disabling the lock (setting it to 0 or false). Disable the lock only if you accept that the balance might become negative * Added email filter to Sip->getAccounts() * Log the call start time in the head of rating info to eliminate the confusion when rating calls that span multiple profiles * Show total call duration in rate info head * Use instead of absolute URIs for call diversions * Removed unnecessary code used in the past for replication of changes to remote soap engine * Fixed replication of customer account to remote platform * Add active_master to replicatedDatabases in global.inc * Added web link between sip target and sip_accounts * Rewrite of mysql monitoring functions * Added DeleteBalance and DeleteBalance History commands to rating engine * Use colors in mysql replication status * Added posibility to replicate customer entries in Customer Port * Added getPrepaidHistory function to the rating engine * Replaced false with 0 and true with 1 for the return values from rating engine * Show database ip address when replication monitor returns an error * Fixed name of sip_ports settings * Added setup/crontabs directory for non debian installations -- Adrian Georgescu Wed, 27 Feb 2008 13:00:21 +0100 cdrtool (6.2.1) unstable; urgency=low * Correct update of radius records when mediaproxy field is NULL or !timeout You must reload the sql stored procedures from setup/radius/OpenSER/radius_accounting.proc or update Freeradius with setup/radius/OpenSER/sql.conf when not using the stored procedures * Log add balance to prepaid_history table -- Adrian Georgescu Tue, 12 Feb 2008 19:32:04 +0100 cdrtool (6.2.0) unstable; urgency=high * Fixed corrupted phone_images.php file -- Adrian Georgescu Tue, 12 Feb 2008 14:08:18 +0100 cdrtool (6.1.9) unstable; urgency=low * Fixed memory leak related to calling the same soap function several times * Added separate access numbers for FUNV, FBUS, FNOL, FNOA * Fixed load of customer properties in ngnpro client * Support multiple clusters for mysql replication monitor * Fixed vulnerability related to missing BYE and MediaProxy radius Update action (reported by Inaki Baz Castil) You must reload the sql stored procedures from setup/radius/OpenSER/radius_accounting.proc or update Freeradius with setup/radius/OpenSER/sql.conf when not using the stored procedures * Specify if output of soap functions is html formatted or not -- Adrian Georgescu Tue, 12 Feb 2008 03:34:45 +0100 cdrtool (6.1.8) unstable; urgency=low * Fixed mrtg buildStatistics call in cron.d (env LANG=C) * Added web page to show replications status and dynamic instructions about how to fix it * Replace $CDRTool['mysql_clusters'] in global.inc with $replicated_databases (see setup/global.inc.in for syntax) * Delete DB1 and DB2 definitions from global.inc -- Adrian Georgescu Wed, 06 Feb 2008 08:58:37 +0100 cdrtool (6.1.7) unstable; urgency=low * Set mobile_number per SIP account * Add sip_accounts_lite to soap engine settings * Update voicemail full name when sip account firstname or lastname changes * Create templates_c dir required by smarty * Added templates directory for sending welcome note -- Adrian Georgescu Mon, 04 Feb 2008 18:46:30 +0100 cdrtool (6.1.6) unstable; urgency=low * Fixed load of customer profiles for prepaid calls when no default customer defined -- Adrian Georgescu Sun, 03 Feb 2008 00:28:15 +0100 cdrtool (6.1.5) unstable; urgency=low * Added lock icon when SIP UA registered using TLS contact * Added more information about renormalizing prepaid calls * Show port number and transport protocol in sip trace * Group trace message per IP instead of ip:port * Added welcome message per soap engine * Show error message when ngnpro client is not configured * Fixed link from sip domains to sip aliases page * Fixed ENUM soap port authentication in sip settings page * Replaced DB_ser with DB_openser Edit global.inc and replace DB_ser with DB_openser * Increased curl timeout for bulk SOAP operations * Return price in debit balance -- Adrian Georgescu Thu, 31 Jan 2008 16:11:56 +0100 cdrtool (6.1.4) unstable; urgency=low * Remove sample mrtg files -- Adrian Georgescu Thu, 10 Jan 2008 10:13:00 +0100 cdrtool (6.1.3) unstable; urgency=high * Fixed calculation of rating profiles when using having specific gateways/domains/subscribers * Fixed default port alocation for NGNPro version < 3 * Allow set of reseller 0.0 (admin) in login account * Show SipThor node in Sip settings title bar * Fixed management of presence rules * Fixed link from Sip accounts to sip settings page -- Adrian Georgescu Wed, 09 Jan 2008 22:17:11 +0100 cdrtool (6.1.2) unstable; urgency=high * Fixed detection of CDR duration when minimumDuration was set -- Adrian Georgescu Tue, 08 Jan 2008 11:18:35 +0100 cdrtool (6.1.1) unstable; urgency=low * Corrected default login account sql insert statement -- Adrian Georgescu Mon, 07 Jan 2008 21:44:39 +0100 cdrtool (6.1.0) unstable; urgency=low * Fixed update of billing_rates entries from csv files * Overwrite defaults from sip_settings class per NGNPro connection * Added contrib directory * Added freeradius patch for freeradius cvs version from Norm Brandinger * Log progress of importing rating files * Show rating engine daemon uptime in syslog * Many fixes in provisioning client * Lookup customers and rates in MySQL, there is no memory limit anymore * Importing rating does not lock the rating engine anymore * Fixed billing of calls over the minimum duration -- Adrian Georgescu Sun, 06 Jan 2008 11:52:19 +0100 cdrtool (6.0) unstable; urgency=low * Fixed links from Group-by output to discrete CDRs * After renormalization, re-cache the monthly usage only for the accounts that had CDRs changed during renormalization * Fixed application type for rating engine (default application is audio) * Added info to ENUM generator * Fixed node IP parsing in sip trace * Fixed default login account creation * Don't log ENUM tld in rate info if is set to none * Added RatingProfiles management in sip settings page * Added prepaid_cards management in Rating tables page * Fixed name of domain table when SIP Thor data-source is enabled * Added link in the trace window to jump to a different SIP Proxy * Import/export delimiter for rating tables can be adjusted, default is , * Must apply database structure changes from setup/mysql/alter_tables.mysql * NGNPro client completed * Save settings before existing provisioning pages -- Adrian Georgescu Tue, 18 Dec 2007 10:42:06 +0100 cdrtool (5.3.3) unstable; urgency=low * Fixed ENUM tld match and logging * Show visual ENUM usage * Provisioning engine update -- Adrian Georgescu Tue, 23 Oct 2007 23:09:27 +0200 cdrtool (5.3.2) unstable; urgency=low * Fixed memory leak -- Adrian Georgescu Tue, 16 Oct 2007 20:12:55 +0200 cdrtool (5.3.1) unstable; urgency=low * Removed reference to soapFilter which was unused * Skip ENUM tld 'none' in discounts * Update presence functions in provisioning client * Fixed initalization of gatewaygroups * Add function for showing customer text box * Allow specification of custom port names and classes per reseller * Fixed phplib typo that caused crash on php5 -- Adrian Georgescu Tue, 16 Oct 2007 19:13:26 +0200 cdrtool (5.3.0) unstable; urgency=low * Added ENUM tld based discounts in the rating engine * Added ENUM tld management in the Rating page * Renamed field radius.Framed-Protocol to radius.ENUMtld to accomodate discounts based on ENUM top level domain. This functionality requires changes to the database structures and reconfigure several components: See doc/Upgrade.txt and setup/mysql/alter_tables.mysql for more information * Removed unused SOAP directory * Added NGNPro client provisioning library * Added sip settings page * Added new rights for provisioning tasks * Change main menu item names -- Adrian Georgescu Thu, 11 Oct 2007 10:12:38 +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