Thursday, July 06, 2023
support@conference.yunohost.org
July
Mon Tue Wed Thu Fri Sat Sun
          1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
           

[03:03:06] <jrkb> amazing, thank you so much for posting this! 🙂
[06:34:48] <sjeremy> Hello, fellow Yunohosters
I am wondering if someone can help me on Ghost's (ghost_ynh) email settings.

1.) Can I use my yunohost email (username@myyunohostdomain.tld) as smtp server for sending magic link (subscribe/login) emails?

2.) If I can, how should I config the Ghost's config.production.json file?

3.) Are there any additional setting I need to change to make it works?
[06:35:51] <Aleks (he/him/il/lui)> behing this, are you meaning that you tried and it doesnt work, and if so, can you elaborate what doesnt work exactly ?
[06:40:50] <sjeremy> > <@Alekswag:matrix.org> behing this, are you meaning that you tried and it doesnt work, and if so, can you elaborate what doesnt work exactly ?

Thanks. I tried:

1) setting the config.production.json with mailgun setting as suggested in the Ghost manual

2) tried using gmail smtp settng

all resulting in same errors:
EmailError: Failed to send email. Reason: Email has been temporarily rejected

[06:41:24] <Aleks (he/him/il/lui)> eeeeh okay, naively I'd rather use something like `ghost@yourdomain.tld` ?
[06:42:23] <Aleks (he/him/il/lui)> it should work, however there's currently an issue ~solved by this PR https://github.com/YunoHost/yunohost/pull/815 such that currently mail sent this way are not authenticated therefore not signed with DKIM hence a higher spam likelihood
[06:42:32] <Aleks (he/him/il/lui)> but shouldnt prevent the mails from at least getting sent
[06:46:59] <sjeremy> Umm! I wondered if it could be an issue specific to Ghost CMS? Because other applications on the same domain (e.g. Wordpress, Backdrop) can send email on behalf of something@myyunohostdomain.tld
[06:49:37] <Aleks (he/him/il/lui)> any app can send emails using something@yourdomain.tld ... but you don't seem to mention that you tried this for Ghost, you only mention trying mailgun and gmail ...
[06:50:27] <sjeremy> > <@Alekswag:matrix.org> any app can send emails using something@yourdomain.tld ... but you don't seem to mention that you tried this for Ghost, you only mention trying mailgun and gmail ...

Sorry for my ambiguity
[06:52:56] <Aleks (he/him/il/lui)> sooooo, does that mean you did try to set something@yourdomain.tld for Ghost too ... ? 🤪
[07:01:22] <sjeremy> > <@Alekswag:matrix.org> sooooo, does that mean you did try to set something@yourdomain.tld for Ghost too ... ? 🤪

Sorry for my delayed response
[07:02:33] <sjeremy> Here is the detail
[07:09:57] <sjeremy> 1. I have a yunohost running on mydomain.tld with few apps (e.g. Wordpress)

2. I installed a Ghost CMS from the Yunohost admin interface to ghostdomain.mydomain.tld

3. The Ghost site at ghostdomain.mydomain.tld was up and running. However, the subscribe and the login functions did not work. When visitor tried to login or subscribe, the site will pop up an error "Failed to send magic link email"

4. I consulted the manual on Ghost documents. https://ghost.org/docs/config/
it sugggests changing the config.production.json file into the following settings and restart ghost

"mail": {
"transport": "SMTP",
"options": {
"service": "Mailgun",
"auth": {
"user": "postmaster@example.mailgun.org",
"pass": "1234567890"
}
}
},

5. After completing step 4. The Ghost refused to restart. The error log said "EmailError: Failed to send email. Reason: Email has been temporarily rejected"

