AmokK

Members
  • Posts

    33
  • Joined

  • Last visited

Posts posted by AmokK

  1. Switched to ipvlan for a few hours, froze again.

    Last syslog entries :

     

    Jul 11 15:25:02 Tower emhttpd: read SMART /dev/sdc
    Jul 11 15:27:23 Tower kernel: mdcmd (47): set md_write_method 1
    Jul 11 15:27:23 Tower kernel: 
    Jul 11 15:40:12 Tower emhttpd: spinning down /dev/sdc
    Jul 11 15:42:23 Tower kernel: mdcmd (48): set md_write_method 0
    Jul 11 15:42:23 Tower kernel: 
  2. Hi !

    My unraid server freezes about every two days (randomly), I can't access web interface, shares or dockers. It won't power down then when I press the physical power button, so I have to shut the power down to power it again.

    I recently changed motherboard/cpu/ram/ssds, memtest runs all night without error.

    I mirrored syslog to flash, last time it froze, latest entry was an array spin down (2 HDDs). This morning it seems last entry was dynamix cache dirs plugin execution (I disabled it now).

    Any help appreciated.

    Thanks !!

    tower-diagnostics-20230711-0814.zip

  3. On 6/29/2023 at 5:32 AM, kiwijunglist said:

    Hi,

     

    Are these errors a problem (unraid 6.11.5) ?

     

    root@manitoba:~# powertop --auto-tune
    powertop: /lib64/libncursesw.so.6: no version information available (required by powertop)
    powertop: /lib64/libtinfo.so.6: no version information available (required by powertop)
    modprobe cpufreq_stats failed
    Loaded 0 prior measurements
    Cannot load from file /var/cache/powertop/saved_parameters.powertop
    File will be loaded after taking minimum number of measurement(s) with battery only
    RAPL device for cpu 0
    RAPL device for cpu 0
    Devfreq not enabled
    glob returned GLOB_ABORTED
    Cannot load from file /var/cache/powertop/saved_parameters.powertop
    File will be loaded after taking minimum number of measurement(s) with battery only
    Leaving PowerTOP

     

     

    Same kind of errors here on unraid 6.12.1 :

     

    root@Tower:~# powertop --quiet --auto-tune
    powertop: /lib64/libncursesw.so.6: no version information available (required by powertop)
    powertop: /lib64/libtinfo.so.6: no version information available (required by powertop)
    Cannot load from file /var/cache/powertop/saved_parameters.powertop
    File will be loaded after taking minimum number of measurement(s) with battery only 
    Cannot load from file /var/cache/powertop/saved_parameters.powertop
    File will be loaded after taking minimum number of measurement(s) with battery only 
    root@Tower:~# 

     

    What's wrong ?

     

    Every (many) lines that are reported as "bad" in tunables, turn to "good" when using autotune command, but if I check later, all is back to their original "bad" status.

  4. Hi !

    I updated to nextcloud 25.0.3, and I have some new warnings (I already had some for monthes, about security-headers and policies, and also reverse proxy, but don't have the skills yet to fix them) regarding the apps folder permissions, it says that the owner is different from the web server user.

    I think it could be fixed with a little bit of chmod, but what is the default web server username ? in nextcloud docs, it is often "www-data", is that the case here ?

  5. 21 minutes ago, jj9987 said:

    Added the template for postgres 15.

     

    Postgres CLI tools default to the same database name as the user you are trying to connect with. Maybe your database has a different name?

    My database is indeed named "nextclouddb". What command should I use then?

  6. @jj9987 Thanks !

    I'm not very confident with command lines, sorry if I make beginner mistakes o.O

    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 ?

  7. @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 :ph34r:

  8. On 11/17/2022 at 10:20 PM, CryPt00n said:

    Not quite sure if i restored it the right way

     

    Used for Backup

    pg_dumpall -U nextcloud -s > bak.sql

     

    Used for restore

    psql -U nextcloud postgres < bak.sql

     

     

     

    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.

  9. 2 minutes ago, andreidelait said:

     

    It should be fine. you don't have to run both. I gave you the -vv one just to see if PHP works. 
    In your script you should run just the first command.
    I don't know why nextcloud says it didn't run though.

    Thanks, I know, I messed up my code paste, I only use the standard command :) 

  10. 17 minutes ago, andreidelait said:

     

    Somethnig is wrong in that case. The command with -vv returns anything? 

    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 ! :)

  11. 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 ?

  12. 4 minutes ago, andreidelait said:

     

    I'm curious how other users do it. I run the cron directly from the Unraid host using User Scripts.

    #!/bin/bash
    docker exec -i nextcloud sudo -u abc php -f /config/www/nextcloud/cron.php

     

    I run it every 5 min:

    */5 * * * *

     

    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 !

  13. On 9/22/2022 at 5:58 PM, AmokK said:

    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 ?

    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 ?

  14. 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 ?

  15. 3 minutes ago, jj9987 said:

    Postgres upgrades can't be done by simply changing the version tags, they often have changes that require additional steps (e.g. pg_upgrade). So definitely don't use the latest tag. I changed the templates long time ago, haven't added newer templates to the repo though.

    Here's the information on how to do it: https://www.postgresql.org/docs/14/upgrading.html

     

    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 :)