/usr/share/cdr_stats/templates/sort_link_frag.html
(cdr-stats)[root@nitro templatetags]# diff -rNup common_tags.py common_tags.py_broken

--- common_tags.py      2012-10-27 23:39:01.520604875 -0400
+++ common_tags.py_broken       2012-10-27 23:38:51.036601825 -0400
@@ -159,7 +159,7 @@ def to_json(value):
     return mark_safe(simplejson.dumps(value))


[email protected]_tag('cdr/sort_link_frag.html', takes_context=True)
[email protected]_tag('sort_link_frag.html', takes_context=True)
 def sort_link(context, link_text, sort_field, visible_name=None):
     """Usage: {% sort_link "link text" "field_name" %}
        Usage: {% sort_link "link text" "field_name" "Visible name" %}

Without this change I would get the following traceback

TemplateDoesNotExist at /cdr_view/

sort_link_frag.html

Request Method:     GET
Request URL:    http://nitro.pyther.net:8080/cdr_view/
Django Version:     1.4.2
Exception Type:     TemplateDoesNotExist
Exception Value:    

sort_link_frag.html

Exception Location:     /usr/share/virtualenvs/cdr-stats/lib/python2.6/site-packages/django/template/loader.py in find_template, line 138
Python Executable:  /usr/bin/python
Python Version:     2.6.6
Python Path:    

['/usr/lib/python2.6/site-packages/virtualenv-1.8.2-py2.6.egg',
 '/usr/lib/python2.6/site-packages/virtualenvwrapper-3.6-py2.6.egg',
 '/usr/lib/python2.6/site-packages/stevedore-0.4-py2.6.egg',
 '/usr/lib/python2.6/site-packages/virtualenv_clone-0.2.4-py2.6.egg',
 '/usr/lib64/python26.zip',
 '/usr/lib64/python2.6',
 '/usr/lib64/python2.6/plat-linux2',
 '/usr/lib64/python2.6/lib-tk',
 '/usr/lib64/python2.6/lib-old',
 '/usr/lib64/python2.6/lib-dynload',
 '/usr/lib64/python2.6/site-packages',
 '/usr/lib/python2.6/site-packages',
 '/usr/lib/python2.6/site-packages/setuptools-0.6c11-py2.6.egg-info',
 '/usr/share/virtualenvs/cdr-stats/lib/python2.6/site-packages',
 '/usr/share/cdr_stats']

Server time:    Sat, 27 Oct 2012 23:45:13 -0400

I've been trying for the past several days to get CDR Stats installed, there appears to be a bug in the install script. From what I can tell from reading the last error I saw it appears to be Django related:

The main webroot (Port 80) is staged correctly but the script itself is not available on port 8008:

Does anyone have any ideas?

followed the steps described here
http://www.cdr-stats.org/documentation/beginners-guide/howto-installing-on-standalone-asterisk/

the script said it's intended to centos 6.x

Why do i see Error 500 when trying to make changes almost anywhere in the Admin section of cdr-stats?

Hello,

The installation was made by scripts provided in Install folder and as is stated in installation procedure:
"cd /usr/src/ ; rm install-cdr-stats.sh ; wget –no-check-certificate https://raw.github.com/cdr-stats/cdr-stats/master/install/install-cdr-stats.sh -O install-cdr-stats.sh ; bash install-cdr-stats.sh"

The installation seems to be fine without any errors. The CDR-stats web interface is up and I can log in and I have data from cdr-pusher (Installed with difficulties), but when I tried to reach customer Analytics/overview (http://localhost:8008/overview/), the gunicorn returns me an error 500 (INTERNAL SERVER ERROR). This happens and when I try to reach "Reports by Country" (http://localhost:8008/country_report/).

Could you please advice, where is the problem. Thanks in advance.

Best regards,

Hi,

The new Asterisk CEL system in 1.8+ is planned to be supported by CDR-Stats ?
https://wiki.asterisk.org/wiki/display/AST/CEL+Design+Goals

Yours.

The following section of the script should be corrected to change the hard coded refference to master to $VERSION as shown below.

echo "Install CDR-Stats..."
mkdir /usr/share/django_app/
cd /usr/src/
wget --no-check-certificate https://github.com/Star2Billing/cdr-stats/tarball/$VERSION
mv $VERSION Star2Billing-cdr-stats-$VERSION.tar.gz
tar xvzf Star2Billing-cdr-stats-.tar.gz
rm -rf Star2Billing-cdr-stats-.tar.gz
mv cdr-stats cdr-stats_$DATETIME
mv Star2Billing-cdr-stats-* cdr-stats
mv /usr/share/django_app/cdr_stats archive_cdr-stats-$DATETIME
ln -s /usr/src/cdr-stats/cdr_stats /usr/share/django_app/cdr_stats

Hi.

Setup is :

CDR-Stats+Mongo->SideA
Mongo+Freeswitch->SideB

ERROR/PoolWorker-9] Error unable to open database file:

I have confirmed that I can connect to the Local SideA Mongo database and the Remote SideB Mongo database. When I run celery CDR's get populated into the CDR_STATS mongo database SideA, I'm still getting this error ? Concurrency reports currently does not work and I'm concerned its something to do with this error.

Please assist.

Kind Regards,

Driter

CDR-stats uses different field types than asterisk in "cdr" table:
disposition = models.PositiveIntegerField(choices=DISPOSITION, default=1)
accountcode = models.PositiveIntegerField(default=0, null=True)

From asterisk contrib/realtime/postgresql/realtime.sql:
disposition character varying(45) DEFAULT '' NOT NULL,
accountcode character varying(20) DEFAULT '' NOT NULL,

So, after executing "python manage.py migrate" asterisk (1.8.5) unable to write new CDR records to the database:
[Aug 18 12:03:12] ERROR[9904] cdr_pgsql.c: Reason: ERROR: invalid input syntax for integer: "ANSWERED"
LINE 1: ...83180&DAHDI/g1/83181&DAHDI/g1/83182,40,m',188,139,'ANSWERED'...

Hello,

Reading /etc/cdr-pusher.yaml content, I see that CDR source database is specified with:

db_file: specify the database path and name

db_file: "./sqlitedb/cdr.db

Does it make sense to specify a remote database, along with settings to access it (hostname, login, password, ...) ?

Cheers

Hi, I try to install CDR-stats step by step, but not install corectly, for me the CDR Import function is important, but if I access this menu I receive a 500 error message. I installed CDR-Push, but nothing, somewhere I find a how to how is working, because I tried the instalation many many times.
Thnaks in advance,

I followed the following
http://www.cdr-stats.org/documentation/beginners-guide/howto-installing-on-standalone-asterisk/

wget –no-check-certificate https://raw.github.com/Star2Billing/cdr-stats/master/install/install-cdr-stats-asterisk.sh -O install-cdr-stats-asterisk.sh

bash ./install-cdr-stats-asterisk.sh

and Got
Press Enter to continue or CTRL-C to exit

ERROR 1060 (42S21) at line 1: Duplicate column name 'acctid'
/usr/share/virtualenvs/cdr-stats/lib/python2.6/site-packages/django/conf/init.py:75: DeprecationWarning: The ADMIN_MEDIA_PREFIX setting has been removed; use STATIC_URL instead.
"use STATIC_URL instead.", DeprecationWarning)
/usr/share/virtualenvs/cdr-stats/lib/python2.6/site-packages/django/utils/translation/init.py:63: DeprecationWarning: Translations in the project directory aren't supported anymore. Use the LOCALE_PATHS setting instead.
DeprecationWarning)
Syncing...
Creating tables ...
Creating table auth_permission
Creating table auth_group_permissions
Creating table auth_group
Creating table auth_user_user_permissions
Creating table auth_user_groups
Creating table auth_user
Creating table django_content_type
Creating table django_session
Creating table django_site
Creating table django_admin_log
Creating table voip_switch
Creating table hangup_cause
Creating table alert_remove_prefix
Creating table alert
Creating table alert_report
Creating table alert_blacklist
Creating table alert_whitelist
Creating table user_profile

however it did not create the tables. I am wondering what happened as there is no error given.

The counter for the real-time calls is always NULL and no line is shown in the graph.
Tested with Google Chrome and Firefox under MacOSX 10.9

I found out the following socketio_server traceback:

(cdr-stats)root@pbx:/# python /usr/share/cdr_stats/socketio_server.py -m -p /var/run/cdr-stats-socketio-server.pid start
Starting as master...
Traceback (most recent call last):
  File "/usr/share/virtualenvs/cdr-stats/local/lib/python2.7/site-packages/gevent/greenlet.py", line 327, in run
    result = self._run(*self.args, **self.kwargs)
  File "/usr/share/virtualenvs/cdr-stats/local/lib/python2.7/site-packages/socketio/server.py", line 49, in handle
    handler.handle()
  File "/usr/share/virtualenvs/cdr-stats/local/lib/python2.7/site-packages/gevent/pywsgi.py", line 184, in handle
    result = self.handle_one_request()
  File "/usr/share/virtualenvs/cdr-stats/local/lib/python2.7/site-packages/gevent/pywsgi.py", line 321, in handle_one_request
    self.handle_one_response()
  File "/usr/share/virtualenvs/cdr-stats/local/lib/python2.7/site-packages/socketio/handler.py", line 58, in handle_one_response
    self.handle_one_response(call_wsgi_app=False)
TypeError: handle_one_response() got an unexpected keyword argument 'call_wsgi_app'
<Greenlet at 0x19064b0: <bound method SocketIOServer.handle of <SocketIOServer at 0x1962b50 fileno=7 address=192.168.17.253:9000>>(<socket at 0x1962c90 fileno=[Errno 9] Bad file des, ('192.168.130.50', 55659))> failed with TypeError

while making of made a call it's the call status appears in CONCURRENT and REAL TIME tabs.
but there is nothing showing in Dashboard.

Please suggest the necessary rectification. Operating system I am using is Windows 7

At the moment, if a new accountcode is added to a user, only the new imported CDRs will be associated to the corresponding user_id. Ideally we should provide a mechanism to let the admin flag all the CDRs and do so retrospectively.

Then im trying to use your aoutoinstaller i have this problem:
Could not connect to MongoDB: could not connect to localhost:27017: [Errno 111] Connection refusedCould not connect to MongoDB: could not connect to localhost:27017: [Errno 111] Connection refusedCreate a super admin user...
Could not connect to MongoDB: could not connect to localhost:27017: [Errno 111] Connection refusedCould not connect to MongoDB: could not connect to localhost:27017: [Errno 111] Connection refusedInstall Redis-server ...
Reading package lists... Done
Building dependency tree
Reading state information... Done
redis-server is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 46 not upgraded.
cdr-stats-functions.sh: line 788: /etc/init.d/redis-server.dpkg-dist: No such file or directory
Could not connect to MongoDB: could not connect to localhost:27017: [Errno 111] Connection refused
But redis installed and working
meditgroup@voip:/usr/src$ redis-cli -h localhost ping
PONG

My system: Linux voip.meditgroup.ru 3.2.0-57-virtual #87-Ubuntu SMP Tue Nov 12 21:53:49 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

I can't find anywhere saying "yes" it works with asterisk 12 or 13? Seeing as how FreePBX 12 is now stable it supports asterisk 11 and 13 out of the box. Will CDR Stats work with Asterisk 13?

There is INTERNAL_CALL option in settings.py, but it doesn't seem to do much.
Also, in cdr-stats 2 there was "Internal calls" option in country list, but it is missing in cdr-stats 3.

The calls that I would expect to be internal (shorter than INTERNAL_CALL is set) have the world icon.

Today I have installed an updated version of cdr-stats.

When I click on the "Search" button in the "Search CDR" section I have an error regarding a CSRF token that is missing or incorrect.

Traceback (most recent call last):
  File "manage.py", line 2, in <module>
    from django.core.management import execute_manager
ImportError: cannot import name execute_manager

This has been deprecated since 1.2 and removed in 1.4

I have two issues:

The account field is not being populated in CDR Stats from my Asterisk/Freepbx server. All calls are imported correctly, but there is not account value. So the customer dashboard doesn't show any data related to their extension.

Also all calls have a direction of unknown vs inbound or outbound. So searching for inbound or outbound calls do not work.

Searched Google Groups, with little results.

I was having this issue, when searched in the grid, leading to show numbers instead of the text dispositions (like '8' instead of 'TORTURE'). The following patch should solve the issue.

--- /home/phani/cdr-stats/cdr_stats/cdr/views.py 2011-08-11 11:26:58.305545163 +0530
+++ views.py 2011-08-11 11:26:55.375545164 +0530
@@ -21,6 +21,7 @@
import operator
import string
import csv, codecs
+import simplejson
from operator import itemgetter
from inspect import stack, getmodule

@@ -45,8 +46,21 @@

 # To add dynamic query set
 grid.queryset  = request.session['cdr_queryset']

• querysetj = grid.get_json(request)
• return HttpResponse(grid.get_json(request), mimetype="application/json")
• queryset = simplejson.loads(querysetj)
• count=0
• for i in queryset['rows']:

•    disposition = i['disposition']
  

•    for d in DISPOSITION:
  

•        if d[0] == i['disposition']:
  

•            disposition = d[1]
  

•    queryset['rows'][count]['disposition'] = disposition
  

•    count +=1
  

• querysetj = simplejson.dumps(queryset)

• return HttpResponse(querysetj, mimetype="application/json")

@login_required
def grid_config(request):
@@ -117,6 +131,7 @@
disposition = d[1]
queryset[count]['disposition'] = disposition
count +=1
+

request.session['cdr_queryset'] = queryset

Hello!

Problem roots lie in the Asterisk's CDR format. Call that has extra characters either as prefix or postfix, for example (what an irony) an asterisk (_), is written completely as it was dialed to the Destination field. In this case a number like 442031234567_123 will fool CDR-Stats and country will not be detected (detected as "unknown" instead of the UK).

Suggestion: strip possible asterisks/pounds/whatever from dialed number. An administrator may have an option to choose which part to use as dialed number and which to throw away.

update: currently I solved the problem by adding MySQL trigger on asteriskcdrdb\cdr table:

CREATE TRIGGER cdr_remove_asterisk BEFORE INSERT ON cdr
FOR EACH ROW BEGIN
SET NEW.dst = SUBSTRING_INDEX(NEW.dst, '*', 1);
END

By adding additional "SET" lines with pounds and other possible characters you may get rid of other garbage in the called number.

Has anybody managed to install cdr-stat on Centos 7?
I have changed scripts to accommodate new environment but there are so many python modules that fail all the time, be it they are no longer available, they changed their name or there are dependencies that require older modules which are no longer supported.
Any help would be appreciated!

We are posting freeswitch cdrs to couchdb.
How easy would it be to replace mongodb with a couchdb connector?

and since it is used by a local carrier, i.e. no international calls. Is this a reason not to use cdr-stats?

Good afternoon!
I have installed asterisk, which already wrote the СDR in Postgres.
How to configure сdr-stats that is take data from an existing database?

I'm using release 1.3.0 of cdr-stats. When exporting CDRs to CSV file, AttributeError exception appears (AttributeError at /export_csv/ 'NoneType' object has no attribute 'encode') if there is a row in cdr_new table where src or clid fields are set to null.

Here is the traceback:
/usr/share/django_app/cdr_stats/cdr/views.py in export_to_csv
158. writer.writerow([cdr['calldate'], cdr['channel'].encode("utf-8"), cdr['src'].encode("utf-8"), cdr['clid'].encode("utf-8"), cdr['dst'].encode("utf-8"), cdr['disposition'], cdr['duration'].encode("utf-8"), cdr['accountcode']])

When dialing from asterisk console, src and clid field are set to null, so whenever asterisk console is used, Export to CSV might not work.

Hi,

I am trying to install onto FreePBX with Asterisk 1.8

I am getting an error message saying “South not installed”, I have check the text before this happens and can see a couple of errors, not sure if this helps

This will install virtualenv & virtualenvwrapper
and create a new virtualenv : cdr-stats
Searching for virtualenv
Best match: virtualenv 1.9.1
Processing virtualenv-1.9.1-py2.6.egg
virtualenv 1.9.1 is already the active version in easy-install.pth
Installing virtualenv script to /usr/bin
Installing virtualenv-2.6 script to /usr/bin

Using /usr/lib/python2.6/site-packages/virtualenv-1.9.1-py2.6.egg
Processing dependencies for virtualenv
Finished processing dependencies for virtualenv
Searching for virtualenvwrapper
Best match: virtualenvwrapper 3.7.1
Processing virtualenvwrapper-3.7.1-py2.6.egg
virtualenvwrapper 3.7.1 is already the active version in easy-install.pth
Installing virtualenvwrapper.sh script to /usr/bin
Installing virtualenvwrapper_lazy.sh script to /usr/bin

Using /usr/lib/python2.6/site-packages/virtualenvwrapper-3.7.1-py2.6.egg
Processing dependencies for virtualenvwrapper
Finished processing dependencies for virtualenvwrapper
New python executable in cdr-stats/bin/python
Installing setuptools.............done.
Installing pip...............done.
Virtualenv cdr-stats created and activated
Install CDR-Stats...
mkdir: cannot create directory /var/log/cdr-stats': File exists Initialized empty Git repository in /usr/src/cdr-stats/.git/ github.com[0: 204.232.175.90]: errno=Connection timed out fatal: unable to connect a socket (Connection timed out) cp: cannot stat/usr/src/cdr-stats/cdr_stats': No such file or directory
Searching for distribute
Reading http://pypi.python.org/simple/distribute/
Reading http://packages.python.org/distribute
Best match: distribute 0.6.36
Processing distribute-0.6.36-py2.6.egg
distribute 0.6.36 is already the active version in easy-install.pth
Installing easy_install script to /usr/share/virtualenvs/cdr-stats/bin
Installing easy_install-2.6 script to /usr/share/virtualenvs/cdr-stats/bin

Using /usr/share/virtualenvs/cdr-stats/lib/python2.6/site-packages/distribute-0.6.36-py2.6.egg
Processing dependencies for distribute
Finished processing dependencies for distribute
Install basic requirements...
cat: /usr/src/cdr-stats/install/requirements/basic-requirements.txt: No such file or directory
Install Django requirements...
cat: /usr/src/cdr-stats/install/requirements/django-requirements.txt: No such file or directory

Checking Python dependencies...

Error : South not installed...

Many Thanks
Rod

The following four files fail to download that are part of the Requirements.txt file

Requirement 'hg+https://bitbucket.org/jespern/django-piston' looks like a filename, but the file does not exist
Requirement 'git+https://github.com/pydanny/django-uni-form.git' looks like a filename, but the file does not exist
Requirement 'hg+https://bitbucket.org/izi/django-admin-tools' looks like a filename, but the file does not exist
Requirement 'git+git://github.com/Star2Billing/switch2bill-common.git' looks like a filename, but the file does not exist

Also it might be noted that most items in this file are not documented.

Hello,

CDR Stat is really awsome solution for voip , but the documentation need to be updated..
I try to install it many time but all the time python module missing and other, it's impossible to install it ..

If you can do an update of the documentation , it will be great .

Thanks you .

Hello,

Thanks for your tools .

I'm trying to setup cdrstats on a new debian but the results is that i don't have the django server running.

This is what i got from the setup.

reate CDR-Stats database...
sudo -u postgres createdb cdrstats_db
Create Postgresql user cdr_stats_43409
sudo -u postgres psql --command="create user cdr_stats_43409 with password 'XXXXXXXXXXXX';"
CREATE ROLE
Create CDR-Pusher database...
sudo -u postgres createdb cdr-pusher
Grant all privileges to user...
GRANT
GRANT
Traceback (most recent call last):
File "manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 367, in execute_from_command_line
utility.execute()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 341, in execute
django.setup()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/init.py", line 27, in setup
apps.populate(settings.INSTALLED_APPS)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/config.py", line 199, in import_models
self.models_module = import_module(models_module_name)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/importlib/init.py", line 37, in import_module
import(name)
File "/usr/share/cdrstats/cdr/models.py", line 18, in
from postgres.fields import json_field
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/init.py", line 4, in
from .range_fields import Int4RangeField # NOQA
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/range_fields.py", line 6, in
from django.db.models.sql import aggregates
ImportError: cannot import name aggregates
Traceback (most recent call last):
File "manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 367, in execute_from_command_line
utility.execute()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 341, in execute
django.setup()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/init.py", line 27, in setup
apps.populate(settings.INSTALLED_APPS)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/config.py", line 199, in import_models
self.models_module = import_module(models_module_name)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/importlib/init.py", line 37, in import_module
import(name)
File "/usr/share/cdrstats/cdr/models.py", line 18, in
from postgres.fields import json_field
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/init.py", line 4, in
from .range_fields import Int4RangeField # NOQA
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/range_fields.py", line 6, in
from django.db.models.sql import aggregates
ImportError: cannot import name aggregates
�[3;J

Create a super admin user...
Traceback (most recent call last):
File "manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 367, in execute_from_command_line
utility.execute()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 341, in execute
django.setup()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/init.py", line 27, in setup
apps.populate(settings.INSTALLED_APPS)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/config.py", line 199, in import_models
self.models_module = import_module(models_module_name)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/importlib/init.py", line 37, in import_module
import(name)
File "/usr/share/cdrstats/cdr/models.py", line 18, in
from postgres.fields import json_field
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/init.py", line 4, in
from .range_fields import Int4RangeField # NOQA
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/range_fields.py", line 6, in
from django.db.models.sql import aggregates
ImportError: cannot import name aggregates
Install Bower deps
Traceback (most recent call last):
File "manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 367, in execute_from_command_line
utility.execute()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 341, in execute
django.setup()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/init.py", line 27, in setup
apps.populate(settings.INSTALLED_APPS)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/config.py", line 199, in import_models
self.models_module = import_module(models_module_name)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/importlib/init.py", line 37, in import_module
import(name)
File "/usr/share/cdrstats/cdr/models.py", line 18, in
from postgres.fields import json_field
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/init.py", line 4, in
from .range_fields import Int4RangeField # NOQA
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/range_fields.py", line 6, in
from django.db.models.sql import aggregates
ImportError: cannot import name aggregates
Collects the static files
Traceback (most recent call last):
File "manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 367, in execute_from_command_line
utility.execute()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 341, in execute
django.setup()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/init.py", line 27, in setup
apps.populate(settings.INSTALLED_APPS)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/config.py", line 199, in import_models
self.models_module = import_module(models_module_name)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/importlib/init.py", line 37, in import_module
import(name)
File "/usr/share/cdrstats/cdr/models.py", line 18, in
from postgres.fields import json_field
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/init.py", line 4, in
from .range_fields import Int4RangeField # NOQA
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/range_fields.py", line 6, in
from django.db.models.sql import aggregates
ImportError: cannot import name aggregates
Traceback (most recent call last):
File "manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 367, in execute_from_command_line
utility.execute()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 341, in execute
django.setup()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/init.py", line 27, in setup
apps.populate(settings.INSTALLED_APPS)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/config.py", line 199, in import_models
self.models_module = import_module(models_module_name)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/importlib/init.py", line 37, in import_module
import(name)
File "/usr/share/cdrstats/cdr/models.py", line 18, in
from postgres.fields import json_field
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/init.py", line 4, in
from .range_fields import Int4RangeField # NOQA
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/range_fields.py", line 6, in
from django.db.models.sql import aggregates
ImportError: cannot import name aggregates
Traceback (most recent call last):
File "manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 367, in execute_from_command_line
utility.execute()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 341, in execute
django.setup()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/init.py", line 27, in setup
apps.populate(settings.INSTALLED_APPS)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/config.py", line 199, in import_models
self.models_module = import_module(models_module_name)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/importlib/init.py", line 37, in import_module
import(name)
File "/usr/share/cdrstats/cdr/models.py", line 18, in
from postgres.fields import json_field
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/init.py", line 4, in
from .range_fields import Int4RangeField # NOQA
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/range_fields.py", line 6, in
from django.db.models.sql import aggregates
ImportError: cannot import name aggregates
Traceback (most recent call last):
File "manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 367, in execute_from_command_line
utility.execute()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 341, in execute
django.setup()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/init.py", line 27, in setup
apps.populate(settings.INSTALLED_APPS)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/config.py", line 199, in import_models
self.models_module = import_module(models_module_name)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/importlib/init.py", line 37, in import_module
import(name)
File "/usr/share/cdrstats/cdr/models.py", line 18, in
from postgres.fields import json_field
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/init.py", line 4, in
from .range_fields import Int4RangeField # NOQA
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/range_fields.py", line 6, in
from django.db.models.sql import aggregates
ImportError: cannot import name aggregates
Traceback (most recent call last):
File "manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 367, in execute_from_command_line
utility.execute()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/core/management/init.py", line 341, in execute
django.setup()
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/init.py", line 27, in setup
apps.populate(settings.INSTALLED_APPS)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/registry.py", line 108, in populate
app_config.import_models(all_models)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/django/apps/config.py", line 199, in import_models
self.models_module = import_module(models_module_name)
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/importlib/init.py", line 37, in import_module
import(name)
File "/usr/share/cdrstats/cdr/models.py", line 18, in
from postgres.fields import json_field
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/init.py", line 4, in
from .range_fields import Int4RangeField # NOQA
File "/opt/miniconda/envs/cdr-stats/lib/python2.7/site-packages/postgres/fields/range_fields.py", line 6, in
from django.db.models.sql import aggregates
ImportError: cannot import name aggregates
[ ok ] Stopping supervisor (via systemctl): supervisor.service.
[ ok ] Starting supervisor (via systemctl): supervisor.service.
Install Logrotate...
rm: cannot remove ‘/etc/logrotate.d/cdr_stats’: No such file or directory

Add Nginx configuration for Welcome page...

This will install CDR-Stats Backend, Celery & Redis on your server
Press Enter to continue or CTRL-C to exit

Install Redis-server ...
OK
Ign http://ftp.belnet.be jessie InRelease
Hit http://ftp.belnet.be jessie-updates InRelease
Hit http://security.debian.org jessie/updates InRelease
Hit http://packages.dotdeb.org jessie InRelease
Hit http://ftp.belnet.be jessie Release.gpg
Hit http://ftp.belnet.be jessie Release
Hit http://apt.postgresql.org jessie-pgdg InRelease
Hit http://ftp.belnet.be jessie-updates/main Sources
Hit http://ftp.us.debian.org jessie-backports InRelease
Hit http://ftp.belnet.be jessie-updates/contrib Sources
Hit http://ftp.belnet.be jessie-updates/non-free Sources
Get:1 http://ftp.belnet.be jessie-updates/main amd64 Packages/DiffIndex [5,440 B]
Hit http://ftp.belnet.be jessie-updates/contrib amd64 Packages
Get:2 http://ftp.belnet.be jessie-updates/non-free amd64 Packages/DiffIndex [736 B]
Hit http://ftp.belnet.be jessie-updates/contrib Translation-en
Get:3 http://ftp.belnet.be jessie-updates/main Translation-en/DiffIndex [2,704 B]
Get:4 http://ftp.belnet.be jessie-updates/non-free Translation-en/DiffIndex [736 B]
Hit http://security.debian.org jessie/updates/main Sources
Hit http://security.debian.org jessie/updates/contrib Sources
Hit http://security.debian.org jessie/updates/non-free Sources
Hit http://packages.dotdeb.org jessie/all Sources
Hit http://security.debian.org jessie/updates/main amd64 Packages
Hit http://ftp.belnet.be jessie/main Sources
Hit http://ftp.belnet.be jessie/contrib Sources
Hit http://ftp.belnet.be jessie/non-free Sources
Hit http://ftp.belnet.be jessie/main amd64 Packages
Hit http://packages.dotdeb.org jessie/all amd64 Packages
Hit http://ftp.belnet.be jessie/contrib amd64 Packages
Hit http://ftp.belnet.be jessie/non-free amd64 Packages
Hit http://ftp.belnet.be jessie/contrib Translation-en
Hit http://security.debian.org jessie/updates/contrib amd64 Packages
Hit http://security.debian.org jessie/updates/non-free amd64 Packages
Hit http://security.debian.org jessie/updates/contrib Translation-en
Hit http://security.debian.org jessie/updates/main Translation-en
Hit http://ftp.belnet.be jessie/main Translation-en
Hit http://ftp.belnet.be jessie/main Translation-fr
Hit http://ftp.belnet.be jessie/non-free Translation-en
Hit http://security.debian.org jessie/updates/non-free Translation-en
Hit http://apt.postgresql.org jessie-pgdg/main amd64 Packages
Ign http://packages.dotdeb.org jessie/all Translation-en_US
Ign http://packages.dotdeb.org jessie/all Translation-en
Ign http://packages.dotdeb.org jessie/all Translation-en_US.UTF-8
Ign http://packages.dotdeb.org jessie/all Translation-fr
Get:5 http://ftp.us.debian.org jessie-backports/main amd64 Packages/DiffIndex [27.8 kB]
Get:6 http://ftp.us.debian.org jessie-backports/main Translation-en/DiffIndex [27.8 kB]
Hit https://deb.nodesource.com jessie InRelease
Hit https://deb.nodesource.com jessie/main Sources
Ign http://apt.postgresql.org jessie-pgdg/main Translation-en_US
Hit https://deb.nodesource.com jessie/main amd64 Packages
Ign http://apt.postgresql.org jessie-pgdg/main Translation-en
Ign http://apt.postgresql.org jessie-pgdg/main Translation-en_US.UTF-8
Ign http://apt.postgresql.org jessie-pgdg/main Translation-fr
Get:7 https://deb.nodesource.com jessie/main Translation-en_US [162 B]
Get:8 https://deb.nodesource.com jessie/main Translation-en [162 B]
Get:9 https://deb.nodesource.com jessie/main Translation-en_US.UTF-8 [162 B]
Get:10 https://deb.nodesource.com jessie/main Translation-fr [162 B]
Get:11 https://deb.nodesource.com jessie/main Translation-en_US [162 B]
Get:12 https://deb.nodesource.com jessie/main Translation-en [162 B]
Get:13 https://deb.nodesource.com jessie/main Translation-en_US.UTF-8 [162 B]
Get:14 https://deb.nodesource.com jessie/main Translation-fr [162 B]
Get:15 https://deb.nodesource.com jessie/main Translation-en_US [162 B]
Get:16 https://deb.nodesource.com jessie/main Translation-en [162 B]
Get:17 https://deb.nodesource.com jessie/main Translation-en_US.UTF-8 [162 B]
Get:18 https://deb.nodesource.com jessie/main Translation-fr [162 B]
Get:19 https://deb.nodesource.com jessie/main Translation-en_US [162 B]
Get:20 https://deb.nodesource.com jessie/main Translation-en [162 B]
Get:21 https://deb.nodesource.com jessie/main Translation-en_US.UTF-8 [162 B]
Get:22 https://deb.nodesource.com jessie/main Translation-fr [162 B]
Get:23 https://deb.nodesource.com jessie/main Translation-en_US [162 B]
Ign https://deb.nodesource.com jessie/main Translation-en_US
Get:24 https://deb.nodesource.com jessie/main Translation-en [162 B]
Ign https://deb.nodesource.com jessie/main Translation-en
Get:25 https://deb.nodesource.com jessie/main Translation-en_US.UTF-8 [162 B]
Ign https://deb.nodesource.com jessie/main Translation-en_US.UTF-8
Get:26 https://deb.nodesource.com jessie/main Translation-fr [162 B]
Ign https://deb.nodesource.com jessie/main Translation-fr
Fetched 65.2 kB in 4s (15.1 kB/s)
Reading package lists... Done
Reading package lists... Done
Building dependency tree
Reading state information... Done
redis-server is already the newest version.
The following packages were automatically installed and are no longer required:
libc-ares2 libv8-3.14.5
Use 'apt-get autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.
[ ok ] Restarting redis-server (via systemctl): redis-server.service.
Install Celery via supervisor...
[ ok ] Stopping supervisor (via systemctl): supervisor.service.
[ ok ] Starting supervisor (via systemctl): supervisor.service.
Checking the permissions for
File: ‘/dev/shm’
Size: 60 Blocks: 0 IO Block: 4096 directory
Device: 11h/17d Inode: 657 Links: 2

I tried a lot on another server and i think at one point django is reinstall to anothe version which breaks the all thing. This log is from a fresh install.

I also try to run it using python manage.py runserver

raceback (most recent call last):
File "manage.py", line 8, in
from django.core.management import execute_from_command_line
ImportError: No module named django.core.management

What can i do ?

Thanks

The select button to select the number of records per page is not working.

after install il see this error in log /var/log/cdr-stats/err-apache-cdr-stats.log

[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] mod_wsgi (pid=3942): Target WSGI script '/usr/share/cdr_stats/django.wsgi' cannot be loaded as Python module.
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] mod_wsgi (pid=3942): SystemExit exception raised by WSGI script '/usr/share/cdr_stats/django.wsgi' ignored.
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] Traceback (most recent call last):
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] File "/usr/share/cdr_stats/django.wsgi", line 31, in
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] import settings
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] File "/usr/share/cdr_stats/settings.py", line 533, in
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] sys.exit(1)
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] SystemExit: 1

what is it ?

Currently the install scripts are broken. They result in a non-working install.
There's an issue with psycopg2 module (fails installation) and python setuptools.
nginx listens on port 8008 but there's no site associated.
no username/passwords and no database is populated in postgres.

There're also warnings for obsolete nodejs and bower but I'm not sure if this is an issue.

Tested system: Debian 8.9 (latest jessie), network install.

quick question sorry for the bother

Hello,

I installed the 3.1.0. "all is fine". Calls are reported in the analytics page.

Seems that the analytics search function is not working properly, example:

• account code: if i try to search by account code, all records are returned without filtering by my search clause;
• caller id number: if i try to search by caller id number, it return always 0 records;
• cdr per page: every number that I select, I get always 10 records per page;

is it a bug o something related only to this installation?

Thanks

Matteo

Installed v2.0.0Beta6 and I can see all reports when I am logged in as Administrator.
I created some users through the admin UI.
When I log in as any of the users I created I can not see any of the reports, clicking the report link shows an empty bouble.

after install il see this error in log /var/log/cdr-stats/err-apache-cdr-stats.log

[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] mod_wsgi (pid=3942): Target WSGI script '/usr/share/cdr_stats/django.wsgi' cannot be loaded as Python module.
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] mod_wsgi (pid=3942): SystemExit exception raised by WSGI script '/usr/share/cdr_stats/django.wsgi' ignored.
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] Traceback (most recent call last):
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] File "/usr/share/cdr_stats/django.wsgi", line 31, in
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] import settings
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] File "/usr/share/cdr_stats/settings.py", line 533, in
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] sys.exit(1)
[Thu Feb 12 17:08:36 2015] [error] [client 89.104.118.7] SystemExit: 1

what is it ?

Much appreciate this application.

Are there any pointers to how an installation on Redhat based systems would be possible?

Cheers