Paperless-App won't start any more

Apps and Virtualization
,
1

I change to a new TrueNAS-Server and my Paperless-App that was running before on the NAS, won’T start any more.
In the log I can see the following:
password authentication failed for user “paperless”
DETAIL: Connection matched pg_hba.conf line 100: “host all all all scram-sha-256”

When I emty the paperless-ngx_postgres_data folder, paperless is starting, but all of my docs are gone.

Is there a way to get this running again?

2

Now I found something that might help here.

I opened the shell docker.io/library/postgres:15.2 of the deploying app
and entert the following:

WARNING: Your user does not have sudo privileges so /usr/local/bin/k3s command will run
on your behalf. This might cause permission issues.

$ psql -U paperless
psql (15.2 (Debian 15.2-1.pgdg110+1))
Type "help" for help.

paperless=# SELECT rolname, rolpassword ~ '^SCRAM-SHA-256\$' AS scram_pw FROM pg_authid WHERE rolcanlogin;
  rolname  | scram_pw 
-----------+----------
 paperless | t
(1 row)

paperless=# \password paperless
Enter new password for user "paperless": 
Enter it again: 
paperless=# exit
$ echo "SELECT rolname, rolpassword ~ '^SCRAM-SHA-256\$' AS scram_pw FROM pg_authid WHERE rolcanlogin;" | psql -U paperless
  rolname  | scram_pw 
-----------+----------
 paperless | f
(1 row)

Strange thing, that I get a "t"rue for scam_pw in psql with a select and with echo select a "f"alse for scram_pw.

3

Does anybody know how to change the password in a docker.io for a psql user?

4

Okay, I started with a clean App-Install.
But now I want to backup the paperless database.
Can anybody help me to setup a conjob (paperless doc) for this under TrueNAS.