# Instalação dos Relatórios na versão 2.1.0

**URL:** <https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302>\
**Category:** Dúvidas\
**Created:** [Dezembro 13, 2018, 7:40pm UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302 "2018-12-13T19:40:54Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![rohanbernartt](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/rohanbernartt/32/177_2.png) [@rohanbernartt](https://forum.ieducar.org/u/rohanbernartt)\
**Post date:** [Dezembro 13, 2018, 7:40pm UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/1 "2018-12-13T19:40:54Z")

</div>

Boa tarde, pessoal

Como faço instalação do pacote de relatórios na versão 2.1.0 do i-Educar?

No repositório, tem apenas o comando para clonar o repositório.

Preciso executar mais algum outro comando?

Desde já, muito obrigado pelo apoio.

---

<div class="post-metadata">

**Author:** ![rohanbernartt](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/rohanbernartt/32/177_2.png) [@rohanbernartt](https://forum.ieducar.org/u/rohanbernartt)\
**Post date:** [Dezembro 15, 2018, 12:15pm UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/2 "2018-12-15T12:15:27Z")

</div>

Consegui fazer a instalação:  
 ![Screenshot_5](https://canada1.discourse-cdn.com/flex036/uploads/ieducar/original/1X/44118c9d1d6166c7ca76efd91150fe93f0e42f98.png)

Porém, ao exibir o relatório para impressão, aparece essa outra mensagem de erro:

 ![Screenshot_6](https://canada1.discourse-cdn.com/flex036/uploads/ieducar/original/1X/f839126cd06d9e8872dc4e3ad1aa2e06aebea154.png)

---

<div class="post-metadata">

**Author:** ![Bonot](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/bonot/32/75_2.png) [@Bonot](https://forum.ieducar.org/u/Bonot)\
**Post date:** [Dezembro 17, 2018, 12:11pm UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/3 "2018-12-17T12:11:23Z")

</div>

Olá, @rohanbernartt!

Veja se os tópicos [Erro relatórios após novo pacote de relatórios](https://forum.ieducar.org/t/erro-relatorios-apos-novo-pacote-de-relatorios/224/16) ou [Erro relatórios após novo pacote de relatórios](https://forum.ieducar.org/t/erro-relatorios-apos-novo-pacote-de-relatorios/224/16) podem te ajudar 😃

---

<div class="post-metadata">

**Author:** ![rohanbernartt](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/rohanbernartt/32/177_2.png) [@rohanbernartt](https://forum.ieducar.org/u/rohanbernartt)\
**Post date:** [Dezembro 17, 2018, 2:24pm UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/4 "2018-12-17T14:24:48Z")

</div>

Olhei esses tópicos, em um deles eu cheguei até o link:

> [Home · portabilis/i-educar Wiki · GitHub](https://github.com/portabilis/i-educar/wiki/Pacote-de-relat%C3%B3rios)

Mas nesse passo-a-passo, fala sobre **phinx** , que parece ter sido removido na versão **2.1.0** do i-educar.

Correto?

---

<div class="post-metadata">

**Author:** ![Bonot](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/bonot/32/75_2.png) [@Bonot](https://forum.ieducar.org/u/Bonot)\
**Post date:** [Dezembro 18, 2018, 11:29am UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/5 "2018-12-18T11:29:20Z")

</div>

Correto, mas acredito que o problema de output(), que você está enfrentando, esteja relacionado ao caminho do relatório está errado no ini.

---

<div class="post-metadata">

**Author:** ![rohanbernartt](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/rohanbernartt/32/177_2.png) [@rohanbernartt](https://forum.ieducar.org/u/rohanbernartt)\
**Post date:** [Dezembro 18, 2018, 1:51pm UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/6 "2018-12-18T13:51:13Z")

</div>

As configurações no **ieducar.ini** estão assim:

 ![image](https://canada1.discourse-cdn.com/flex036/uploads/ieducar/original/1X/17410190500d1d3a351fabc3c46b4b32396173ab.png)

---

<div class="post-metadata">

**Author:** ![Bonot](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/bonot/32/75_2.png) [@Bonot](https://forum.ieducar.org/u/Bonot)\
**Post date:** [Dezembro 18, 2018, 3:49pm UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/7 "2018-12-18T15:49:43Z")

</div>

Tente substituir a linha `report.source_path...` por:

```auto
report.source_path = /application/ieducar/modules/Reports/ReportSources/

```

---

<div class="post-metadata">

**Author:** ![rohanbernartt](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/rohanbernartt/32/177_2.png) [@rohanbernartt](https://forum.ieducar.org/u/rohanbernartt)\
**Post date:** [Dezembro 18, 2018, 6:28pm UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/8 "2018-12-18T18:28:49Z")

</div>

@Bonot,

Mesmo substituindo permanece o erro.

O caminho lá em cima tá assim  
`http://IP_DA_VPS:PORTA/module/Reports/StudentsPerClass`

não sei se isso ajuda para identificar-mos a configuração correta.

---

<div class="post-metadata">

**Author:** ![Bonot](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/bonot/32/75_2.png) [@Bonot](https://forum.ieducar.org/u/Bonot)\
**Post date:** [Dezembro 18, 2018, 6:31pm UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/9 "2018-12-18T18:31:39Z")

</div>

Acho que você vai precisar reproduzir os passos que indiquei no [Erro relatórios após novo pacote de relatórios](https://forum.ieducar.org/t/erro-relatorios-apos-novo-pacote-de-relatorios/224/16), para ver qual o caminho dos relatórios que está no container. Você fez o clone dos relatórios certinho?

---

<div class="post-metadata">

**Author:** ![rohanbernartt](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/rohanbernartt/32/177_2.png) [@rohanbernartt](https://forum.ieducar.org/u/rohanbernartt)\
**Post date:** [Dezembro 19, 2018, 12:34am UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/10 "2018-12-19T00:34:53Z")

</div>

Segue esses passos:

> - Acessar o container: `docker exec -it ieducar_1604 bash` , em alguns casos precisa do `sudo` na frente.
> - Entrar na pasta em que os relatórios se encontram, padrão: `cd ieducar/modules/Reports/ReportSources/`
> - Execute uma listagem dos arquivos, pra ver se estão aí mesmo: `ls`
> - Se estiver tudo ok, use o comando `pwd` para mostrar na tela o caminho atual, e coloque ele no ini.

E o resultado foi esse, depois que digitei **pwd** de dentro da pasta ReportSource:  
`/root/i-educar/ieducar/modules/Reports/ReportSources`

---

<div class="post-metadata">

**Author:** ![rohanbernartt](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/rohanbernartt/32/177_2.png) [@rohanbernartt](https://forum.ieducar.org/u/rohanbernartt)\
**Post date:** [Dezembro 19, 2018, 12:35am UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/11 "2018-12-19T00:35:29Z")

</div>

> [@rohanbernartt](#):
>
> ieducar\_1604

Na verdade na versão 2.1.0, não tem mais esse **ieducar\_1604** , na instalação.

---

<div class="post-metadata">

**Author:** ![Bonot](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/bonot/32/75_2.png) [@Bonot](https://forum.ieducar.org/u/Bonot)\
**Post date:** [Dezembro 19, 2018, 4:17pm UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/12 "2018-12-19T16:17:40Z")

</div>

Tenta colocar assim no ini então:

`report.source_path = /root/i-educar/ieducar/modules/Reports/ReportSources/`

> _Na verdade na versão 2.1.0, não tem mais esse **ieducar\_1604** , na instalação._

Sim, não tem mais.

---

<div class="post-metadata">

**Author:** ![rohanbernartt](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/rohanbernartt/32/177_2.png) [@rohanbernartt](https://forum.ieducar.org/u/rohanbernartt)\
**Post date:** [Dezembro 19, 2018, 6:51pm UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/13 "2018-12-19T18:51:28Z")

</div>

Alterei,  
Mesmo assim, continua se abrir.

É normal ter esses dois parâmetros:

![image](https://canada1.discourse-cdn.com/flex036/uploads/ieducar/original/1X/d9e15bbed3ba5582e4d7f9827244001b7ff1876d.png)

Outra dúvida,  
Preciso rodar algum comando depois de atualizar esse arquivo **.ini**

---

<div class="post-metadata">

**Author:** ![IsaelCoelho](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/isaelcoelho/32/86_2.png) [@IsaelCoelho](https://forum.ieducar.org/u/IsaelCoelho)\
**Post date:** [Dezembro 19, 2018, 7:03pm UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/14 "2018-12-19T19:03:12Z")

</div>

estou precisando resolver o mesmo problema, a pergunta é : tenho que executar aqueles procedimentos que estão em [Instalação dos Relatórios na versão 2.1.0](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/13) ? o arquivo phinx.php fica onde nesta ultima versão?

---

<div class="post-metadata">

**Author:** ![Juchem](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/juchem/32/173_2.png) [@Juchem](https://forum.ieducar.org/u/Juchem)\
**Post date:** [Dezembro 20, 2018, 12:16am UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/15 "2018-12-20T00:16:58Z")

</div>

Depois de fazer o clone dos relatórios você rodaram:  
**docker-compose exec php artisan reports:install**  
**docker-compose exec php artisan migrate**

Esses comandos são executados fora do docker.

---

<div class="post-metadata">

**Author:** ![rohanbernartt](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/rohanbernartt/32/177_2.png) [@rohanbernartt](https://forum.ieducar.org/u/rohanbernartt)\
**Post date:** [Dezembro 20, 2018, 12:34am UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/16 "2018-12-20T00:34:40Z")

</div>

Rodei sim, @Juchem

De dentro da pasta /i-educar/  
`docker-compose exec php artisan reports:install`

 ![image](https://canada1.discourse-cdn.com/flex036/uploads/ieducar/original/1X/ec2d089f9b7be28ca6c617098b7c1cc1d27bbbdc.png)

E nesse:  
`docker-compose exec php artisan migrate`

 ![image](https://canada1.discourse-cdn.com/flex036/uploads/ieducar/original/1X/c8e897f137e70d8f3e5071db287c8d0698bf3451.png)

---

<div class="post-metadata">

**Author:** ![Juchem](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/juchem/32/173_2.png) [@Juchem](https://forum.ieducar.org/u/Juchem)\
**Post date:** [Dezembro 20, 2018, 12:44am UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/17 "2018-12-20T00:44:23Z")

</div>

Esse erro para exibir relatórios acontece com todos os relatórios? Já testou outro relatório?

Em **i-educar/storage/logs** tem alguns arquivos de texto com erros da aplicação, vê se ai não te da uma luz do que pode estar acontecendo.

---

<div class="post-metadata">

**Author:** ![rohanbernartt](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/rohanbernartt/32/177_2.png) [@rohanbernartt](https://forum.ieducar.org/u/rohanbernartt)\
**Post date:** [Dezembro 20, 2018, 12:48am UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/18 "2018-12-20T00:48:43Z")

</div>

Acontece com todos os Relatórios.  
Vou verificar os **logs**

---

<div class="post-metadata">

**Author:** ![rohanbernartt](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/rohanbernartt/32/177_2.png) [@rohanbernartt](https://forum.ieducar.org/u/rohanbernartt)\
**Post date:** [Dezembro 20, 2018, 1:06am UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/19 "2018-12-20T01:06:19Z")

</div>

As últimas linhas do Log de hoje, estão assim:

> Name: situacao\_matricula\_pkey; Type: CONSTRAINT; Schema: relatorio; Owner: postgres
> 
> ALTER TABLE ONLY situacao\_matricula  
> ADD CONSTRAINT situacao\_matricula\_pkey PRIMARY KEY (cod\_situacao);  
> ) at /application/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664, PDOException(code: 42723): SQLSTATE[42723]: Duplicate function: 7 ERROR: function "get\_ddd\_escola" already exists with same argument types at /application/vendor/laravel/framework/src/Illuminate/Database/Connection.php:507)  
> [stacktrace]  
> #0 /application/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\Database\Connection-\>runQueryCallback(‘SET search\_path…’, Array, Object(Closure))  
> #1 /application/vendor/laravel/framework/src/Illuminate/Database/Connection.php(511): Illuminate\Database\Connection-\>run(‘SET search\_path…’, Array, Object(Closure))  
> #2 /application/app/Console/Commands/ReportsInstallCommand.php(58): Illuminate\Database\Connection-\>unprepared(‘SET search\_path…’)  
> #3 [internal function]: App\Console\Commands\ReportsInstallCommand-\>handle(Object(Illuminate\Filesystem\Filesystem), Object(Illuminate\Database\PostgresConnection))  
> #4 /application/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(29): call\_user\_func\_array(Array, Array)  
> #5 /application/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()  
> #6 /application/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))  
> #7 /application/vendor/laravel/framework/src/Illuminate/Container/Container.php(572): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)  
> #8 /application/vendor/laravel/framework/src/Illuminate/Console/Command.php(183): Illuminate\Container\Container-\>call(Array)  
> #9 /application/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command-\>execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))  
> #10 /application/vendor/laravel/framework/src/Illuminate/Console/Command.php(170): Symfony\Component\Console\Command\Command-\>run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))  
> #11 /application/vendor/symfony/console/Application.php(901): Illuminate\Console\Command-\>run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))  
> #12 /application/vendor/symfony/console/Application.php(262): Symfony\Component\Console\Application-\>doRunCommand(Object(App\Console\Commands\ReportsInstallCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))  
> #13 /application/vendor/symfony/console/Application.php(145): Symfony\Component\Console\Application-\>doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))  
> #14 /application/vendor/laravel/framework/src/Illuminate/Console/Application.php(89): Symfony\Component\Console\Application-\>run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))  
> #15 /application/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(122): Illuminate\Console\Application-\>run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))  
> #16 /application/artisan(37): Illuminate\Foundation\Console\Kernel-\>handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))  
> #17 {main}  
> "}

---

<div class="post-metadata">

**Author:** ![rohanbernartt](https://yyz2.discourse-cdn.com/flex036/user_avatar/forum.ieducar.org/rohanbernartt/32/177_2.png) [@rohanbernartt](https://forum.ieducar.org/u/rohanbernartt)\
**Post date:** [Dezembro 20, 2018, 1:14am UTC](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302/20 "2018-12-20T01:14:35Z")

</div>

Não consegui executar em modo **debug** , pra tentar visualizar onde tá o erro.

[Próxima página](https://forum.ieducar.org/t/instalacao-dos-relatorios-na-versao-2-1-0/302.md?page=2)
