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(a)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(a)lists.openser.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFH2W6+rxOjjFYWQtoRArCWAJ9QkC2+Tf1YN9/B4fsy9LdLtYx8cwCdERXC /zFJ21sC3f6DHOq7KoH9ow0= =slmA -----END PGP SIGNATURE-----

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(a)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ó: [...] 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(a)lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users

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...).