Help with InvoiceNinja docker?


cyberspectre

48 posts in this topic Last Reply

Recommended Posts

  • 3 weeks later...
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'='johndoe@example.com' -e 'MAIL_FROM_ADDRESS'='invoice@example.com' -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 by Technazz
Link to post

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.

Link to post

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'

 

 

Link to post
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

 

Link to post
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

 

Link to post

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 by Technazz
Link to post
  • 2 weeks later...
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.

 

Link to post
  • 3 months later...
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:

 

214351427_WelcomeScreen.JPG.40f2f7ac19e0639cf7a99f71d01a38bf.JPG

 

 

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:

 

VM.thumb.JPG.636d121760bce2330b3702bc4810e88d.JPG

 

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.

Link to post

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.

Link to post
  • 3 weeks later...

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

InvoiceNinja.thumb.png.c71d25b162c162c43506d75db944fdf4.png

 

 

(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 by DesktopMasters
Link to post

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.

Link to post

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 by DesktopMasters
Link to post

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.