Reinstalling mediacms

[rafaila42]

How to reinstall mediacms
Kubuntu 22.04, 6.5.0-25-generic x86_64

• Installation method: [single server install] local
• Browser: Vivaldi

After struggling for two nights trying to install ffmpeg with h264_nvenc for my GTX750Ti, on an expiramental system with very low hdd space, I managed to lost contents of my /var partition.
Together with it, (probably), the contents of the postgres database, created on installation. "PANIC: could not locate a valid checkpoint record" was recorded on the log, among other cuties, like "django.db.utils.OperationalError: connection failed: Connection refused", "Is the server running on host". It was also coplaining for a missing /var/run/postgresql/.s.PGSQL.5432 [tail -f /home/mediacms.io/mediacms/logs/debug.log]

As of https://stackoverflow.com/questions/2748607/how-to-thoroughly-purge-and-reinstall-postgresql-on-ubuntu
I had to:

$ pg_lsclusters
Ver Cluster Port Status Owner    Data directory              Log file
14  main    5432 online postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
$ sudo systemctl stop postgresql@14-main
$ sudo pg_dropcluster --stop 14 main
$ sudo pg_createcluster --start 14 main

and use the installer (/home/mediacms.io/mediacms/install.sh) to re-create it.
Modifications on it were needed, attaching below.

install.sh.txt
Also, this link was needed, too, because my new ffmpeg installation was on opt:
sudo ln -s /opt/ffmpeg/bin/ffmpeg /usr/local/bin

Please take care of the admin password mentioned at the end of the installer.

PS:
Ok, while I was trying to resolve this problem, I wasn't keeping notes on it. Everything I wrote here comes from memory, so maybe there are some inaccuracies.

With kind greetings from Thassos