Jump to content

CryPt00n

Members
 View Profile  See their activity

  • Posts

    38

  • Joined

  • Last visited

 Content Type 

Posts posted by CryPt00n

    [Support] jj9987 - PostgreSQL

    in Docker Containers

    Posted · Edited by CryPt00n

    11 hours ago, AmokK said:

     

    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.

     

    Hi, i don´t know how it would work with adminer, should just export from the old one and import to the new. But this is how i migrated:

     

     

    I´ve used the same port for the new database, so i switch with powering on and off between them. Just don´t wanted to change the nextcloud config.

     

    -shut down nextcloud & postgres and do a backup of your appdata folders

     

    -install target postgres docker

    IMPORTANT: You need to create a user with the same credentials used by nextcloud after starting the docker (you can find it in the nextcloud config) or add it to the postgres docker template (easiest way)

     

    -start target postgres docker (if you did not entered the user credentials for nextcloud to the template, you have to create the user now)

    -shut down target postgres docker

    -start source postgres docker

     

    -backup Database

    run in source docker: 

    pg_dumpall -U YOUR-NEXTCLOUD-DB-USER -s > /var/lib/postgresql/data/bak.sql

     

    -in unraid, move it to your target appdata folder (e.g. from /mnt/user/appdata/postgres13 to /mnt/user/appdata/postgres15)

    -stop source docker

     

    -import Database
    run in target docker: 

    psql -U YOUR-NEXTCLOUD-DB-USER -d nextclouddb < /var/lib/postgresql/data/bak.sql

     

     

    Database should be imported, you can now start nextcloud again and test it

    • Like 1

    [Support] jj9987 - PostgreSQL

    in Docker Containers

    Posted · Edited by CryPt00n
    Added feedback

    The user oc_admin is auto generated, my db "root" user is nextcloud. I´ve set the password for this one the same like in the v11 docker.

     

    I´ll try to reset it for oc_admin

     

    Shouldnt the password of oc_admin also get backed up and imported with my commands above?

     

    EDIT: Works, thank you!

    [Support] jj9987 - PostgreSQL

    in Docker Containers

    Posted

    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

     

    Set up the docker with same username/password and port configured.

     

     

    Receive this in logs then 

    2022-11-17 22:15:13.463 CET [274] FATAL:  password authentication failed for user "oc_admin"
2022-11-17 22:15:13.463 CET [274] DETAIL:  User "oc_admin" does not have a valid SCRAM secret.
        Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"

     

    [6.9.1-6.11.0] Possible hardware failure? - Samsung 980 Pro Cache disk

    in General Support

    Posted · Edited by CryPt00n
    More informations added

    Hello,

     

    since i use the Samsung 980 Pro nvme in my system it sometime crashes with the following logs. The logs repeat indefinitely and the system is crashed with this. Only hard shutdown is possible. At the restart, sometimes the disk is not detected from the system, so i have to restart again.

    Could this be a hardware issue? SMART dont gives me any information about this, no errors found with Scrub. Is there another way to test the drive?

     

    Other Specs:

    Intel® Core™ i9-10900

    ASRock Z490 PG Velocita

    32-GB RAM

    GTX 1070

    Dell H310

     

    Attached SMART report

    Scrub: 

    UUID:             c8c0b930-1ed7-47db-8bec-641f81b3a351
Scrub started:    Fri Oct 21 12:58:20 2022
Status:           finished
Duration:         0:02:51
Total to scrub:   242.47GiB
Rate:             1.42GiB/s
Error summary:    no errors found

     

    Logs from crash:

      

    Oct 21 11:27:52 server kernel: blk_print_req_error: 103 callbacks suppressed
