Connection refused on specific MySQL version

bumbamtrap

The issue

I literally have just installed a clean forum on a subdomain. There were no problems when I was logged in from the admin account. Once I logged out of the account, I found various errors being showed for unlogged users.

I don't think this is a general problem, because it's definitely not the only thing running using php on this server.

However, I can speculate that the issue may have something related to the SSL certificate, perhaps some kind of redirect problem or whatever.

I will be updating the information in this thread.

Flarum encountered a boot error (Doctrine\DBAL\Driver\PDO\Exception)
SQLSTATE[HY000] [2002] Connection refused
thrown in /var/www/hub.gta-ace.ru/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php on line 18

500 Internal Server Error

GET https://hub.gta-ace.ru/api/discussions

PDOException: SQLSTATE[HY000] [2002] Connection refused in /var/www/hub.gta-ace.ru/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40
Stack trace:
#0 /var/www/hub.gta-ace.ru/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(40): PDO->__construct()
#1 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct()
#2 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connectors/Connector.php(100): Illuminate\Database\Connectors\Connector->createPdoConnection()
#3 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connectors/Connector.php(50): Illuminate\Database\Connectors\Connector->tryAgainIfCausedByLostConnection()
#4 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()
#5 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect()
#6 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#7 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(1064): call_user_func()
#8 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(1100): Illuminate\Database\Connection->getPdo()
#9 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(442): Illuminate\Database\Connection->getReadPdo()
#10 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(368): Illuminate\Database\Connection->getPdoForSelect()
#11 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#12 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(784): Illuminate\Database\Connection->runQueryCallback()
#13 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(764): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()
#14 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(675): Illuminate\Database\Connection->handleQueryException()
#15 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#16 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#17 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#18 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#19 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#20 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get()
#21 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#22 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Filter/AbstractFilterer.php(79): Illuminate\Database\Eloquent\Builder->get()
#23 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(102): Flarum\Filter\AbstractFilterer->filter()
#24 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(115): Flarum\Api\Controller\ListDiscussionsController->data()
#25 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#26 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#27 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#28 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#29 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#30 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#31 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#32 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#33 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#34 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#35 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#36 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#37 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#38 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#39 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#40 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#41 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#42 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#43 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#44 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#45 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#46 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#47 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#48 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#49 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#50 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#51 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#52 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#53 /var/www/hub.gta-ace.ru/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#54 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#55 /var/www/hub.gta-ace.ru/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#56 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#57 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#58 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#59 /var/www/hub.gta-ace.ru/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#60 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#61 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#62 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#63 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#64 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#65 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#66 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#67 /var/www/hub.gta-ace.ru/public/index.php(26): Flarum\Http\Server->listen()
#68 {main}

Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000] [2002] Connection refused in /var/www/hub.gta-ace.ru/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:
#0 /var/www/hub.gta-ace.ru/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(44): Doctrine\DBAL\Driver\PDO\Exception::new()
#1 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connectors/Connector.php(67): Doctrine\DBAL\Driver\PDOConnection->__construct()
#2 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connectors/Connector.php(100): Illuminate\Database\Connectors\Connector->createPdoConnection()
#3 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connectors/Connector.php(50): Illuminate\Database\Connectors\Connector->tryAgainIfCausedByLostConnection()
#4 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()
#5 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect()
#6 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}()
#7 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(1064): call_user_func()
#8 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(1100): Illuminate\Database\Connection->getPdo()
#9 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(442): Illuminate\Database\Connection->getReadPdo()
#10 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(368): Illuminate\Database\Connection->getPdoForSelect()
#11 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(705): Illuminate\Database\Connection->Illuminate\Database\{closure}()
#12 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(784): Illuminate\Database\Connection->runQueryCallback()
#13 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(764): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()
#14 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(675): Illuminate\Database\Connection->handleQueryException()
#15 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#16 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#17 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#18 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#19 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#20 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get()
#21 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#22 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Filter/AbstractFilterer.php(79): Illuminate\Database\Eloquent\Builder->get()
#23 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(102): Flarum\Filter\AbstractFilterer->filter()
#24 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(115): Flarum\Api\Controller\ListDiscussionsController->data()
#25 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#26 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#27 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#28 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#29 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#30 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#31 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#32 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#33 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#34 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#35 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#36 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#37 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#38 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#39 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#40 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#41 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#42 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#43 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#44 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#45 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#46 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#47 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#48 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#49 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#50 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#51 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#52 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#53 /var/www/hub.gta-ace.ru/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#54 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#55 /var/www/hub.gta-ace.ru/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#56 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#57 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#58 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#59 /var/www/hub.gta-ace.ru/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#60 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#61 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#62 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#63 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#64 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#65 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#66 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#67 /var/www/hub.gta-ace.ru/public/index.php(26): Flarum\Http\Server->listen()
#68 {main}

