<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><br>
Olá a todos,<div><br></div><div>estou tentando configurar o cdr-stats no asterisk 1.8.15 e estou com o seguinte erro: "<span style="color: rgb(51, 51, 51); line-height: 40px;">Não há dados podem ser encontrados em suas coleções, certifique-se a importação de dados está funcionando corretamente.</span><font color="#333333"><span style="line-height: 40px;">”</span></font></div><div><font color="#333333"><span style="line-height: 40px;">Não encontro erro algum nos logs.</span></font></div><div><font color="#333333"><span style="line-height: 40px;">Estou apenas com warnnings, </span>q<span style="line-height: 40px;">ue não deveria ser problema:</span></font></div><div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">service cdr-stats-celeryd status</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">/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.</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> "use STATIC_URL instead.", DeprecationWarning)</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">/usr/share/virtualenvs/cdr-stats/lib/python2.6/site-packages/celery/utils/__init__.py:72: CPendingDeprecationWarning: </div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> The 'BROKER_HOST' setting is scheduled for deprecation in version 2.5 and removal in version v4.0. Use BROKER_URL instead</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> warnings.warn(w)</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">/usr/share/virtualenvs/cdr-stats/lib/python2.6/site-packages/celery/utils/__init__.py:72: CPendingDeprecationWarning: </div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> The 'BROKER_PORT' setting is scheduled for deprecation in version 2.5 and removal in version v4.0. Use BROKER_URL instead</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> warnings.warn(w)</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; color: rgb(52, 187, 199);"><span style="color: #cbcbcb"><b>-></b></span><span style="color: #000000"> </span><b>cdr-stats-node1.ip-172-XXX-XXX-XXX: </b><span style="color: #34bd26"><b>OK</b></span></div></div><div><font color="#333333"><span style="line-height: 40px;"><br></span></font></div><div><font color="#333333"><span style="line-height: 40px;">No Diagnostic a conexão com o MySQL está OK, porém no <span class="Apple-tab-span" style="white-space:pre"> </span>MongoDB tenho tudo zerado.</span></font></div><div><font color="#333333"><span style="line-height: 40px;">O campo acctid foi adicionado ao asteriskcdrdb.cdr mas não o import_cdr.</span></font></div><div><font color="#333333"><span style="line-height: 40px;"><br></span></font></div><div><font color="#333333"><span style="line-height: 40px;">Alguém passou por algo semelhante?</span></font></div><div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">CentOS release 6.5 (Final)</div></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"><div style="margin: 0px;">Asterisk 1.8.15-cert5 built by toor @ ip-172-XXX-XXX-XXX on a x86_64 running Linux on 2014-05-16 14:02:54 UTC</div></div><div><font color="#333333"><span style="line-height: 40px;"><br></span></font></div><div><font color="#333333"><span style="line-height: 40px;">Segue meu </span></font><span style="font-family: Menlo; font-size: 11px;">settings_local.py</span></div><div><font color="#333333"><span style="line-height: 40px;"><br></span></font></div><div><font color="#333333"><span style="line-height: 40px;"><br></span></font></div><div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># CDR-Stats License</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># <a href="http://www.cdr-stats.org">http://www.cdr-stats.org</a></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># This Source Code Form is subject to the terms of the Mozilla Public</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># License, v. 2.0. If a copy of the MPL was not distributed with this file,</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># You can obtain one at <a href="http://mozilla.org/MPL/2.0/">http://mozilla.org/MPL/2.0/</a>.</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># Copyright (C) 2011-2012 Star2Billing S.L.</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># The Initial Developer of the Original Code is</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># Arezqui Belaid <<a href="mailto:info@star2billing.com">info@star2billing.com</a>></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">import os</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">DEBUG = False</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">TEMPLATE_DEBUG = False</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">ADMINS = (</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # ('Your Name', '<a href="mailto:your_email@domain.com">your_email@domain.com</a>'),</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">)</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">TIME_ZONE = ''</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">APPLICATION_DIR = os.path.dirname(globals()['__file__'])</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#DATABASE SETTINGS</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#=================</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">DATABASES = {</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'default': {</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # Add 'postgresql_psycopg2','postgresql','mysql','sqlite3','oracle'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'ENGINE': 'django.db.backends.postgresql_psycopg2',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'NAME': 'cdrstats_db',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'USER': 'cdr_stats_43579',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'PASSWORD': '1NiYoIsHqcQ2FXXXXXXt',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'HOST': '127.0.0.1',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'PORT': '5432',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'OPTIONS': {</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> #Needed on Mysql</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'init_command': 'SET storage_engine=INNODB',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> #Postgresql Autocommit</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'autocommit': True,</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> }</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> }</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">}</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#CELERY SETTINGS</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#===============</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">CARROT_BACKEND = 'redis'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">BROKER_HOST = 'localhost' # Maps to redis host.</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">BROKER_PORT = 6379 # Maps to redis port.</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">BROKER_VHOST = 0 # Maps to database number.</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">CELERY_RESULT_BACKEND = 'redis'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">REDIS_HOST = 'localhost'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">REDIS_PORT = 6379</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">REDIS_DB = 0</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#REDIS_CONNECT_RETRY = True</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#EMAIL BACKEND</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#=============</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># Email configuration</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">DEFAULT_FROM_EMAIL = 'CDR-Stats <<a href="mailto:cdr-stats@localhost.com">cdr-stats@localhost.com</a>>'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">EMAIL_USE_TLS = True</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">EMAIL_HOST = '<a href="http://smtp.gmail.com">smtp.gmail.com</a>'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">EMAIL_PORT = 587</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">EMAIL_HOST_USER = '<a href="mailto:username@gmail.com">username@gmail.com</a>'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">EMAIL_HOST_PASSWORD = 'password'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">EMAIL_SUBJECT_PREFIX = '[CDR-Stats] '</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#TASTYPIE</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#========</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">API_ALLOWED_IP = [</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> '127.0.0.1',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'localhost',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> '172.31.25.236',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">]</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#GENERAL</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#=======</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># PHONENUMBER_PREFIX_LIMIT_MIN & PHONENUMBER_PREFIX_LIMIT_MAX are used to know</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># how many digits are used to match against the dialcode prefix database</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">PHONENUMBER_PREFIX_LIMIT_MIN = 2</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">PHONENUMBER_PREFIX_LIMIT_MAX = 5</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># If PN is lower than PN_MIN_DIGITS it will be considered as an extension</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># If PN is longer than PN_MIN_DIGITS but lower than PN_MAX_DIGITS then</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># The PN will be considered as local call and the LOCAL_DIALCODE will be added</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">LOCAL_DIALCODE = 1 # Set the Dialcode of your country (44 for UK, 1 for US)</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">PN_MIN_DIGITS = 6</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">PN_MAX_DIGITS = 9</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># List of phonenumber prefix to ignore, this will be remove prior analysis</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">PREFIX_TO_IGNORE = "+,0,00,000,0000,00000,011,55555,99999"</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># When the dialed number is less or equal to INTERNAL_CALL, the call will be considered</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"># as a internal call, for example when dialed number is 41200</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">INTERNAL_CALL = 5</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#Realtime Graph : set the Y axis limit</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">REALTIME_Y_AXIS_LIMIT = 300</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#ASTERISK IMPORT</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#===============</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">ASTERISK_PRIMARY_KEY = 'acctid' # acctid, _id</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#CDR_BACKEND</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#===========</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#list of CDR Backends to import</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">CDR_BACKEND = {</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> '127.0.0.1': {</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'db_engine': 'mysql', # mysql, pgsql, mongo</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'cdr_type': 'asterisk', # asterisk or freeswitch</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'db_name': 'asteriskcdrdb',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'table_name': 'cdr',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'host': '127.0.0.1',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'port': 3306, # 3306 mysql, 5432 pgsql</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'user': ’teste',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'password': ’senhateste',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> },</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # '127.0.0.1': {</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'db_engine': 'mysql', # mysql, pgsql, mongodb</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'cdr_type': 'asterisk', # asterisk or freeswitch</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'db_name': 'asteriskcdr',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'table_name': 'cdr', # collection if mongodb</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'host': 'localhost',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'port': 3306, # 3306 mysql, 5432 pgsql, 27017 mongodb</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'user': 'root',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'password': 'password',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # },</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # '127.0.0.1': {</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'db_engine': 'mongodb', # mysql, pgsql, mongodb</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'cdr_type': 'asterisk', # asterisk or freeswitch</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'db_name': 'freeswitch_cdr',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'table_name': 'cdr', # collection if mongodb</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'host': 'localhost',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'port': 27017, # 3306 mysql, 5432 pgsql, 27017 mongodb</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'user': '',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # 'password': '',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> # },</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">}</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#Define the IP of your local Switch, it needs to exist in the CDR_BACKEND list</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">LOCAL_SWITCH_IP = '127.0.0.1'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#Asterisk Manager / Used for Realtime and Concurrent calls</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">ASTERISK_MANAGER_HOST = 'localhost'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">ASTERISK_MANAGER_USER = 'cdrstats_user'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">ASTERISK_MANAGER_SECRET = 'cdrstats_secret'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo; min-height: 13px;"><br></div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#MONGODB</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#=======</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">#Settings of CDR-Stats MongoDB server, this is used to store the analytic data</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">MONGO_CDRSTATS = {</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'DB_NAME': 'cdr-stats',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'HOST': '127.0.0.1',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'PORT': 27017,</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'CDR_COMMON': 'cdr_common',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'DAILY_ANALYTIC': 'daily_analytic',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'MONTHLY_ANALYTIC': 'monthly_analytic',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'CONC_CALL': 'concurrent_call',</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;"> 'CONC_CALL_AGG': 'concurrent_call_aggregate'</div><div style="margin: 0px; font-size: 11px; font-family: Menlo;">}</div></div><div><br></div><div><br></div><div>Grato,</div><div><br></div><div>João Marcelo Queiroz</div></body></html>