Oct 21 11:27:52 server kernel: I/O error, dev loop2, sector 29120 op 0x0:(READ) flags 0x0 phys_seg 1 prio class 0
Oct 21 11:27:52 server kernel: I/O error, dev loop2, sector 29120 op 0x0:(READ) flags 0x0 phys_seg 1 prio class 0
Oct 21 11:27:52 server kernel: I/O error, dev loop2, sector 29120 op 0x0:(READ) flags 0x0 phys_seg 1 prio class 0
Oct 21 11:27:52 server kernel: I/O error, dev loop2, sector 29120 op 0x0:(READ) flags 0x0 phys_seg 1 prio class 0
Oct 21 11:27:52 server kernel: I/O error, dev loop2, sector 29120 op 0x0:(READ) flags 0x0 phys_seg 1 prio class 0
Oct 21 11:27:52 server kernel: I/O error, dev loop2, sector 29120 op 0x0:(READ) flags 0x0 phys_seg 1 prio class 0
Oct 21 11:27:52 server kernel: I/O error, dev loop2, sector 15745232 op 0x0:(READ) flags 0x0 phys_seg 1 prio class 0
Oct 21 11:27:52 server kernel: I/O error, dev loop2, sector 29120 op 0x0:(READ) flags 0x0 phys_seg 1 prio class 0
Oct 21 11:27:52 server kernel: I/O error, dev loop2, sector 29120 op 0x0:(READ) flags 0x0 phys_seg 1 prio class 0
Oct 21 11:27:52 server kernel: I/O error, dev loop2, sector 29120 op 0x0:(READ) flags 0x0 phys_seg 1 prio class 0
Oct 21 11:27:56 server kernel: btrfs_dev_stat_print_on_error: 489 callbacks suppressed
Oct 21 11:27:56 server kernel: BTRFS error (device dm-2: state EA): bdev /dev/mapper/nvme0n1p1 errs: wr 177, rd 30929, flush 0, corrupt 0, gen 0
Oct 21 11:27:56 server kernel: BTRFS error (device dm-2: state EA): bdev /dev/mapper/nvme0n1p1 errs: wr 177, rd 30930, flush 0, corrupt 0, gen 0
Oct 21 11:27:56 server kernel: BTRFS error (device dm-2: state EA): bdev /dev/mapper/nvme0n1p1 errs: wr 177, rd 30931, flush 0, corrupt 0, gen 0
Oct 21 11:27:56 server kernel: BTRFS error (device dm-2: state EA): bdev /dev/mapper/nvme0n1p1 errs: wr 177, rd 30932, flush 0, corrupt 0, gen 0
Oct 21 11:27:56 server kernel: BTRFS error (device dm-2: state EA): bdev /dev/mapper/nvme0n1p1 errs: wr 177, rd 30933, flush 0, corrupt 0, gen 0
Oct 21 11:27:56 server kernel: BTRFS error (device dm-2: state EA): bdev /dev/mapper/nvme0n1p1 errs: wr 177, rd 30934, flush 0, corrupt 0, gen 0
Oct 21 11:27:56 server kernel: BTRFS error (device dm-2: state EA): bdev /dev/mapper/nvme0n1p1 errs: wr 177, rd 30935, flush 0, corrupt 0, gen 0
Oct 21 11:27:56 server kernel: BTRFS error (device dm-2: state EA): bdev /dev/mapper/nvme0n1p1 errs: wr 177, rd 30936, flush 0, corrupt 0, gen 0
Oct 21 11:27:56 server kernel: BTRFS error (device dm-2: state EA): bdev /dev/mapper/nvme0n1p1 errs: wr 177, rd 30937, flush 0, corrupt 0, gen 0
Oct 21 11:27:56 server kernel: BTRFS error (device dm-2: state EA): bdev /dev/mapper/nvme0n1p1 errs: wr 177, rd 30938, flush 0, corrupt 0, gen 0

     

     

    Thanks in advance for your help

     

    Samsung_SSD_980_PRO_1TB_S5G-20221021-1305.txt

    [Support] Octoprint docker template - Spants

    in Docker Containers

    Posted

    Hi,
    i´m trying to set up my camera resolution, but it won´t work for me. It´s reset to default every time.
    I receive the following error in the log:
     
    i: Using V4L2 device.: /dev/video0i: Desired Resolution: 2560 x 1440i: Frames Per Second.: 15i: Format............: YUYVi: JPEG Quality......: 80i: TV-Norm...........: DEFAULTi: The specified resolution is unavailable, using: width 1280 height 720 insteadi: FPS coerced ......: from 15 to 10o: www-folder-path......: /usr/local/share/mjpg-streamer/www/

    image.thumb.png.05f423a4f6972caa831efe668564f6a4.png
     
     
    Due missing file at "/boot/config.txt" i´m not able to test it the "official" way. I laso played with mjpg settings a bit, but no success. Did someone managed to handle this?
     
    Regards
    Marc



    Hey, any idea on this?

    [Plugin] unbalanced

    in Plugin Support

    Posted

    Hi,

     

    do you still need these information? I would really appreciate the feature and would like to assist if i can.

     

    Regards
     

    On 2/19/2022 at 11:28 PM, jbrodriguez said:

    i'd still like to extend unbalance for multiple cache pools, but since i don't use it, i need some data to make it work.

     

    This post

    fleshes out what i would need.

     

    if anyone is up for it, i will take a look.

     

    [Support] knex666 - FileBrowser

    in Docker Containers

    Posted

    Hi,

     

    i´m trying to publish FileBrowser to web with nginx proxy manager, but only the shared urls. Wand to allow everything from my lan.

    Trying since some hours now to find the correct config for npm but seem not to work. Was anyone of you successful?

    This is my config at the moment: 

    location / { client_max_body_size 0; proxy_pass http://192.168.2.122:80/;}

     

    Not my wanted solution, login is reachable from the internet. But in general working atm.

     

     

    This is what i already tried in different variations: 

    location / { client_max_body_size 0; proxy_pass http://192.168.2.122:80/; allow 192.168.2.0/24; deny all;}
location /api { client_max_body_size 0; proxy_pass http://192.168.2.122:80/; allow all;}
location /static { client_max_body_size 0; proxy_pass http://192.168.2.122:80/; allow all;}
location /share { client_max_body_size 0; proxy_pass http://192.168.2.122:80/; allow all;}

     

    Here the site is just not loading at all or i receive a message, that something went wrong.

     

    Does anyone have an idea how i can solfe this?

     

    Regards

    [Support] Octoprint docker template - Spants

    in Docker Containers

    Posted

    Hi,

    i´m trying to set up my camera resolution, but it won´t work for me. It´s reset to default every time.

    I receive the following error in the log:

      

    i: Using V4L2 device.: /dev/video0
i: Desired Resolution: 2560 x 1440
i: Frames Per Second.: 15
i: Format............: YUYV
i: JPEG Quality......: 80
i: TV-Norm...........: DEFAULT
i: The specified resolution is unavailable, using: width 1280 height 720 instead
i: FPS coerced ......: from 15 to 10
o: www-folder-path......: /usr/local/share/mjpg-streamer/www/

    image.thumb.png.05f423a4f6972caa831efe668564f6a4.png

     

     

    Due missing file at "/boot/config.txt" i´m not able to test it the "official" way. I laso played with mjpg settings a bit, but no success. Did someone managed to handle this?

     

    Regards

    Marc

    Massive Performance Issue on Unraid 6.9.2

    in General Support

    Posted · Edited by CryPt00n

    Hi,

     

    this night something happened on my server, i´m not sure what. Dockers where online, but was not able to use them (Pihole online but no dns possible). Even after restarting the server i´m not able to us it. But thats another problem, i fist want to understand why unraid isnt working.

     

    On Unraid, the Performance is very poor. Loading times of Dashboard, Settings etc of more than a minute, Docker Page wont load at all. Already watched into enhanced system logs, only can find an nginx issue. But dont know what it means and how to fix it.

     

    I have attached the server diagnostics, it would be great if someone could help me.

     

    Thanks

    server-diagnostics-20220114-0936.zip

×
×
  • Create New...