rvoosterhout

Hi, I just moved from LinuxServer image to the official one, but running docker exec --user 99 Nextcloud php occ db:add-missing-indices gives me the following error. How to fix this? Console has to be executed with the user that owns the file config/config.php Current user id: 99 Owner id of config.php: 1001 Try adding 'sudo -u #1001' to the beginning of the command (without the single quotes) If running with 'docker exec' try adding the option '-u 1001' to the docker command (without the single quotes) Changing the user to 1001 gives me the following error: Your data directory is invalid. Ensure there is a file called ".ocdata" in the root of the data directory. Cannot write into "config" directory. This can usually be fixed by giving the web server write access to the config directory. See https://docs.nextcloud.com/server/27/go.php?to=admin-dir_permissions. Or, if you prefer to keep config.php file read only, set the option "config_is_read_only" to true in it. See https://docs.nextcloud.com/server/27/go.php?to=admin-config Cannot write into "apps" directory. This can usually be fixed by giving the web server write access to the apps directory or disabling the App Store in the config file. Your data directory is not writable. Permissions can usually be fixed by giving the web server write access to the root directory. See https://docs.nextcloud.com/server/27/go.php?to=admin-dir_permissions. An unhandled exception has been thrown: Exception: Environment not properly prepared. in /var/www/html/lib/private/Console/Application.php:167 Stack trace: #0 /var/www/html/console.php(99): OC\Console\Application->loadCommands(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #1 /var/www/html/occ(11): require_once('/var/www/html/c...') #2 {main}{"reqId":"DCZ0M6EfFVvOtVTdz1TQ","level":3,"time":"2023-07-05T20:53:52+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"fopen(/var/www/html/data/data_dir_writability_test_64a5d8606a64e.tmp): Failed to open stream: Permission denied at /var/www/html/lib/private/legacy/OC_Util.php#579","userAgent":"--","version":"27.0.0.8","data":{"app":"PHP"}} {"reqId":"DCZ0M6EfFVvOtVTdz1TQ","level":3,"time":"2023-07-05T20:53:52+00:00","remoteAddr":"","user":"--","app":"PHP","method":"","url":"--","message":"fopen(/var/www/html/data/nextcloud.log): Failed to open stream: Permission denied at /var/www/html/lib/private/Log/File.php#84","userAgent":"--","version":"27.0.0.8","data":{"app":"PHP"}} Running su asks me for a password, which I don't have.

