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]
$ 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.
How to reinstall mediacms Kubuntu 22.04, 6.5.0-25-generic x86_64
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:
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/binPlease 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