{"id":116,"date":"2011-05-31T11:46:28","date_gmt":"2011-05-31T14:46:28","guid":{"rendered":"http:\/\/blog.abratel.com.br\/2011\/05\/31\/asternic-instalacao-queue-analise-de-agentes\/"},"modified":"2011-07-08T19:50:55","modified_gmt":"2011-07-08T22:50:55","slug":"asternic-instalacao-queue-analise-de-agentes","status":"publish","type":"post","link":"https:\/\/blog.abratel.com.br\/?p=116","title":{"rendered":"Asternic instala\u00e7\u00e3o &#8211; queue &#8211; An\u00e1lise de Agentes"},"content":{"rendered":"<p>How to Install<\/p>\n<p>Fazer o Download dosoftware:<br \/>\ncd \/usr\/src<br \/>\nwget http:\/\/www.asternic.org\/stats\/asternic-stats-1.3.tgz<br \/>\nou baixar <a href=\"http:\/\/www.digavoip.com.br\/downloads\/asternic-stats-1.3.tgz\">clicando aqui<\/a><\/p>\n<p>Descompactar:<br \/>\ntar zvxf asternic-stats-1.3.tgz<br \/>\ncd asternic-stats<\/p>\n<p>Create a mysql database:<br \/>\nmysqladmin -u root -p create qstats<\/p>\n<p>Create the tables for the database:<br \/>\nmysql -u root -p qstats < sql\/qstats.sql\n\nIMPORTANTISSIMO ADICIONAR ESSAS DUAS LINHAS PARA FUNCIONAMENTO (no config.php):\n$queue_log_dir  = '\/var\/log\/asterisk\/';\n$queue_log_file = 'queue_log'; \n \n\nEdit \/usr\/src\/asternic-stats\/html\/config.php to set authenticate information for the database:\n$dbhost = 'localhost';\n$dbname = 'qstats';\n$dbuser = 'root';\n$dbpass = '';\n\n$manager_host   = \"127.0.0.1\";\n$manager_user   = \"admin\";\n$manager_secret = \"admin\";\n\n$language = \"es\";\n\n \n\nEdit \/usr\/src\/asternic-stats\/parselog\/config.php with auth information for the database:\n$queue_log_dir  = '\/var\/log\/asterisk\/';\n$queue_log_file = 'queue_log';\n\n$dbhost = 'localhost';\n$dbname = 'qstats';\n$dbuser = 'root';\n$dbpass = '';\n\n<strong> ATEN\u00c7\u00c3O!!!! Nesse arquivo o nome do database esta errado.. esta $dbname = &#8216;qstat&#8217;;    NO SINGULAR.. alterar para plural!!!!<\/strong><\/p>\n<p>Criar no \/etc\/asterisk\/manager.conf<\/p>\n<p>[admin]<br \/>\nsecret=admin<br \/>\nread=system,call,log,verbose,command,agent,user<br \/>\nwrite=system,call,log,verbose,command,agent,user<\/p>\n<p>Move the html directory to Apache DocumentRoot:<br \/>\nmv \/usr\/src\/asternic-stats\/html \/var\/www\/html\/queue-stats<\/p>\n<p>Move the parselog directory to its new home:<br \/>\nmv \/usr\/src\/asternic-stats\/parselog \/usr\/local<\/p>\n<p> Pode enviar o config e o lang\/pt_BR.php (dessa forma de diretorio) para o \/usr\/local\/parselog\/<\/p>\n<p>======================================= <\/p>\n<p>Create a cron job to parse data from queue_log and populate the database:<br \/>\ncrontab -e<\/p>\n<p> No manual, esta escrito para executar no cron assim:<br \/>\nAnd type this in your cronjob file:<br \/>\n0 0      * * *  php -q \/usr\/local\/parselog\/parselog.php convertlocal<br \/>\nPorem somente deu certo para mim quando executei de 1 em 1 minuto assim:<br \/>\n*\/1 *   * * *   root   \/usr\/bin\/relatorio.sh<\/p>\n<p>onde relatorio.sh contem:<br \/>\n#!\/bin\/sh<br \/>\nphp -q \/usr\/local\/parselog\/parselog.php convertlocal<\/p>\n<p>lembrando de dar o chmod +x no mesmo. :)<\/p>\n<p>======================================= <\/p>\n<p>PARA VER O LOG se tem ou n\u00e3o sucesso basta editar o arquivo parselog.php comentando do mesmo a linha:<br \/>\n#error_reporting(0);<\/p>\n<p>You can save it by pressing \u201c:x\u201d<\/p>\n<p>Para passar para portugues:<br \/>\nA tradu\u00e7\u00e3o feita por Edter Miotto pode ser baixada em: http:\/\/usuarios.upf.br\/~eder\/asternic-stats-lang-pt_BR.tar.gz<br \/>\nou <a href=\"http:\/\/www.digavoip.com.br\/downloads\/asternic-stats-lang-pt_BR.tar.gz\">clicando aqui<\/a><\/p>\n<p>Para instalar o modulo pt_Br do Asternic, basta copiar o arquivo pt_BR.php para dentro da pasta html\/lang e alterar o vari\u00e1vel $language para pt_Br dentro do arquivo config.php de acordo.<\/p>\n<p>To parse the log at periodic intervals via a cronjob:<\/p>\n<p>Inside the \/parselog directory you will find a script to do the job:<\/p>\n<p>.\/parselog.php<\/p>\n<p>If you dont have binftm_misc installed you might need to run:<\/p>\n<p>php -q .\/parselog.php<\/p>\n<p><strong>Clean up database<\/strong><\/p>\n<p>If you want to clean up the data and start over and fresh, you can run<\/p>\n<p>.\/parselog.php purge<\/p>\n<p>Finally, you can see the statistics and reports with your browser from http:\/\/ip.asterisk\/queue-stats<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Install Fazer o Download dosoftware: cd \/usr\/src wget http:\/\/www.asternic.org\/stats\/asternic-stats-1.3.tgz ou baixar clicando aqui Descompactar: tar zvxf asternic-stats-1.3.tgz cd asternic-stats Create a mysql database: mysqladmin -u root -p create qstats Create the tables for the database: mysql -u root -p qstats < sql\/qstats.sql IMPORTANTISSIMO...\n<\/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\/116"}],"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=116"}],"version-history":[{"count":0,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=\/wp\/v2\/posts\/116\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.abratel.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}