[07:11:08] <sjeremy> > <@sjeremy:mozilla.org> 1. I have a yunohost running on mydomain.tld with few apps (e.g. Wordpress)
>
> 2. I installed a Ghost CMS from the Yunohost admin interface to ghostdomain.mydomain.tld
>
> 3. The Ghost site at ghostdomain.mydomain.tld was up and running. However, the subscribe and the login functions did not work. When visitor tried to login or subscribe, the site will pop up an error "Failed to send magic link email"
>
> 4. I consulted the manual on Ghost documents. https://ghost.org/docs/config/
> it sugggests changing the config.production.json file into the following settings and restart ghost
>
> "mail": {
> "transport": "SMTP",
> "options": {
> "service": "Mailgun",
> "auth": {
> "user": "postmaster@example.mailgun.org",
> "pass": "1234567890"
> }
> }
> },
>
> 5. After completing step 4. The Ghost refused to restart. The error log said "EmailError: Failed to send email. Reason: Email has been temporarily rejected"

6. I tried changing the setting in 4 into gmail, the Ghost still refused to restart with the same error with same error message "EmailError: Failed to send email. Reason: Email has been temporarily rejected"
[07:12:46] <sjeremy> > <@sjeremy:mozilla.org> 6. I tried changing the setting in 4 into gmail, the Ghost still refused to restart with the same error with same error message "EmailError: Failed to send email. Reason: Email has been temporarily rejected"

7. I tried again, changing etting in 4 into something@yourdomain.tld, the Ghost still refused to restart with the same error with same error message "EmailError: Failed to send email. Reason: Email has been temporarily rejected"
[07:13:33] <sjeremy> If any additional info needed please let me know. I'm not quite sure which info would be relevant
[07:15:03] <Aleks (he/him/il/lui)> eeeeh, i'm confused why it would "refuse to start" with some email-related error
[07:15:12] <Aleks (he/him/il/lui)> like does Ghost ... tries to send email when it starts ? x_X
[07:19:00] <sjeremy> > <@Alekswag:matrix.org> like does Ghost ... tries to send email when it starts ? x_X

I'm not quite sure about that.
[07:22:03] <Aleks (he/him/il/lui)> can you share the error message about `Reason: Email has been temporarily rejected` like with maybe the full context so we understand better where it comes from
[07:22:12] <Aleks (he/him/il/lui)> like is it a systemctl error message or ...?
[07:23:58] <sjeremy> > <@Alekswag:matrix.org> can you share the error message about `Reason: Email has been temporarily rejected` like with maybe the full context so we understand better where it comes from

It was from the web ui at yunohost/admin > Tools > Services > ghost
[07:25:46] <Aleks (he/him/il/lui)> alright, but can you share like a couple lines before / after ..?
[07:26:13] <sjeremy> > <@Alekswag:matrix.org> alright, but can you share like a couple lines before / after ..?

Ok
[07:26:18] <sjeremy> Please wait a while
[07:38:45] <Owen> > <@owen:tanti.org.uk> Hi all. I'm getting an error when trying to run migration 26:
> ```
> ERROR - Migration 0026_new_admins_group did not complete, aborting. Error: error during LDAP search operation with: base='cn=admin,dc=yunohost,dc=org', filter='(objectClass=*)', attrs={'userPassword'} and exception {'desc': 'No such object', 'matched': 'dc=yunohost,dc=org'}
> ```
> Can anyone point me in the right direction to fix things?

Any help on this one would be much appreciated
[07:41:30] <sjeremy> > <@Alekswag:matrix.org> alright, but can you share like a couple lines before / after ..?

