What type of hardware are you using: Virtual machine
What YunoHost version are you running: 12.0.13
What app is this about: ListMonk
Describe your issue
I wasn’t able to update listmonk from version 3.0.0 to version 4.
The error was about pgcrypto. Sorry I didn’t kept the error log and I can’t see it in my yunohost log.
I first found this topic : Upgrade from version 3.0.0~ynh2 to version 4.1.0~ynh1 fails · Issue #54 · YunoHost-Apps/listmonk_ynh · GitHub that is interesting as it explain that two lines in the /var/www/listmonk/config.toml file have to be commented :
# admin_username = ""
# admin_password = ""
But this wasn’t enaught to fix my issue.
I found this other topics : Installation script crashes while trying to install or use pgcrypto extension · Issue #52 · YunoHost-Apps/listmonk_ynh · GitHub
That explain how to fix manually the issue with pgcrypto. I’m copying Franc00018 words and give more details :
Backup the existing executable /var/www/listmonk/listmonk to listmonk_backup
sudo cp -Rv /var/www/listmonk /home/myuser/
In your home folder, create a temp folder, download the new listmonk executable from GitHub Releases
mkdir temp
cd temp
wget https://github.com/knadh/listmonk/releases/download/v4.1.0/listmonk_4.1.0_linux_amd64.tar.gz
Extract the new executable and replace the existing one
sudo tar -xvzf listmonk_4.1.0_linux_amd64.tar.gz
sudo cp -v listmonk /var/www/listmonk/
Do these steps to fix the PostgreSQL database
In Bash :
sudo su -
su postgres
psql
Then in PostgreSQL :
\c listmonk
CREATE EXTENSION pgcrypto;
run upgrade
cd /var/www/listmonk
./listmonk --upgrade
Go to the web interface and create admin user on web application form in browser
Then do the upgrade for the Yunohost app (which does nothing but clears it from upgrades).
Share relevant logs or error messages
The error was about pgcrypto. Sorry I didn’t kept the error log and I can’t see it in my yunohost log.
Cyril