Next Illuminate\Database\QueryException: SQLSTATE[HY000] [2002] Connection refused (SQL: select `hub_discussions`.* from `hub_discussions` where (`hub_discussions`.`id` not in (select `discussion_id` from `hub_discussion_tag` where `tag_id` not in (select `hub_tags`.`id` from `hub_tags` where (`hub_tags`.`id` in (select `hub_perm_tags`.`id` from `hub_tags` as `hub_perm_tags` where (`hub_perm_tags`.`is_restricted` = 1 and 0 = 1) or `hub_perm_tags`.`is_restricted` = 0) and (`hub_tags`.`parent_id` in (select `hub_perm_tags`.`id` from `hub_tags` as `hub_perm_tags` where (`hub_perm_tags`.`is_restricted` = 1 and 0 = 1) or `hub_perm_tags`.`is_restricted` = 0) or `hub_tags`.`parent_id` is null))))) and (`hub_discussions`.`is_private` = 0 or (((`hub_discussions`.`is_approved` = 0 and (`hub_discussions`.`user_id` = 0 or ((`hub_discussions`.`id` not in (select `discussion_id` from `hub_discussion_tag` where `tag_id` not in (select `hub_tags`.`id` from `hub_tags` where (`hub_tags`.`id` in (select `hub_perm_tags`.`id` from `hub_tags` as `hub_perm_tags` where (`hub_perm_tags`.`is_restricted` = 1 and 0 = 1)) and (`hub_tags`.`parent_id` in (select `hub_perm_tags`.`id` from `hub_tags` as `hub_perm_tags` where (`hub_perm_tags`.`is_restricted` = 1 and 0 = 1)) or `hub_tags`.`parent_id` is null))))) and exists (select * from `hub_tags` inner join `hub_discussion_tag` on `hub_tags`.`id` = `hub_discussion_tag`.`tag_id` where `hub_discussions`.`id` = `hub_discussion_tag`.`discussion_id`))))))) and (`hub_discussions`.`hidden_at` is null or `hub_discussions`.`user_id` = 0 or ((`hub_discussions`.`id` not in (select `discussion_id` from `hub_discussion_tag` where `tag_id` not in (select `hub_tags`.`id` from `hub_tags` where (`hub_tags`.`id` in (select `hub_perm_tags`.`id` from `hub_tags` as `hub_perm_tags` where (`hub_perm_tags`.`is_restricted` = 1 and 0 = 1)) and (`hub_tags`.`parent_id` in (select `hub_perm_tags`.`id` from `hub_tags` as `hub_perm_tags` where (`hub_perm_tags`.`is_restricted` = 1 and 0 = 1)) or `hub_tags`.`parent_id` is null))))) and exists (select * from `hub_tags` inner join `hub_discussion_tag` on `hub_tags`.`id` = `hub_discussion_tag`.`tag_id` where `hub_discussions`.`id` = `hub_discussion_tag`.`discussion_id`))) and (`hub_discussions`.`comment_count` > 0 or `hub_discussions`.`user_id` = 0 or ((`hub_discussions`.`id` not in (select `discussion_id` from `hub_discussion_tag` where `tag_id` not in (select `hub_tags`.`id` from `hub_tags` where (`hub_tags`.`id` in (select `hub_perm_tags`.`id` from `hub_tags` as `hub_perm_tags` where (`hub_perm_tags`.`is_restricted` = 1 and 0 = 1)) and (`hub_tags`.`parent_id` in (select `hub_perm_tags`.`id` from `hub_tags` as `hub_perm_tags` where (`hub_perm_tags`.`is_restricted` = 1 and 0 = 1)) or `hub_tags`.`parent_id` is null))))) and exists (select * from `hub_tags` inner join `hub_discussion_tag` on `hub_tags`.`id` = `hub_discussion_tag`.`tag_id` where `hub_discussions`.`id` = `hub_discussion_tag`.`discussion_id`))) and (`hub_discussions`.`id` in (select `discussion_id` from `hub_discussion_tag` where `tag_id` = 2)) order by `is_sticky` desc, `last_posted_at` desc limit 21) in /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(784): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(764): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()
#2 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(675): Illuminate\Database\Connection->handleQueryException()
#3 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Connection.php(376): Illuminate\Database\Connection->run()
#4 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Query/Builder.php(2414): Illuminate\Database\Connection->select()
#5 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Query/Builder.php(2402): Illuminate\Database\Query\Builder->runSelect()
#6 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Query/Builder.php(2936): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#7 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Query/Builder.php(2403): Illuminate\Database\Query\Builder->onceWithColumns()
#8 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Eloquent/Builder.php(625): Illuminate\Database\Query\Builder->get()
#9 /var/www/hub.gta-ace.ru/vendor/illuminate/database/Eloquent/Builder.php(609): Illuminate\Database\Eloquent\Builder->getModels()
#10 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Filter/AbstractFilterer.php(79): Illuminate\Database\Eloquent\Builder->get()
#11 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Api/Controller/ListDiscussionsController.php(102): Flarum\Filter\AbstractFilterer->filter()
#12 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Api/Controller/AbstractSerializeController.php(115): Flarum\Api\Controller\ListDiscussionsController->data()
#13 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/RouteHandlerFactory.php(41): Flarum\Api\Controller\AbstractSerializeController->handle()
#14 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/ExecuteRoute.php(27): Flarum\Http\RouteHandlerFactory->Flarum\Http\{closure}()
#15 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ExecuteRoute->process()
#16 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Api/Middleware/ThrottleApi.php(33): Laminas\Stratigility\Next->handle()
#17 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\ThrottleApi->process()
#18 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/CheckCsrfToken.php(36): Laminas\Stratigility\Next->handle()
#19 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\CheckCsrfToken->process()
#20 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/ResolveRoute.php(67): Laminas\Stratigility\Next->handle()
#21 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ResolveRoute->process()
#22 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/SetLocale.php(51): Laminas\Stratigility\Next->handle()
#23 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\SetLocale->process()
#24 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/AuthenticateWithHeader.php(58): Laminas\Stratigility\Next->handle()
#25 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithHeader->process()
#26 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/AuthenticateWithSession.php(31): Laminas\Stratigility\Next->handle()
#27 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\AuthenticateWithSession->process()
#28 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/RememberFromCookie.php(52): Laminas\Stratigility\Next->handle()
#29 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\RememberFromCookie->process()
#30 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/StartSession.php(61): Laminas\Stratigility\Next->handle()
#31 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\StartSession->process()
#32 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Api/Middleware/FakeHttpMethods.php(29): Laminas\Stratigility\Next->handle()
#33 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Api\Middleware\FakeHttpMethods->process()
#34 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/ParseJsonBody.php(28): Laminas\Stratigility\Next->handle()
#35 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ParseJsonBody->process()
#36 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/HandleErrors.php(57): Laminas\Stratigility\Next->handle()
#37 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\HandleErrors->process()
#38 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/InjectActorReference.php(25): Laminas\Stratigility\Next->handle()
#39 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\InjectActorReference->process()
#40 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#41 /var/www/hub.gta-ace.ru/vendor/middlewares/request-handler/src/RequestHandler.php(84): Laminas\Stratigility\MiddlewarePipe->process()
#42 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\RequestHandler->process()
#43 /var/www/hub.gta-ace.ru/vendor/middlewares/base-path-router/src/BasePathRouter.php(101): Laminas\Stratigility\Next->handle()
#44 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePathRouter->process()
#45 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Middleware/OriginalMessages.php(36): Laminas\Stratigility\Next->handle()
#46 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Laminas\Stratigility\Middleware\OriginalMessages->process()
#47 /var/www/hub.gta-ace.ru/vendor/middlewares/base-path/src/BasePath.php(73): Laminas\Stratigility\Next->handle()
#48 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Middlewares\BasePath->process()
#49 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Middleware/ProcessIp.php(24): Laminas\Stratigility\Next->handle()
#50 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/Next.php(49): Flarum\Http\Middleware\ProcessIp->process()
#51 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(75): Laminas\Stratigility\Next->handle()
#52 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-stratigility/src/MiddlewarePipe.php(64): Laminas\Stratigility\MiddlewarePipe->process()
#53 /var/www/hub.gta-ace.ru/vendor/laminas/laminas-httphandlerrunner/src/RequestHandlerRunner.php(96): Laminas\Stratigility\MiddlewarePipe->handle()
#54 /var/www/hub.gta-ace.ru/vendor/flarum/core/src/Http/Server.php(44): Laminas\HttpHandlerRunner\RequestHandlerRunner->run()
#55 /var/www/hub.gta-ace.ru/public/index.php(26): Flarum\Http\Server->listen()
#56 {main}