```
-- Journal begins at Sat 2023-07-01 15:51:43 EEST, ends at Thu 2023-07-06 10:40:36 EEST. --
Jul 02 19:02:18 node[256842]: [2023-07-02 16:02:18] INFO "GET /assets/built/casper.js?v=48e1232ef1" 200 71ms
Jul 02 19:02:19 node[256842]: [2023-07-02 16:02:19] INFO "GET /members/api/member/" 204 3ms
Jul 02 19:02:19 node[256842]: [2023-07-02 16:02:19] INFO "GET /favicon.ico" 200 10ms
Jul 02 19:02:20 node[256842]: [2023-07-02 16:02:20] INFO "GET /ghost/api/content/settings/?key=4c94caf955a647bf3b5b3d3d2f&limit=all" 200 60ms
Jul 02 19:02:20 node[256842]: [2023-07-02 16:02:20] INFO "GET /ghost/api/content/newsletters/?key=4c94caf955a647bf3b5b3d3d2f&limit=all" 200 65ms
Jul 02 19:02:20 node[256842]: [2023-07-02 16:02:20] INFO "GET /ghost/api/content/tiers/?key=4c94caf955a647bf3b5b3d3d2f&limit=all&include=monthly_price,yearly_price,benefits" 200 81ms
Jul 02 19:02:42 node[256842]: [2023-07-02 16:02:42] ERROR "POST /members/api/send-magic-link/" 500 232ms
Jul 02 19:02:42 node[256842]:
Jul 02 19:02:42 node[256842]: Failed to send email. Reason: Email has been temporarily rejected.
Jul 02 19:02:42 node[256842]: "Please see https://ghost.org/docs/config/#mail for instructions on configuring email."
Jul 02 19:02:42 node[256842]: Error ID:
Jul 02 19:02:42 node[256842]: e0882db0-18f1-11ee-b78d-9fa8fa9a8d6f
Jul 02 19:02:42 node[256842]: ----------------------------------------
Jul 02 19:02:42 node[256842]: EmailError: Failed to send email. Reason: Email has been temporarily rejected.
Jul 02 19:02:42 node[256842]: at createMailError (/var/www/ghost/ghost/versions/5.44.0/core/server/services/mail/GhostMailer.js:68:12)
Jul 02 19:02:42 node[256842]: at GhostMailer.handleDirectTransportResponse (/var/www/ghost/ghost/versions/5.44.0/core/server/services/mail/GhostMailer.js:158:19)
Jul 02 19:02:42 node[256842]: at GhostMailer.send (/var/www/ghost/ghost/versions/5.44.0/core/server/services/mail/GhostMailer.js:120:25)
Jul 02 19:02:42 node[256842]: at processTicksAndRejections (node:internal/process/task_queues:96:5)
Jul 02 19:02:42 node[256842]: at async MagicLink.sendMagicLink (/var/www/ghost/ghost/versions/5.44.0/node_modules/@tryghost/magic-link/lib/MagicLink.js:71:22)
Jul 02 19:02:42 node[256842]: at async RouterController.sendMagicLink (/var/www/ghost/ghost/versions/5.44.0/node_modules/@tryghost/members-api/lib/controllers/router.js:374:17)
Jul 02 19:02:42 node[256842]: at async /var/www/ghost/ghost/versions/5.44.0/node_modules/@tryghost/members-api/lib/MembersAPI.js:309:13
Jul 02 19:02:42 node[256842]:
Jul 02 19:05:01 node[256842]: [2023-07-02 16:05:01] INFO "GET //ghost" 301 1ms
Jul 02 19:05:01 node[256842]: [2023-07-02 16:05:01] INFO "GET /ghost/" 200 30ms
Jul 02 19:05:02 node[256842]: [2023-07-02 16:05:02] INFO "GET /ghost/api/admin/users/me/?include=roles" 200 121ms
Jul 02 19:05:02 node[256842]: [2023-07-02 16:05:02] INFO "GET /ghost/api/admin/site/" 200 7ms
Jul 02 19:05:03 node[256842]: [2023-07-02 16:05:03] INFO "GET /ghost/api/admin/config/" 200 70ms
Jul 02 19:05:03 node[256842]: [2023-07-02 16:05:03] INFO "GET /ghost/api/admin/settings/?group=site%2Ctheme%2Cprivate%2Cmembers%2Cportal%2Cnewsletter%2Cemail%2Camp%2Clabs%2Cslack%2Cunsplash%2Cviews%2Cfirstpromoter%2Ceditor%2Ccomments%2Canalytics" 200 222ms
Jul 02 19:05:03 node[256842]: [2023-07-02 16:05:03] INFO "GET /ghost/api/admin/tiers/?filter=type%3Apaid%2Bactive%3Atrue&limit=all" 200 246ms
Jul 02 19:05:03 node[256842]: [2023-07-02 16:05:03] INFO "GET /ghost/api/admin/themes/active/" 200 90ms
Jul 02 19:05:03 node[256842]: [2023-07-02 16:05:03] INFO "GET /ghost/api/admin/notifications/" 200 100ms
Jul 02 19:05:03 node[256842]: [2023-07-02 16:05:03] INFO "GET /ghost/api/admin/stats/member_count/" 200 91ms
Jul 02 19:05:04 node[256842]: [2023-07-02 16:05:04] INFO "GET /ghost/assets/img/user-image-639a88b784fb5f10964be8b975ca9fdf.png" 200 7ms
Jul 02 19:05:04 node[256842]: [2023-07-02 16:05:04] INFO "GET /ghost/" 200 49ms
Jul 02 19:05:04 node[256842]: [2023-07-02 16:05:04] INFO "GET /ghost/assets/img/community-background-3f501ff1d764d0cb81f7c2cbacfc6503.jpg" 200 41ms
Jul 02 19:05:04 node[256842]: [2023-07-02 16:05:04] INFO "GET /ghost/api/admin/stats/member_count/" 200 699ms
Jul 02 19:05:04 node[256842]: [2023-07-02 16:05:04] INFO "GET /ghost/api/admin/stats/referrers/" 200 851ms
Jul 02 19:05:05 node[256842]: [2023-07-02 16:05:05] INFO "GET /ghost/api/admin/members/?filter=last_seen_at%3A%3E2023-06-01T17%3A00%3A00.000Z&limit=1&page=1&include=newsletters%2Clabels" 200 797ms
Jul 02 19:05:05 node[256842]: [2023-07-02 16:05:05] INFO "GET /ghost/api/admin/members/?filter=last_seen_at%3A%3E2023-06-24T17%3A00%3A00.000Z&limit=1&page=1&include=newsletters%2Clabels" 200 818ms
Jul 02 19:05:05 node[256842]: [2023-07-02 16:05:05] INFO "GET /ghost/api/admin/members/?filter=newsletters.status%3Aactive%2Bstatus%3A-free&limit=1&page=1&include=newsletters%2Clabels" 200 839ms
Jul 02 19:05:05 node[256842]: [2023-07-02 16:05:05] INFO "GET /ghost/api/admin/members/?filter=newsletters.status%3Aactive%2Bstatus%3Afree&limit=1&page=1&include=newsletters%2Clabels" 200 832ms
Jul 02 19:05:05 node[256842]: [2023-07-02 16:05:05] INFO "GET /ghost/api/admin/posts/?formats=mobiledoc%2Clexical&limit=5&filter=status%3A%5Bpublished%2Csent%5D&order=published_at%20desc" 200 890ms
Jul 02 19:05:05 node[256842]: [2023-07-02 16:05:05] INFO "GET /ghost/api/admin/stats/member_count/" 200 57ms
Jul 02 19:05:35 node[256842]: [2023-07-02 16:05:35] WARN Ghost is shutting down
Jul 02 19:05:35 systemd[1]: Stopping ghost systemd service...
Jul 02 19:05:36 node[256842]: [2023-07-02 16:05:35] WARN Ghost has shut down
Jul 02 19:05:36 node[256842]: [2023-07-02 16:05:35] WARN Your site is now offline
Jul 02 19:05:36 node[256842]: [2023-07-02 16:05:35] WARN Ghost was running for 11 minutes
Jul 02 19:05:36 systemd[1]: ghost.service: Succeeded.
Jul 02 19:05:36 systemd[1]: Stopped ghost systemd service
```
[07:52:27] <Aleks (he/him/il/lui)> > <@owen:tanti.org.uk> Any help on this one would be much appreciated

