Koozali.org: home of the SME Server

Obsolete Releases => SME VoIP (Asterisk, SAIL etc) => Topic started by: Teviot on February 20, 2011, 11:33:46 AM

Title: CDR Database in Sail v3.x
Post by: Teviot on February 20, 2011, 11:33:46 AM

I notice that there is a different way of viewing the CDR Database now.

What is the recommended way of converting that into something that easier to read?

Is there a software package that will do this or something else?

Title: Re: CDR Database in Sail v3.x
Post by: SARK devs on February 20, 2011, 04:54:03 PM

The original Areski stats package has been superceded by a totally new offering called CDR-stats (http://www.cdr-stats.org/) and you can download and install it from their website.

Kind Regards

S

Title: Re: CDR Database in Sail v3.x
Post by: Teviot on February 20, 2011, 06:15:55 PM

S

Following the instructions for install and getting the requirements etc ... I have come to a halt with part of the install procedure

Quote

* django-debug-toolbar
------------------------

   download :
       wget http://github.com/robhudson/django-debug-toolbar/tarball/0.8.2
   
   install :
       tar -xvzf robhudson-django-debug-toolbar-0.8.2-0-g55b5a77.tar.gz
       cd robhudson-django-debug-toolbar-55b5a77/
       sudo python setup.py install

At this point I get the following error

Quote

[root@saint robhudson-django-debug-toolbar-55b5a77]# sudo python setup.py install
Traceback (most recent call last):
  File "setup.py", line 1, in ?
    from setuptools import setup, find_packages
ImportError: No module named setuptools
[root@saint robhudson-django-debug-toolbar-55b5a77]#

Have no idea where to go from here. Can you or someone else help?

Title: Re: CDR Database in Sail v3.x
Post by: SARK devs on February 21, 2011, 01:53:51 AM

Hi there

I'm afraid we have no experience with this new stat package.    Suggest you post this in the cdr-stat forum. 

Kind Regards

S

Title: Re: CDR Database in Sail v3.x
Post by: Teviot on February 21, 2011, 01:42:38 PM

S

I couldn't find a forum on their website and ended up calling them.

They weren't very helpful and suggested that I purchase a support package. While I understand the reasoning behind a support package I would have thought that they might have had/given me some ideas on how to fix my problem from the scripts and documentation that they supply with the package.

That being said, I am now giving up as I don't have the still and knowleged of linux behind me.

My next question is, Do you know of a simpler way of viewing the CDR?

Title: Re: CDR Database in Sail v3.x
Post by: SARK devs on February 21, 2011, 10:27:35 PM

A spreadsheet is as good as anything else.

Kind Regards

S

Title: Re: CDR Database in Sail v3.x
Post by: Teviot on February 22, 2011, 12:54:06 AM

Thanks S

What is your suggested best way of getting the data from the SME/SARK server to a speadsheet (IE MS Excel or Open Office Shreadsheet) for viewing?

Title: Re: CDR Database in Sail v3.x
Post by: compsos on June 02, 2011, 03:56:02 AM

Hi Moglj
Got a little further with this. add the following to get past your error

Code: [Select]

yum install python-setuptools But there is a script that appears to be working
https://github.com/Star2Billing/cdr-stats/raw/master/scripts/install-cdr-stats.sh (https://github.com/Star2Billing/cdr-stats/raw/master/scripts/install-cdr-stats.sh)
There are a couple of minor changes required, like DISTRO and the database settings.
But the apache section needs more modification to add VirtualHost settings and listening port 9000.

Code: [Select]

# prepare Apache
echo "Prepare Apache configuration..."
echo '
Listen *:9000

<VirtualHost *:9000>
DocumentRoot /usr/share/django_app/cdr_stats/
ErrorLog /var/log/err-cdr-stats.log
LogLevel warn

WSGIPassAuthorization On
WSGIDaemonProcess cdr_stats user=www-data user=www-data threads=25
WSGIProcessGroup cdr_stats
WSGIScriptAlias / /usr/share/django_app/cdr_stats/django.wsgi

<Directory /usr/share/django_app/cdr_stats>
Order deny,allow
Allow from all
</Directory>

</VirtualHost>


' > $APACHE_CONF_DIR/cdr-stats.conf
#correct the above file
sed -i "s/@/'/g" $APACHE_CONF_DIR/cdr-stats.conf


Any suggestions?