The software can be downloaded from:
http://download.dns-hosting.info/CDRTool/
Changelog since 6.1.0:
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
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
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 <voice-mailbox> 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
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
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
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
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
cdrtool (6.1.6) unstable; urgency=low
* Fixed load of customer profiles for prepaid calls when no default customer defined
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
cdrtool (6.1.4) unstable; urgency=low
* Remove sample mrtg files
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
cdrtool (6.1.2) unstable; urgency=high
* Fixed detection of CDR duration when minimumDuration was set
cdrtool (6.1.1) unstable; urgency=low
* Corrected default login account sql insert statement
Regards, Adrian
Hi. This looks very interesting for us... but at the same time utterly confusing.
I download the package and went on to try an install...
Created the mysql db successfully (though I needed to do a cd /var/www/CDRTool/setup/mysql since the setup_mysql.sh script references ./)
Checked that my php/apache2 settings were correct (was missing the .phtml for indexes, which the install doc didn't mention I needed)
I edited the global.inc to the best of my knowledge (and began getting confused here!)
Then I stumbled upon rating engine...
There's no /etc/default/cdrtool and there's no /etc/init.d/cdrtool!
From there the install.txt delves deeply into RADIUS config (we're not using
radius...)
Trying to run http://myserver.tld/CDRTool/index.phtml gives me some other errors with regards to missing modules SOAP/Client and Pear sticks out;
Warning: require(SOAP/Client.php) [function.require http://sip/CDRTool/function.require ]: failed to open stream: No such file or directory in /var/www/CDRTool/phplib/prepend.php3 on line 34
Fatal error: require() [function.require http://sip/CDRTool/function.require ]: Failed opening required 'SOAP/Client.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/CDRTool/phplib/prepend.php3 on line 34
So now what...!? I'm guessing the install.txt is missing some steps, and possibly a list of pre-req's I'd need to have installed?!
Hope you can clear this up.
- gojensen
_____
From: users-bounces@lists.openser.org [mailto:users-bounces@lists.openser.org] On Behalf Of Adrian Georgescu Sent: 12. mars 2008 18:41 To: users openser.org; devel Subject: [OpenSER-Users] new CDRTool release 6.3.0
The software can be downloaded from:
http://download.dns-hosting.info/CDRTool/
Changelog since 6.1.0:
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
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
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 <voice-mailbox> 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
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
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
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
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
cdrtool (6.1.6) unstable; urgency=low
* Fixed load of customer profiles for prepaid calls when no default customer defined
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
cdrtool (6.1.4) unstable; urgency=low
* Remove sample mrtg files
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
cdrtool (6.1.2) unstable; urgency=high
* Fixed detection of CDR duration when minimumDuration was set
cdrtool (6.1.1) unstable; urgency=low
* Corrected default login account sql insert statement
Regards, Adrian
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hello Install php-soap to solve your problem!
Geir O. Jensen a écrit :
Hi. This looks very interesting for us... but at the same time utterly confusing.
I download the package and went on to try an install...
Created the mysql db successfully (though I needed to do a cd /var/www/CDRTool/setup/mysql since the setup_mysql.sh script references ./)
Checked that my php/apache2 settings were correct (was missing the .phtml for indexes, which the install doc didn't mention I needed)
I edited the global.inc to the best of my knowledge (and began getting confused here!)
Then I stumbled upon rating engine...
There's no /etc/default/cdrtool and there's no /etc/init.d/cdrtool!
From there the install.txt delves deeply into RADIUS config (we're not using radius...)
Trying to run http://myserver.tld/CDRTool/index.phtml gives me some other errors with regards to missing modules SOAP/Client and Pear sticks out;
*Warning*: require(SOAP/Client.php) [function.require http://sip/CDRTool/function.require]: failed to open stream: No such file or directory in */var/www/CDRTool/phplib/prepend.php3* on line *34*
*Fatal error*: require() [function.require http://sip/CDRTool/function.require]: Failed opening required 'SOAP/Client.php' (include_path='.:/usr/share/php:/usr/share/pear') in */var/www/CDRTool/phplib/prepend.php3* on line *34* ** So now what...!? I'm guessing the install.txt is missing some steps, and possibly a list of pre-req's I'd need to have installed?!
Hope you can clear this up.
gojensen
*From:* users-bounces@lists.openser.org [mailto:users-bounces@lists.openser.org] *On Behalf Of *Adrian Georgescu *Sent:* 12. mars 2008 18:41 *To:* users openser.org; devel *Subject:* [OpenSER-Users] new CDRTool release 6.3.0
The software can be downloaded from:
http://download.dns-hosting.info/CDRTool/
Changelog since 6.1.0:
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
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
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 <voice-mailbox> 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
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
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
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
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
cdrtool (6.1.6) unstable; urgency=low
* Fixed load of customer profiles for prepaid calls when no default customer defined
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
cdrtool (6.1.4) unstable; urgency=low
* Remove sample mrtg files
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
cdrtool (6.1.2) unstable; urgency=high
* Fixed detection of CDR duration when minimumDuration was set
cdrtool (6.1.1) unstable; urgency=low
* Corrected default login account sql insert statement
Regards, Adrian
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
Hello Install php-soap to solve your problem!
Installed php-soap and php-pear but still get error: [20-Mar-2008 19:15:15] PHP Warning: require(SOAP/Client.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /var/www/CDRTool_6.3.0/phplib/prepend.php3 on line 34 [20-Mar-2008 19:15:15] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'SOAP/Client.php' (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/CDRTool_6.3.0/phplib/prepend.php3 on line 34
Nothing called Client.php found on the system.
Found a hit suggesting using pear to install soap: pear install soap Failed to download pear/soap within preferred state "stable", latest release is version 0.11.0, stability "beta", use "channel://pear.php.net/soap-0.11.0" to install Cannot initialize 'soap', invalid or missing package file Package "soap" is not valid install failed
Any other suggestions?
Regards
Cameron
Cameron -
I have no idea what it will do for you at this point but I used:
pear install F SOAP
and it worked for me.
Mark
At 06:37 p.m. 20/03/2008, you wrote:
Hello Install php-soap to solve your problem!
Installed php-soap and php-pear but still get error: [20-Mar-2008 19:15:15] PHP Warning: require(SOAP/Client.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /var/www/CDRTool_6.3.0/phplib/prepend.php3 on line 34 [20-Mar-2008 19:15:15] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'SOAP/Client.php' (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/CDRTool_6.3.0/phplib/prepend.php3 on line 34
Nothing called Client.php found on the system.
Found a hit suggesting using pear to install soap: pear install soap Failed to download pear/soap within preferred state "stable", latest release is version 0.11.0, stability "beta", use "channel://pear.php.net/soap-0.11.0" to install Cannot initialize 'soap', invalid or missing package file Package "soap" is not valid install failed
Any other suggestions?
Regards
Cameron
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
-- No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1335
- Release Date: 19/03/2008 9:54 AM
El Thursday 13 March 2008 11:28:52 Geir O. Jensen escribió:
Hi. This looks very interesting for us... but at the same time utterly confusing.
[...]
From there the install.txt delves deeply into RADIUS config (we're not using radius...)
I think you misunderstood what CDRTool does, because if you don't use radius, you will not be able to use CDRTool, because it is deeply related to an scenario in which a RADIUS server is the core of it.
Raul,
RADIUS is just a tool to insert the CDRs inside accounting database, one of the strong parts of CDRTool consists in the modularity of design. You are not bound to any software, just need your datasource properly filled in the way you choose.
DanB
On Thu, Mar 13, 2008 at 7:40 PM, Raúl Alexis Betancor Santana < rabs@dimension-virtual.com> wrote:
El Thursday 13 March 2008 11:28:52 Geir O. Jensen escribió:
Hi. This looks very interesting for us... but at the same time utterly confusing.
[...]
From there the install.txt delves deeply into RADIUS config (we're not using radius...)
I think you misunderstood what CDRTool does, because if you don't use radius, you will not be able to use CDRTool, because it is deeply related to an scenario in which a RADIUS server is the core of it.
-- Saludos.
Raúl Alexis Betancor Santana Dimensión Virtual S.L.
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
El Jueves, 13 de Marzo de 2008, Raúl Alexis Betancor Santana escribió:
El Thursday 13 March 2008 11:28:52 Geir O. Jensen escribió:
Hi. This looks very interesting for us... but at the same time utterly confusing.
[...]
From there the install.txt delves deeply into RADIUS config (we're not using radius...)
I think you misunderstood what CDRTool does, because if you don't use radius, you will not be able to use CDRTool, because it is deeply related to an scenario in which a RADIUS server is the core of it.
Hi, you don't need at al Radius to have CDRTool running:
- MediaProxy does accounting (to store media info, to make fix calls with no BYE after RTP end...). Media proxy can store data via MySQL or via Radius.
- In case of OpenSer, CDRTool expects to get CDR data from the "radacct" table so OpenSer should fill that table using Radius (as "acc" module does when using Radius) but you can also use "acc" DB and storing data into radacct table by configuring "acc,db-extra" parameters.
- In fact, CDRTool can work with Asterisk CDR table, and of course Asterisk has not CDR Radius support at all.
In conclusion, CDRTool just need to load CDR data from a DB table (radacct table, asteriskcdr table, custom table...).
Best regards.
El Thursday 13 March 2008 21:51:15 Iñaki Baz Castillo escribió:
Hi, you don't need at al Radius to have CDRTool running:
- MediaProxy does accounting (to store media info, to make fix calls with
no BYE after RTP end...). Media proxy can store data via MySQL or via Radius.
- In case of OpenSer, CDRTool expects to get CDR data from the "radacct"
table so OpenSer should fill that table using Radius (as "acc" module does when using Radius) but you can also use "acc" DB and storing data into radacct table by configuring "acc,db-extra" parameters.
- In fact, CDRTool can work with Asterisk CDR table, and of course Asterisk
has not CDR Radius support at all.
In conclusion, CDRTool just need to load CDR data from a DB table (radacct table, asteriskcdr table, custom table...).
Hi Iñaki ;-) , so it's obvious that I was the one that misundestood CDRTool features, thanks to all for the explanation.
Best regards
El Friday 14 March 2008 10:20:26 Raúl Alexis Betancor Santana escribió:
In conclusion, CDRTool just need to load CDR data from a DB table (radacct table, asteriskcdr table, custom table...).
Hi Iñaki ;-) , so it's obvious that I was the one that misundestood CDRTool features, thanks to all for the explanation.
In fact, CDRTool has not very friendly documentation, but when depping into it and spending some time it becomes very flexible and powerful. :)