Sounds like theres no admin on your system, can you elaborate on the cobtext, like maybe you restored a backup or something...
[07:54:03] <Aleks (he/him/il/lui)> > <@sjeremy:mozilla.org> ```
> -- Journal begins at Sat 2023-07-01 15:51:43 EEST, ends at Thu 2023-07-06 10:40:36 EEST. --
> Jul 02 19:02:18 node[256842]: [2023-07-02 16:02:18] INFO "GET /assets/built/casper.js?v=48e1232ef1" 200 71ms
> Jul 02 19:02:19 node[256842]: [2023-07-02 16:02:19] INFO "GET /members/api/member/" 204 3ms
> Jul 02 19:02:19 node[256842]: [2023-07-02 16:02:19] INFO "GET /favicon.ico" 200 10ms
> Jul 02 19:02:20 node[256842]: [2023-07-02 16:02:20] INFO "GET /ghost/api/content/settings/?key=4c94caf955a647bf3b5b3d3d2f&limit=all" 200 60ms
> Jul 02 19:02:20 node[256842]: [2023-07-02 16:02:20] INFO "GET /ghost/api/content/newsletters/?key=4c94caf955a647bf3b5b3d3d2f&limit=all" 200 65ms
> Jul 02 19:02:20 node[256842]: [2023-07-02 16:02:20] INFO "GET /ghost/api/content/tiers/?key=4c94caf955a647bf3b5b3d3d2f&limit=all&include=monthly_price,yearly_price,benefits" 200 81ms
> Jul 02 19:02:42 node[256842]: [2023-07-02 16:02:42] ERROR "POST /members/api/send-magic-link/" 500 232ms
> Jul 02 19:02:42 node[256842]:
> Jul 02 19:02:42 node[256842]: Failed to send email. Reason: Email has been temporarily rejected.
> Jul 02 19:02:42 node[256842]: "Please see https://ghost.org/docs/config/#mail for instructions on configuring email."
> Jul 02 19:02:42 node[256842]: Error ID:
> Jul 02 19:02:42 node[256842]: e0882db0-18f1-11ee-b78d-9fa8fa9a8d6f
> Jul 02 19:02:42 node[256842]: ----------------------------------------
> Jul 02 19:02:42 node[256842]: EmailError: Failed to send email. Reason: Email has been temporarily rejected.
> Jul 02 19:02:42 node[256842]: at createMailError (/var/www/ghost/ghost/versions/5.44.0/core/server/services/mail/GhostMailer.js:68:12)
> Jul 02 19:02:42 node[256842]: at GhostMailer.handleDirectTransportResponse (/var/www/ghost/ghost/versions/5.44.0/core/server/services/mail/GhostMailer.js:158:19)
> Jul 02 19:02:42 node[256842]: at GhostMailer.send (/var/www/ghost/ghost/versions/5.44.0/core/server/services/mail/GhostMailer.js:120:25)
> Jul 02 19:02:42 node[256842]: at processTicksAndRejections (node:internal/process/task_queues:96:5)
> Jul 02 19:02:42 node[256842]: at async MagicLink.sendMagicLink (/var/www/ghost/ghost/versions/5.44.0/node_modules/@tryghost/magic-link/lib/MagicLink.js:71:22)
> Jul 02 19:02:42 node[256842]: at async RouterController.sendMagicLink (/var/www/ghost/ghost/versions/5.44.0/node_modules/@tryghost/members-api/lib/controllers/router.js:374:17)
> Jul 02 19:02:42 node[256842]: at async /var/www/ghost/ghost/versions/5.44.0/node_modules/@tryghost/members-api/lib/MembersAPI.js:309:13
> Jul 02 19:02:42 node[256842]:
> Jul 02 19:05:01 node[256842]: [2023-07-02 16:05:01] INFO "GET //ghost" 301 1ms
> Jul 02 19:05:01 node[256842]: [2023-07-02 16:05:01] INFO "GET /ghost/" 200 30ms
> Jul 02 19:05:02 node[256842]: [2023-07-02 16:05:02] INFO "GET /ghost/api/admin/users/me/?include=roles" 200 121ms
> Jul 02 19:05:02 node[256842]: [2023-07-02 16:05:02] INFO "GET /ghost/api/admin/site/" 200 7ms
> Jul 02 19:05:03 node[256842]: [2023-07-02 16:05:03] INFO "GET /ghost/api/admin/config/" 200 70ms
> Jul 02 19:05:03 node[256842]: [2023-07-02 16:05:03] INFO "GET /ghost/api/admin/settings/?group=site%2Ctheme%2Cprivate%2Cmembers%2Cportal%2Cnewsletter%2Cemail%2Camp%2Clabs%2Cslack%2Cunsplash%2Cviews%2Cfirstpromoter%2Ceditor%2Ccomments%2Canalytics" 200 222ms
> Jul 02 19:05:03 node[256842]: [2023-07-02 16:05:03] INFO "GET /ghost/api/admin/tiers/?filter=type%3Apaid%2Bactive%3Atrue&limit=all" 200 246ms
> Jul 02 19:05:03 node[256842]: [2023-07-02 16:05:03] INFO "GET /ghost/api/admin/themes/active/" 200 90ms
> Jul 02 19:05:03 node[256842]: [2023-07-02 16:05:03] INFO "GET /ghost/api/admin/notifications/" 200 100ms
> Jul 02 19:05:03 node[256842]: [2023-07-02 16:05:03] INFO "GET /ghost/api/admin/stats/member_count/" 200 91ms
> Jul 02 19:05:04 node[256842]: [2023-07-02 16:05:04] INFO "GET /ghost/assets/img/user-image-639a88b784fb5f10964be8b975ca9fdf.png" 200 7ms
> Jul 02 19:05:04 node[256842]: [2023-07-02 16:05:04] INFO "GET /ghost/" 200 49ms
> Jul 02 19:05:04 node[256842]: [2023-07-02 16:05:04] INFO "GET /ghost/assets/img/community-background-3f501ff1d764d0cb81f7c2cbacfc6503.jpg" 200 41ms
> Jul 02 19:05:04 node[256842]: [2023-07-02 16:05:04] INFO "GET /ghost/api/admin/stats/member_count/" 200 699ms
> Jul 02 19:05:04 node[256842]: [2023-07-02 16:05:04] INFO "GET /ghost/api/admin/stats/referrers/" 200 851ms
> Jul 02 19:05:05 node[256842]: [2023-07-02 16:05:05] INFO "GET /ghost/api/admin/members/?filter=last_seen_at%3A%3E2023-06-01T17%3A00%3A00.000Z&limit=1&page=1&include=newsletters%2Clabels" 200 797ms
> Jul 02 19:05:05 node[256842]: [2023-07-02 16:05:05] INFO "GET /ghost/api/admin/members/?filter=last_seen_at%3A%3E2023-06-24T17%3A00%3A00.000Z&limit=1&page=1&include=newsletters%2Clabels" 200 818ms
> Jul 02 19:05:05 node[256842]: [2023-07-02 16:05:05] INFO "GET /ghost/api/admin/members/?filter=newsletters.status%3Aactive%2Bstatus%3A-free&limit=1&page=1&include=newsletters%2Clabels" 200 839ms
> Jul 02 19:05:05 node[256842]: [2023-07-02 16:05:05] INFO "GET /ghost/api/admin/members/?filter=newsletters.status%3Aactive%2Bstatus%3Afree&limit=1&page=1&include=newsletters%2Clabels" 200 832ms
> Jul 02 19:05:05 node[256842]: [2023-07-02 16:05:05] INFO "GET /ghost/api/admin/posts/?formats=mobiledoc%2Clexical&limit=5&filter=status%3A%5Bpublished%2Csent%5D&order=published_at%20desc" 200 890ms
> Jul 02 19:05:05 node[256842]: [2023-07-02 16:05:05] INFO "GET /ghost/api/admin/stats/member_count/" 200 57ms
> Jul 02 19:05:35 node[256842]: [2023-07-02 16:05:35] WARN Ghost is shutting down
> Jul 02 19:05:35 systemd[1]: Stopping ghost systemd service...
> Jul 02 19:05:36 node[256842]: [2023-07-02 16:05:35] WARN Ghost has shut down
> Jul 02 19:05:36 node[256842]: [2023-07-02 16:05:35] WARN Your site is now offline
> Jul 02 19:05:36 node[256842]: [2023-07-02 16:05:35] WARN Ghost was running for 11 minutes
> Jul 02 19:05:36 systemd[1]: ghost.service: Succeeded.
> Jul 02 19:05:36 systemd[1]: Stopped ghost systemd service
> ```

