<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16608" name=GENERATOR></HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2>Hi. This looks very interesting for us... but at the same
time utterly confusing.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2>I download the package and went on to try an
install...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2>Created the mysql db successfully (though I needed to do
a cd /var/www/CDRTool/setup/mysql since the setup_mysql.sh script
references ./)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2>Checked that my php/apache2 settings were correct (was
missing the .phtml for indexes, which the install doc didn't mention I
needed)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2>I edited the global.inc to the best of my knowledge (and
began getting confused here!)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2>Then I stumbled upon rating engine...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2>There's no /etc/default/cdrtool and there's no
/etc/init.d/cdrtool!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2>From there the install.txt delves deeply into RADIUS config
(we're not using radius...)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2>Trying to run <A
href="http://myserver.tld/CDRTool/index.phtml">http://myserver.tld/CDRTool/index.phtml</A>
gives me some other errors with regards to missing modules SOAP/Client and Pear
sticks out;</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><STRONG>Warning</STRONG>:
require(SOAP/Client.php) [<A
href="http://sip/CDRTool/function.require">function.require</A>]: failed to open
stream: No such file or directory in <B>/var/www/CDRTool/phplib/prepend.php3</B>
on line <B>34</B><BR><BR><B>Fatal error</B>: require() [<A
href="http://sip/CDRTool/function.require">function.require</A>]: Failed opening
required 'SOAP/Client.php' (include_path='.:/usr/share/php:/usr/share/pear') in
<B>/var/www/CDRTool/phplib/prepend.php3</B> on line <B>34</B></SPAN></DIV>
<DIV dir=ltr align=left><SPAN
class=752122011-13032008><STRONG></STRONG></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2>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?!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2>Hope you can clear this up.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2>- gojensen</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=752122011-13032008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> users-bounces@lists.openser.org
[mailto:users-bounces@lists.openser.org] <B>On Behalf Of </B>Adrian
Georgescu<BR><B>Sent:</B> 12. mars 2008 18:41<BR><B>To:</B> users openser.org;
devel<BR><B>Subject:</B> [OpenSER-Users] new CDRTool release
6.3.0<BR></FONT><BR></DIV>
<DIV></DIV>The software can be downloaded from:<BR><BR><A
href="http://download.dns-hosting.info/CDRTool/">http://download.dns-hosting.info/CDRTool/</A><BR><BR>Changelog
since 6.1.0:<BR><BR>
<DIV>
<DIV>cdrtool (6.3.0) unstable; urgency=low</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Boost the speed of the rating engine from 100% to 1000%
depending on</DIV>
<DIV> the complexity of the rating tables</DIV>
<DIV> * Fixed set of delimiter from global.inc setting when
exporting csv files</DIV>
<DIV> * Added GetEntityProfiles command to rating engine</DIV>
<DIV> * Return json encoded for GetPrepaidHistory</DIV>
<DIV> * Added script to create partial billing_rates tables</DIV>
<DIV> * Moved $CDRTool['rating'] settings to $RatingEngine in
global.inc</DIV>
<DIV> * Added $RatingEngine['split_rating_table'] option to query
rating data in</DIV>
<DIV> multiple tables, each table name is autogenerated from
the</DIV>
<DIV> billing_rates.name field</DIV>
<DIV> * Fixed set of timeout for each SOAP connection</DIV>
<DIV> * Adjust some column lengths</DIV>
<DIV> Must apply setup/mysql/alter_tables.mysql</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV>
<DIV>cdrtool (6.2.3) unstable; urgency=low</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Print information about the normalize lock in syslog and to
stdout</DIV>
<DIV> * Log if rating engine takes more time to complete. Must
set</DIV>
<DIV> $RatingEngine['log_delay'] to a value in micro seconds
in global.inc and</DIV>
<DIV> restart ratingEngine</DIV>
<DIV> * Small html changes in sip settings page</DIV>
<DIV> * Renamed RatingEngine object to differ from the same setting
name from global.inc</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV>
<DIV>cdrtool (6.2.2) unstable; urgency=low</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Added setting in global.inc $RatingEngine['prepaid_lock']
to enable</DIV>
<DIV> multiple parallel calls using the same prepaid
account, this is done by</DIV>
<DIV> disabling the lock (setting it to 0 or false). Disable
the lock only if</DIV>
<DIV> you accept that the balance might become
negative</DIV>
<DIV> * Added email filter to Sip->getAccounts()</DIV>
<DIV> * Log the call start time in the head of rating info to
eliminate</DIV>
<DIV> the confusion when rating calls that span multiple
profiles</DIV>
<DIV> * Show total call duration in rate info head</DIV>
<DIV> * Use <voice-mailbox> instead of absolute URIs for call
diversions</DIV>
<DIV> * Removed unnecessary code used in the past for replication
of changes to remote soap engine</DIV>
<DIV> * Fixed replication of customer account to remote
platform</DIV>
<DIV> * Add active_master to replicatedDatabases in
global.inc</DIV>
<DIV> * Added web link between sip target and sip_accounts</DIV>
<DIV> * Rewrite of mysql monitoring functions</DIV>
<DIV> * Added DeleteBalance and DeleteBalance History commands to
rating engine</DIV>
<DIV> * Use colors in mysql replication status</DIV>
<DIV> * Added posibility to replicate customer entries in Customer
Port</DIV>
<DIV> * Added getPrepaidHistory function to the rating engine</DIV>
<DIV> * Replaced false with 0 and true with 1 for the return values
from rating engine</DIV>
<DIV> * Show database ip address when replication monitor returns
an error</DIV>
<DIV> * Fixed name of sip_ports settings</DIV>
<DIV> * Added setup/crontabs directory for non debian
installations</DIV>
<DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV>cdrtool (6.2.1) unstable; urgency=low</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Correct update of radius records when mediaproxy field is
NULL or !timeout</DIV>
<DIV> You must reload the sql stored procedures
from</DIV>
<DIV> setup/radius/OpenSER/radius_accounting.proc or</DIV>
<DIV> update Freeradius with
setup/radius/OpenSER/sql.conf</DIV>
<DIV> when not using the stored procedures</DIV>
<DIV> * Log add balance to prepaid_history table</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV>
<DIV>cdrtool (6.1.9) unstable; urgency=low</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Fixed memory leak related to calling the same soap function
several times</DIV>
<DIV> * Added separate access numbers for FUNV, FBUS, FNOL,
FNOA</DIV>
<DIV> * Fixed load of customer properties in ngnpro client</DIV>
<DIV> * Support multiple clusters for mysql replication
monitor</DIV>
<DIV> * Fixed vulnerability related to missing BYE and
MediaProxy</DIV>
<DIV> radius Update action (reported by Inaki Baz
Castil)</DIV>
<DIV> You must reload the sql stored procedures
from</DIV>
<DIV> setup/radius/OpenSER/radius_accounting.proc or</DIV>
<DIV> update Freeradius with
setup/radius/OpenSER/sql.conf</DIV>
<DIV> when not using the stored procedures</DIV>
<DIV> * Specify if output of soap functions is html formatted or
not</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV>
<DIV>cdrtool (6.1.8) unstable; urgency=low</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Fixed mrtg buildStatistics call in cron.d (env
LANG=C)</DIV>
<DIV> * Added web page to show replications status and
dynamic</DIV>
<DIV> instructions about how to fix it</DIV>
<DIV> * Replace $CDRTool['mysql_clusters'] in global.inc
with </DIV>
<DIV> $replicated_databases (see setup/global.inc.in for
syntax)</DIV>
<DIV> * Delete DB1 and DB2 definitions from global.inc</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV>cdrtool (6.1.7) unstable; urgency=low</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Set mobile_number per SIP account</DIV>
<DIV> * Add sip_accounts_lite to soap engine settings</DIV>
<DIV> * Update voicemail full name when sip account firstname or
lastname changes</DIV>
<DIV> * Create templates_c dir required by smarty</DIV>
<DIV> * Added templates directory for sending welcome note</DIV>
<DIV><BR></DIV>
<DIV>
<DIV>cdrtool (6.1.6) unstable; urgency=low</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Fixed load of customer profiles for prepaid calls
when </DIV>
<DIV> no default customer defined</DIV>
<DIV><BR class=webkit-block-placeholder></DIV></DIV></DIV></DIV></DIV>
<DIV>cdrtool (6.1.5) unstable; urgency=low</DIV>
<DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Added lock icon when SIP UA registered using TLS
contact</DIV>
<DIV> * Added more information about renormalizing prepaid
calls</DIV>
<DIV> * Show port number and transport protocol in sip trace</DIV>
<DIV> * Group trace message per IP instead of ip:port</DIV>
<DIV> * Added welcome message per soap engine</DIV>
<DIV> * Show error message when ngnpro client is not
configured</DIV>
<DIV> * Fixed link from sip domains to sip aliases page</DIV>
<DIV> * Fixed ENUM soap port authentication in sip settings
page</DIV>
<DIV> * Replaced DB_ser with DB_openser</DIV>
<DIV> Edit global.inc and replace DB_ser with
DB_openser</DIV>
<DIV> * Increased curl timeout for bulk SOAP operations</DIV>
<DIV> * Return price in debit balance</DIV>
<DIV><BR></DIV>
<DIV>
<DIV>cdrtool (6.1.4) unstable; urgency=low</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Remove sample mrtg files</DIV>
<DIV><BR></DIV>
<DIV>cdrtool (6.1.3) unstable; urgency=high</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Fixed calculation of rating profiles when using having
specific</DIV>
<DIV> gateways/domains/subscribers</DIV>
<DIV> * Fixed default port alocation for NGNPro version <
3</DIV>
<DIV> * Allow set of reseller 0.0 (admin) in login account</DIV>
<DIV> * Show SipThor node in Sip settings title bar</DIV>
<DIV> * Fixed management of presence rules</DIV>
<DIV> * Fixed link from Sip accounts to sip settings page</DIV>
<DIV><BR></DIV>
<DIV>cdrtool (6.1.2) unstable; urgency=high</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Fixed detection of CDR duration when minimumDuration was
set</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV>
<DIV>cdrtool (6.1.1) unstable; urgency=low</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV> * Corrected default login account sql insert statement</DIV>
<DIV><BR></DIV></DIV></DIV></DIV></DIV></DIV>Regards,
<DIV>Adrian</DIV>
<DIV><BR class=webkit-block-placeholder></DIV></DIV></BLOCKQUOTE></BODY></HTML>