Every time I try to invite someone to a brand new instance, an error is thrown and the user is not invited

[CADawg]

Just spun up a brand new instance of plausible with the following command:

docker compose -f docker-compose.yml -f reverse-proxy/docker-compose.caddy-gen.yml up -d

And the web app is timing out every time I try to invite someone (request takes 1min and then fails) - attached below are the logs at the time of the incident.

My Plausible Env Config is as follows:

BASE_URL=https://a.dbuidl.com
SECRET_KEY_BASE=***
TOTP_VAULT_KEY=***
DISABLE_REGISTRATION=invite_only
SMTP_HOST_ADDR=box.dbuidl.com
SMTP_HOST_PORT=465
SMTP_USER_NAME=***@dbuidl.com
SMTP_USER_PWD=***
MAILER_NAME=Plausible
MAILER_EMAIL=***@dbuidl.com

Most recent docker logs at time of issue:

plausible-1            | Migration done!
plausible-1            | Migrations successful!
plausible-1            | 23:06:00.517 [error] GenServer :tzdata_release_updater terminating
plausible-1            | ** (ArgumentError) errors were found at the given arguments:
plausible-1            | 
plausible-1            |   * 2nd argument: not a tuple
plausible-1            | 
plausible-1            |     :erlang.element(1, :error)
plausible_events_db-1  | Processing configuration file '/etc/clickhouse-server/config.xml'.
plausible_events_db-1  | Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
plausible_events_db-1  | Merging configuration file '/etc/clickhouse-server/config.d/logging.xml'.
plausible_events_db-1  | Logging warning to /var/log/clickhouse-server/clickhouse-server.log
plausible_events_db-1  | Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
plausible_events_db-1  | 2024.09.16 23:05:37.401197 [ 1 ] {} <Warning> Context: Delay accounting is not enabled, OSIOWaitMicroseconds will not be gathered. You can enable it using `echo 1 > /proc/sys/kernel/task_delayacct` or by using sysctl.
plausible_events_db-1  | 2024.09.16 23:05:37.561495 [ 1 ] {} <Error> Application: Disabling cgroup memory observer because of an error during initialization: Code: 107. DB::Exception: Cannot find cgroups v1 or v2 current memory file. (FILE_DOESNT_EXIST), Stack trace (when copying this message, always include the lines below):
plausible_events_db-1  | 
plausible_events_db-1  | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cbc851b
plausible_events_db-1  | 1. DB::Exception::Exception<>(int, FormatStringHelperImpl<>) @ 0x00000000076614c3
plausible_events_db-1  | 2. DB::CgroupsMemoryUsageObserver::CgroupsMemoryUsageObserver(std::chrono::duration<long long, std::ratio<1l, 1l>>) @ 0x000000000cce452e
plausible_events_db-1  | 3. DB::Server::main(std::vector<String, std::allocator<String>> const&) @ 0x000000000cd562bd
plausible_events_db-1  | 4. Poco::Util::Application::run() @ 0x0000000014ca8606
plausible_events_db-1  | 5. DB::Server::run() @ 0x000000000cd46671
plausible_events_db-1  | 6. Poco::Util::ServerApplication::run(int, char**) @ 0x0000000014cb14b9
plausible_events_db-1  | 7. mainEntryClickHouseServer(int, char**) @ 0x000000000cd4246a
plausible_events_db-1  | 8. main @ 0x0000000007651578
plausible_events_db-1  | 9. ? @ 0x00007aeef59ee083
plausible_events_db-1  | 10. _start @ 0x0000000005dee46e
plausible_events_db-1  |  (version 24.3.3.102 (official build))
plausible_events_db-1  | 2024.09.16 23:05:37.653764 [ 1 ] {} <Warning> Application: Listen [::]:9009 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
plausible_events_db-1  | 2024.09.16 23:05:37.663539 [ 1 ] {} <Warning> Access(local_directory): File /var/lib/clickhouse/access/users.list doesn't exist
plausible_events_db-1  | 2024.09.16 23:05:37.663577 [ 1 ] {} <Warning> Access(local_directory): Recovering lists in directory /var/lib/clickhouse/access/
plausible_events_db-1  | 2024.09.16 23:05:37.704852 [ 1 ] {} <Warning> Application: Listen [::]:8123 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
plausible_events_db-1  | 2024.09.16 23:05:37.705078 [ 1 ] {} <Warning> Application: Listen [::]:9000 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
plausible_events_db-1  | 2024.09.16 23:05:37.705245 [ 1 ] {} <Warning> Application: Listen [::]:9004 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
plausible_events_db-1  | 2024.09.16 23:05:37.705493 [ 1 ] {} <Warning> Application: Listen [::]:9005 failed: Poco::Exception. Code: 1000, e.code() = 0, DNS error: EAI: Address family for hostname not supported (version 24.3.3.102 (official build)). If it is an IPv6 or IPv4 address and your host has disabled IPv6 or IPv4, then consider to specify not disabled IPv4 or IPv6 address to listen in <listen_host> element of configuration file. Example for disabled IPv6: <listen_host>0.0.0.0</listen_host> . Example for disabled IPv4: <listen_host>::</listen_host>
plausible_events_db-1  | 2024.09.16 23:05:47.993384 [ 49 ] {} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
plausible_events_db-1  | 
plausible_events_db-1  | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cbc851b
plausible_events_db-1  | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x0000000007654b03
plausible_events_db-1  | 2. DB::DatabaseCatalog::assertDatabaseExists(String const&) const @ 0x000000001055538e
plausible_events_db-1  | 3. DB::Context::setCurrentDatabase(String const&) @ 0x000000001049dc32
plausible_events_db-1  | 4. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&, StrongTypedef<unsigned long, ProfileEvents::EventTag> const&) @ 0x00000000122ef386
plausible_events_db-1  | 5. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&, StrongTypedef<unsigned long, ProfileEvents::EventTag> const&) @ 0x00000000122f4b34
plausible_events_db-1  | 6. DB::HTTPServerConnection::run() @ 0x00000000123740da
plausible_events_db-1  | 7. Poco::Net::TCPServerConnection::start() @ 0x0000000014c9b8d2
plausible_events_db-1  | 8. Poco::Net::TCPServerDispatcher::run() @ 0x0000000014c9c719
plausible_events_db-1  | 9. Poco::PooledThread::run() @ 0x0000000014d94e81
plausible_events_db-1  | 10. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000014d9341d
plausible_events_db-1  | 11. ? @ 0x00007aeef5bc4609
plausible_events_db-1  | 12. ? @ 0x00007aeef5ae9353
plausible_events_db-1  |  (version 24.3.3.102 (official build))
plausible_events_db-1  | 2024.09.16 23:05:47.994167 [ 48 ] {} <Error> DynamicQueryHandler: Code: 81. DB::Exception: Database plausible_events_db does not exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
plausible_events_db-1  | 
plausible_events_db-1  | 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000cbc851b
plausible_events_db-1  | 1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x0000000007654b03
plausible_events_db-1  | 2. DB::DatabaseCatalog::assertDatabaseExists(String const&) const @ 0x000000001055538e
plausible_events_db-1  | 3. DB::Context::setCurrentDatabase(String const&) @ 0x000000001049dc32
plausible_events_db-1  | 4. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::optional<DB::CurrentThread::QueryScope>&, StrongTypedef<unsigned long, ProfileEvents::EventTag> const&) @ 0x00000000122ef386
plausible_events_db-1  | 5. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&, StrongTypedef<unsigned long, ProfileEvents::EventTag> const&) @ 0x00000000122f4b34
plausible_events_db-1  | 6. DB::HTTPServerConnection::run() @ 0x00000000123740da
plausible_events_db-1  | 7. Poco::Net::TCPServerConnection::start() @ 0x0000000014c9b8d2
plausible_events_db-1  | 8. Poco::Net::TCPServerDispatcher::run() @ 0x0000000014c9c719
plausible-1            |     (tzdata 1.1.1) lib/tzdata/util.ex:223: Tzdata.Util.to_int/1
plausible-1            |     (tzdata 1.1.1) lib/tzdata/parser.ex:38: Tzdata.Parser.process_rule/1
plausible-1            |     (tzdata 1.1.1) lib/tzdata/parser.ex:24: Tzdata.Parser.process_tz_list/1
plausible-1            |     (tzdata 1.1.1) lib/tzdata/parser.ex:86: Tzdata.Parser.process_zone/5
plausible-1            |     (tzdata 1.1.1) lib/tzdata/parser.ex:24: Tzdata.Parser.process_tz_list/1
plausible-1            |     (tzdata 1.1.1) lib/tzdata/parser.ex:86: Tzdata.Parser.process_zone/5
plausible-1            |     (tzdata 1.1.1) lib/tzdata/parser.ex:24: Tzdata.Parser.process_tz_list/1
plausible-1            | Last message: :check_if_time_to_update
plausible_events_db-1  | 9. Poco::PooledThread::run() @ 0x0000000014d94e81
plausible_events_db-1  | 10. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000014d9341d
plausible_events_db-1  | 11. ? @ 0x00007aeef5bc4609
plausible_events_db-1  | 12. ? @ 0x00007aeef5ae9353
plausible_events_db-1  |  (version 24.3.3.102 (official build))

[ruslandoga]

👋 @CADawg

Port 465 uses SMTPS. You need to specify it in the config. Or you can use port 587, as that's what is usually used for relays.

See: https://github.com/plausible/community-edition/tree/v2.1.1#smtp_host_ssl_enabled

[ruslandoga]

More info on SMTP ports:

• https://sendgrid.com/en-us/blog/whats-the-difference-between-ports-465-and-587
• https://www.mailgun.com/blog/email/which-smtp-port-understanding-ports-25-465-587/

[CADawg]

🤦 that makes sense - my mail server only accepts SMTPS, just didn't realise there was a flag for it - thanks for your help!