hi @dosch, please don’t remove anything yet, your data is not lost but inside the postgresql database.
password authentication failed for user "outline" error while everything seems to be OK for the identificationThanks and sorry for the late feedback, I’ll try to stay connected to the forum today
Yes
This one?
sudo yunohost app upgrade outline --debug -b
Sadly the same outcome so far…
Bad news, sorry for that.
Could you please try to install the adminer app, and connect as per the below screen ;
@dosch and can you share your logs even if the issue was similar ?
I’ll check whether your access to the database was under the “dev” mode or not.
and the logs are here
OK, we are getting there. The “production” environment is now well triggered.
However, there is apparently an issue with your database.
I’ll check for you what should be the next step.
Shall I assume that you didn’t make any backup before starting the upgrade ?
Can you open the command line and type
su postgres
then psql
then \l
then \du
And copy here the output of these last two commands please ?
Here are mine for reference
postgres-# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-----------+----------+-------------+-------------+----------------------------
nextcloud | nextcloud | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/nextcloud +
| | | | | nextcloud=C*T*c*/nextcloud
outline | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres=CTc/postgres +
| | | | | =c/postgres
postgres-# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------+-----------
nextcloud | | {}
outline | | {}
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
I suspect that for some reason your “outline” role was deleted, which shouldn’t be a big deal. I just hope that the “outline” database by itself is still there…
here you go
postgres-# \l
Name | Owner | Encoding | Collate | Ctype | Access privileges
-------------+----------+----------+-------------+-------------+--------------------------
hedgedoc | hedgedoc | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/hedgedoc +
| | | | | hedgedoc=C*T*c*/hedgedoc
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
vriendenvan | odoo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(5 rows)
postgres-# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------+-----------
hedgedoc | | {}
odoo | Create DB | {}
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
Outline seems totally absent indeed…
No, I did make a backup. Or, better said, YNH made the pre-upgrade backup.
Well, now I understand your problem that is rather simple, your outline database is gone indeed. It’s very probably a bad consequence of your instance running out of space while installing at that time.
If the pre-upgrade backup was when you upgraded here the I think the best is clearly to remove your outline app from the web admin and then restore Outline from that pre-upgrade backup. You’ll get all your previous data !
HOWEVER, before doing so, please copy-paste carefully somewhere the content of your /var/www/outline/.env file, as it contains important encryption keys. This is just in case as the pre-upgrade archive should have it too, but we can’t be too prudent !
Once restored if you aren’t fed-up, which I would fully understand… You can attempt another upgrade again !
Sorry again for the time lost and all hassle involved…
Finger crossed
yes, restoration has succeded.
So now we are back at sudo yunohost app upgrade outline --debug -b
Yes you can remove MinIO, but please do a backup of it before and check if all images are successfully uploading / downloading within Outline.
Thanks @ericg and @tituspijean for your backstage help during that debug !
1
clean install
1.1
reinstall worked
2
now grant access dont really work
Run into the same problem here.
Can you please describe the problem you are running into ?
I’m not sure if you have the same issue I ran into but I started getting this auth failure message recently after an update, and it related to Outline not accepting the token from Dex when using self-signed cert (I’m not sure why this is, as I have a valid cert installed).
The solution was to add the following line in /var/www/outline/.env:
NODE_TLS_REJECT_UNAUTHORIZED=0
After restarting the Outline service I could then authenticate.
Thanks for the hint. However, I wouldn’t advise using self signed certs !
Me neither! For me I found the LE cert autorenew had failed for that subdomain (due to Cloudflare Proxy being on); I was able to get the cert renewed and remove that line in the env file, and auth continued to work fine. This was with Dex 2.39.1~ynh1 and Outline 0.76.1~ynh1 just for reference.