• Posts

  • Joined

  • Last visited

Everything posted by AmokK

  1. @jj9987 Thanks ! I'm not very confident with command lines, sorry if I make beginner mistakes So I tried this : / # pg_dump -U nextcloud -s > /var/lib/postgresql/data/bak.sql pg_dump: error: connection to database "nextcloud" failed: FATAL: database "nextcloud" does not exist I don't know how the command arguments work, but it seems I'm not using it correctly ! "-U" is for username (nextcloud) but the command seems to understand "nextcloud" database, and skips the username part ?
  2. @CryPt00n Thanks for the detailed answer ! First, I was referring to adminer not to use it to backup/migrate, but to point out that database and credentials are valid, as it can be accessed by adminer. I tried your method, but when trying to backup database in source container, i get this error : / # pg_dumpall -U nextcloud -s > /var/lib/postgresql/data/bak.sql pg_dumpall: error: query failed: ERROR: permission denied for table pg_authid pg_dumpall: error: query was: SELECT oid, rolname, rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcanlogin, rolconnlimit, rolpassword, rolvaliduntil, rolreplication, rolbypassrls, pg_catalog.shobj_description(oid, 'pg_authid') as rolcomment, rolname = current_user AS is_current_user FROM pg_authid WHERE rolname !~ '^pg_' ORDER BY 2 Nextcloud db user is really "nextcloud", no error on that, like I said, database is accessed by the same user by adminer with no problem, and I can see all entries. I don't know what I did wrong in my setup to end up with this result
  3. Currently running PostgresQL 13.9 for nextcloud database, I would like to upgrade to PostgresQL 15.1, but I'm struggling with theses commands, what is the exact syntax to use ? (I'm running command in PostgresQL container console) My database is named "nextclouddb", I can access it using adminer.
  4. Thanks, I know, I messed up my code paste, I only use the standard command
  5. root@Tower:~# docker exec -it nextcloud sudo -u abc php -f /config/www/nextcloud/cron.php root@Tower:~# docker exec -it nextcloud sudo -u abc php -f /config/www/nextcloud/cron.php -vv PHP 7.4.26 (cli) (built: Nov 18 2021 21:39:13) ( NTS ) Copyright (c) The PHP Group Zend Engine v3.4.0, Copyright (c) Zend Technologies with Zend OPcache v7.4.26, Copyright (c), by Zend Technologies No error at least !
  6. So I tried the commands : docker exec -it nextcloud sudo -u abc php -f /config/www/nextcloud/cron.php docker exec -it nextcloud sudo -u abc php -f /config/www/nextcloud/cron.php -vv like @andreidelait advised, and it seems to work fine, no errors, it runs. I created a script to use it regularly. In my nextcloud instance, it still reports no cron jobs have been running for 29 days, is it supposed to be aware an external script is running ?
  7. Thanks for your input. In my case, I never set up anything relative to cron, I even never heard of it before it started to get errors I just thought it was part of the nextcloud container, as an internal routine or so ... I'll try to make it work like you did !
  8. Updated to nextcloud 24.0.6 (both instance and docker container), still having cron jobs not working / something went wrong, for 21 days now. Can someone help me diagnose or fix this ? As nextcloud seems to work fine, is it a serious problem ?
  9. Hi ! I'm having an issue with my Nextcloud 24 instance, I get a "something went wrong" in the background tasks, that is 7 days old. It runs on default setting "Cron", i tried to switch to Webcron, to test if it got better, but it switches back automatically to Cron a few minutes later. What can I do to solve this problem ?
  10. I'm surely missing something, how to switch from old and deprecated scrutiny to analogj image ? Just tried to install a fresh analogj, can't get in webui, template seems way different than the deprecated one ... refers to "influxdb" for example, don't know what it is.
  11. Thanks for the great work, and the guide in OP, manual update let me upgrade from 21.0.5 to 21.0.7, and then 22.2.3
  12. Same problem here, even when choosing script v0.3.4, nothing happens, test is blank with 0 Mb/s results.
  13. Thank you for pointing me in the right direction
  14. Thank you for your answer, I understand now why it can't work automatically, as it is a major postgres update. I will stick to the 13.4 version for the moment, as the database upgrade procedure seems a little bit complicated, but I will study it thoroughly and try it later
  15. Hi ! I'm using a Postgres container to get my Nextcloud Database running, I followed some tutorials here and there when I set it all up, all was working great. This morning, Postgres was not running, checked the logs : My container was using the postgres:latest tag, so I guess it auto-updated to the latest 14 version. Switched back to tag postgres:13.4 , all is working. Question is, what should I do ? Leave it as is and stay on the 13.4 version for a while (or forever ?), or seek a solution to update database to 14.0 so it could be compatible ? i'm a bit of a noob with this, maybe I didn't understand the problem correctly, but any reference site or procedure to follow could help me, and any advice is welcome Thanks for your help !!
  16. I completely deleted the container including appdata folder, rebuilt it, no problems now. Not being behind a large NAT by the way, just my personal home connection. Thanks for your help @TQ
  17. Hi everyone ! i'm getting this errors / warnings : Updating ClamAV scan DB ClamAV update process started at Sat Sep 4 08:52:39 2021 WARNING: FreshClam previously received error code 429 from the ClamAV Content Delivery Network (CDN). WARNING: You are still on cool-down until after: 2021-09-04 12:48:27 This means that you have been rate limited by the CDN. 1. Run FreshClam no more than once an hour to check for updates. FreshClam should check DNS first to see if an update is needed. 2. If you have more than 10 hosts on your network attempting to download, it is recommended that you set up a private mirror on your network using cvdupdate ( to save bandwidth on the CDN and your own network. 3. Please do not open a ticket asking for an exemption from the rate limit, it will not be granted. Freshclam updated the DB ClamAV 0.103.3/26217/Wed Jun 30 11:10:04 2021 Scanning /scan LibClamAV Warning: ************************************************** LibClamAV Warning: *** The virus database is older than 7 days! *** LibClamAV Warning: *** Please update it as soon as possible. *** LibClamAV Warning: ************************************************** Any idea what the problem could be ? I'm running ClamAV on a monthly basis, nothing more
  18. Thanks @JorgeB, I'm a real dummy ! 😀 I'm so used to my new rock solid unraid server (been using it for just 3 monthes), that I totally forgot such a simple thing as to reboot it !
  19. Hi ! I'm getting an error while trying to mount my backup usb drive : It was working fine last week using automount. Any idea ?
  20. Hi everyone ! I just recently decided to switch from synology to unraid, quite happy with as I managed to get almost all my usages covered, but I need help backing up my unraid server. On my synology nas, I used hyper backup to back everything up (apps/docker/shares, the whole package) to an external hard drive once a week, and to synology C2 daily (both with versioning). I can't figure out exactly how to get a similar result with unraid. It seems many use scripts to back up to ext hd using rclone or mc, even duplicati, with unassigned drives plugins. For the cloud part, I see many using backblaze b2 with cloudberry (not cheap) or duplicati, other using crashplanpro. I'm a bit lost ... What would you recommend in my case ? Any advice appreciated 😀
  21. Comment passer de mariadb à PostGres ?
  22. Merci pour ce tuto, moi qui n'y connais rien, ça me met le pied à l'étrier !