[01:21:04]
<Yunohost Git/Infra notifications> [dokuwiki_ynh] @yalh76 pushed 1 commit to upgrade: Apply example_ynh https://github.com/YunoHost-Apps/dokuwiki_ynh/commit/da54fe887542cf13acff7833d1889791cca20113
[01:21:04]
<Yunohost Git/Infra notifications> [dokuwiki_ynh] @yalh76 created new branch upgrade
[01:21:32]
<Yunohost Git/Infra notifications> [dokuwiki_ynh] @yalh76 opened pull request #95: Apply example_ynh https://github.com/YunoHost-Apps/dokuwiki_ynh/pull/95
[01:21:44]
<Yunohost Git/Infra notifications> [dokuwiki_ynh] @yalh76 commented on issue #95 Apply example_ynh: testme https://github.com/YunoHost-Apps/dokuwiki_ynh/pull/95#issuecomment-1258846966
[01:21:45]
<Yunohost Git/Infra notifications> [dokuwiki_ynh] @yunohost-bot commented on issue #95 Apply example_ynh: :carousel_horse:
[[Test Badge](https://img.shields.io/endpoint?url=https://ci-apps-dev.yunohost.org/ci/api/job/3491/bad... https://github.com/YunoHost-Apps/dokuwiki_ynh/pull/95#issuecomment-1258846980
[13:16:28]
<eric_G[m]> mariadb becoming unsupported by Mattermost, I am trying to set a migration script from mariadb to postgresql using pgloader. -> https://github.com/YunoHost-Apps/mattermost_ynh/blob/9b31c26db62b64df76881feafb203e621aa809d5/scripts/_common.sh#L14-L38
Of course I am doing something wrong… it is not working.
When trying to upgrade I got this error: https://paste.yunohost.org/raw/jadiyehije
Maybe someone with fresh eyes can spot what is wrong with this script.
[13:33:33]
<Aleks> wtf, this is a yunohost helper returning this message o.O
[13:35:10]
<Aleks> eric_G: somehow `ynh_psql_setup_db` is not happy because the user `mattermost` already exists in postgresql
[13:35:21]
<Aleks> could it be that you previously created it ?
[13:35:29]
<Aleks> (or is it on the CI ?)
[13:35:50]
<Aleks> otherwise there's `ynh_psql_drop_user`
[13:36:22]
<eric_G[m]> no it is on local... and I may have created it 🙄
[13:44:52]
<eric_G[m]> As always, I am testing in my production server... so yes I may have created a Mattermost postgreSQL database without deleting it afterward 😭
[13:46:04]
<Aleks> yes that's not a huge deal : https://github.com/YunoHost/yunohost/blob/6a914fb2b5713caa4f611acb1d162309b90660e8/helpers/postgresql#L214 :P
[13:46:13]
<Aleks> soooo from the command line maybe just:
[13:46:41]
<Aleks> sudo --login --user=postgres psql
[13:46:46]
<Aleks> (to open a psql shell)
[13:46:54]
<Aleks> then just `DROP USER mattermost;` ?
[13:48:35]
<eric_G[m]> I get this :
```
ERROR: role "mattermost" cannot be dropped because some objects depend on it
DETAIL: owner of database mattermost
```
[13:50:32]
<Aleks> eeeeh
[13:50:38]
<Aleks> so gotta drop the db mattermost too i guess
[13:51:18]
<Aleks> `sudo --login --user=postgres dropdb mattermost`
[13:58:07]
<eric_G[m]> Ok, after dropping the postgresql db and launching an update I get the same error.
[13:58:23]
<eric_G[m]> I am using the CI to check if the error persiste : https://ci-apps-dev.yunohost.org/ci/job/3496
[13:59:35]
<Aleks> 😬
[14:00:34]
<Aleks> (side note but figuring out migrating from mysql to postgresql would be great, postgresql always seemed more solid than mysql 👍️)