Technazz
-
Posts
7 -
Joined
-
Last visited
Content Type
Profiles
Forums
Downloads
Store
Gallery
Bug Reports
Documentation
Landing
Posts posted by Technazz
-
-
Ok . If try it from the Invoice Ninja Console i get
# mysql -u ninja -p tzz9090;
sh: 2: mysql: not foundUnraid/Linux noob here. How do i let the Invoice ninja container access the MariaDB container path for the mysql cmd?
Chris
-
42 minutes ago, fmp4m said:
Hi Chris,
Can you access the database with them?
Yes. The only way i know how to test is to use the console for the MariaDB docker. How do i test from the Invoice Ninja Docker?
msql -u ninja -ptzz9090 works
Chris
-
14 hours ago, fmp4m said:
I briefly looked at this, and it seems that the docker is wanting to run as the user that is authorized in the sql database. The user is ninja. however it seems the permissions on the sql version are not correctly setup. It would take someone with docker and sql expierence to go further than this, but my debugging is showing ninja does not have the permission to access the DB.
The RUN command shows: 'DB_DATABASE'='ninjadb' -e 'DB_USERNAME'='ninja' -e 'DB_PASSWORD'='tzz9090'
Yes those are my credentials, I can log into the MariaDB docker terminal with them.
Chris
-
Fair enough! Any Takers?
I think I may just set up on a Ubuntu KVM for now.
Chris -
13 hours ago, Squid said:
Not that I'm the one to help, unless the problem is obvious, but at the very least, you're going to have to post the docker run command, and a screen shot of whatever the error is...
Here is the Run command
root@localhost:# /usr/local/emhttp/plugins/dynamix.docker.manager/scripts/docker run -d --name='invoiceninja' --net='bridge' --log-opt max-size='50m' --log-opt max-file='1' --privileged=true -e TZ="America/New_York" -e HOST_OS="Unraid" -e 'APP_ENV'='production' -e 'APP_DEBUG'='true' -e 'DB_TYPE'='mysql' -e 'DB_STRICT'='false' -e 'DB_HOST'='192.168.0.151:3306' -e 'DB_DATABASE'='ninjadb' -e 'DB_USERNAME'='ninja' -e 'DB_PASSWORD'='tzz9090' -e 'APP_URL'='http://192.168.0.151:8001' -e 'APP_KEY'='r+BvncSxAf+fQXYUxSW6wXbSvsOL+Ns5' -e 'MAIL_DRIVER'='smtp' -e 'MAIL_PORT'='587' -e 'MAIL_ENCRYPTION'='tls' -e 'MAIL_HOST'='smtp.example.com' -e 'MAIL_USERNAME'='[email protected]' -e 'MAIL_FROM_ADDRESS'='[email protected]' -e 'MAIL_FROM_NAME'='Invoice' -e 'MAIL_PASSWORD'='technazz9090' -p '8001:8000/tcp' -p '8443:8443/tcp' -p '8000:80/tcp' -p '9443:443/tcp' -v '/mnt/user/appdata/invoiceninja':'/var/www/app/storage':'rw' -v '/mnt/user/appdata/invoiceninja':'/var/www/app/public/logo':'rw' 'anojht/invoiceninja' a133721988b49a8907f95e04459ce368324f9a60d56326f1e9c09a659bea9e28 The command finished successfully!
The log from Invoice Ninja
clone public directory start /bin/sh: 0: Can't open Starting [17-Oct-2019 11:13:59] NOTICE: fpm is running, pid 1 [17-Oct-2019 11:13:59] NOTICE: ready to handle connections Thu, 17 Oct 2019 15:19:00 +0000 Running SendRecurringInvoices... [2019-10-17 15:19:00] production.ERROR: ***Doctrine\DBAL\Driver\PDOException*** [1045] : /var/www/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php [Line 47] => SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using password: YES) {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"GET","user_agent":"","locale":"en","ip":"127.0.0.1","count":1,"is_console":"yes","is_api":"no","db_server":"mysql","url":"/"} [] [2019-10-17 15:19:00] production.ERROR: [stacktrace] 2019-10-17 03:19:00 SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using password: YES): #0 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(65): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=192....', 'ninja', 'tzz9090', Array) #1 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(44): Illuminate\Database\Connectors\Connector->createPdoConnection('mysql:host=192....', 'ninja', 'tzz9090', Array) #2 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection('mysql:host=192....', Array, Array) #3 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(183): Illuminate\Database\Connectors\MySqlConnector->connect(Array) #4 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}() #5 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(883): call_user_func(Object(Closure)) #6 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(904): Illuminate\Database\Connection->getPdo() #7 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(392): Illuminate\Database\Connection->getReadPdo() #8 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(318): Illuminate\Database\Connection->getPdoForSelect(true) #9 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select * from `...', Array) #10 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure)) #11 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #12 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1705): Illuminate\Database\Connection->select('select * from `...', Array, true) #13 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1690): Illuminate\Database\Query\Builder->runSelect() #14 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(462): Illuminate\Database\Query\Builder->get(Array) #15 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(446): Illuminate\Database\Eloquent\Builder->getModels(Array) #16 /var/www/app/app/Console/Commands/SendRecurringInvoices.php(70): Illuminate\Database\Eloquent\Builder->get() #17 /var/www/app/app/Console/Commands/SendRecurringInvoices.php(59): App\Console\Commands\SendRecurringInvoices->resetCounters() #18 [internal function]: App\Console\Commands\SendRecurringInvoices->fire() #19 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(29): call_user_func_array(Array, Array) #20 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #21 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure)) #22 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/Container.php(539): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL) #23 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Illuminate\Container\Container->call(Array) #24 /var/www/app/vendor/symfony/console/Command/Command.php(252): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #25 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(167): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #26 /var/www/app/vendor/symfony/console/Application.php(946): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #27 /var/www/app/vendor/symfony/console/Application.php(248): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\SendRecurringInvoices), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #28 /var/www/app/vendor/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #29 /var/www/app/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(122): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #30 /var/www/app/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #31 {main} {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"GET","user_agent":"","locale":"en","ip":"127.0.0.1","count":2,"is_console":"yes","is_api":"no","db_server":"mysql","url":"/"} [] [2019-10-17 15:19:00] production.ERROR: ***Illuminate\Database\QueryException*** [1045] : /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 647] => SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using password: YES) (SQL: select * from `accounts` where `reset_counter_frequency_id` > 0 and `accounts`.`deleted_at` is null order by `id` asc) {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"GET","user_agent":"","locale":"en","ip":"127.0.0.1","count":3,"is_console":"yes","is_api":"no","db_server":"mysql","url":"/"} [] [2019-10-17 15:19:00] production.ERROR: [stacktrace] 2019-10-17 03:19:00 SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using password: YES) (SQL: select * from `accounts` where `reset_counter_frequency_id` > 0 and `accounts`.`deleted_at` is null order by `id` asc): #0 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure)) #1 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #2 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1705): Illuminate\Database\Connection->select('select * from `...', Array, true) #3 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1690): Illuminate\Database\Query\Builder->runSelect() #4 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(462): Illuminate\Database\Query\Builder->get(Array) #5 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(446): Illuminate\Database\Eloquent\Builder->getModels(Array) #6 /var/www/app/app/Console/Commands/SendRecurringInvoices.php(70): Illuminate\Database\Eloquent\Builder->get() #7 /var/www/app/app/Console/Commands/SendRecurringInvoices.php(59): App\Console\Commands\SendRecurringInvoices->resetCounters() #8 [internal function]: App\Console\Commands\SendRecurringInvoices->fire() #9 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(29): call_user_func_array(Array, Array) #10 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #11 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure)) #12 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/Container.php(539): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL) #13 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Illuminate\Container\Container->call(Array) #14 /var/www/app/vendor/symfony/console/Command/Command.php(252): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #15 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(167): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #16 /var/www/app/vendor/symfony/console/Application.php(946): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/app/vendor/symfony/console/Application.php(248): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\SendRecurringInvoices), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/app/vendor/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 /var/www/app/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(122): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #20 /var/www/app/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #21 {main} {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"GET","user_agent":"","locale":"en","ip":"127.0.0.1","count":4,"is_console":"yes","is_api":"no","db_server":"mysql","url":"/"} [] In Connection.php line 647: SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using p assword: YES) (SQL: select * from `accounts` where `reset_counter_frequency _id` > 0 and `accounts`.`deleted_at` is null order by `id` asc) In PDOConnection.php line 47: SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using p assword: YES) In PDOConnection.php line 43: SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using p assword: YES) Thu, 17 Oct 2019 15:19:00 +0000 Running SendReminders... [2019-10-17 15:19:00] production.ERROR: ***Doctrine\DBAL\Driver\PDOException*** [1045] : /var/www/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php [Line 47] => SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using password: YES) {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"GET","user_agent":"","locale":"en","ip":"127.0.0.1","count":1,"is_console":"yes","is_api":"no","db_server":"mysql","url":"/"} [] [2019-10-17 15:19:00] production.ERROR: [stacktrace] 2019-10-17 03:19:00 SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using password: YES): #0 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(65): Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=192....', 'ninja', 'tzz9090', Array) #1 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(44): Illuminate\Database\Connectors\Connector->createPdoConnection('mysql:host=192....', 'ninja', 'tzz9090', Array) #2 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection('mysql:host=192....', Array, Array) #3 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(183): Illuminate\Database\Connectors\MySqlConnector->connect(Array) #4 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors\{closure}() #5 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(883): call_user_func(Object(Closure)) #6 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(904): Illuminate\Database\Connection->getPdo() #7 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(392): Illuminate\Database\Connection->getReadPdo() #8 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(318): Illuminate\Database\Connection->getPdoForSelect(true) #9 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->Illuminate\Database\{closure}('select * from `...', Array) #10 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure)) #11 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #12 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1705): Illuminate\Database\Connection->select('select * from `...', Array, true) #13 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1690): Illuminate\Database\Query\Builder->runSelect() #14 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(462): Illuminate\Database\Query\Builder->get(Array) #15 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(446): Illuminate\Database\Eloquent\Builder->getModels(Array) #16 /var/www/app/app/Console/Commands/SendReminders.php(107): Illuminate\Database\Eloquent\Builder->get() #17 /var/www/app/app/Console/Commands/SendReminders.php(81): App\Console\Commands\SendReminders->billInvoices() #18 [internal function]: App\Console\Commands\SendReminders->fire() #19 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(29): call_user_func_array(Array, Array) #20 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #21 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure)) #22 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/Container.php(539): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL) #23 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Illuminate\Container\Container->call(Array) #24 /var/www/app/vendor/symfony/console/Command/Command.php(252): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #25 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(167): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #26 /var/www/app/vendor/symfony/console/Application.php(946): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #27 /var/www/app/vendor/symfony/console/Application.php(248): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\SendReminders), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #28 /var/www/app/vendor/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #29 /var/www/app/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(122): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #30 /var/www/app/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #31 {main} {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"GET","user_agent":"","locale":"en","ip":"127.0.0.1","count":2,"is_console":"yes","is_api":"no","db_server":"mysql","url":"/"} [] [2019-10-17 15:19:00] production.ERROR: ***Illuminate\Database\QueryException*** [1045] : /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 647] => SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using password: YES) (SQL: select * from `invoices` where is_deleted IS FALSE AND deleted_at IS NULL AND is_recurring IS FALSE AND is_public IS TRUE AND balance > 0 AND due_date = 2019-10-17 AND recurring_invoice_id IS NOT NULL and `invoices`.`deleted_at` is null order by `invoices`.`id` asc) {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"GET","user_agent":"","locale":"en","ip":"127.0.0.1","count":3,"is_console":"yes","is_api":"no","db_server":"mysql","url":"/"} [] [2019-10-17 15:19:00] production.ERROR: [stacktrace] 2019-10-17 03:19:00 SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using password: YES) (SQL: select * from `invoices` where is_deleted IS FALSE AND deleted_at IS NULL AND is_recurring IS FALSE AND is_public IS TRUE AND balance > 0 AND due_date = 2019-10-17 AND recurring_invoice_id IS NOT NULL and `invoices`.`deleted_at` is null order by `invoices`.`id` asc): #0 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(607): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure)) #1 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(326): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #2 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1705): Illuminate\Database\Connection->select('select * from `...', Array, true) #3 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1690): Illuminate\Database\Query\Builder->runSelect() #4 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(462): Illuminate\Database\Query\Builder->get(Array) #5 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(446): Illuminate\Database\Eloquent\Builder->getModels(Array) #6 /var/www/app/app/Console/Commands/SendReminders.php(107): Illuminate\Database\Eloquent\Builder->get() #7 /var/www/app/app/Console/Commands/SendReminders.php(81): App\Console\Commands\SendReminders->billInvoices() #8 [internal function]: App\Console\Commands\SendReminders->fire() #9 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(29): call_user_func_array(Array, Array) #10 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #11 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure)) #12 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/Container.php(539): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL) #13 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Illuminate\Container\Container->call(Array) #14 /var/www/app/vendor/symfony/console/Command/Command.php(252): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #15 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(167): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #16 /var/www/app/vendor/symfony/console/Application.php(946): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/app/vendor/symfony/console/Application.php(248): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\SendReminders), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/app/vendor/symfony/console/Application.php(148): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 /var/www/app/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(122): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #20 /var/www/app/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #21 {main} {"context":"PHP","user_id":0,"account_id":0,"user_name":"","method":"GET","user_agent":"","locale":"en","ip":"127.0.0.1","count":4,"is_console":"yes","is_api":"no","db_server":"mysql","url":"/"} [] In Connection.php line 647: SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using p assword: YES) (SQL: select * from `invoices` where is_deleted IS FALSE AND deleted_at IS NULL AND is_recurring IS FALSE AND is_public IS TRUE AND balance > 0 AND due_date = 2019-10-17 AND recurring_invoice _id IS NOT NULL and `invoices`.`deleted_at` is null order by `invoices`.`id ` asc) In PDOConnection.php line 47: SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using p assword: YES) In PDOConnection.php line 43: SQLSTATE[HY000] [1045] Access denied for user 'ninja'@'172.17.0.1' (using p assword: YES)
When I go the the WebUI i get
This site can’t be reached192.168.0.151 refused to connect. Search Google for 192 168 151 8001 ERR_CONNECTION_REFUSED
Thanks
-
+1
Having issues with this as well
Web UI error.
[Support] Linuxserver.io - SWAG - Secure Web Application Gateway (Nginx/PHP/Certbot/Fail2ban)
in Docker Containers
Posted · Edited by Technazz
I have this working on my unraid server with sonarr, radarr, nextcloud and plex. But i have another Unbuntu NUC server running Invoice Ninja. I have made a subdomain for it but how do I create a .conf to file for it to use outside of the docker network?
Thanks