Yeyo53

Hello, After having problems with the upgrade from Nextcloud 23 to 26 a couple of months ago, It has stopped working again. I am in 26.0.1 and Nextcloud is in Maintenance Mode after a reboot (I did it because I can't login). In the Nextcloud docker log I see this: using keys found in /config/keys **** The following active confs have different version dates than the samples that are shipped. **** **** This may be due to user customization or an update to the samples. **** **** You should compare the following files to the samples in the same folder and update them. **** **** Use the link at the top of the file to view the changelog. **** ┌────────────┬────────────┬────────────────────────────────────────────────────────────────────────┐ │ old date │ new date │ path │ ├────────────┼────────────┼────────────────────────────────────────────────────────────────────────┤ │ 2018-08-16 │ 2023-04-13 │ /config/nginx/nginx.conf │ │ │ 2023-04-13 │ /config/nginx/site-confs/default.conf │ └────────────┴────────────┴────────────────────────────────────────────────────────────────────────┘ **** The following site-confs have extensions other than .conf **** **** This may be due to user customization. **** **** You should review the files and rename them to use the .conf extension or remove them. **** **** nginx.conf will only include site-confs with the .conf extension. **** Should I remove those fields? I dont think I have modified it and they look pretty similar to the sample files. Is this the reason why my Nextcloud has stopped working? Thanks in advance. EDIT1: I updated through terminal and maintenance mode is now off (im in 26.0.2) but Im an internal server error when login again. Do you know which log should I be checking to get more info? I have been reading it could be the Mariadb or an incompatible app.. Btw, the message above with the .conf files is still in the log EDIT2: I have check the /config/log/nginx/error.log and I have found this error: 2023/05/29 13:30:08 [error] 288#288: *5 FastCGI sent in stderr: "PHP message: {"reqId":"JcLdeQjsPRdnVkTf10Ry","level":3,"time":"2023-05-29T11:30:07+00:00","remoteAddr":"47.61.125.213","user":"notarealuser","app":"index","method":"POST","url":"/login","message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_id' in 'where clause'","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/113.0","version":"26.0.2.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user_id' in 'where clause'","Code":1054,"Trace":[{"file":"/config/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":295,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::"},{"file":"/config/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":276,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/config/www/n" while reading response header from upstream, client: 47.61.125.213, server: _, request: "POST /login HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "mynotrealhost.com" I dont know what to do at this point, to be honest.

Yes, I know. But at the moment I dont really want to spend more money. I think the ROI will be very high. Yes This is my first unraid build and I messed up with my space distribution/shares. Basically I need to move 1 of the disk in the unraid to an unassigned device, because disk 5 is ONLY use for seeding torrents. but right now it also implies parity to be UP and a lot of reads in both disks. The problem is that I think I need a disk to replace disk 5 before moving it outside the array so Im delaying this a bit. Well, in this case again not worth the expense IMO.

Wow, I'm surprised how you guys manage to get 20w-30w idle servers. I'm going to ask about recommendations on my setup in case Im missing something. - 4690K - Asus ROG Maximus VII Gene Z96 - 4x4GB DDR3 - 8xHHDs - 1xNVME - 1xLSI SAS2008 - 1x1060 (idle 7w) - Corsair RM650x currently 66W at idle. (im running several docker containers but 99% of the time they are not doing nothing). Only 2 disks spinning. - C states seems to be working fine - I have already run powertop --auto-tune I can change my 4x4GB to 2x8GB, and I have 3 small disk that can be replace for 1 big hd. Do you think there is something more I can do to lower my power consumption? Thanks in advance.

Hello, I have a 1060 GTX connected to unraid and a Windows 10 VM that I use from time to time to play some games. The thing is in an unraid fresh boot, GPU is correctly detected and I can run a script to force P0 State (power consumption 6W and fan off) but after I have run a start/stop with the VM, the graphic card is no longer available so it keep with the fan ON and, I guess, consumption is way more elevated. Is there any way to fix this in 6.10.3? Do I have to restart Unraid everytime I turnoff the VM to recover the low consumption or it is possible to somehow restart the nvidia driver or similar through a script? I only turn on that VM once in a month or less.. so it is important to me to save some electricity. Thanks in advance!

Regarding this topic: could be possible to share a 1060 GTX with the PLEX container (90% of the time) but if I start a Windows VM (10% of the time) it get locked by the VM?

Hello Its my first time setting up a OpenVPN server so I don't know if this is the correct way of working or I'm missing something. I have followed the Spaceinvaders guide and my VPN is working. I have tested it with my mobile phone using 4G and it works perfect. The problem was that I was at the office this morning and want to test it but I didn't have the profile so I tried to access to mydomain:943 and It couldn't be reached. I 'opened' the port just in case and still not working. So: 1) Is openVPN GUI only accesible through LAN for security reasons? 2) In this way, should I keep a copy of the profile somewhere in the cloud (my nextcloud, for example) in case this happen again to me? 3) In the case OpenVPN can be accesed through wan, what I'm missing? I tried the port in a hurry, but I'm using nginxproxymanager. Thanks in advance.

