1 – apt-get install mysql-server, libmysqlclient15-dev
\n2 – Compilar o asterisk-addons:
\n.\/configure
\nmake
\nmake install
\nmake samples
\n3 – Configurar o \/etc\/asterisk\/cdr_mysql.conf para conextar no asterisk
\n[global]
\nhostname=127.0.0.1
\ndbname=asteriskcdrdb
\ntable=cdr
\npassword=senha
\nuser=root
\nport=3306
\nuserfielt=1 <\/p>\n
4 – Fazer download da tabela pronta cdr.sql 8 – Copiar o conte\u00fado do asterisk stats para \/var\/www\/ 9 – Comentar a linha do cdr.php (\/var\/www\/) onde se diz session_start(); <\/p>\n 10 – Editar o arquivo defines.php (\/var\/www\/lib\/defines.php) define (“WEBROOT”, “http:\/\/192.168.254.254\/relatorio\/”); FSROOT: This is the server path which contain the application. 11 – Entre no browser e teste. :) <\/p>\n NO FREEBSD e CENTOS tive que alterar dois parametros no php.ini 1 – apt-get install mysql-server, libmysqlclient15-dev 2 – Compilar o asterisk-addons: .\/configure make make install make samples 3 – Configurar o \/etc\/asterisk\/cdr_mysql.conf para conextar no asterisk [global] hostname=127.0.0.1 dbname=asteriskcdrdb table=cdr password=senha user=root port=3306 userfielt=1 4 – Fazer download da tabela pronta cdr.sql Ap\u00f3s intruduzir no…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/71"}],"collection":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=71"}],"version-history":[{"count":6,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions"}],"predecessor-version":[{"id":657,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/71\/revisions\/657"}],"wp:attachment":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nAp\u00f3s intruduzir no mysql:
\nmysql -u root -p
\ncp * \/var\/www -r <\/p>\n
\nEdit defines.php e alterar os parametros de acordo com sua necessidade. <\/p>\n
\ndefine (“FSROOT”, “\/var\/www\/html\/relatorio\/”); <\/p>\n
\nExample: \/home\/users\/asterisk-stat\/
\nHOST: 127.0.0.1
\nExample: localhost
\nPORT: 3306
\nExample: 5432
\nUSER: root
\nExample: username
\nPASS: Database password of the user.
\nExample: password
\nDBNAME: asteriskcdrdb
\nExample: asteriskcdr
\nDB_TYPE: mysql
\nsupport: mysql and postgres
\nDB_TABLENAME: Table of the database containing the CDR.
\nExample: cdrtable
\nappli_list: PHP array used to associate extension to a name. This can be useful if you want to give more signification during the CDR browsing
\n$appli_list[‘4677’]=array(“Voicemail”);
\n$appli_list[‘6544’]=array(“Conference-MeetMe”); <\/p>\n
\nshort_open_tag = On
\nerror_reporting = E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED<\/p>\n","protected":false},"excerpt":{"rendered":"