Postgres Password Prompt During Nextcloud VM menu.sh Script Execution

[n0one42]

Postgres Password Prompt During Nextcloud VM menu.sh Script Execution

[enoch85]

It seems like you're doing a lot of tweaks to your VM. It never happened to me, and there's no reason for it either.

Only thing I can think of is this, but then you must have done something to your DB.

[enoch85]

Here's how the backup happens: https://github.com/nextcloud/vm/blob/master/nextcloud_update.sh#L962-L996

[n0one42]

This machine is currently in a "clean" state, meaning no custom configurations or tweaks have been applied. My actions involved only the installation and subsequent uninstallation of "FullTextSearch" using the menu.sh script. It is likely that the same issue would occur if these steps are repeated.

Edit:

    # Drop database tables
    sudo -Hiu postgres psql "$NCDB" -c "DROP TABLE oc_fulltextsearch_ticks;"
    sudo -Hiu postgres psql "$NCDB" -c "DROP TABLE oc_fulltextsearch_index;"
    sudo -Hiu postgres psql "$NCDB" -c "DELETE FROM oc_migrations WHERE app='fulltextsearch';"
    sudo -Hiu postgres psql "$NCDB" -c "DELETE FROM oc_preferences WHERE appid='fulltextsearch';"

Yes, these commands likely led to the current situation. Nonetheless, I am still interested in finding out the postgres password :)

[n0one42]

And yeah, now that I've seen what the script does, I could totally handle dropping those tables and doing the deletes with the nextcloud_db_user. Still curious though, where is that postgres password set?

Edit:
Okey, after taking a closer look to what you provided to me about the backup solution, I think, I have to set it from md5 to trust to be able to access it.
Did not tested it jet and I also think, I will let it as it is because I found a less insecure way for me.
Thanks for the link.

[n0one42]

I was also able to import my docker structure and also userns-remap with my ansible tasks. The containers created from the main.sh are still working as it should and I am happy. Otherwise, its anyway my fault changing such stuff.
About the postgres, I will make a note and test it if needed in the future.
Thanks again for your time.