Invitations don't work after upgrade to v3.0.1

[janlavi]

Hello,

when I try to send invitation via GUI to a site or team I don't receive any email. I tried to send email via default MT with docker compose exec plausible bin/plausible remote and I get this error:

iex(plausible@31af0e6cf234)4> Plausible.Mailer.deliver_now(email)
{:error,
 %Mua.TransportError{
   reason: {:tls_alert,
    {:bad_certificate,
     ~c"TLS client: In state wait_cert_cr at ssl_handshake.erl:2181 generated CLIENT ALERT: Fatal - Bad Certificate\n selfsigned_peer"}}
 }}

SMTP server runs on port 25 with self-signed certificates. In my plausible-conf.env I have this relevant directives:

DISABLE_REGISTRATION=invite_only
[email protected]
SMTP_HOST_ADDR=mailer.xxx.xx
SMTP_HOST_PORT=25
SMTP_RETRIES=2

Then I switched from Mua to SMTPAdapter:

Added to plausible-conf-env this line: EXTRA_CONFIG_PATH=/app/my_config.exs and mounted file my_config.exs to plausible service and line - ./my_config.exs:/app/my_config.exs to plausible service volumes:

import Config

config :plausible, Plausible.Mailer,
  # in v2.1.1 and after this option is called :ssl, see my comment below (https://github.com/plausible/analytics/discussions/4149#discussioncomment-9725329)
  # transport_opts: [middlebox_comp_mode: false]
  adapter: Bamboo.SMTPAdapter,
  server: "mailer.xxx.xx",
  hostname: "plausible.xxx.xx",
  port: 25,
  username: nil,
  password: nil,
  tls: :never,
  ssl: false,
  allowed_tls_versions: [:tlsv1, :"tlsv1.1", :"tlsv1.2"],
  retries: 2,
  no_mx_lookups: true,
  no_verify: true  # <-- Add this to avoid the self-signed cert error

With this config I successfully sent email from docker compose exec plausible bin/plausible remote (elixir) to my mailbox.

The thing is that when I click to send invitation via GUI to a site or team I don't receive any email. I looked to the database and tables like guest_invitations, invitations or team_invitations are empty. In logs there is nothing.

I bet it should be database because when I run my docker-compose.yml on another docker host (but with fresh / empty databases), the invitations are sent successfully.

Is there something wrong with database (I use only default postgres user)? Or with GUI?

Is there a way to add user account to team or site manually? (I tried to add user to table users with hashed password with bcrypt, but didn't succeed to login due to "wrong username or password").

Is it possible to enable verbose logging?