cyberspectre Posted October 1, 2019 Share Posted October 1, 2019 Anyone using the InvoiceNinja docker successfully? After installing it, I get an error when trying to access the web UI. Thanks! Quote Link to comment
Technazz Posted October 17, 2019 Share Posted October 17, 2019 +1 Having issues with this as well Web UI error. Quote Link to comment
Squid Posted October 17, 2019 Share Posted October 17, 2019 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... Quote Link to comment
Technazz Posted October 17, 2019 Share Posted October 17, 2019 (edited) 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 Edited October 17, 2019 by Technazz Quote Link to comment
alpha51588 Posted October 19, 2019 Share Posted October 19, 2019 I've been trying to get this working for a couple of weeks now with no luck. Installation completes but then unable to access the webui. When trying to access via https (default port 8443) I get SSL_ERROR_RX_RECORD_TOO_LONG. When trying to access via http (default port 8000) the page loads and I can see the initial setup page and forms but with no formatting. When viewing the page source it is trying to fetch resources and assets, CSS, Javascript etc via https which obviously isn't working. I've tried everything I can think of including changing the web URL to both http and https, as well as adding some additional variables I found on the docker documentation E.G. REQUIRE_HTTPS=true/false and some others. Have even tried NGINX and accessing via https with the hope that that would then proxy everything through https but I couldn't get NGINX and InvoiceNinja working together. I'm out of ideas and to be honest barely know what I'm doing. But maybe that can point someone with more knowledge in the right direction. I think when accessing the UI over http the assets should also be served over http which would at least allow us to complete the inital setup. Quote Link to comment
dockerPolice Posted October 19, 2019 Share Posted October 19, 2019 Since a bunch of you are having issues with this, and datahoarding repository isn't actually a user, and the support thread effectively just points to a GitHub repository, I'm going to get this out of CA Quote Link to comment
cyberspectre Posted October 19, 2019 Author Share Posted October 19, 2019 What a shame. Really wanted to use this. InvoiceNinja billed me the other day and I thought, why am I paying them when I can host this on my own server? Eagerly awaiting a new implementation for UnRaid. But I don't have the chops to do it myself. Quote Link to comment
Squid Posted October 19, 2019 Share Posted October 19, 2019 If someone knows how to set it up and posts, then I'm sure@dockerPolice might be persuaded to reverse his decisionSent from my NSA monitored device Quote Link to comment
Technazz Posted October 21, 2019 Share Posted October 21, 2019 Fair enough! Any Takers? I think I may just set up on a Ubuntu KVM for now. Chris Quote Link to comment
ijuarez Posted October 21, 2019 Share Posted October 21, 2019 I am using their free account with the watermark, because I also could not get it to work correctly. If you can get it man, you will be THE MAN (or LADY). Quote Link to comment
DieFalse Posted October 21, 2019 Share Posted October 21, 2019 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' Quote Link to comment
Technazz Posted October 22, 2019 Share Posted October 22, 2019 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 Quote Link to comment
DieFalse Posted October 22, 2019 Share Posted October 22, 2019 2 hours ago, Technazz said: Yes those are my credentials, I can log into the MariaDB docker terminal with them. Chris Hi Chris, Can you access the database with them? Quote Link to comment
Technazz Posted October 22, 2019 Share Posted October 22, 2019 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 Quote Link to comment
Technazz Posted October 22, 2019 Share Posted October 22, 2019 (edited) Ok . If try it from the Invoice Ninja Console i get # mysql -u ninja -p tzz9090; sh: 2: mysql: not found Unraid/Linux noob here. How do i let the Invoice ninja container access the MariaDB container path for the mysql cmd? Chris Edited October 22, 2019 by Technazz Quote Link to comment
SRB Posted November 5, 2019 Share Posted November 5, 2019 On 10/21/2019 at 11:41 AM, Technazz said: Fair enough! Any Takers? I think I may just set up on a Ubuntu KVM for now. Chris I struggled with InvoiceNinja as a docker for a while, never got it to work and so decided to run it as an Ubuntu VM. Been running smoothly for over 6 months now and I have no complaints. Followed this guide to get it up and running: https://websiteforstudents.com/install-invoice-ninja-on-ubuntu-16-04-18-04-lts-with-nginx-mariadb-and-php-7-2-fpm/ Did a little bit of customizing to get it to work with the Linuxserver letsencrypt docker, which I'd be happy to share if anyone is interested. Quote Link to comment
Iceman24 Posted February 10, 2020 Share Posted February 10, 2020 Has there been any progress on getting this to work? I was going to try it since I could self-host, but I wouldn't be willing to do a VM just for it. Quote Link to comment
Z3RO Posted February 12, 2020 Share Posted February 12, 2020 On 11/5/2019 at 9:47 PM, SRB said: I struggled with InvoiceNinja as a docker for a while, never got it to work and so decided to run it as an Ubuntu VM. Been running smoothly for over 6 months now and I have no complaints. Followed this guide to get it up and running: https://websiteforstudents.com/install-invoice-ninja-on-ubuntu-16-04-18-04-lts-with-nginx-mariadb-and-php-7-2-fpm/ Did a little bit of customizing to get it to work with the Linuxserver letsencrypt docker, which I'd be happy to share if anyone is interested. Hi SRB, Since you got Invoiceninja running using that guide, I would appreciate if you could at all assist. I have finished the guide but get the following screen when I go to the domain I placed in step 6: In step 6, I was not quite sure what they meant by replace directory root location, however I did replace example.com www.example.com with my subdomains. This Is the VM setup: The VM seems to be working as it should. I would like to get to the point where I can ask your help to get the Letsencrypt part setup (I do have Letsencrypt docker working well with some dockers but not with any VMs). If you are able to help and need any logs etc, please tell me where to go to find the logs. Thank you. Quote Link to comment
Z3RO Posted February 16, 2020 Share Posted February 16, 2020 I managed to get it up and running on the VM, just had to change the listen port in the below settings from 80 to 443. _____________________________________________ server { listen 80; listen [::]:80; root /var/www/html/invoiceninja/public; index index.php index.html index.htm; server_name example.com www.example.com; client_max_body_size 100M; location / { try_files $uri $uri/ /index.php?$query_string; } location ~ \.php$ { include snippets/fastcgi-php.conf; fastcgi_pass unix:/var/run/php/php7.2-fpm.sock; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; include fastcgi_params; } } ________________________________________________ Still have not got the letsencrypt part sorted as yet. Quote Link to comment
DesktopMasters Posted March 6, 2020 Share Posted March 6, 2020 I am sorry, I am unclear. Has anyone got this working as a docker container? I see there is an image in the unraid apps repository. But I am unable to get it working or find step by step directions on how to use it. Quote Link to comment
Z3RO Posted March 6, 2020 Share Posted March 6, 2020 Unfortunately never got it working either. Hoping that the community will getting it going soon enough though. Definitely a program I want to use. Quote Link to comment
DesktopMasters Posted March 6, 2020 Share Posted March 6, 2020 (edited) Okay, as you might imagine, I am very excited to tell you.... I GOT IT WORKING in that unraid container... Below are the (rough?) steps I followed. Please keep in mind that I am JUST teaching myself docker and have never used invoiceninja. I figured this out through research and massive tweaking and troubleshooting. But that does not mean I cannot help you through your issues. 🙂 If you want to discuss this with me, or drop in and say thank you, I can be found in IRC on the FreeNode network in #DesktopMasters. Just comment and idle and I will respond to you when I am no longer idle. (We have a pretty incredible network of techs sharing their knowledge through multiple platforms.) or.. just leave a note here and let me/us know if it worked!! Search apps for: invoiceninja anojht [Install] Configure with your network settings. Fill in settings. Note: On the APP_URL remove the "https://" prefix. It can cause weird redirect loops on the forwarding if it is there. Note: on the APP_KEY leave blank you will fill this in after. Add Variable: REQUIRE_HTTPS Key: REQUIRE_HTTPS Value: false ^^ Not sure if this does anything at all. [APPLY] settings. In the below picture it does not show it but I later changed port 8000 to 80 and port 8443 to 443 (This following is the missing step) Go into console of running container... Run the following commands php artisan key:generate # ^^ remember you have to type "yes" php artisan config:clear php artisan config:cache Now copy the key on your screen from the first command from between the brackets without the brackets: base64:PbmLdQrTYfcSDJSLKDALDKFFvvq/yWaGlfwiNAvjHXQ= (The left key is an example do not use it) Past it into the APP_KEY field you previously left blank in the settings of the container. (replace whatever text is there now) [APPLY] After this I was able to access it on port 8000 through my NGinX forwarded proxy (if that does not work try 80). I was able to make it use 80 and 443 by editing the settings and advanced settings but for the sake of this and leaving defaults I did not do it on my final run and it worked on 8000. I later changed it to 80 to do my port forwarding. It worked on 8000 for a while then stopped. No idea why. After setting up I could not access it on 8000 directly and it would always to try redirect me to https. Also the login screen looked strange. This happened NO MATTER what I did. however... Whenever I access it through my web server proxy with the ssl certs it looks and works perfectly. This is my NGinX web server config.... server { server_name billing.desktopmasters.com; location / { proxy_pass http://invoiceninja:443/; proxy_redirect off; proxy_set_header Host $host; proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; client_max_body_size 100m; client_body_buffer_size 128k; proxy_connect_timeout 90; proxy_send_timeout 90; proxy_read_timeout 90; proxy_buffer_size 4k; proxy_buffers 4 32k; proxy_busy_buffers_size 64k; proxy_temp_file_write_size 64k; } listen 443 ssl; # managed by Certbot # ssl off; ssl_certificate /etc/ssl/private/desktopmasters.com/fullchain1.pem; # managed by Certbot ssl_certificate_key /etc/ssl/private/desktopmasters.com/privkey1.pem; # managed by Certbot include /etc/letsencrypt/options-ssl-nginx.conf; # managed by Certbot ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; # managed by Certbot } # And of course for redirect from port 80 to ssl/443 server { server_name billing.desktopmasters.com; listen 80; if ($host = billing.desktopmasters.com) { return 301 https://$host$request_uri; } return 404; } ~ The Father Edited March 6, 2020 by DesktopMasters 1 Quote Link to comment
DesktopMasters Posted March 7, 2020 Share Posted March 7, 2020 In my directions I said to leave the prefix off the URL. Doing this causes the buttons in the EMails not to work so I have put it back. I will likely delete my post and rewrite it from scratch so it is less confusing. I have also found this post https://www.invoiceninja.com/forums/topic/attach-pdfs-to-emails-using-https-domain/ I am going to test to see if I can get the PDF generation working. Quote Link to comment
DesktopMasters Posted March 7, 2020 Share Posted March 7, 2020 Another update, there seem to be issues with client passwords and logging into to the portal if they use the buttons in the EMail. This does not seem usable in its current state. I will be looking into this further. Possible a more up to date docker image? Quote Link to comment
DesktopMasters Posted March 8, 2020 Share Posted March 8, 2020 (edited) I was able to get the EMailing of templates working. But it is really touch and go. Not sure why. Add a Variable to the container "PHANTOMJS_BIN_PATH" with the value "/usr/local/bin/phantomjs" (no quotes). Still having issues with client passwords trying to access the portal though. Edited March 8, 2020 by DesktopMasters Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.