Flarum information

Flarum core 1.4.1
PHP version: 7.4.3
MySQL version: 8.0.20-0ubuntu0.20.04.1
Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, pcntl, Reflection, SPL, session, standard, sodium, mysqlnd, PDO, xml, bz2, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, iconv, json, exif, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlwriter, xsl, zip, Zend OPcache
+----------------------+---------+--------+
| Flarum Extensions    |         |        |
+----------------------+---------+--------+
| ID                   | Version | Commit |
+----------------------+---------+--------+
| flarum-flags         | v1.4.0  |        |
| flarum-tags          | v1.4.0  |        |
| flarum-suspend       | v1.4.0  |        |
| flarum-subscriptions | v1.4.0  |        |
| flarum-sticky        | v1.4.0  |        |
| flarum-statistics    | v1.4.1  |        |
| flarum-mentions      | v1.4.0  |        |
| flarum-markdown      | v1.4.0  |        |
| flarum-lock          | v1.4.0  |        |
| flarum-likes         | v1.4.0  |        |
| flarum-lang-english  | v1.4.0  |        |
| flarum-emoji         | v1.4.0  |        |
| flarum-bbcode        | v1.4.0  |        |
| flarum-approval      | v1.4.0  |        |
+----------------------+---------+--------+
Base URL: https://hub.gta-ace.ru
Installation path: /var/www/hub.gta-ace.ru
Queue driver: sync
Mail driver: mail
Debug mode: ON

luceos

bumbamtrap MySQL version: 8.0.20-0ubuntu0.20.04.1

Flarum requires MySQL 8.0.23 or higher, there are some issues with older versions in the 8 series.

MySQL 5.6+/8.0.23+ or MariaDB 10.0.5+

luceos

Connection refused implies no connection could be made to the database. Sometimes this happens when using localhost when using a socket and the local IP should be used. Can you show your database settings without showing the actual credentials?

bumbamtrap

luceos Thanks for response. I already tried some tips like changing 'host' from 'localhost' to '127.0.0.1' but unfortunately this makes no sense.

Database settings, you mean in my config.php?

  'database' => 
  array (
    'driver' => 'mysql',
    'host' => '127.0.0.1',
    'port' => 3306,
    'database' => 'ace_hub',
    'username' => '_USERNAME_',
    'password' => '_PASSWORD_',
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix' => 'hub_',
    'strict' => false,
    'engine' => NULL,
    'prefix_indexes' => true,
  ),

bumbamtrap

luceos Thank you so much. I will try to upgrade my mysql server and post the results.

bumbamtrap

Sorry for some delay. I just updated mysql-server (from 8.0.20 to 8.0.30).

The result: problem solved! Thanks for the help!