Novo SGA v2.0.0

rogeriolino

Novo SGA v2.0.1

LOG:

[2018-08-03 14:10:40] event.DEBUG: Notified event "console.command" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". {"event":"console.command","listener":"Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"} []
[2018-08-03 14:10:40] event.DEBUG: Notified event "console.command" to listener "Symfony\Bridge\Monolog\Handler\ConsoleHandler::onCommand". {"event":"console.command","listener":"Symfony\\Bridge\\Monolog\\Handler\\ConsoleHandler::onCommand"} []
[2018-08-03 14:10:40] console.ERROR: Error thrown while running command "novosga:install". Message: "An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)" {"exception":"[object] (Doctrine\\DBAL\\Exception\\ConnectionException(code: 0): An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) at /var/www/html/novosga/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:113, Doctrine\\DBAL\\Driver\\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) at /var/www/html/novosga/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:50, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) at /var/www/html/novosga/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:46)","command":"novosga:install","message":"An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)"} []
[2018-08-03 14:10:40] event.DEBUG: Notified event "console.error" to listener "Symfony\Bundle\SwiftmailerBundle\EventListener\EmailSenderListener::onException". {"event":"console.error","listener":"Symfony\\Bundle\\SwiftmailerBundle\\EventListener\\EmailSenderListener::onException"} []
[2018-08-03 14:10:40] event.DEBUG: Notified event "console.error" to listener "Symfony\Component\Console\EventListener\ErrorListener::onConsoleError". {"event":"console.error","listener":"Symfony\\Component\\Console\\EventListener\\ErrorListener::onConsoleError"} []
[2018-08-03 14:10:40] console.DEBUG: Command "novosga:install" exited with code "1" {"command":"novosga:install","code":1} []
[2018-08-03 14:10:40] event.DEBUG: Notified event "console.terminate" to listener "Symfony\Bundle\SwiftmailerBundle\EventListener\EmailSenderListener::onTerminate". {"event":"console.terminate","listener":"Symfony\\Bundle\\SwiftmailerBundle\\EventListener\\EmailSenderListener::onTerminate"} []
[2018-08-03 14:10:40] event.DEBUG: Notified event "console.terminate" to listener "Symfony\Component\Console\EventListener\ErrorListener::onConsoleTerminate". {"event":"console.terminate","listener":"Symfony\\Component\\Console\\EventListener\\ErrorListener::onConsoleTerminate"} []
[2018-08-03 14:10:40] event.DEBUG: Notified event "console.terminate" to listener "Symfony\Bridge\Monolog\Handler\ConsoleHandler::onTerminate". {"event":"console.terminate","listener":"Symfony\\Bridge\\Monolog\\Handler\\ConsoleHandler::onTerminate"} []
[2018-08-03 14:10:53] event.DEBUG: Notified event "console.command" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". {"event":"console.command","listener":"Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"} []
[2018-08-03 14:10:53] event.DEBUG: Notified event "console.command" to listener "Symfony\Bridge\Monolog\Handler\ConsoleHandler::onCommand". {"event":"console.command","listener":"Symfony\\Bridge\\Monolog\\Handler\\ConsoleHandler::onCommand"} []
[2018-08-03 14:10:53] console.ERROR: Error thrown while running command "novosga:install". Message: "An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)" {"exception":"[object] (Doctrine\\DBAL\\Exception\\ConnectionException(code: 0): An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) at /var/www/html/novosga/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:113, Doctrine\\DBAL\\Driver\\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) at /var/www/html/novosga/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:50, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO) at /var/www/html/novosga/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:46)","command":"novosga:install","message":"An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)"} []
[2018-08-03 14:10:53] event.DEBUG: Notified event "console.error" to listener "Symfony\Bundle\SwiftmailerBundle\EventListener\EmailSenderListener::onException". {"event":"console.error","listener":"Symfony\\Bundle\\SwiftmailerBundle\\EventListener\\EmailSenderListener::onException"} []
[2018-08-03 14:10:53] event.DEBUG: Notified event "console.error" to listener "Symfony\Component\Console\EventListener\ErrorListener::onConsoleError". {"event":"console.error","listener":"Symfony\\Component\\Console\\EventListener\\ErrorListener::onConsoleError"} []
[2018-08-03 14:10:53] console.DEBUG: Command "novosga:install" exited with code "1" {"command":"novosga:install","code":1} []
[2018-08-03 14:10:53] event.DEBUG: Notified event "console.terminate" to listener "Symfony\Bundle\SwiftmailerBundle\EventListener\EmailSenderListener::onTerminate". {"event":"console.terminate","listener":"Symfony\\Bundle\\SwiftmailerBundle\\EventListener\\EmailSenderListener::onTerminate"} []
[2018-08-03 14:10:53] event.DEBUG: Notified event "console.terminate" to listener "Symfony\Component\Console\EventListener\ErrorListener::onConsoleTerminate". {"event":"console.terminate","listener":"Symfony\\Component\\Console\\EventListener\\ErrorListener::onConsoleTerminate"} []
[2018-08-03 14:10:53] event.DEBUG: Notified event "console.terminate" to listener "Symfony\Bridge\Monolog\Handler\ConsoleHandler::onTerminate". {"event":"console.terminate","listener":"Symfony\\Bridge\\Monolog\\Handler\\ConsoleHandler::onTerminate"} []

Obrigado!

juanzapatac Hola Rogerio, I updated today to 2.0.3 and changed PHP to version 7.1.20, still not working triagem.
I set app in prod but no log created, but dev log may have some clue to this issue.

Info&Errors:
INFO
12:02:15
request	Matched route "novosga_triage_index".
Hide context
[▼
  "route" => "novosga_triage_index"
  "route_parameters" => []
  "request_uri" => "http://192.192.1.157/novosga.triage/"
  "method" => "GET"
]

Deprecations:
12:02:15
php	User Deprecated: Doctrine\Common\ClassLoader is deprecated.
Hide context    Show trace
[▼
  "exception" => ErrorException {#91 }
]
11:36:39
-	The "Novosga\Entity\Usuario" class implements "Symfony\Component\Security\Core\User\AdvancedUserInterface" that is deprecated since Symfony 4.1 *.
Hide context    Show trace
[▼
  "exception" => SilencedErrorContext {#1443 }
]

If you require some more info, just let me know.

Thaks a lot !!

Regards,

Juan

Boa tarde Rogerio, moito obrigado pela sua resposta.

I have tested today different variations trying to understand why that happens.
Finally I found that .htaccess is "somehow" responsible.

If I delete .htaccess and set .env APP_ENV=dev, everything works just fine accesing with server:run command. With .env APP_ENV=prod it doesn event start novo.

If I use .htaccess as prod or as dev, triagem menu options did not shoy anything.

I have added service to units, actually I create all variables include departments and assign them. In fact, using .env in dev environment works ok.

Permissions for .htaccess and .env are ok.

Hope this info can help to undertand or reproduce this issue.

Regards.

Juan

Exactly, but only in production, triagem menu page comes out white, and the only error that I have is:

Uncaught ReferenceError: servicos is not defined
    at script.js:33
    at script.js:325

Hola Rogerio, found the solution

In RC3 I have in my .htaccess this line:

SetEnv DATABASE_URL mysql://novosga:123456@localhost:3306/novosga 

and everithing worked ok (I still have RC3 installed)

But v2.x.x needs the correct ddbb reference like this:

SetEnv DATABASE_URL mysql://root:123456@localhost:3306/novosga?charset=utf8mb4&serverVersion=5.7 

And now I can see triagem page correctly.

Regards

Juan