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?

I don't think it would be a bad connection. I'm using an R710, which has a sas plane with 2 sas cables running to and SAS card. If I had a connection error, more drives would have suffered from that. I Don't have the smart report for the original disk 2. Could I stop the current rebuild, remove the new drive, place the original disk 2 back, assign it as disk 2 again, create smart report? Or would I lose guaranteed data that way? It became disabled a few days ago. I shut down the server when it became disabled and tried a few smart checks. Received the new 6tb drive today.

Yes I do

Disk 2 had failed in Unraid, it had a red cross in front of it. A long smart self test on disk 2 would not succeed, that's how I figured it would have been broken.

Hello, I'm rebuilding a 6tb drive (disk2) right now (upgrade from a failed 4tb) and I just got an read error on disk 1. What is the best I can do right now and did I lose any data? Error on disk 1: Nov 18 21:47:41 Behemoth kernel: blk_update_request: critical medium error, dev sdg, sector 883130016 op 0x0:(READ) flags 0x0 phys_seg 12 prio class 0 I added diagnostics, i hope they will help. behemoth-diagnostics-20211118-2228.zip

Ah yeah, got it! I completely looked over it. I though when you run a dry run, after that you can uncheck the dryrun box. Thanks for the quick response!

I got the same issue where that I can't uncheck the dryrun box. I changed the RSYNC flags, restarted the plugin a few times, reinstalled the plugin but nothing works. I'm running unraid version 6.7.2. I created a pastebin from the log: https://pastebin.com/PxZT3wMJ Is there any other thing I can try?

Hi, I've got some troubles post processing my downloads. Sonarr does send the request to my SABnzbd, but then after sabnzbd finishes downloading, sonarr doesn't move the file to my series folder, and updates plex. When I select manual import at activity, it sais ' No video files were found in the selected folder', but when i check the folder itself, there is a file in there. I got my sabnzbd set up to download to a folder called ' incomplete' and afterwards move it to a folder series in the complete folder. Sonarr also looks at the data/complete/series folder. Where do i need to start looking for trouble shooting? I got my radarr set up the same way, which is working fine.

Yeah you could. I'm not skipping those though. I have the time and better safe than sorry.

I'm not setting any, been running the script fine without.

Short explanations: - Copy the scipt to the root of your usb thumb-drive - Open up a terminal screen (you can do this on your main screen of unraid) - enter: cd /boot you are now in your flashdrive. - enter: ls -l This wil show you a list of files and directories - verify that you preclear scipt is in that list - enter preclear_bjp.sh -l this wil show you a list of disk that are able to be preacleared - Check if the drive you want to clear is pressent in the list (you can check the name of the drive in the main screen of unraid, under Unassigned devices), for example mine is: SAMSUNG_HD204UI_S2H7J1AZA06529 - write down you hard drive ID (/dev/SDX the last letter is your drive) in my case this would be /dev/sdd. - enter: preclear_bjp.sh /dev/sdX - Type Yes to start the pre clear. Make absolutelty sure that you chose the right drive, as this will overwrite your data. Quick explanation, please anybody correct me if i'm wrong, but like this it's working here.