Koozali.org: home of the SME Server

CDR Database in Sail v3.x

Offline Teviot

  • *
  • 610
  • +0/-0
CDR Database in Sail v3.x
« 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?
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline SARK devs

  • *****
  • 2,806
  • +1/-0
    • http://sarkpbx.com
Re: CDR Database in Sail v3.x
« Reply #1 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


Offline Teviot

  • *
  • 610
  • +0/-0
Re: CDR Database in Sail v3.x
« Reply #2 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?
« Last Edit: February 20, 2011, 06:30:43 PM by M0GLJ »
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline SARK devs

  • *****
  • 2,806
  • +1/-0
    • http://sarkpbx.com
Re: CDR Database in Sail v3.x
« Reply #3 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


Offline Teviot

  • *
  • 610
  • +0/-0
Re: CDR Database in Sail v3.x
« Reply #4 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?
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline SARK devs

  • *****
  • 2,806
  • +1/-0
    • http://sarkpbx.com
Re: CDR Database in Sail v3.x
« Reply #5 on: February 21, 2011, 10:27:35 PM »


A spreadsheet is as good as anything else.

Kind Regards

S

Offline Teviot

  • *
  • 610
  • +0/-0
Re: CDR Database in Sail v3.x
« Reply #6 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?
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline compsos

  • *
  • 472
  • +0/-0
Re: CDR Database in Sail v3.x
« Reply #7 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
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?

Regards

Gordon............