Question - Post install PHP Errors

jack · November 22, 2022, 7:52pm

Hi there!

We are currently evaluating Eramba and wanted to configure the app on-prem via docker. We’ve run the installation via the guidance provided in the Eramba documentation. Unfortunately, when we attempt to navigate to the site, we get a 500 error. I’m wondering if somebody can help me look at these logs and determine what the solution is? I’ve re-deployed the containers a few times to no avail. I’ll post the errors that we see when somebody navigates to the page, but I have the install logs if somebody would like to see those as well.

[Tue Nov 22 19:43:39.093402 2022] [php:error] [pid 29] [client 172.20.20.76:55772] PHP Fatal error:  [Cake\\Routing\\Exception\\MissingRouteException] A route matching "array (\n  'controller' => 'Settings',\n  'action' => 'getLogo',\n  'plugin' => false,\n  'prefix' => false,\n  0 => 'white',\n  '_ext' => NULL,\n)" could not be found. (/var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Routing/RouteCollection.php:326)\n#0 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Routing/Router.php(497): Cake\\Routing\\RouteCollection->match(Array, Array)\n#1 /var/www/eramba/app/upgrade/src/View/Helper/LogoHelper.php(45): Cake\\Routing\\Router::url(Array, true)\n#2 /var/www/eramba/app/upgrade/src/View/Helper/LogoHelper.php(21): App\\View\\Helper\\LogoHelper->url(Array)\n#3 /var/www/eramba/app/upgrade/templates/layout/error.php(64): App\\View\\Helper\\LogoHelper->render()\n#4 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/View/View.php(1181): include('/var/www/eramba...')\n#5 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/View/View.php(1138): Cake\\View\\View->_evaluate('/var/www/eramba...', Array)\n#6 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/View/View.php(821): Cake\\View\\View->_render('/var/www/eramba...')\n#7 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/View/View.php(780): Cake\\View\\View->renderLayout('', 'error')\n#8 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Controller/Controller.php(764): Cake\\View\\View->render()\n#9 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/ExceptionRenderer.php(392): Cake\\Controller\\Controller->render('error500')\n#10 /var/www/eramba/app/upgrade/vendor/mixerapi/exception-render/src/MixerApiExceptionRenderer.php(100): Cake\\Error\\ExceptionRenderer->_outputMessage('error500')\n#11 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/ErrorHandler.php(138): MixerApi\\ExceptionRender\\MixerApiExceptionRenderer->render()\n#12 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/BaseErrorHandler.php(218): Cake\\Error\\ErrorHandler->_displayException(Object(Cake\\Error\\FatalErrorException))\n#13 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/BaseErrorHandler.php(257): Cake\\Error\\BaseErrorHandler->handleException(Object(Cake\\Error\\FatalErrorException))\n#14 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/BaseErrorHandler.php(155): Cake\\Error\\BaseErrorHandler->handleFatalError(256, '[Cake\\\\Routing\\\\E...', '/var/www/eramba...', 196)\n#15 [internal function]: Cake\\Error\\BaseErrorHandler->handleError(256, '[Cake\\\\Routing\\\\E...', '/var/www/eramba...', 196)\n#16 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/ErrorHandler.php(196): trigger_error('[Cake\\\\Routing\\\\E...', 256)\n#17 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/ErrorHandler.php(141): Cake\\Error\\ErrorHandler->_logInternalError(Object(Cake\\Routing\\Exception\\MissingRouteException))\n#18 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/BaseErrorHandler.php(218): Cake\\Error\\ErrorHandler->_displayException(Object(Cake\\Routing\\Exception\\MissingRouteException))\n#19 [internal function]: Cake\\Error\\BaseErrorHandler->handleException(Object(Cake\\Database\\Exception\\DatabaseException))\n#20 {main} in /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/ErrorHandler.php on line 196
[Tue Nov 22 19:43:39.095069 2022] [php:error] [pid 29] [client 172.20.20.76:55772] PHP Fatal error:  [Cake\\Routing\\Exception\\MissingRouteException] A route matching "array (\n  'controller' => 'Settings',\n  'action' => 'getLogo',\n  'plugin' => false,\n  'prefix' => false,\n  0 => 'white',\n  '_ext' => NULL,\n)" could not be found. (/var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Routing/RouteCollection.php:326)\n#0 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Routing/Router.php(497): Cake\\Routing\\RouteCollection->match(Array, Array)\n#1 /var/www/eramba/app/upgrade/src/View/Helper/LogoHelper.php(45): Cake\\Routing\\Router::url(Array, true)\n#2 /var/www/eramba/app/upgrade/src/View/Helper/LogoHelper.php(21): App\\View\\Helper\\LogoHelper->url(Array)\n#3 /var/www/eramba/app/upgrade/templates/layout/error.php(64): App\\View\\Helper\\LogoHelper->render()\n#4 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/View/View.php(1181): include('/var/www/eramba...')\n#5 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/View/View.php(1138): Cake\\View\\View->_evaluate('/var/www/eramba...', Array)\n#6 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/View/View.php(821): Cake\\View\\View->_render('/var/www/eramba...')\n#7 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/View/View.php(780): Cake\\View\\View->renderLayout('', 'error')\n#8 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Controller/Controller.php(764): Cake\\View\\View->render()\n#9 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/ExceptionRenderer.php(392): Cake\\Controller\\Controller->render('error500')\n#10 /var/www/eramba/app/upgrade/vendor/mixerapi/exception-render/src/MixerApiExceptionRenderer.php(100): Cake\\Error\\ExceptionRenderer->_outputMessage('error500')\n#11 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/ErrorHandler.php(138): MixerApi\\ExceptionRender\\MixerApiExceptionRenderer->render()\n#12 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/BaseErrorHandler.php(218): Cake\\Error\\ErrorHandler->_displayException(Object(Cake\\Error\\FatalErrorException))\n#13 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/BaseErrorHandler.php(257): Cake\\Error\\BaseErrorHandler->handleException(Object(Cake\\Error\\FatalErrorException))\n#14 /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/BaseErrorHandler.php(119): Cake\\Error\\BaseErrorHandler->handleFatalError(256, '[Cake\\\\Routing\\\\E...', '/var/www/eramba...', 196)\n#15 [internal function]: Cake\\Error\\BaseErrorHandler->Cake\\Error\\{closure}()\n#16 {main} in /var/www/eramba/app/upgrade/vendor/cakephp/cakephp/src/Error/ErrorHandler.php on line 196
172.20.20.76 - - [22/Nov/2022:19:43:38 +0000] "GET / HTTP/1.1" 500 2831 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36"

