Installation script crashes while trying to install or use pgcrypto extension

[franc00018]

Describe the bug

Installation script crashes while trying to install or use pgcrypto extension on PostgreSQL database

Context

• Hardware: VPS bought online
• YunoHost version: 12.0.6
• I have access to my server: Through SSH
• Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no, it's pretty vanilla with apps installed from the catalog, except this one.
• Using, or trying to install package version/branch: ci-auto-update-4.0.1

Steps to reproduce

sudo yunohost app install https://github.com/YunoHost-Apps/listmonk_ynh/tree/ci-auto-update-4.0.1 --debug

Expected behavior

I expect the app to install successfully using the command line, as it's possible to do so with version 3.x
This is a new installation on a recently migrated Yunohost 12. This server never had ListMonk installed before migrating to Yunohost 12.

Logs

https://paste.yunohost.org/raw/egovaqocap

[franc00018]

Same issue now with released script: https://paste.yunohost.org/raw/tosalisine

[franc00018]

I was able to fix manually doing these steps:

1. Download the new listmonk executable from GitHub Releases
2. Backup the existing executable /var/www/listmonk/listmonk to listmonk_backup
3. Extract the new executable and replace the existing one
4. Do these steps to fix the PostgreSQL database

In Bash

sudo su -
su postgres
psql

In PostgreSQL

\c listmonk
CREATE EXTENSION pgcrypto;

5. run ./listmonk --upgrade
6. Create user on web application form in browser

Then do the upgrade for the Yunohost app (which does nothing but clears it from upgrades).

[colmoneill]

Hi @franc00018

I'm experiencing the same issue. To your knowledge, does the fix you provided still work in Feb 2025? I need to install listmonk on my YNH instance and I'm hitting the same error on install.

My logs: https://paste.yunohost.org/raw/ovakekitec

Thanks and best regards,

Colm