search

nuxsmin / docker-syspass

Docker stuff for running sysPass on Docker
GNU General Public License v3.0
39 stars 21 forks source link

Error - access denied (docker-swarm) #55

Closed Fernand0S closed 3 years ago

Fernand0S commented 3 years ago

Error syspass running docker-swarm, the execution present message below.

[Warning] Access denied for user 'sp_612186194a48d'@'ip.address' (using password: YES)

If do execution normaly docker-compose is done success!

Syspass don`t it achieves understand about the tree network of swarm ?

Below my .yml

version: '3.7'

networks: net: driver: overlay attachable: true

services: app: image: syspass/syspass:3.2.2 ports:

Fernand0S commented 3 years ago

Realize execution in mariadb-server GRANT ALL PRIVILEGES ON . TO 'root'@'ip.address' IDENTIFIED BY 'syspass';

message below, before execution installation syspass:

Error while setting the database permissions ('SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'root'@'ip.address' to database 'syspass'') Please check the database user permissions

observation: added info in environment db below. 

environment:
  - MYSQL_ROOT_PASSWORD=syspass
  - MYSQL_ROOT_HOST=%
command: --default-authentication-plugin=mysql_native_password
Fernand0S commented 3 years ago

I redid the installation from 0 and got the log below;

[2021-08-25 00:15:40] syspass.EXCEPTION: logger {"message":"Context not initialized

0 /var/www/html/sysPass/lib/SP/Core/Context/ContextBase.php(143): SP\Core\Context\ContextBase->checkContext()

1 /var/www/html/sysPass/lib/SP/Core/Context/SessionContext.php(100): SP\Core\Context\ContextBase->getContextKey(String,Object(SP\Services\User\UserLoginResponse))

2 /var/www/html/sysPass/lib/SP/Core/Context/SessionContext.php(232): SP\Core\Context\SessionContext->getContextKey(String,Object(SP\Services\User\UserLoginResponse))

3 /var/www/html/sysPass/lib/SP/Config/Config.php(200): SP\Core\Context\SessionContext->getUserData()

4 /var/www/html/sysPass/lib/SP/Config/Config.php(121): SP\Config\Config->saveConfig(Object(SP\Config\ConfigData),Boolean)

5 /var/www/html/sysPass/lib/SP/Config/Config.php(95): SP\Config\Config->initialize()

6 /var/www/html/sysPass/lib/Definitions.php(65): SP\Config\Config->__construct(Object(SP\Storage\File\XmlHandler),Object(SP\Storage\File\FileCache),Object(DI\Container))

7 [internal function]: DI\Definition\Source\DefinitionFile->{closure}(Object(DI\Container))

8 /var/www/html/sysPass/vendor/php-di/invoker/src/Invoker.php(74): call_user_func_array(Object(Closure),Array)

9 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Resolver/FactoryResolver.php(80): Invoker\Invoker->call(Object(Closure),Array)

10 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Resolver/ResolverDispatcher.php(64): DI\Definition\Resolver\FactoryResolver->resolve(Object(DI\Definition\FactoryDefinition),Array)

11 /var/www/html/sysPass/vendor/php-di/php-di/src/Container.php(380): DI\Definition\Resolver\ResolverDispatcher->resolve(Object(DI\Definition\FactoryDefinition),Array)

12 /var/www/html/sysPass/vendor/php-di/php-di/src/Container.php(138): DI\Container->resolveDefinition(Object(DI\Definition\FactoryDefinition))

13 /var/www/html/sysPass/lib/SP/Bootstrap.php(126): DI\Container->get(String)

14 /var/www/html/sysPass/lib/SP/Bootstrap.php(457): SP\Bootstrap->__construct(Object(DI\Container))

15 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap->run(Object(DI\Container))

16 /var/www/html/sysPass/index.php(28): require(String)","caller":"N/A"}

[2021-08-25 00:15:40] syspass.INFO: logger {"message":"Config file created","caller":"SP\Config\Config::initialize"} [2021-08-25 00:15:40] syspass.INFO: logger {"message":"Extensions checked","caller":"SP\Core\PhpExtensionChecker::checkMandatory"} [2021-08-25 00:15:40] syspass.ERROR: logger {"message":"Could not set locale","caller":"SP\Core\Language::setLocales"} [2021-08-25 00:15:40] syspass.EXCEPTION: logger {"message":"File not found (/var/www/html/sysPass/app/cache/icons.cache)

0 /var/www/html/sysPass/lib/SP/Storage/File/FileCacheBase.php(70): SP\Storage\File\FileHandler->checkFileExists()

1 /var/www/html/sysPass/lib/SP/Core/UI/Theme.php(159): SP\Storage\File\FileCacheBase->isExpired(Integer)

2 /var/www/html/sysPass/lib/SP/Core/UI/Theme.php(127): SP\Core\UI\Theme->initIcons()

3 /var/www/html/sysPass/app/modules/web/Init.php(173): SP\Core\UI\Theme->initTheme(Boolean)

4 /var/www/html/sysPass/lib/SP/Bootstrap.php(232): SP\Modules\Web\Init->initialize(String)

5 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

6 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure),Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

7 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route),Object(Klein\DataCollection\RouteCollection),Array)

8 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

9 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap->run(Object(DI\Container))

10 /var/www/html/sysPass/index.php(28): require(String)","caller":"N/A"}

[2021-08-25 00:15:40] syspass.INFO: logger {"message":"Saved icons cache","caller":"SP\Core\UI\Theme::saveIcons"} [2021-08-25 00:15:40] syspass.EXCEPTION: logger {"message":"File not found (/var/www/html/sysPass/app/cache/actions.cache)

0 /var/www/html/sysPass/lib/SP/Storage/File/FileCacheBase.php(70): SP\Storage\File\FileHandler->checkFileExists()

1 /var/www/html/sysPass/lib/SP/Core/Acl/Actions.php(90): SP\Storage\File\FileCacheBase->isExpired(Integer)

2 /var/www/html/sysPass/lib/SP/Core/Acl/Actions.php(78): SP\Core\Acl\Actions->loadCache()

3 /var/www/html/sysPass/lib/Definitions.php(77): SP\Core\Acl\Actions->__construct(Object(SP\Storage\File\FileCache),Object(SP\Storage\File\XmlHandler))

4 [internal function]: DI\Definition\Source\DefinitionFile->{closure}(Object(DI\Container))

5 /var/www/html/sysPass/vendor/php-di/invoker/src/Invoker.php(74): call_user_func_array(Object(Closure),Array)

6 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Resolver/FactoryResolver.php(80): Invoker\Invoker->call(Object(Closure),Array)

7 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Resolver/ResolverDispatcher.php(64): DI\Definition\Resolver\FactoryResolver->resolve(Object(DI\Definition\FactoryDefinition),Array)

8 /var/www/html/sysPass/vendor/php-di/php-di/src/Container.php(380): DI\Definition\Resolver\ResolverDispatcher->resolve(Object(DI\Definition\FactoryDefinition),Array)

9 /var/www/html/sysPass/vendor/php-di/php-di/src/Container.php(138): DI\Container->resolveDefinition(Object(DI\Definition\FactoryDefinition))

10 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Reference.php(53): DI\Container->get(String)

11 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Resolver/ResolverDispatcher.php(59): DI\Definition\Reference->resolve(Object(DI\Container))

12 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Resolver/ParameterResolver.php(78): DI\Definition\Resolver\ResolverDispatcher->resolve(Object(DI\Definition\Reference))

13 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Resolver/ObjectCreator.php(137): DI\Definition\Resolver\ParameterResolver->resolveParameters(Object(DI\Definition\ObjectDefinition\MethodInjection),Object(ReflectionMethod),Array)

14 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Resolver/ObjectCreator.php(71): DI\Definition\Resolver\ObjectCreator->createInstance(Object(DI\Definition\AutowireDefinition),Array)

15 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Resolver/ResolverDispatcher.php(64): DI\Definition\Resolver\ObjectCreator->resolve(Object(DI\Definition\AutowireDefinition),Array)

16 /var/www/html/sysPass/vendor/php-di/php-di/src/Container.php(380): DI\Definition\Resolver\ResolverDispatcher->resolve(Object(DI\Definition\AutowireDefinition),Array)

17 /var/www/html/sysPass/vendor/php-di/php-di/src/Container.php(138): DI\Container->resolveDefinition(Object(DI\Definition\AutowireDefinition))

18 /var/www/html/sysPass/app/modules/web/Controllers/Traits/WebControllerTrait.php(140): DI\Container->get(String)

19 /var/www/html/sysPass/app/modules/web/Controllers/ControllerBase.php(104): SP\Modules\Web\Controllers\ControllerBase->setUp(Object(DI\Container))

20 /var/www/html/sysPass/lib/SP/Bootstrap.php(238): SP\Modules\Web\Controllers\ControllerBase->__construct(Object(DI\Container),String)

21 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

22 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure),Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

23 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route),Object(Klein\DataCollection\RouteCollection),Array)

24 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

25 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap->run(Object(DI\Container))

26 /var/www/html/sysPass/index.php(28): require(String)","caller":"N/A"}

[2021-08-25 00:15:40] syspass.INFO: logger {"message":"ACTION CACHE MISS","caller":"SP\Core\Acl\Actions::mapAndSave"} [2021-08-25 00:15:40] syspass.INFO: logger {"message":"Saved actions cache","caller":"SP\Core\Acl\Actions::saveCache"} [2021-08-25 00:15:40] syspass.EXCEPTION: logger {"message":"File not found (/var/www/html/sysPass/app/config/pubkey.pem)

0 /var/www/html/sysPass/lib/SP/Core/Crypt/CryptPKI.php(82): SP\Storage\File\FileHandler->checkFileExists()

1 /var/www/html/sysPass/lib/SP/Core/Crypt/CryptPKI.php(67): SP\Core\Crypt\CryptPKI->setUp()

2 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Resolver/ObjectCreator.php(142): SP\Core\Crypt\CryptPKI->__construct(Object(phpseclib\Crypt\RSA))

3 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Resolver/ObjectCreator.php(71): DI\Definition\Resolver\ObjectCreator->createInstance(Object(DI\Definition\ObjectDefinition),Array)

4 /var/www/html/sysPass/vendor/php-di/php-di/src/Definition/Resolver/ResolverDispatcher.php(64): DI\Definition\Resolver\ObjectCreator->resolve(Object(DI\Definition\ObjectDefinition),Array)

5 /var/www/html/sysPass/vendor/php-di/php-di/src/Container.php(380): DI\Definition\Resolver\ResolverDispatcher->resolve(Object(DI\Definition\ObjectDefinition),Array)

6 /var/www/html/sysPass/vendor/php-di/php-di/src/Container.php(138): DI\Container->resolveDefinition(Object(DI\Definition\ObjectDefinition))

7 /var/www/html/sysPass/app/modules/web/Controllers/Helpers/LayoutHelper.php(125): DI\Container->get(String)

8 /var/www/html/sysPass/app/modules/web/Controllers/Helpers/LayoutHelper.php(378): SP\Modules\Web\Controllers\Helpers\LayoutHelper->initBody()

9 /var/www/html/sysPass/app/modules/web/Controllers/InstallController.php(59): SP\Modules\Web\Controllers\Helpers\LayoutHelper->getPublicLayout(String,String)

10 [internal function]: SP\Modules\Web\Controllers\InstallController->indexAction()

11 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array,Array)

12 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

13 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure),Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

14 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route),Object(Klein\DataCollection\RouteCollection),Array)

15 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

16 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap->run(Object(DI\Container))

17 /var/www/html/sysPass/index.php(28): require(String)","caller":"N/A"}

[2021-08-25 00:15:40] syspass.INFO: logger {"message":"Extensions checked","caller":"SP\Core\PhpExtensionChecker::checkMandatory"} [2021-08-25 00:15:40] syspass.ERROR: logger {"message":"Could not set locale","caller":"SP\Core\Language::setLocales"} [2021-08-25 00:15:40] syspass.INFO: logger {"message":"Loaded icons cache","caller":"SP\Core\UI\Theme::initIcons"} [2021-08-25 00:15:40] syspass.INFO: logger {"message":"Loaded actions cache","caller":"SP\Core\Acl\Actions::loadCache"} [2021-08-25 00:15:40] syspass.INFO: logger {"message":"Extensions checked","caller":"SP\Core\PhpExtensionChecker::checkMandatory"} [2021-08-25 00:15:40] syspass.ERROR: logger {"message":"Could not set locale","caller":"SP\Core\Language::setLocales"} [2021-08-25 00:15:40] syspass.INFO: logger {"message":"Loaded icons cache","caller":"SP\Core\UI\Theme::initIcons"} [2021-08-25 00:15:40] syspass.INFO: logger {"message":"Loaded actions cache","caller":"SP\Core\Acl\Actions::loadCache"} [2021-08-25 00:15:41] syspass.INFO: logger {"message":"Extensions checked","caller":"SP\Core\PhpExtensionChecker::checkMandatory"} [2021-08-25 00:15:41] syspass.INFO: logger {"message":"Extensions checked","caller":"SP\Core\PhpExtensionChecker::checkMandatory"} [2021-08-25 00:15:41] syspass.ERROR: logger {"message":"Could not set locale","caller":"SP\Core\Language::setLocales"} [2021-08-25 00:15:41] syspass.INFO: logger {"message":"Loaded icons cache","caller":"SP\Core\UI\Theme::initIcons"} [2021-08-25 00:15:41] syspass.INFO: logger {"message":"Loaded actions cache","caller":"SP\Core\Acl\Actions::loadCache"} [2021-08-25 00:15:41] syspass.INFO: logger {"message":"Extensions checked","caller":"SP\Core\PhpExtensionChecker::checkMandatory"} [2021-08-25 00:15:41] syspass.ERROR: logger {"message":"Could not set locale","caller":"SP\Core\Language::setLocales"} [2021-08-25 00:15:41] syspass.INFO: logger {"message":"Loaded icons cache","caller":"SP\Core\UI\Theme::initIcons"} [2021-08-25 00:15:41] syspass.INFO: logger {"message":"Loaded actions cache","caller":"SP\Core\Acl\Actions::loadCache"} [2021-08-25 00:15:41] syspass.ERROR: logger {"message":"Could not set locale","caller":"SP\Core\Language::setLocales"} [2021-08-25 00:15:41] syspass.INFO: logger {"message":"Loaded icons cache","caller":"SP\Core\UI\Theme::initIcons"} [2021-08-25 00:15:41] syspass.INFO: logger {"message":"Loaded actions cache","caller":"SP\Core\Acl\Actions::loadCache"} [2021-08-25 00:15:41] syspass.INFO: logger {"message":"Extensions checked","caller":"SP\Core\PhpExtensionChecker::checkMandatory"} [2021-08-25 00:15:41] syspass.ERROR: logger {"message":"Could not set locale","caller":"SP\Core\Language::setLocales"} [2021-08-25 00:15:41] syspass.INFO: logger {"message":"Loaded icons cache","caller":"SP\Core\UI\Theme::initIcons"} [2021-08-25 00:15:41] syspass.INFO: logger {"message":"Loaded actions cache","caller":"SP\Core\Acl\Actions::loadCache"} [2021-08-25 00:15:41] syspass.EXCEPTION: logger {"message":"Unable to connect to DB

0 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(216): SP\Storage\Database\MySQLHandler->getConnection()

1 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(175): SP\Storage\Database\Database->prepareQueryData(Object(SP\Storage\Database\QueryData))

2 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(136): SP\Storage\Database\Database->doQuery(Object(SP\Storage\Database\QueryData))

3 /var/www/html/sysPass/lib/SP/Repositories/Plugin/PluginRepository.php(451): SP\Storage\Database\Database->doSelect(Object(SP\Storage\Database\QueryData))

4 /var/www/html/sysPass/lib/SP/Services/Plugin/PluginService.php(292): SP\Repositories\Plugin\PluginRepository->getEnabled()

5 /var/www/html/sysPass/lib/SP/Plugin/PluginManager.php(462): SP\Services\Plugin\PluginService->getEnabled()

6 /var/www/html/sysPass/app/modules/web/Controllers/BootstrapController.php(117): SP\Plugin\PluginManager->getEnabledPlugins()

7 /var/www/html/sysPass/app/modules/web/Controllers/BootstrapController.php(70): SP\Modules\Web\Controllers\BootstrapController->getPlugins()

8 [internal function]: SP\Modules\Web\Controllers\BootstrapController->getEnvironmentAction()

9 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array,Array)

10 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

11 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure),Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

12 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route),Object(Klein\DataCollection\RouteCollection),Array)

13 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

14 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap->run(Object(DI\Container))

15 /var/www/html/sysPass/index.php(28): require(String)","caller":"N/A"}

[2021-08-25 00:15:41] syspass.EXCEPTION: logger {"message":"Unable to connect to DB

0 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(175): SP\Storage\Database\Database->prepareQueryData(Object(SP\Storage\Database\QueryData))

1 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(136): SP\Storage\Database\Database->doQuery(Object(SP\Storage\Database\QueryData))

2 /var/www/html/sysPass/lib/SP/Repositories/Plugin/PluginRepository.php(451): SP\Storage\Database\Database->doSelect(Object(SP\Storage\Database\QueryData))

3 /var/www/html/sysPass/lib/SP/Services/Plugin/PluginService.php(292): SP\Repositories\Plugin\PluginRepository->getEnabled()

4 /var/www/html/sysPass/lib/SP/Plugin/PluginManager.php(462): SP\Services\Plugin\PluginService->getEnabled()

5 /var/www/html/sysPass/app/modules/web/Controllers/BootstrapController.php(117): SP\Plugin\PluginManager->getEnabledPlugins()

6 /var/www/html/sysPass/app/modules/web/Controllers/BootstrapController.php(70): SP\Modules\Web\Controllers\BootstrapController->getPlugins()

7 [internal function]: SP\Modules\Web\Controllers\BootstrapController->getEnvironmentAction()

8 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array,Array)

9 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

10 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure),Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

11 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route),Object(Klein\DataCollection\RouteCollection),Array)

12 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

13 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap->run(Object(DI\Container))

14 /var/www/html/sysPass/index.php(28): require(String)","caller":"N/A"}

[2021-08-25 00:15:41] syspass.EXCEPTION: logger {"message":"(P) Unable to connect to DB

0 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(216): SP\Storage\Database\MySQLHandler->getConnection()

1 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(175): SP\Storage\Database\Database->prepareQueryData(Object(SP\Storage\Database\QueryData))

2 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(136): SP\Storage\Database\Database->doQuery(Object(SP\Storage\Database\QueryData))

3 /var/www/html/sysPass/lib/SP/Repositories/Plugin/PluginRepository.php(451): SP\Storage\Database\Database->doSelect(Object(SP\Storage\Database\QueryData))

4 /var/www/html/sysPass/lib/SP/Services/Plugin/PluginService.php(292): SP\Repositories\Plugin\PluginRepository->getEnabled()

5 /var/www/html/sysPass/lib/SP/Plugin/PluginManager.php(462): SP\Services\Plugin\PluginService->getEnabled()

6 /var/www/html/sysPass/app/modules/web/Controllers/BootstrapController.php(117): SP\Plugin\PluginManager->getEnabledPlugins()

7 /var/www/html/sysPass/app/modules/web/Controllers/BootstrapController.php(70): SP\Modules\Web\Controllers\BootstrapController->getPlugins()

8 [internal function]: SP\Modules\Web\Controllers\BootstrapController->getEnvironmentAction()

9 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array, Array)

10 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request), Object(Klein\Response), Object(Klein\ServiceProvider), Object(Klein\App), Object(Klein\Klein), Object(Klein\DataCollection\RouteCollection), Array)

11 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure), Object(Klein\Request), Object(Klein\Response), Object(Klein\ServiceProvider), Object(Klein\App), Object(Klein\Klein), Object(Klein\DataCollection\RouteCollection), Array)

12 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route), Object(Klein\DataCollection\RouteCollection), Array)

13 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

14 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap::run(Object(DI\Container))

15 /var/www/html/sysPass/index.php(28): require('/var/www/html/s...')

16 {main}","caller":"N/A"}

[2021-08-25 00:15:41] syspass.EXCEPTION: logger {"message":"Unable to connect to DB

0 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(175): SP\Storage\Database\Database->prepareQueryData(Object(SP\Storage\Database\QueryData))

1 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(136): SP\Storage\Database\Database->doQuery(Object(SP\Storage\Database\QueryData))

2 /var/www/html/sysPass/lib/SP/Repositories/Plugin/PluginRepository.php(451): SP\Storage\Database\Database->doSelect(Object(SP\Storage\Database\QueryData))

3 /var/www/html/sysPass/lib/SP/Services/Plugin/PluginService.php(292): SP\Repositories\Plugin\PluginRepository->getEnabled()

4 /var/www/html/sysPass/lib/SP/Plugin/PluginManager.php(462): SP\Services\Plugin\PluginService->getEnabled()

5 /var/www/html/sysPass/app/modules/web/Controllers/BootstrapController.php(117): SP\Plugin\PluginManager->getEnabledPlugins()

6 /var/www/html/sysPass/app/modules/web/Controllers/BootstrapController.php(70): SP\Modules\Web\Controllers\BootstrapController->getPlugins()

7 [internal function]: SP\Modules\Web\Controllers\BootstrapController->getEnvironmentAction()

8 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array,Array)

9 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

10 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure),Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

11 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route),Object(Klein\DataCollection\RouteCollection),Array)

12 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

13 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap->run(Object(DI\Container))

14 /var/www/html/sysPass/index.php(28): require(String)","caller":"N/A"}

[2021-08-25 00:15:41] syspass.EXCEPTION: logger {"message":"(P) Unable to connect to DB

0 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(216): SP\Storage\Database\MySQLHandler->getConnection()

1 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(175): SP\Storage\Database\Database->prepareQueryData(Object(SP\Storage\Database\QueryData))

2 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(136): SP\Storage\Database\Database->doQuery(Object(SP\Storage\Database\QueryData))

3 /var/www/html/sysPass/lib/SP/Repositories/Plugin/PluginRepository.php(451): SP\Storage\Database\Database->doSelect(Object(SP\Storage\Database\QueryData))

4 /var/www/html/sysPass/lib/SP/Services/Plugin/PluginService.php(292): SP\Repositories\Plugin\PluginRepository->getEnabled()

5 /var/www/html/sysPass/lib/SP/Plugin/PluginManager.php(462): SP\Services\Plugin\PluginService->getEnabled()

6 /var/www/html/sysPass/app/modules/web/Controllers/BootstrapController.php(117): SP\Plugin\PluginManager->getEnabledPlugins()

7 /var/www/html/sysPass/app/modules/web/Controllers/BootstrapController.php(70): SP\Modules\Web\Controllers\BootstrapController->getPlugins()

8 [internal function]: SP\Modules\Web\Controllers\BootstrapController->getEnvironmentAction()

9 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array, Array)

10 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request), Object(Klein\Response), Object(Klein\ServiceProvider), Object(Klein\App), Object(Klein\Klein), Object(Klein\DataCollection\RouteCollection), Array)

11 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure), Object(Klein\Request), Object(Klein\Response), Object(Klein\ServiceProvider), Object(Klein\App), Object(Klein\Klein), Object(Klein\DataCollection\RouteCollection), Array)

12 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route), Object(Klein\DataCollection\RouteCollection), Array)

13 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

14 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap::run(Object(DI\Container))

15 /var/www/html/sysPass/index.php(28): require('/var/www/html/s...')

16 {main}","caller":"N/A"}

[2021-08-25 00:16:08] syspass.INFO: logger {"message":"Extensions checked","caller":"SP\Core\PhpExtensionChecker::checkMandatory"} [2021-08-25 00:16:08] syspass.ERROR: logger {"message":"Could not set locale","caller":"SP\Core\Language::setLocales"} [2021-08-25 00:16:08] syspass.INFO: logger {"message":"Loaded icons cache","caller":"SP\Core\UI\Theme::initIcons"} [2021-08-25 00:16:08] syspass.INFO: logger {"message":"Loaded actions cache","caller":"SP\Core\Acl\Actions::loadCache"} [2021-08-25 00:16:08] syspass.EXCEPTION: logger {"message":"Unable to connect to DB

0 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(216): SP\Storage\Database\MySQLHandler->getConnection()

1 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(175): SP\Storage\Database\Database->prepareQueryData(Object(SP\Storage\Database\QueryData))

2 /var/www/html/sysPass/lib/SP/Repositories/Config/ConfigRepository.php(70): SP\Storage\Database\Database->doQuery(Object(SP\Storage\Database\QueryData))

3 /var/www/html/sysPass/lib/SP/Services/Config/ConfigService.php(93): SP\Repositories\Config\ConfigRepository->create(Object(SP\DataModel\ConfigData))

4 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(314): SP\Services\Config\ConfigService->create(Object(SP\DataModel\ConfigData))

5 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(190): SP\Services\Install\Installer->saveMasterPassword()

6 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(99): SP\Services\Install\Installer->install()

7 /var/www/html/sysPass/app/modules/web/Controllers/InstallController.php(94): SP\Services\Install\Installer->run(Object(SP\Services\Install\InstallData))

8 [internal function]: SP\Modules\Web\Controllers\InstallController->installAction()

9 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array,Array)

10 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

11 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure),Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

12 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route),Object(Klein\DataCollection\RouteCollection),Array)

13 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

14 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap->run(Object(DI\Container))

15 /var/www/html/sysPass/index.php(28): require(String)","caller":"N/A"}

[2021-08-25 00:16:08] syspass.EXCEPTION: logger {"message":"(P) SQLSTATE[HY000] [1045] Access denied for user 'sp_61258bc8716fa'@'10.0.110.142' (using password: YES)

0 /var/www/html/sysPass/lib/SP/Storage/Database/MySQLHandler.php(109): PDO->__construct('mysql:charset=u...', 'sp_61258bc8716f...', '%ZzBYbYiA3};HF9...', Array)

1 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(216): SP\Storage\Database\MySQLHandler->getConnection()

2 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(175): SP\Storage\Database\Database->prepareQueryData(Object(SP\Storage\Database\QueryData))

3 /var/www/html/sysPass/lib/SP/Repositories/Config/ConfigRepository.php(70): SP\Storage\Database\Database->doQuery(Object(SP\Storage\Database\QueryData))

4 /var/www/html/sysPass/lib/SP/Services/Config/ConfigService.php(93): SP\Repositories\Config\ConfigRepository->create(Object(SP\DataModel\ConfigData))

5 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(314): SP\Services\Config\ConfigService->create(Object(SP\DataModel\ConfigData))

6 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(190): SP\Services\Install\Installer->saveMasterPassword()

7 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(99): SP\Services\Install\Installer->install()

8 /var/www/html/sysPass/app/modules/web/Controllers/InstallController.php(94): SP\Services\Install\Installer->run(Object(SP\Services\Install\InstallData))

9 [internal function]: SP\Modules\Web\Controllers\InstallController->installAction()

10 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array, Array)

11 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request), Object(Klein\Response), Object(Klein\ServiceProvider), Object(Klein\App), Object(Klein\Klein), Object(Klein\DataCollection\RouteCollection), Array)

12 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure), Object(Klein\Request), Object(Klein\Response), Object(Klein\ServiceProvider), Object(Klein\App), Object(Klein\Klein), Object(Klein\DataCollection\RouteCollection), Array)

13 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route), Object(Klein\DataCollection\RouteCollection), Array)

14 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

15 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap::run(Object(DI\Container))

16 /var/www/html/sysPass/index.php(28): require('/var/www/html/s...')

17 {main}","caller":"N/A"}

[2021-08-25 00:16:08] syspass.EXCEPTION: logger {"message":"Unable to connect to DB

0 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(175): SP\Storage\Database\Database->prepareQueryData(Object(SP\Storage\Database\QueryData))

1 /var/www/html/sysPass/lib/SP/Repositories/Config/ConfigRepository.php(70): SP\Storage\Database\Database->doQuery(Object(SP\Storage\Database\QueryData))

2 /var/www/html/sysPass/lib/SP/Services/Config/ConfigService.php(93): SP\Repositories\Config\ConfigRepository->create(Object(SP\DataModel\ConfigData))

3 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(314): SP\Services\Config\ConfigService->create(Object(SP\DataModel\ConfigData))

4 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(190): SP\Services\Install\Installer->saveMasterPassword()

5 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(99): SP\Services\Install\Installer->install()

6 /var/www/html/sysPass/app/modules/web/Controllers/InstallController.php(94): SP\Services\Install\Installer->run(Object(SP\Services\Install\InstallData))

7 [internal function]: SP\Modules\Web\Controllers\InstallController->installAction()

8 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array,Array)

9 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

10 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure),Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

11 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route),Object(Klein\DataCollection\RouteCollection),Array)

12 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

13 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap->run(Object(DI\Container))

14 /var/www/html/sysPass/index.php(28): require(String)","caller":"N/A"}

[2021-08-25 00:16:08] syspass.EXCEPTION: logger {"message":"(P) Unable to connect to DB

0 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(216): SP\Storage\Database\MySQLHandler->getConnection()

1 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(175): SP\Storage\Database\Database->prepareQueryData(Object(SP\Storage\Database\QueryData))

2 /var/www/html/sysPass/lib/SP/Repositories/Config/ConfigRepository.php(70): SP\Storage\Database\Database->doQuery(Object(SP\Storage\Database\QueryData))

3 /var/www/html/sysPass/lib/SP/Services/Config/ConfigService.php(93): SP\Repositories\Config\ConfigRepository->create(Object(SP\DataModel\ConfigData))

4 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(314): SP\Services\Config\ConfigService->create(Object(SP\DataModel\ConfigData))

5 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(190): SP\Services\Install\Installer->saveMasterPassword()

6 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(99): SP\Services\Install\Installer->install()

7 /var/www/html/sysPass/app/modules/web/Controllers/InstallController.php(94): SP\Services\Install\Installer->run(Object(SP\Services\Install\InstallData))

8 [internal function]: SP\Modules\Web\Controllers\InstallController->installAction()

9 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array, Array)

10 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request), Object(Klein\Response), Object(Klein\ServiceProvider), Object(Klein\App), Object(Klein\Klein), Object(Klein\DataCollection\RouteCollection), Array)

11 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure), Object(Klein\Request), Object(Klein\Response), Object(Klein\ServiceProvider), Object(Klein\App), Object(Klein\Klein), Object(Klein\DataCollection\RouteCollection), Array)

12 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route), Object(Klein\DataCollection\RouteCollection), Array)

13 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

14 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap::run(Object(DI\Container))

15 /var/www/html/sysPass/index.php(28): require('/var/www/html/s...')

16 {main}","caller":"N/A"}

[2021-08-25 00:16:08] syspass.EXCEPTION: logger {"message":"Unable to connect to DB

0 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(190): SP\Services\Install\Installer->saveMasterPassword()

1 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(99): SP\Services\Install\Installer->install()

2 /var/www/html/sysPass/app/modules/web/Controllers/InstallController.php(94): SP\Services\Install\Installer->run(Object(SP\Services\Install\InstallData))

3 [internal function]: SP\Modules\Web\Controllers\InstallController->installAction()

4 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array,Array)

5 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

6 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure),Object(Klein\Request),Object(Klein\Response),Object(Klein\ServiceProvider),Object(Klein\App),Object(Klein\Klein),Object(Klein\DataCollection\RouteCollection),Array)

7 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route),Object(Klein\DataCollection\RouteCollection),Array)

8 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

9 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap->run(Object(DI\Container))

10 /var/www/html/sysPass/index.php(28): require(String)","caller":"N/A"}

[2021-08-25 00:16:08] syspass.EXCEPTION: logger {"message":"(P) Unable to connect to DB

0 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(175): SP\Storage\Database\Database->prepareQueryData(Object(SP\Storage\Database\QueryData))

1 /var/www/html/sysPass/lib/SP/Repositories/Config/ConfigRepository.php(70): SP\Storage\Database\Database->doQuery(Object(SP\Storage\Database\QueryData))

2 /var/www/html/sysPass/lib/SP/Services/Config/ConfigService.php(93): SP\Repositories\Config\ConfigRepository->create(Object(SP\DataModel\ConfigData))

3 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(314): SP\Services\Config\ConfigService->create(Object(SP\DataModel\ConfigData))

4 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(190): SP\Services\Install\Installer->saveMasterPassword()

5 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(99): SP\Services\Install\Installer->install()

6 /var/www/html/sysPass/app/modules/web/Controllers/InstallController.php(94): SP\Services\Install\Installer->run(Object(SP\Services\Install\InstallData))

7 [internal function]: SP\Modules\Web\Controllers\InstallController->installAction()

8 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array, Array)

9 [internal function]: SP\Bootstrap->SP{closure}(Object(Klein\Request), Object(Klein\Response), Object(Klein\ServiceProvider), Object(Klein\App), Object(Klein\Klein), Object(Klein\DataCollection\RouteCollection), Array)

10 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(879): call_user_func(Object(Closure), Object(Klein\Request), Object(Klein\Response), Object(Klein\ServiceProvider), Object(Klein\App), Object(Klein\Klein), Object(Klein\DataCollection\RouteCollection), Array)

11 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route), Object(Klein\DataCollection\RouteCollection), Array)

12 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))

13 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap::run(Object(DI\Container))

14 /var/www/html/sysPass/index.php(28): require('/var/www/html/s...')

15 {main}","caller":"N/A"}

root@f7d406d6a55a:/var/www/html/sysPass/app/config#

Fernand0S commented 3 years ago

solved problem, open /var/www/html/sysPass/lib/SP/Services/Install/Installer.php modified word false for true and ip address for % close document, realize installation success in docker swarm.

if (strpos('%', $this->installData->getDbHost()) === true && strpos('%', $this->installData->getDbHost()) === true ) { if (APP_MODULE === 'tests') { $address = SELF_IP_ADDRESS; } else { $address = $this->request->getServer('SERVER_ADDR'); }

        $this->installData->setDbAuthHost($address);
        $this->installData->setDbAuthHostDns(gethostbyaddr($address));
    } else {
        $this->installData->setDbAuthHost('%');
    }
}