nuxsmin / docker-syspass

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

unable to connect to external DB #58

Open Gamechiefx opened 2 years ago

Gamechiefx commented 2 years ago

Hello,

I have a fresh install of 3.2 and MariaDB version 10.3 and during setup the app continues to tell me that it is unable to connect to the DB.

  1. I have rooted into the container executed various ping and tcp connections to verify it can reach the DB
  2. I see the connections being made on my workbench client from the app and its in process of trying to create the DB and build tables
  3. the syspass db user has full DBA rights

I need some help here.

Thanks,

Gamechiefx commented 2 years ago

[Mon Jan 17 04:05:01.573740 2022] [php7:notice] [pid 590] [client 172.26.0.1:59210] [EXCEPTION] [(P) Unable to connect to DB\n#0 /var/www/html/sysPass/lib/SP/Storage/Database/Database.php(175): SP\Storage\Database\Database->prepareQueryData(Object(SP\Storage\Database\QueryData))\n#1 /var/www/html/sysPass/lib/SP/Repositories/Config/ConfigRepository.php(70): SP\Storage\Database\Database->doQuery(Object(SP\Storage\Database\QueryData))\n#2 /var/www/html/sysPass/lib/SP/Services/Config/ConfigService.php(93): SP\Repositories\Config\ConfigRepository->create(Object(SP\DataModel\ConfigData))\n#3 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(314): SP\Services\Config\ConfigService->create(Object(SP\DataModel\ConfigData))\n#4 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(190): SP\Services\Install\Installer->saveMasterPassword()\n#5 /var/www/html/sysPass/lib/SP/Services/Install/Installer.php(99): SP\Services\Install\Installer->install()\n#6 /var/www/html/sysPass/app/modules/web/Controllers/InstallController.php(94): SP\Services\Install\Installer->run(Object(SP\Services\Install\InstallData))\n#7 [internal function]: SP\Modules\Web\Controllers\InstallController->installAction()\n#8 /var/www/html/sysPass/lib/SP/Bootstrap.php(240): call_user_func_array(Array, Array)\n#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)\n#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)\n#11 /var/www/html/sysPass/vendor/klein/klein/src/Klein/Klein.php(588): Klein\Klein->handleRouteCallback(Object(Klein\Route), Object(Klein\DataCollection\RouteCollection), Array)\n#12 /var/www/html/sysPass/lib/SP/Bootstrap.php(464): Klein\Klein->dispatch(Object(Klein\Request))\n#13 /var/www/html/sysPass/lib/Base.php(75): SP\Bootstrap::run(Object(DI\Container))\n#14 /var/www/html/sysPass/index.php(28): require('/var/www/html/s...')\n#15 {main}] N/A, referer:xxxx 172.26.0.1 - - [17/Jan/2022:04:04:52 +0000] "POST /index.php?r=install/install HTTP/1.1" 200 1828 "xxxx" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.71 Safari/537.36"