All bookmarks and users missing after migration of database to new host machine

[teksider]

Hello and good day! First I want to thank you for taking the time and energy to develop this awesome tool! I have had this up and running for 3+ months and wanted to migrate to a beefier machine. I am using a docker-compose.yaml and copied over my database volume and then my compose and .env. However when i started up the new container - all my history and users are gone. Including my compose file and db check output:

docker-compose.yaml

version: "3.8"
services:
  web:
    image: ghcr.io/hoarder-app/hoarder:${HOARDER_VERSION:-release}
    restart: unless-stopped
    volumes:
      - /data/hoarder:/data
    ports:
      - 3000:3000
    env_file:
      - .env
    environment:
      MEILI_ADDR: http://meilisearch:7700
      BROWSER_WEB_URL: http://chrome:9222
      OPENAI_API_KEY: sk-key
      DATA_DIR: /data
  chrome:
    image: gcr.io/zenika-hub/alpine-chrome:123
    restart: unless-stopped
    command:
      - --no-sandbox
      - --disable-gpu
      - --disable-dev-shm-usage
      - --remote-debugging-address=0.0.0.0
      - --remote-debugging-port=9222
      - --hide-scrollbars
  meilisearch:
    image: getmeili/meilisearch:v1.11.1
    restart: unless-stopped
    env_file:
      - .env
    environment:
      MEILI_NO_ANALYTICS: "true"
    volumes:
      - meilisearch:/meili_data
volumes:
  meilisearch: null
  data: null
networks: {}

db validation

[tech@slave-nuc-1:/data]$ nix-shell -p sqlite

[nix-shell:/data]$ which sqlite3
/nix/store/1r1bngv6p56pbp28h3vlzd61mq6rz4sc-sqlite-3.46.1-bin/bin/sqlite3

[nix-shell:/data]$ cd hoarder/

[nix-shell:/data/hoarder]$ sqlite3 
_data/    db.db     queue.db  

[nix-shell:/data/hoarder]$ sqlite3 db.db 
SQLite version 3.46.1 2024-08-13 09:16:08
Enter ".help" for usage hints.
sqlite> PRAGMA integrity_check;
ok

Not really sure what path to go down next and any help is much appreciated.

PC Specs

[nix-shell:/data/hoarder]$ neofetch
          ▗▄▄▄       ▗▄▄▄▄    ▄▄▄▖            tech@slave-nuc-1 
          ▜███▙       ▜███▙  ▟███▛            ---------------- 
           ▜███▙       ▜███▙▟███▛             OS: NixOS 24.11.713159.9c6b49aeac36 (Vicuna) x86_64 
            ▜███▙       ▜██████▛              Host: Intel Corporation D54250WYK 
     ▟█████████████████▙ ▜████▛     ▟▙        Kernel: 6.6.71 
    ▟███████████████████▙ ▜███▙    ▟██▙       Uptime: 5 days, 11 hours, 58 mins 
           ▄▄▄▄▖           ▜███▙  ▟███▛       Packages: 747 (nix-system) 
          ▟███▛             ▜██▛ ▟███▛        Shell: bash 5.2.37 
         ▟███▛               ▜▛ ▟███▛         Terminal: /dev/pts/0 
▟███████████▛                  ▟██████████▙   CPU: Intel i5-4250U (4) @ 2.600GHz 
▜██████████▛                  ▟███████████▛   GPU: Intel Haswell-ULT 
      ▟███▛ ▟▙               ▟███▛            Memory: 1290MiB / 7843MiB 
     ▟███▛ ▟██▙             ▟███▛
    ▟███▛  ▜███▙           ▝▀▀▀▀                                      
    ▜██▛    ▜███▙ ▜██████████████████▛                                
     ▜▛     ▟████▙ ▜████████████████▛
           ▟██████▙       ▜███▙
          ▟███▛▜███▙       ▜███▙
         ▟███▛  ▜███▙       ▜███▙
         ▝▀▀▀    ▀▀▀▀▘       ▀▀▀▘

[MohamedBassem]

@teksider a couple of questions:

1. Did you run docker compose up after updating the volume mounts?
2. Can you run select count(*) from user in the sqlite3 shell and see if it shows any users? If not, then is there a chance you copied the wrong database files?
3. Not that it'll matter here, but it seems that you also didn't copy the assets directory although you should've.

Side note: if you haven't already, I'd highly recommend you immediately rotate the key that got leaked.

[teksider]

@MohamedBassem - Thank you so much for the prompt reply!

1. Yes - I have recently migrated over to using Dockge to manage my containers and I'm suspecting this may be permission related....
2. [nix-shell:/data/hoarder]$ sqlite3 /data/hoarder/db.db "select count(*) from user;" 1 --> 1 user is what i expect as I have just been testing with 1 single user.
3. Oh i must have missed that - interesting i still have the old container on my old server and i just tried to login and its showing the same thing - no user and when i created my main one all data is gone....so im guessing I did something wrong in my original configuration....

Side Note: YEA! Key has been decomm'ed and a new one provisioned....smh what a dummy I was!

[teksider]

Docker output

[+] Running 3/3
✔ Container hoarder-meilisearch-1 Started 0.0s
✔ Container hoarder-chrome-1 Started 0.0s
✔ Container hoarder-web-1 Started 0.0s
[+] Restarting 3/3
✔ Container hoarder-chrome-1 Started 0.7s
✔ Container hoarder-meilisearch-1 Started 0.7s
✔ Container hoarder-web-1 Started

[nix-shell:/data/hoarder]$ docker ps

CONTAINER ID   IMAGE                                 COMMAND                  CREATED        STATUS                    PORTS                                       NAMES
35d6c3eb6ac0   ghcr.io/hoarder-app/hoarder:release   "/init"                  20 hours ago   Up 13 minutes (healthy)   0.0.0.0:3000->3000/tcp, :::3000->3000/tcp   hoarder-web-1
bc1f1926eea3   getmeili/meilisearch:v1.11.1          "tini -- /bin/sh -c …"   20 hours ago   Up 13 minutes             7700/tcp                                    hoarder-meilisearch-1
b85129f91dcd   gcr.io/zenika-hub/alpine-chrome:123   "chromium-browser --…"   24 hours ago   Up 13 minutes                                                         hoarder-chrome-1
af69c1b673d9   ghcr.io/alexta69/metube               "/sbin/tini -g -- ./…"   2 days ago     Up 2 days                 0.0.0.0:8081->8081/tcp, :::8081->8081/tcp   metube
dfa63646898c   tailscale/tailscale:latest            "/usr/local/bin/cont…"   2 days ago     Up 2 days                                                             metube-ts
41da00342a7b   tailscale/tailscale:latest            "/usr/local/bin/cont…"   3 days ago     Up 3 days                                                             tools-ts
294fb8d5f681   ghcr.io/sharevb/it-tools:nightly      "/docker-entrypoint.…"   3 days ago     Up 3 days                 0.0.0.0:8080->80/tcp, [::]:8080->80/tcp     it-tools
f5416848d1f7   hywax/mafl                            "docker-entrypoint.s…"   5 days ago     Up 5 days (healthy)       0.0.0.0:80->3000/tcp, [::]:80->3000/tcp     mafl
af4ceb754b43   tailscale/tailscale:latest            "/usr/local/bin/cont…"   5 days ago     Up 5 days                                                             mafl-ts
acfe47313076   louislam/dockge:1                     "/usr/bin/dumb-init …"   5 days ago     Up 5 days (healthy)       0.0.0.0:5001->5001/tcp, :::5001->5001/tcp   dockge
'''