Any assistance is much appreciated!

Thank you!

sam · November 23, 2022, 7:03am

Can you send all the logs to support@eramba.org so we can review them?
Your server is meeting HW requirements for the docker engine?
I had a similar problem once, the reason was that the eramba container was trying to connect to MySQL container (5 times after that, it stopped trying), but since the Mysql container was not up, I ended with this error.

jack · November 23, 2022, 2:28pm

Hi sam,

Just sent over the full logs. It does appear we are meeting the minimum HW requirements per dockers documentation.

I believe we may have experienced a similar issue. My interpretation of the logs makes it seem as though there was a similar issue connecting to the MySQL container. But when I check my containers, the MySQL one is up and running.

Thanks for your help!

sam · November 24, 2022, 9:37am

Workaround for this should be:
docker compose -f docker-compose.simple-install.yml down
now, when the MySQL container is built, on the second attempt eramba container should be able to connect to it. We need to compose again:
docker compose -f docker-compose.simple-install.yml up -d

I’m also creating an issue, so we handle this error properly during the first run.
Int. ref.: Handle situation when eramba container can not connect to mysql container during compose · Issue #34 · eramba/docker · GitHub

jack · November 28, 2022, 10:06pm

Hi sam,

Apologies for my delayed response as I’ve just returned from Holiday. I’ve run the commands you specified but looking at the logs indicates there is still a problem. I can send over the full logs, however, here is a screenshot of what I am seeing frequently in the logs for the eramba container.

Thanks again for all of your assistance.

sam · November 30, 2022, 9:34am

It looks like you are missing data in the database. I will contact you over support, so we arrange a call and have a look.

jack · November 30, 2022, 3:35pm

Hey sam,

Sounds good. I’ll wait for you to reach out.

Thank you!

kisero · November 30, 2022, 4:19pm

i dont even know why we are helping him : )

jack · November 30, 2022, 4:59pm

: ( If I change my photo to Dwight would you help? lol