Mokay so it's not "when it starts", it's " when you ask Ghost to send the magic link" if i understand correctly
[07:55:16] <Aleks (he/him/il/lui)> I guess we could try to dig the issue by retriggering it, and then immediately check for new lines in /var/log/mail.*
[07:55:46] <Aleks (he/him/il/lui)> Like using `tail -n 10 /var/log/mail.*`
[07:56:03] <Aleks (he/him/il/lui)> Zblerg, cant write proper markdown from phone
[07:58:49] <sjeremy> I'm trying to retriggering it
[07:59:03] <sjeremy> Thank you all so much
[07:59:14] <sjeremy> for today
[08:04:11] <Owen> > <@Alekswag:matrix.org> Sounds like theres no admin on your system, can you elaborate on the cobtext, like maybe you restored a backup or something...

There's an admin user and yes I had to do a restore some while ago when I changed hardware.
[08:23:56] <Owen> everything works fine but there's this outstanding migration and it won't run.
[08:31:37] <olivier_test> hello, I broke my synapse install by upgrading it minutes ago : https://paste.yunohost.org/sunorimuxe.sql
[08:32:15] <olivier_test> that duplicate key thing somehow sound familiar, and I'm pretty sure it could be fixed by tackling pgsql directly, but before trying to do anything reckless I'd rather know if there's a known fix already
[08:33:53] <Aleks (he/him/il/lui)> > <@owen:tanti.org.uk> everything works fine but there's this outstanding migration and it won't run.