I think the InvoiceNinja template is not working anymore. When I deploy a fresh install on a clean DB, the install doesn't start. The logs after starting the container for the 1st time: clone public directory Generating RSA private key, 4096 bit long modulus (2 primes) ...................................................................................................................................................................................++++ ....++++ e is 65537 (0x010001) You are about to be asked to enter information that will be incorporated into your certificate request. What you are about to enter is what is called a Distinguished Name or a DN. There are quite a few fields but you can leave some blank For some fields there will be a default value, If you enter '.', the field will be left blank. ----- start 2022-03-30 08:36:39,048 INFO Set uid to user 0 succeeded 2022-03-30 08:36:39,220 INFO supervisord started with pid 1 2022-03-30 08:36:40,224 INFO spawned: 'nginx' with pid 27 2022-03-30 08:36:40,227 INFO spawned: 'php-fpm' with pid 28 Country Name (2 letter code) [AU]:State or Province Name (full name) [Some-State]:Locality Name (eg, city) []:Organization Name (eg, company) [Internet Widgits Pty Ltd]:Organizational Unit Name (eg, section) []:Common Name (e.g. server FQDN or YOUR name) []:Email Address []:[30-Mar-2022 08:36:40] NOTICE: fpm is running, pid 28 [30-Mar-2022 08:36:40] NOTICE: ready to handle connections 2022-03-30 08:36:41,821 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) 2022-03-30 08:36:41,821 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) Wed, 30 Mar 2022 08:41:39 +0000 Running SendRecurringInvoices... Wed, 30 Mar 2022 08:41:39 +0000 Running SendRecurringInvoices... [2022-03-30 08:41:40] production.ERROR: ***Illuminate\Database\QueryException*** [42S02] : /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 669] => SQLSTATE[42S02]: Base table or view not found: 1146 Table 'invoiceninjafrl.accounts' doesn't exist (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":1,"is_console":"yes","is_api":"no","db_server":"mysql","url":"/"} [2022-03-30 08:41:40] production.ERROR: [stacktrace] 2022-03-30 08:41:40 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'invoiceninjafrl.accounts' doesn't exist (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(629): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure)) #1 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #2 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\Database\Connection->select('select * from `...', Array, true) #3 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\Database\Query\Builder->runSelect() #4 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2148): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(546): Illuminate\Database\Query\Builder->get(Array) #7 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(530): Illuminate\Database\Eloquent\Builder->getModels(Array) #8 /var/www/app/app/Console/Commands/SendRecurringInvoices.php(70): Illuminate\Database\Eloquent\Builder->get() #9 /var/www/app/app/Console/Commands/SendRecurringInvoices.php(59): App\Console\Commands\SendRecurringInvoices->resetCounters() #10 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\SendRecurringInvoices->handle() #11 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #12 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure(Object(Closure)) #13 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure)) #14 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL) #15 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call(Array) #16 /var/www/app/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #17 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #18 /var/www/app/vendor/symfony/console/Application.php(1009): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 /var/www/app/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\SendRecurringInvoices), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #20 /var/www/app/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #21 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #22 /var/www/app/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #23 /var/www/app/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #24 {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":"/"} In Connection.php line 669: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'invoiceninjafrl. accounts' doesn't exist (SQL: select * from `accounts` where `reset_counter _frequency_id` > 0 and `accounts`.`deleted_at` is null order by `id` asc) In PDOConnection.php line 79: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'invoiceninjafrl. accounts' doesn't exist In PDOConnection.php line 77: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'invoiceninjafrl. accounts' doesn't exist Wed, 30 Mar 2022 08:41:41 +0000 Running SendReminders... [2022-03-30 08:41:41] production.ERROR: ***Illuminate\Database\QueryException*** [42S02] : /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 669] => SQLSTATE[42S02]: Base table or view not found: 1146 Table 'invoiceninjafrl.invoices' doesn't exist (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 = 2022-03-30 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":1,"is_console":"yes","is_api":"no","db_server":"mysql","url":"/"} [2022-03-30 08:41:41] production.ERROR: [stacktrace] 2022-03-30 08:41:41 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'invoiceninjafrl.invoices' doesn't exist (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 = 2022-03-30 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(629): Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure)) #1 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #2 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2159): Illuminate\Database\Connection->select('select * from `...', Array, true) #3 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2147): Illuminate\Database\Query\Builder->runSelect() #4 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2619): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #5 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2148): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #6 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(546): Illuminate\Database\Query\Builder->get(Array) #7 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(530): Illuminate\Database\Eloquent\Builder->getModels(Array) #8 /var/www/app/app/Console/Commands/SendReminders.php(107): Illuminate\Database\Eloquent\Builder->get() #9 /var/www/app/app/Console/Commands/SendReminders.php(81): App\Console\Commands\SendReminders->billInvoices() #10 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\Console\Commands\SendReminders->handle() #11 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/Util.php(37): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() #12 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\Container\Util::unwrapIfClosure(Object(Closure)) #13 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure)) #14 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/Container.php(590): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL) #15 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(134): Illuminate\Container\Container->call(Array) #16 /var/www/app/vendor/symfony/console/Command/Command.php(255): Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #17 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle)) #18 /var/www/app/vendor/symfony/console/Application.php(1009): Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 /var/www/app/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(App\Console\Commands\SendReminders), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #20 /var/www/app/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #21 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Application.php(93): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #22 /var/www/app/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(131): Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #23 /var/www/app/artisan(35): Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #24 {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":"/"} In Connection.php line 669: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'invoiceninjafrl. invoices' doesn't exist (SQL: select * from `invoices` where is_deleted IS FALSE AND deleted_at IS NULL AND is_recurring IS FALSE AND is_public IS TRU E AND balance > 0 AND due_date = 2022-03-30 AND recurring_invoice _id IS NOT NULL and `invoices`.`deleted_at` is null order by `invoices`.`id ` asc) In PDOConnection.php line 79: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'invoiceninjafrl. invoices' doesn't exist In PDOConnection.php line 77: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'invoiceninjafrl. invoices' doesn't exist

