Estou tentando instalar o agente, mas está dando erro, primeiro que o meu webserver interno só tem com certificado ssl, abri uma exceção e coloquei o cacic sem, mas mesmo assim ele dá erro "Insucesso no Teste de Comunicação com o Endereço Informado!"...não sei mais o que fazer!
O cacic está rodando no servidor através do seguinte endereço "http://cacic.intranet/web/app.php/" ou através de "http://cacic.intranet/cacic/web/app.php/", mas ainda não descobri onde que ele quer comunicar....segue abaixo os logs do agente:
01/10 19:21:37 Efetuando comunicação com o endereço informado...
01/10 19:21:37 Comm: PROBLEMAS DURANTE A COMUNICAÇÃO:
01/10 19:21:37 Comm: Endereço: http://cacic.intranet/ws/get/test
01/10 19:21:37 Comm: Mensagem:
01/10 19:21:38 Efetuando comunicação com o endereço informado...
01/10 19:21:38 Comm: PROBLEMAS DURANTE A COMUNICAÇÃO:
01/10 19:21:38 Comm: Endereço: http://cacic.intranet/ws/get/test
01/10 19:21:38 Comm: Mensagem:
Debugando o Servidor web descobri que isso causa conflito com o Modsecurity, segue abaixo o log do Modsecurity:
[error] [client ] ModSecurity: Access denied with code 403 (phase 2). Pattern match "([\\\\~\\\\!\\\\@\\\\#\\\\$\\\\%\\\\^\\\\&\\\\*\\\\(\\\\)\\\\-\\\\+\\\\=\\\\{\\\\}\\\\[\\\\]\\\\|\\\\:\\\\;\\"\\\\'\\\\\\xc2\\xb4\\\\\\xe2\\x80\\x99\\\\\\xe2\\x80\\x98\\\\`\\\\<\\\\>].*?){4,}" at ARGS:ComputerSystem. [file "modsecurity_crs_41_sql_injection_attacks.conf"] [line "170"] [id "981173"] [rev "2"] [msg "Restricted SQL Character Anomaly Detection Alert - Total # of special characters exceeded"] [data "Matched Data: ] found within ARGS:ComputerSystem: B5DKWqxBQQHsIumUvAYS448dMa6mL7eHchykVHlnNRojPu75t8q7TVFOKkkaKHLBs/iooFyxTl0SF9[[MAIS]]gI6l6pNmfVeCEJmUTLioKYfURrqpCQlvuj5Cs[[MAIS]]WmuS6Ln2GUsIo5EddGkueWIZ8cWW1DgGWx[[MAIS]]2wfGJ5GCBqUWKtDPAPIimKW8NQd__CRYPTED__"] [ver "OWASP_CRS/2.2.6"] [maturity "9"] [accuracy "8"] [hostname "cacic.intranet"] [uri "/ws/get/test"]
Depois de colocar a exceção no modsecurity, o apache retorna o seguinte erro:
[error] [client ] File does not exist: /var/www/cacic/ws
[error] [client ] File does not exist: /var/www/cacic/ws
Já testei todas as possibilidades, mas não sei que tipo de acesso o agente quer fazer com o server.....
Alguém pode me ajudar?
Autor: Willen Coelho
1818 comentários
03/10 16:31:57 Comm: PROBLEMAS DURANTE A COMUNICAÇÃO:
03/10 16:31:57 Comm: Endereço: cacic.ci.ifes.edu.br/web/app.php/ws/get/test
03/10 16:31:57 Comm: Mensagem:
03/10 16:31:59 Efetuando comunicação com o endereço informado...
03/10 16:32:00 Comm: PROBLEMAS DURANTE A COMUNICAÇÃO:
03/10 16:32:00 Comm: Endereço: cacic.ci.ifes.edu.br/web/app.php/ws/get/test
03/10 16:32:01 Comm: Mensagem: Log do Cacic gerente (app/logs/prod.log): [2013-10-03 16:31:57] request.INFO: Matched route "cacic_ws_get_test" (parameters: "_controller": "Cacic\WSBundle\Controller\DefaultController::testAction", "_route": "cacic_ws_get_test") [] []
[2013-10-03 16:31:57] security.INFO: Populated SecurityContext with an anonymous Token [] []
[2013-10-03 16:31:57] security.INFO: No expression found; abstaining from voting. [] []
[2013-10-03 16:31:57] request.CRITICAL: Uncaught PHP Exception Doctrine\ORM\NoResultException: "No result was found for query although at least one row was expected." at /var/www/cacic/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 613 {"exception":"[object] (Doctrine\\ORM\\NoResultException: No result was found for query although at least one row was expected. at /var/www/cacic/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:613)"} []
[2013-10-03 16:31:58] security.DEBUG: Write SecurityContext in the session [] []
[2013-10-03 16:32:00] request.INFO: Matched route "cacic_ws_get_test" (parameters: "_controller": "Cacic\WSBundle\Controller\DefaultController::testAction", "_route": "cacic_ws_get_test") [] []
[2013-10-03 16:32:00] security.INFO: Populated SecurityContext with an anonymous Token [] []
[2013-10-03 16:32:00] security.INFO: No expression found; abstaining from voting. [] []
[2013-10-03 16:32:00] request.CRITICAL: Uncaught PHP Exception Doctrine\ORM\NoResultException: "No result was found for query although at least one row was expected." at /var/www/cacic/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php line 613 {"exception":"[object] (Doctrine\\ORM\\NoResultException: No result was found for query although at least one row was expected. at /var/www/cacic/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:613)"} []
[2013-10-03 16:32:00] security.DEBUG: Write SecurityContext in the session [] [] O apache não retorna nenhum erro! Não sei o que está acontecendo....
Warning: This development build of composer is over 30 days old. It is recommended to update it by running "composer.phar self-update" to get the latest version.
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Nothing to install or update
Generating autoload files
Clearing the cache for the dev environment with debug true
Installing assets using the symlink option
Installing assets for Symfony\Bundle\FrameworkBundle into web/bundles/framework
Installing assets for Cacic\CommonBundle into web/bundles/caciccommon
Installing assets for Cacic\RelatorioBundle into web/bundles/cacicrelatorio
Installing assets for JMS\TranslationBundle into web/bundles/jmstranslation
Installing assets for FM\ElfinderBundle into web/bundles/fmelfinder
Installing assets for Sensio\Bundle\DistributionBundle into web/bundles/sensiodistribution server:/srv/gerente# php app/console doctrine:schema:update --force
Nothing to update - your database is already in sync with the current entity metadata. server:/srv/gerente# php app/console assets:install --symlink
Installing assets using the symlink option
Installing assets for Symfony\Bundle\FrameworkBundle into web/bundles/framework
Installing assets for Cacic\CommonBundle into web/bundles/caciccommon
Installing assets for Cacic\RelatorioBundle into web/bundles/cacicrelatorio
Installing assets for JMS\TranslationBundle into web/bundles/jmstranslation
Installing assets for FM\ElfinderBundle into web/bundles/fmelfinder
Installing assets for Sensio\Bundle\DistributionBundle into web/bundles/sensiodistribution server:/srv/gerente# php app/console assetic:dump
Dumping all dev assets.
Debug mode is on. 18:32:37 [file+] /srv/gerente/app/../web/assets/login_part_1.js
18:32:37 [file+] /srv/gerente/app/../web/js/jquery_jquery-1.9.1_1.js
18:32:37 [file+] /srv/gerente/app/../web/assets/base_part_3.js
18:32:37 [file+] /srv/gerente/app/../web/js/bootstrap_bootstrap-transition_1.js
18:32:37 [file+] /srv/gerente/app/../web/js/bootstrap_bootstrap-alert_2.js MUITO GRANDE, COPIEI SÓ ATÉ AQUI, MAS NADA DE ERRO TUDO OK. server:/srv/gerente# php app/console doctrine:fixtures:load
Careful, database will be purged. Do you want to continue Y/N ?y
> purging database
> loading [1] Cacic\CommonBundle\DataFixtures\ORM\LoadLocalData
> loading [1] Cacic\CommonBundle\DataFixtures\ORM\LoadClasseData
> loading [2] Cacic\CommonBundle\DataFixtures\ORM\LoadGrupoUsuarioData
> loading [2] Cacic\CommonBundle\DataFixtures\ORM\LoadClassPropertyData
> loading [3] Cacic\CommonBundle\DataFixtures\ORM\LoadUsuarioData
> loading [4] Cacic\CommonBundle\DataFixtures\ORM\LoadConfiguracaoPadraoData
> loading [5] Cacic\CommonBundle\DataFixtures\ORM\LoadConfiguracaoLocalData
> loading [6] Cacic\CommonBundle\DataFixtures\ORM\LoadAcaoData
> loading [7] Cacic\CommonBundle\DataFixtures\ORM\LoadCollectDefClassData Fiz toda a instalação novamente, criei a subrede, blz, ele achou a máquina que mandei instalar, e só, não mostra os dados coletados, nem coleta de software e quando rodo o mapa pede para instalar novamente.
03/10 18:13:49 Efetuando comunicação com o endereço informado...
03/10 18:13:49 Criando pasta C:\Cacic\Temp
03/10 18:13:49 Criando pasta C:\Cacic\Modules
03/10 18:13:49 Liberando as conexões de Saída para o serviço FTP
03/10 18:13:49 Liberando as conexões de Saída para o InstallCACIC
03/10 18:13:49 Liberando as conexões de Saída para o ChkSIS
03/10 18:13:49 Fazendo contato com Gerente WEB.
03/10 18:13:50 Comm: PROBLEMAS DURANTE A COMUNICAÇÃO:
03/10 18:13:50 Comm: Endereço: cacicserver/ws/get/config
03/10 18:13:50 Comm: Mensagem: Quando Rodo o mapacacic Fala para reinstalar o cacic na estação, que a estrutura se encontra corrompida, já fiz isso e nada.
>> Teste de Conexão Negativo!
Efetuando comunicação com o endereço informado...
>> Teste de Conexão Negativo! Desde já obrigado pela atenção.
>> Teste de Conexão OK!
Liberando as conexões de Saída para o serviço FTP
Liberando as conexões de Saída para o InstallCACIC
Liberando as conexões de Saída para o ChkSIS
Fazendo contato com Gerente WEB. O que pode ser? Obrigado mais um vez.