soooo like could it be that you restored a 11.1 backup on top of an older version
[08:42:22] <Owen> I don't think so. I was actually rebuilding the same hardware, so I brought everything up to date, ran a back up, rebuilt the server and restored - so I think it would all have been the same version.
[09:05:59] <olivier_test> this is weird (following up on my pgsql constraint issue) : apparently, there IS a constraint on unicity (`"profiles_full_user_id_key" UNIQUE, btree (full_user_id)`), but currently no record in `profiles` have a `full_user_id` ; some of my (less active users) I've managed to manually set the full_user_id ; some of my most active - myself included - can't be told to take ANY full_user_id...
[09:06:19] <olivier_test> I can't see where the unicity violation comes from...
[09:17:05] <olivier_test> I'm trying to remove (temporarily) said constraint, but : ```matrix\_synapse=# ALTER TABLE profiles ADD CONSTRAINT "profiles\_full\_user\_id\_key" UNIQUE (full\_user\_id);
ERROR: relation "profiles\_full\_user\_id\_key" already exists
matrix\_synapse=# ALTER TABLE profiles DROP CONSTRAINT "profiles\_full\_user\_id\_key";
ERROR: constraint "profiles\_full\_user\_id\_key" of relation "profiles" does not exist```
[09:17:42] <olivier_test> I'm trying to remove (temporarily) said constraint, but :
> matrix\_synapse=# ALTER TABLE profiles ADD CONSTRAINT "profiles\_full\_user\_id\_key" UNIQUE (full\_user\_id);
> ERROR: relation "profiles\_full\_user\_id\_key" already exists
> matrix\_synapse=# ALTER TABLE profiles DROP CONSTRAINT "profiles\_full\_user\_id\_key";
> ERROR: constraint "profiles\_full\_user\_id\_key" of relation "profiles" does not exist`
[09:32:06] <olivier_test> ok, from what I gathered so far, it's because it's NOT a TABLE CONSTRAINT per se, but an INDEX with a UNIQUE constraint on it ; managed to remove it and the service finished starting ; so basically it's fixed(-ish). And now I need to get my UNIQUE INDEX back on my base, and I have almost every record duplicated on `profiles`, and in some particularly ugly cases, both lines are definitely indentical
[09:32:25] <olivier_test> at that point, it'd be easier to just delete and recreate them (which I might eventually do, now to think of it)
[09:33:33] <olivier_test> and....done!
[11:50:06] <amu> Hi. The "edit" button on the website takes you to a *404 - page not found*