Awesome! I'm already running my dockers and vm's. It seems everything is running fine so far.

I ran it witout the -n, but with -v. No lost+found share has been created nor is there a lost+found share on the drive.

The check filesystem: Phase 1 - find and verify superblock... - block cache size set to 1011800 entries Phase 2 - using internal log - zero log... zero_log: head block 171120 tail block 171120 - scan filesystem freespace and inode maps... - found root inode chunk Phase 3 - for each AG... - scan (but don't clear) agi unlinked lists... - process known inodes and perform inode discovery... - agno = 0 - agno = 1 - agno = 2 - agno = 3 - agno = 4 - agno = 5 - agno = 6 - agno = 7 - agno = 8 - agno = 9 - agno = 10 - agno = 11 - process newly discovered inodes... Phase 4 - check for duplicate blocks... - setting up duplicate extent list... - check for inodes claiming duplicate blocks... - agno = 0 - agno = 1 - agno = 6 - agno = 9 - agno = 3 - agno = 4 - agno = 5 - agno = 7 - agno = 2 - agno = 10 - agno = 11 - agno = 8 No modify flag set, skipping phase 5 Phase 6 - check inode connectivity... - traversing filesystem ... - agno = 0 - agno = 1 - agno = 2 - agno = 3 - agno = 4 - agno = 5 - agno = 6 - agno = 7 - agno = 8 - agno = 9 - agno = 10 - agno = 11 - traversal finished ... - moving disconnected inodes to lost+found ... Phase 7 - verify link counts... No modify flag set, skipping filesystem flush and exiting. XFS_REPAIR Summary Mon Nov 22 21:27:45 2021 Phase Start End Duration Phase 1: 11/22 21:27:44 11/22 21:27:44 Phase 2: 11/22 21:27:44 11/22 21:27:44 Phase 3: 11/22 21:27:44 11/22 21:27:45 1 second Phase 4: 11/22 21:27:45 11/22 21:27:45 Phase 5: Skipped Phase 6: 11/22 21:27:45 11/22 21:27:45 Phase 7: 11/22 21:27:45 11/22 21:27:45 Total run time: 1 second

I understand. I will run the check filesystem on the rebuild drive, when that's good i'll start up my dockers and vm's and see how everything responds. I'll see if I can fit disk1 on disk2, but I think it's almost full so that won't work. Thank you very, very much for you help and quick responses.

Yes the backups have finished, but I don't have a second newdrive to also replace disk1. Disk1 is a 6 TB drive, disk2 used to be 4tb, but now is a 6TB (new). I don't think I can replace disk1 (6TB) with the old disk2 drive (4tb)?

The extended SMART test of disk 1 behemoth-smart-20211122-0827.zip

In the disk log information, see attached file. I will run the extended self test. Data looks fine so far. I haven't written anything to the server yet. Dockers and VM's are not running, so I don't know about my media.

behemoth-diagnostics-20211121-1605.zip

So the restore has finished, i'm still backing up some files to Dropbox. How to check if the restore went good? disk1 still shows read errors. Should I create a smart report from that drive?

Yes, emulated disk 2 is still mounted. I'm creating backup's right now to Dropbox using duplicati. I paused the rebuild last night, I set it to continue this morning, still 11 hours to go. It's 10 am here now. My dockers and vm's are stopped, so nothing is being written to the server right now.

So should I cancel the rebuild, put this drive back and start a rebuild on disk 1 with the new 6tb disk?

Attached the cristaldiskinfo screenshot

I do not unfortunately. My array is still reachable, so I could create a backup but I don't have a medium to back it up to. Yes I can connect the original disk2 to my pc, which software do you recommend to create a smart report?