At first, thank you for answering. I gonna try to clarify some points: 1-Do you want all your files (movies/tv) in your "Plex" share to eventually be moved to your gdrive? Or are you going to keep some files local and some on the cloud? No. I'm having two different folders: one for 'special movies' I want to keep local in /mnt/user/Plex/movies and other with 'less special' movies in '/mnt/user/Plex/mount_mergefs'. Then I add these two folders in the same library in Plex so I see all the movies together. 2- Do you seed files for a LONG time or just to meet ratio/hit-and-run rules (like 7 days seed before you delete it from your torrent client)? Well, it depends, but could be a month or two. 3- That's up to you. I would use unassigned device for seeds to avoid parity writes OR use your cache. But that of course would make those files unprotected (likely not an issue for torrents). Consider keeping the seeds on your cache drive if it's big enough and that will avoid excessive spin ups. I don't really care about protection in those files, and my cache drive is 1TB so it could handle. I like this idea more than the unassigned device, but IDK. The thing is that if radarr/sonarr are moving files just after the download completes from /mnt/user/Torrent/downloads (disk3) to /mnt/user/Plex/movies(disks 4,5,6,7) it means that files are being seeded for the Plex user share so those disks are being spinned all the time, right? Maybe I should look for an option to tell sonarr/radarr to DON'T move the files after 1month or something like that? 4- Regarding the gdrive folders: I put the mount_mergefs in /mnt/user/Plex/mount_mergefs because i have my local folder of movies in the same place (/mnt/user/Plex/movies) so mount_mergefs is the folder inside my plex user share where movies in gdrive are (both yet not uploaded and already uploaded). as you said this is only a shortcut to the other two folders. In this case when radar downloads a movie it moves it to '/mnt/user/Plex/mount_mergefs' which in reality is my local gdrive folder located in /mnt/user/Torrent/gdrivedownloads + the RcloneMountShare which is a link to my gdrive, right? but imagine that theres is no new downloads so all my files are in GDRIVE currently. Now I download a new file (/mnt/user/Torrent/downloads) so disk 3 is spinned up. Then in completes and radarr moves it to /mnt/user/Plex/mount_mergefs so one of the disks related to that user share (disks,4,5,6,7) are spinned up. but /mnt/user/Plex/mount_mergefs in reality is a link to /mnt/user/Torrent/gdrivedownloads so another time disk 3. And then file is uploaded to gdrive and now is ''''virtuallly?''' in /mnt/user/Storage/mount_rclone so disk 2 is spinned up? I know, I know. I'm just making things complicated. I really like to keep things organized so for me it makes sense thats 'gdrive movies local&notlocal' (aka mergefs) are ''located'' in the Plex user share. And it also makes sense that my 'gdrive' remote (aka mount_rclone) is the Storage user share where my 'personal files' are (nextcloud). Hope I have clarified something! thanks in advance!

Sorry guys! I have been busy this week. I just accomplished it! The main problem was in my cache remote (I read it in a spanish forum that it was better for plex but I have try with only the crypt and it is working fine so...) Anyway I would like to ask because I think I can optimize it a little bit but it is hard to explain: At first Im pretty new to unraid so maybe I am doing things wrong. - I have 1 user shared called Torrent that use disk 3 (cache: no) for downloads (first question: should I use an unassigned device for torrent downloads to avoid writing all the time in parity?) - Then I have a user shared called Plex with 4 HDs (disks 1,2,5,6) where movies and tv shows are and where downloads are moved after complete (radar&sonarr do this). Cache is set to YES so I guess sonnar and radar move it to cache drive and then the mover move it sometime to the final destination. am I right? - Then I have a user share Storage (disk 4) for nextcloud. So: - I have mounted 'mount_rclone' (AKA gdrive) in Storage (but there is no real info there, right? I mean no space is occupied?) - I have mounted 'local' in Torrent/gdrivedownloads (which I think I did wrong because anyway my transmission is dowloading to Torrent/download but keep reading) - I have mounted 'mount_mergefs' in Plex user shared. So files are downloaded through sonarr&radarr to 1)Torrent/download/incomplete 2)Torrent/download/complete, then 3) they move it to 'Plex/mount_mergefs/gdrivemovies' (but phisicaly they are 'occuping space' in Storage/mount_rclone AKA disk 4. Is it weird or it makes sense? What I want to avoid is 'spinning disks' for nothing and try to save some power and so because Plex is not used until night (but if I'm sharing a complete with transmission... which have been moved to Plex but it '''is''' stil at Torrent/Downloads... which disk is active??) SORRY for the long post but my head is a mess right now! thanks in advance if you read it!!

Hello! Im trying to mount my gdrive in unraid but Im facing some problems. I'm not a native english speaker so maybe thats the main problem haha I have created 3 remotes in rclone. one called gdrive with connect to my gdrive, one called gcache which points to 'gdrive:media' and one gcrypt which points to 'gcache:'. I think thats ok. Now I have to create a user script with the rclone_mount script but I'm seeing all the folders at the beginning and that's where I'm getting lost. I have a user share (calle Plex) with 3 disks. I have a folder called 'movies' inside that share, so /mnt/user/Plex/movies. I want to create another folder called gdrivemovies so /mnt/user/Plex/gdrivemovies. So, in my case: RcloneRemoteName="gcrypt" RcloneMountShare= LocalFilesShare="/mnt/user/Plex/gdrivemovies" MergerfsMountShare="ignore" DockerStart="transmission plex sonarr radarr" MountFolders=these should be folders inside my gdrive? I mean I have two folders one called 'media' (which I think I need for the cache) and one 'movies'. Do I need more? Thanks in advance and great work.