[11:53:18] <tituspijean[m]> > <amu> Hi. The "edit" button on the website takes you to a *404 - page not found*

which page?
[12:02:27] <orhtej2> > <amu> Hi. The "edit" button on the website takes you to a *404 - page not found*

assuming it's some doc it should take you here: https://github.com/YunoHost/doc
[12:02:51] <amu> I've tried with several, they all gave me a 404
[12:04:29] <orhtej2> > <amu> I've tried with several, they all gave me a 404

still, what page for example?
[12:05:08] <amu> Yes, https://yunohost.org/en
[12:17:26] <tituspijean[m]> OK, it is a known problem and we do not expect visitors to suggest modifications of the frontpage. 🙂 Documentation Edit links work though. 🙂
[15:38:21] <ParanoSprite> Bonjour tout le monde
[15:40:43] <ParanoSprite> Petite question (je n'ai pas encore cherché sur le net ...), dans la sauvegarde standard de YunoHost, a quoi correspond la sauvegarde de "hook_data_multimedia" SVP ?
[15:42:23] <ParanoSprite> et "hook_data_multimedia_desc" qui fait partie de la même sauvegarde ?
[15:51:10] <sebarosanul> https://paste.yunohost.org/raw/uxogemuzoz
[15:55:45] <sebarosanul> The dns records aren't getting updated.
[16:01:10] <Aleks (he/him/il/lui)> > <@ParanoSprite:libera.chat> Petite question (je n'ai pas encore cherché sur le net ...), dans la sauvegarde standard de YunoHost, a quoi correspond la sauvegarde de "hook_data_multimedia" SVP ?

ça corresponds à un message manquant :D
[16:01:31] <Aleks (he/him/il/lui)> mais sinon c'est les données multimédia stockées dans /home/yunohost.multimedia
[17:09:43] <tolot> Hello everyone and thanks for the brilliant work with the Yunohost project. I'm struggling a bit with the installation of the Headscale app, the logs say that "...the asset doesn't match the expected checksum." Is there someone here that faced the same problem and can give me an advice on how to solve it? Thanks a lot
[17:16:13] <tituspijean[m]> Damn, I think Github has started sneakily changing their compression system again, and that changes the checksums
[17:17:42] <tituspijean[m]> I'll have a look later tonight. Bear in mind (but I think the catalog shows the warning), headscale is still not fully tested for YunoHost.
[17:21:26] <Aleks (he/him/il/lui)> > <@titus:pijean.ovh> Damn, I think Github has started sneakily changing their compression system again, and that changes the checksums

eeeeh
[17:30:39] <tolot> > I'll have a look later tonight. Bear in mind (but I think the catalog shows the warning), headscale is still not fully tested for YunoHost.
Yep, I read through the warnings. Thanks for reminding me that
[17:32:08] <tituspijean[m]> I'll ping you when it's fixed. ;)

If you end up satisfied with headscale feel free to share your experience and setup :)
[18:50:30] <tituspijean[m]> tolot fixed!
[22:17:57] <hayden> Would anyone be able to help me with this?
[22:21:43] <tolot> > tolot fixed!
Brilliant!!! Thanks a lot
[22:22:04] <tolot> > I'll ping you when it's fixed. ;)
>
> If you end up satisfied with headscale feel free to share your experience and setup :)
Yepp, I wil try and report back the feedbacks
[22:32:41] <tituspijean[m]> hayden's message for Matrix users :

> It seems that there's something weird going on with SSOWat and Mastodon to where I can't log in from anything but the browser session I installed Mastodon with
[22:34:17] <Chatpitaine Caverne> > <@hayden:libera.chat> Would anyone be able to help me with this?

Or we missed messages, or it's not clear.
[22:35:48] <hayden> Yeah, sorry, just gotten a lil frustrated banging my head against this for a few hours lol
[22:40:15] <hayden> But basically it looks like the Mastodon package just isn’t playing nicely with SSOWat. To be honest, I’d kinda like to just disable it for Mastodon so I can manage the users within Mastodon itself