[Bug] Can't log into console admin with fresh self-hosted deployment even with default config: HTTP 200 status message: "Invalid email or password" statusCode: "404"

[meetnick]

Bug Description

I just got exhausted after spending a whole day trying to deploy a fresh install of self-hosted appflowy with no luck. I keep getting the same error:

Steps to reproduce:

1. access http://:/console
2. Enter GOTRUE admin username and password
3. Press login

Results: Modal says: "An unexpected error occurred. Please try again." (See attached screenshot)

Login POST says HTTP Status 200, however response body says "Invalid email or password" with statusCode 404.
I used default username and password: admin@example.com and password

| NOTE: As you can see in the logs below, the only difference is running nginx with ports 82 and 8443 since I have a nginx-proxy-manager instance running on 80. However, I already tried running it in a different machine with nginx at port 80/443 and same results.

What I've tried so far

1. I also tried installing in another machine using nginx at port 80, but same results.Because the server I was planning to host already have nginx-proxy-manager at 80.
2. Different custom and simple (without special characteres) admin email and passwords

How to Reproduce

1. Access http://:/console
2. Enter GOTRUE admin username and password
3. Press login

Expected Behavior

Successful login to admin console is what I would expect.

Operating System

Fedora / Mac OS

AppFlowy Version(s)

docker latest: AppFlowy Cloud version:0.12.2 | Admin frontend Version: 0.12.2 | AI "Server version: "0.10.2"

Screenshots

Additional Context

Request Payload:

POST /console/login HTTP/1.1
Accept: text/x-component
Accept-Encoding: gzip, deflate
Accept-Language: pt-BR,pt;q=0.9
Cache-Control: no-cache
Connection: keep-alive
Content-Length: 53
Content-Type: text/plain;charset=UTF-8
Host: 192.168.191.21:82
Origin: http://192.168.191.21:82
Pragma: no-cache
Referer: http://192.168.191.21:82/console/login
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36
next-action: 40329874513bd5cf54682a97b1d9038624de83aace
next-router-state-tree: %5B%22%22%2C%7B%22children%22%3A%5B%22login%22%2C%7B%22children%22%3A%5B%22__PAGE__%22%2C%7B%7D%2Cnull%2Cnull%5D%7D%2Cnull%2Cnull%5D%7D%2Cnull%2Cnull%2Ctrue%5D
[
    {
        "email": "admin@example.com",
        "password": "password"
    }
]

Response:

0:{"a":"$@1","f":"","b":"7CMAmARe21ZW4v0rs1Rhv"}
1:{"success":false,"error":{"message":"Invalid email or password","type":"UNKNOWN","statusCode":404}}

Full logs:

WARN[0000] The "APPFLOWY_S3_REGION" variable is not set. Defaulting to a blank string.
WARN[0000] The "APPFLOWY_S3_REGION" variable is not set. Defaulting to a blank string.
WARN[0000] The "AZURE_OPENAI_API_KEY" variable is not set. Defaulting to a blank string.
WARN[0000] The "AZURE_OPENAI_ENDPOINT" variable is not set. Defaulting to a blank string.
WARN[0000] The "AZURE_OPENAI_API_VERSION" variable is not set. Defaulting to a blank string.
WARN[0000] The "APPFLOWY_S3_REGION" variable is not set. Defaulting to a blank string.
admin_frontend-1   | =========================================
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.731766Z","level":"INFO","fields":{"message":"config loaded: Config { app_env: Production, redis_url: \"redis://redis:6379\", db_settings: DatabaseSetting { pg_conn_opts: PgConnectOptions { host: \"postgres\", port: 5432, socket: None, username: \"postgres\", password: Some(\"password\"), database: Some(\"appflowy\"), ssl_mode: Prefer, ssl_root_cert: None, ssl_client_cert: None, ssl_client_key: None, statement_cache_capacity: 100, application_name: None, log_settings: LogSettings { statements_level: Debug, slow_statements_level: Warn, slow_statements_duration: 1s }, extra_float_digits: Some(\"2\"), options: None }, require_ssl: false, max_connections: 10, database_name: \"appflowy\" }, s3_setting: S3Setting { create_bucket: true, use_minio: true, minio_url: \"http://minio:9000\", access_key: \"minioadmin\", secret_key: Secret([REDACTED alloc::string::String]), bucket: \"appflowy\", region: \"\", presigned_url_endpoint: None }, mailer: MailerSetting { smtp_host: \"smtp.gmail.com\", smtp_port: 465, smtp_username: \"email_sender@some_company.com\", smtp_email: \"email_sender@some_company.com\", smtp_password: Secret([REDACTED alloc::string::String]), smtp_tls_kind: \"wrapper\" }, enable_database_blob: false, database_blob: DatabaseBlobSetting { append_flush_interval: 10s, append_batch_size: 50, append_batch_max_bytes: 5242880, scheduler_interval: 300s, scheduler_max_per_tick: 2, max_blob_bytes: 5242880, compaction_min_sealed_blobs: 2, compaction_min_total_bytes: 31457280, compact_on_rotation: true, compaction_max_stale_interval: None, reconcile_interval: 1s, manifest_cache_ttl: 60s, manifest_cache_max_bytes: 262144, row_cache_max_bytes: 629145600, row_cache_ttl: 86400s } }"},"target":"appflowy_worker::application"}
ai-1               | {"timestamp":"2026-02-22T14:19:42.643424Z","level":"INFO","fields":{"message":"Server version: \"0.10.2\", is self host:true"},"target":"appflowy_ai"}
ai-1               | {"timestamp":"2026-02-22T14:19:42.643524Z","level":"INFO","fields":{"message":"Enabled AI providers: [\"openai\", \"azure_openai\"]"},"target":"appflowy_ai"}
admin_frontend-1   | AppFlowy Super Admin - Runtime Configuration
admin_frontend-1   | =========================================
admin_frontend-1   | Version: 0.12.2
admin_frontend-1   | =========================================
admin_frontend-1   |
admin_frontend-1   | Injecting runtime configuration...
admin_frontend-1   | APPFLOWY_BASE_URL: http://192.168.191.21
ai-1               | {"timestamp":"2026-02-22T14:19:42.643545Z","level":"INFO","fields":{"message":"Connecting to database: postgres://postgres:password@postgres:5432/appflowy"},"target":"appflowy_ai::state"}
minio-1            | INFO: Formatting 1st pool, 1 set(s), 1 drives per set.
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.732025Z","level":"INFO","fields":{"message":"Starting server at: Ok([::]:4001)"},"target":"appflowy_worker::application"}
admin_frontend-1   | APPFLOWY_GOTRUE_BASE_URL: http://192.168.191.21/gotrue
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.732065Z","level":"INFO","fields":{"message":"Preparing to run database migrations..."},"target":"appflowy_worker::application"}
admin_frontend-1   | APPFLOWY_ALLOWED_ORIGINS: http://192.168.191.21
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.732076Z","level":"INFO","fields":{"message":"Connecting to postgres database with setting: DatabaseSetting { pg_conn_opts: PgConnectOptions { host: \"postgres\", port: 5432, socket: None, username: \"postgres\", password: Some(\"********\"), database: Some(\"appflowy\"), ssl_mode: Prefer, ssl_root_cert: None, ssl_client_cert: None, ssl_client_key: None, statement_cache_capacity: 100, application_name: None, log_settings: LogSettings { statements_level: Debug, slow_statements_level: Warn, slow_statements_duration: 1s }, extra_float_digits: Some(\"2\"), options: None }, require_ssl: false, max_connections: 10 }"},"target":"appflowy_worker::application"}
admin_frontend-1   |
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.741544Z","level":"INFO","fields":{"message":"Postgres test query ok in 0ms (DatabaseSetting { pg_conn_opts: PgConnectOptions { host: \"postgres\", port: 5432, socket: None, username: \"postgres\", password: Some(\"********\"), database: Some(\"appflowy\"), ssl_mode: Prefer, ssl_root_cert: None, ssl_client_cert: None, ssl_client_key: None, statement_cache_capacity: 100, application_name: None, log_settings: LogSettings { statements_level: Debug, slow_statements_level: Warn, slow_statements_duration: 1s }, extra_float_digits: Some(\"2\"), options: None }, require_ssl: false, max_connections: 10 })"},"target":"appflowy_worker::application"}
minio-1            | INFO: WARNING: Host local has more than 0 drives of set. A host failure will result in data becoming unavailable.
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.741574Z","level":"INFO","fields":{"message":"Connecting to redis at redis://redis:6379"},"target":"appflowy_worker::application"}
ai-1               | {"timestamp":"2026-02-22T14:19:42.652838Z","level":"INFO","fields":{"message":"Creating AIProviderManager"},"target":"appflowy_ai::state"}
minio-1            | MinIO Object Storage Server
minio-1            | Copyright: 2015-2026 MinIO, Inc.
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.742581Z","level":"INFO","fields":{"message":"Redis PING ok in 0ms (response=PONG)"},"target":"appflowy_worker::application"}
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.824148Z","level":"INFO","fields":{"message":"Setting up S3 bucket (bucket=appflowy, region=, use_minio=true, create_bucket=true, endpoint=http://minio:9000/)"},"target":"appflowy_worker::application"}
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.840125Z","level":"INFO","fields":{"message":"Bucket already exists"},"target":"appflowy_s3::client"}
ai-1               | {"timestamp":"2026-02-22T14:19:42.652862Z","level":"INFO","fields":{"message":"Creating S3 client"},"target":"appflowy_ai::state"}
ai-1               | {"timestamp":"2026-02-22T14:19:42.750591Z","level":"INFO","fields":{"message":"No valid license found for host: http://192.168.191.21/, defaulting to free plan"},"target":"appflowy_ai::biz::license::self_host_license_state"}
ai-1               | {"timestamp":"2026-02-22T14:19:42.750627Z","level":"INFO","fields":{"message":"Free plan limits - max_users: 1, max_guests: 3"},"target":"appflowy_entity::shared::dto::billing_dto"}
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.841226Z","level":"INFO","fields":{"message":"S3 health check succeeded during startup (bucket=appflowy, region=, use_minio=true, create_bucket=true, endpoint=http://minio:9000/)"},"target":"appflowy_worker::application"}
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.841518Z","level":"INFO","fields":{"message":"Using pgvector storage"},"target":"database::index::vector_storage"}
redis-1            | Starting Redis Server
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.841540Z","level":"INFO","fields":{"message":"📦 Vector storage configuration: PostgreSQL with pgvector extension"},"target":"database::index::storage_factory"}
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.841548Z","level":"INFO","fields":{"message":"✅ Initializing pgvector storage backend"},"target":"database::index::storage_factory"}
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.841655Z","level":"INFO","fields":{"message":"Starting export worker"},"target":"appflowy_worker::export_worker::worker"}
minio-1            | License: GNU AGPLv3 - https://www.gnu.org/licenses/agpl-3.0.html
minio-1            | Version: RELEASE.2025-09-07T16-13-09Z (go1.24.6 linux/amd64)
admin_frontend-1   | Updating server.js with runtime configuration...
admin_frontend-1   |
admin_frontend-1   | Starting application on port 3000...
admin_frontend-1   | Environment variables:
admin_frontend-1   |   APPFLOWY_BASE_URL=http://192.168.191.21
redis-1            | 1:C 22 Feb 2026 14:19:13.931 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
ai-1               | {"timestamp":"2026-02-22T14:19:42.750641Z","level":"INFO","fields":{"message":"Started periodic license check"},"target":"appflowy_ai"}
ai-1               | {"timestamp":"2026-02-22T14:19:42.750970Z","level":"INFO","fields":{"message":"CORS configured - origins: *, credentials: false (wildcard origin)"},"target":"appflowy_ai"}
ai-1               | {"timestamp":"2026-02-22T14:19:42.751075Z","level":"INFO","fields":{"message":"start server on 0.0.0.0:5001"},"target":"appflowy_ai"}
redis-1            | 1:C 22 Feb 2026 14:19:13.931 * oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
minio-1            |
redis-1            | 1:C 22 Feb 2026 14:19:13.931 * Redis version=8.6.0, bits=64, commit=00000000, modified=1, pid=1, just started
minio-1            | API: http://172.20.0.3:9000  http://127.0.0.1:9000
minio-1            | WebUI: http://192.168.191.21/minio
minio-1            |
admin_frontend-1   |   APPFLOWY_GOTRUE_BASE_URL=http://192.168.191.21/gotrue
admin_frontend-1   | =========================================
redis-1            | 1:C 22 Feb 2026 14:19:13.931 * Configuration loaded
redis-1            | 1:M 22 Feb 2026 14:19:13.932 * monotonic clock: POSIX clock_gettime
minio-1            | Docs: https://docs.min.io
minio-1            | WARN: Detected default credentials 'minioadmin:minioadmin', we recommend that you change these values with 'MINIO_ROOT_USER' and 'MINIO_ROOT_PASSWORD' environment variables
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.841720Z","level":"INFO","fields":{"message":"Starting importer worker (concurrency = 5)"},"target":"appflowy_worker::import_worker::worker"}
gotrue-1           | {"level":"info","msg":"Go runtime metrics collection started","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"level":"info","msg":"Create schema if not exists: auth","time":"2026-02-22T14:19:30Z"}
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.841702Z","level":"INFO","fields":{"message":"Starting snapshot worker loop"},"target":"appflowy_worker::snapshot_worker::worker"}
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.841645Z","level":"ERROR","fields":{"message":"AI provider is not configured. Stop background indexer"},"target":"appflowy_worker::indexer_worker::worker"}
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.842356Z","level":"INFO","fields":{"message":"Found 0 unacknowledged export tasks"},"target":"appflowy_worker::export_worker::worker"}
gotrue-1           | {"args":["init_auth_schema"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["alter_users"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["adds_confirmed_at"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_email_change_confirmed"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
appflowy_worker-1  | {"timestamp":"2026-02-22T14:19:42.842379Z","level":"INFO","fields":{"message":"Found 0 unacknowledged tasks"},"target":"appflowy_worker::import_worker::worker"}
postgres-1         | The files belonging to this database system will be owned by user "postgres".
postgres-1         | This user must also own the server process.
redis-1            | 1:M 22 Feb 2026 14:19:13.933 * Running mode=standalone, port=6379.
redis-1            | 1:M 22 Feb 2026 14:19:13.934 * <bf> RedisBloom version 8.6.0 (Git=unknown)
postgres-1         |
redis-1            | 1:M 22 Feb 2026 14:19:13.934 * <bf> Registering configuration options: [
redis-1            | 1:M 22 Feb 2026 14:19:13.934 * <bf> 	{ bf-error-rate       :      0.01 }
appflowy_web-1     | ════════════════════════════════════════════════════════════════════
gotrue-1           | {"args":["create_identities_table"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_refresh_token_parent"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["create_user_id_idx"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["update_auth_functions"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
postgres-1         | The database cluster will be initialized with locale "en_US.utf8".
postgres-1         | The default database encoding has accordingly been set to "UTF8".
postgres-1         | The default text search configuration will be set to "english".
redis-1            | 1:M 22 Feb 2026 14:19:13.934 * <bf> 	{ bf-initial-size     :       100 }
redis-1            | 1:M 22 Feb 2026 14:19:13.934 * <bf> 	{ bf-expansion-factor :         2 }
redis-1            | 1:M 22 Feb 2026 14:19:13.934 * <bf> 	{ cf-bucket-size      :         2 }
gotrue-1           | {"args":["update_auth_uid"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
nginx-1            | /docker-entrypoint.sh: /docker-entrypoint.d/ is not empty, will attempt to perform configuration
nginx-1            | /docker-entrypoint.sh: Looking for shell scripts in /docker-entrypoint.d/
postgres-1         |
postgres-1         | Data page checksums are disabled.
postgres-1         |
postgres-1         | fixing permissions on existing directory /var/lib/postgresql/data ... ok
postgres-1         | creating subdirectories ... ok
postgres-1         | selecting dynamic shared memory implementation ... posix
postgres-1         | selecting default max_connections ... 100
gotrue-1           | {"args":["update_user_idx"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_banned_until"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["update_auth_functions"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_user_reauthentication"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_unique_idx"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
postgres-1         | selecting default shared_buffers ... 128MB
postgres-1         | selecting default time zone ... Etc/UTC
postgres-1         | creating configuration files ... ok
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:36.135903Z","level":"INFO","fields":{"message":"Using AppFlowy Cloud version:0.12.2, using self-hosted version, running env: Production"},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":224}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:36.136363Z","level":"INFO","fields":{"message":"Preparing to run database migrations..."},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":234}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:36.136383Z","level":"INFO","fields":{"message":"Connecting to postgres database with setting: DatabaseSetting { pg_conn_opts: PgConnectOptions { host: \"postgres\", port: 5432, socket: None, username: \"postgres\", password: Some(\"********\"), database: Some(\"appflowy\"), ssl_mode: Prefer, ssl_root_cert: None, ssl_client_cert: None, ssl_client_key: None, statement_cache_capacity: 100, application_name: None, log_settings: LogSettings { statements_level: Debug, slow_statements_level: Warn, slow_statements_duration: 1s }, extra_float_digits: Some(\"2\"), options: None }, require_ssl: false, max_connections: 40 }"},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":800}
appflowy_web-1     |   AppFlowy Web v0.10.7
appflowy_web-1     | ════════════════════════════════════════════════════════════════════
appflowy_web-1     |
appflowy_web-1     | Environment variables configured:
appflowy_web-1     |   APPFLOWY_BASE_URL: http://192.168.191.21
appflowy_web-1     |   APPFLOWY_GOTRUE_BASE_URL: http://192.168.191.21/gotrue
appflowy_web-1     |   APPFLOWY_WS_BASE_URL: ws://192.168.191.21/ws/v2
appflowy_web-1     |
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:36.287561Z","level":"INFO","fields":{"message":"Postgres test query ok in 0ms (DatabaseSetting { pg_conn_opts: PgConnectOptions { host: \"postgres\", port: 5432, socket: None, username: \"postgres\", password: Some(\"********\"), database: Some(\"appflowy\"), ssl_mode: Prefer, ssl_root_cert: None, ssl_client_cert: None, ssl_client_key: None, statement_cache_capacity: 100, application_name: None, log_settings: LogSettings { statements_level: Debug, slow_statements_level: Warn, slow_statements_duration: 1s }, extra_float_digits: Some(\"2\"), options: None }, require_ssl: false, max_connections: 40 })"},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":816}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:36.287617Z","level":"INFO","fields":{"message":"Startup state changed: initializing -> database_ready (component: Database ready)"},"target":"appflowy_cloud::startup_state","filename":"src/startup_state.rs","line_number":199}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:36.713243Z","level":"INFO","fields":{"message":"trigger \"af_user_change_trigger\" for relation \"af_user\" does not exist, skipping"},"target":"sqlx::postgres::notice","filename":"/usr/local/cargo/registry/src/index.crates.io-1949cf8c6b5b557f/sqlx-postgres-0.8.6/src/connection/stream.rs","line_number":185}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:36.858441Z","level":"INFO","fields":{"message":"extension \"uuid-ossp\" already exists, skipping"},"target":"sqlx::postgres::notice","filename":"/usr/local/cargo/registry/src/index.crates.io-1949cf8c6b5b557f/sqlx-postgres-0.8.6/src/connection/stream.rs","line_number":185}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:38.043442Z","level":"WARN","fields":{"message":"there is already a transaction in progress"},"target":"sqlx::postgres::notice","filename":"/usr/local/cargo/registry/src/index.crates.io-1949cf8c6b5b557f/sqlx-postgres-0.8.6/src/connection/stream.rs","line_number":185}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:39.957837Z","level":"INFO","fields":{"message":"owner_uid column marked as deprecated"},"target":"sqlx::postgres::notice","filename":"/usr/local/cargo/registry/src/index.crates.io-1949cf8c6b5b557f/sqlx-postgres-0.8.6/src/connection/stream.rs","line_number":185}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.209964Z","level":"INFO","fields":{"message":"trigger \"set_updated_at_workspace_member_profile\" for relation \"af_workspace_member_profile\" does not exist, skipping"},"target":"sqlx::postgres::notice","filename":"/usr/local/cargo/registry/src/index.crates.io-1949cf8c6b5b557f/sqlx-postgres-0.8.6/src/connection/stream.rs","line_number":185}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.210832Z","level":"INFO","fields":{"message":"trigger \"set_updated_at_workspace_shared_view\" for relation \"af_workspace_shared_view\" does not exist, skipping"},"target":"sqlx::postgres::notice","filename":"/usr/local/cargo/registry/src/index.crates.io-1949cf8c6b5b557f/sqlx-postgres-0.8.6/src/connection/stream.rs","line_number":185}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.313207Z","level":"INFO","fields":{"message":"Earliest user either lacks system admin flag or is not linked to af_user; skipping reversion"},"target":"sqlx::postgres::notice","filename":"/usr/local/cargo/registry/src/index.crates.io-1949cf8c6b5b557f/sqlx-postgres-0.8.6/src/connection/stream.rs","line_number":185}
postgres-1         | running bootstrap script ... ok
postgres-1         | performing post-bootstrap initialization ... ok
postgres-1         | syncing data to disk ... ok
postgres-1         |
postgres-1         |
postgres-1         | Success. You can now start the database server using:
postgres-1         |
nginx-1            | /docker-entrypoint.sh: Launching /docker-entrypoint.d/10-listen-on-ipv6-by-default.sh
nginx-1            | 10-listen-on-ipv6-by-default.sh: info: Getting the checksum of /etc/nginx/conf.d/default.conf
nginx-1            | 10-listen-on-ipv6-by-default.sh: info: Enabled listen on IPv6 in /etc/nginx/conf.d/default.conf
nginx-1            | /docker-entrypoint.sh: Sourcing /docker-entrypoint.d/15-local-resolvers.envsh
nginx-1            | /docker-entrypoint.sh: Launching /docker-entrypoint.d/20-envsubst-on-templates.sh
nginx-1            | /docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh
nginx-1            | /docker-entrypoint.sh: Configuration complete; ready for start up
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.520619Z","level":"INFO","fields":{"message":"Connecting to Redis..."},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":264}
gotrue-1           | {"args":["add_auth_jwt_function"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
redis-1            | 1:M 22 Feb 2026 14:19:13.934 * <bf> 	{ cf-initial-size     :      1024 }
postgres-1         |     pg_ctl -D /var/lib/postgresql/data -l logfile start
redis-1            | 1:M 22 Feb 2026 14:19:13.934 * <bf> 	{ cf-max-iterations   :        20 }
redis-1            | 1:M 22 Feb 2026 14:19:13.934 * <bf> 	{ cf-expansion-factor :         1 }
redis-1            | 1:M 22 Feb 2026 14:19:13.934 * <bf> 	{ cf-max-expansions   :        32 }
redis-1            | 1:M 22 Feb 2026 14:19:13.934 * <bf> ]
redis-1            | 1:M 22 Feb 2026 14:19:13.934 * Module 'bf' loaded from /usr/local/lib/redis/modules//redisbloom.so
redis-1            | 1:M 22 Feb 2026 14:19:13.937 * <search> Redis version found by RedisSearch : 8.6.0 - oss
redis-1            | 1:M 22 Feb 2026 14:19:13.937 * <search> RediSearch version 8.6.0 (Git=7782b97)
gotrue-1           | {"args":["add_ip_address_to_audit_log"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_sessions_table"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_mfa_schema"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_aal_and_factor_id_to_sessions"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_mfa_indexes"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_sessions_user_id_index"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_refresh_tokens_session_id_revoked_index"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_saml"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["add_identities_user_id_idx"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.520649Z","level":"INFO","fields":{"message":"Connecting to redis at redis://redis:6379"},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":746}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.521778Z","level":"INFO","fields":{"message":"Redis PING ok in 0ms (response=PONG)"},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":839}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.564706Z","level":"INFO","fields":{"message":"stared Redis stream router with 60 workers"},"target":"collab_stream::stream_router","filename":"libs/collab-stream/src/stream_router.rs","line_number":113}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.564729Z","level":"INFO","fields":{"message":"Startup state changed: database_ready -> redis_ready (component: Redis ready)"},"target":"appflowy_cloud::startup_state","filename":"src/startup_state.rs","line_number":199}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.644394Z","level":"INFO","fields":{"message":"Setting up S3 bucket (bucket=appflowy, region=, use_minio=true, create_bucket=true, endpoint=http://minio:9000/, presigned_url_endpoint=http://192.168.191.21/minio-api)"},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":303}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.669205Z","level":"INFO","fields":{"message":"bucket created successfully: appflowy, region: "},"target":"appflowy_s3::client","filename":"libs/appflowy-s3/src/client.rs","line_number":74}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.670070Z","level":"INFO","fields":{"message":"Setting up Published Collab storage..."},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":326}
postgres-1         |
postgres-1         | initdb: warning: enabling "trust" authentication for local connections
postgres-1         | initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
postgres-1         | waiting for server to start....2026-02-22 14:19:21.981 UTC [54] LOG:  starting PostgreSQL 16.12 (Debian 16.12-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
postgres-1         | 2026-02-22 14:19:21.989 UTC [54] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres-1         | 2026-02-22 14:19:22.011 UTC [57] LOG:  database system was shut down at 2026-02-22 14:19:14 UTC
postgres-1         | 2026-02-22 14:19:22.038 UTC [54] LOG:  database system is ready to accept connections
postgres-1         |  done
postgres-1         | server started
postgres-1         | CREATE DATABASE
postgres-1         |
postgres-1         |
postgres-1         | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
postgres-1         |
postgres-1         | 2026-02-22 14:19:22.281 UTC [54] LOG:  received fast shutdown request
redis-1            | 1:M 22 Feb 2026 14:19:13.938 * <search> Low level api version 1 initialized successfully
redis-1            | 1:M 22 Feb 2026 14:19:13.938 * <search> gc: ON, prefix min length: 2, min word length to stem: 4, prefix max expansions: 200, query timeout (ms): 500, timeout policy: return, oom policy: return, cursor read size: 1000, cursor max idle (ms): 300000, max doctable size: 1000000, max number of search results:  1000000, default scorer: BM25STD,
redis-1            | 1:M 22 Feb 2026 14:19:13.938 * <search> Initialized thread pools!
redis-1            | 1:M 22 Feb 2026 14:19:13.938 * <search> Disabled workers threadpool of size 0
redis-1            | 1:M 22 Feb 2026 14:19:13.938 * <search> Subscribe to config changes
redis-1            | 1:M 22 Feb 2026 14:19:13.938 * <search> Subscribe to cluster slot migration events
redis-1            | 1:M 22 Feb 2026 14:19:13.938 * <search> Enabled role change notification
appflowy_web-1     | 2026-02-22 14:19:42,890 CRIT Supervisor is running as root.  Privileges were not dropped because no user is specified in the config file.  If you intend to run as root, you can set user=root in the config file to avoid this message.
appflowy_web-1     | 2026-02-22 14:19:42,900 INFO supervisord started with pid 1
gotrue-1           | {"args":["add_session_not_after_column"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["remove_parent_foreign_key_refresh_tokens"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["backfill_email_identity"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["backfill_email_last_sign_in_at"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
gotrue-1           | {"args":["modify_users_email_unique_index"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:30Z"}
postgres-1         | waiting for server to shut down....2026-02-22 14:19:22.288 UTC [54] LOG:  aborting any active transactions
postgres-1         | 2026-02-22 14:19:22.290 UTC [54] LOG:  background worker "logical replication launcher" (PID 60) exited with exit code 1
postgres-1         | 2026-02-22 14:19:22.292 UTC [55] LOG:  shutting down
postgres-1         | 2026-02-22 14:19:22.299 UTC [55] LOG:  checkpoint starting: shutdown immediate
postgres-1         | .2026-02-22 14:19:24.141 UTC [73] FATAL:  the database system is shutting down
postgres-1         | .2026-02-22 14:19:24.578 UTC [55] LOG:  checkpoint complete: wrote 922 buffers (5.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.055 s, sync=2.183 s, total=2.287 s; sync files=301, longest=0.045 s, average=0.008 s; distance=4255 kB, estimate=4255 kB; lsn=0/1912118, redo lsn=0/1912118
postgres-1         | 2026-02-22 14:19:24.585 UTC [54] LOG:  database system is shut down
postgres-1         |  done
gotrue-1           | {"args":["add_identities_email_column"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["remove_sso_sessions"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["alter_phone_type"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_deleted_at"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["backfill_invite_identities"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_flow_state_table"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_authentication_method_to_flow_state_table"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
postgres-1         | server stopped
postgres-1         |
postgres-1         | PostgreSQL init process complete; ready for start up.
postgres-1         |
postgres-1         | 2026-02-22 14:19:24.629 UTC [1] LOG:  starting PostgreSQL 16.12 (Debian 16.12-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
postgres-1         | 2026-02-22 14:19:24.629 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
postgres-1         | 2026-02-22 14:19:24.629 UTC [1] LOG:  listening on IPv6 address "::", port 5432
postgres-1         | 2026-02-22 14:19:24.644 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres-1         | 2026-02-22 14:19:24.660 UTC [77] LOG:  database system was shut down at 2026-02-22 14:19:24 UTC
postgres-1         | 2026-02-22 14:19:24.706 UTC [1] LOG:  database system is ready to accept connections
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.670090Z","level":"INFO","fields":{"message":"Using S3 as the Published Collab storage backend with Postgres as the backup ..."},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":337}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.670098Z","level":"INFO","fields":{"message":"Connecting to GoTrue..."},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":347}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.670103Z","level":"INFO","fields":{"message":"Connecting to GoTrue with setting: GoTrueSetting { base_url: \"http://gotrue:9999\", jwt_secret: Secret([REDACTED alloc::string::String]), service_role: \"service_role\" }"},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":864}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.748804Z","level":"INFO","fields":{"message":"Setting up Pg listeners..."},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":352}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.752564Z","level":"INFO","fields":{"message":"Startup state changed: redis_ready -> access_control_ready (component: Access Control ready)"},"target":"appflowy_cloud::startup_state","filename":"src/startup_state.rs","line_number":199}
postgres-1         | 2026-02-22 14:19:30.112 UTC [89] ERROR:  relation "schema_migrations" does not exist at character 15
postgres-1         | 2026-02-22 14:19:30.112 UTC [89] STATEMENT:  select * from schema_migrations
postgres-1         | 2026-02-22 14:19:38.043 UTC [103] WARNING:  there is already a transaction in progress
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.753074Z","level":"INFO","fields":{"message":"Connecting to mailer with setting: MailerSetting { smtp_host: \"smtp.gmail.com\", smtp_port: 465, smtp_username: \"email_sender@some_company.com\", smtp_email: \"email_sender@some_company.com\", smtp_password: Secret([REDACTED alloc::string::String]), smtp_tls_kind: \"wrapper\" }"},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":785}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.830974Z","level":"INFO","fields":{"message":"Initializing vector storage..."},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":520}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.831012Z","level":"INFO","fields":{"message":"Using pgvector storage"},"target":"database::index::vector_storage","filename":"libs/database/src/index/vector_storage.rs","line_number":122}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.831020Z","level":"INFO","fields":{"message":"📦 Vector storage configuration: PostgreSQL with pgvector extension"},"target":"database::index::storage_factory","filename":"libs/database/src/index/storage_factory.rs","line_number":50}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.831027Z","level":"INFO","fields":{"message":"✅ Initializing pgvector storage backend"},"target":"database::index::storage_factory","filename":"libs/database/src/index/storage_factory.rs","line_number":18}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.831033Z","level":"INFO","fields":{"message":"Setting up Indexer scheduler..."},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":525}
redis-1            | 1:M 22 Feb 2026 14:19:13.938 * <search> Cluster configuration: AUTO partitions, type: 0, coordinator timeout: 0ms
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * Module 'search' loaded from /usr/local/lib/redis/modules//redisearch.so
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> RedisTimeSeries version 80600, git_sha=05fd355db748676861dc4c17d19c8c1ca74c0154
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> Redis version found by RedisTimeSeries : 8.6.0 - oss
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.831040Z","level":"INFO","fields":{"message":"Indexer is enabled: true"},"target":"indexer::collab_indexer::provider","filename":"libs/indexer/src/collab_indexer/provider.rs","line_number":50}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.831047Z","level":"INFO","fields":{"message":"Indexer scheduler config: IndexerConfiguration { enable: true, ai_provider: None }"},"target":"indexer::scheduler","filename":"libs/indexer/src/scheduler.rs","line_number":60}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.831054Z","level":"INFO","fields":{"message":"Indexer scheduler is enabled: false"},"target":"indexer::scheduler","filename":"libs/indexer/src/scheduler.rs","line_number":92}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.831148Z","level":"INFO","fields":{"message":"creating arbiter pool on 12 threads (stack size 4194304 bytes)"},"target":"appflowy_collaborate::ws2::actors::arbiter_pool","filename":"services/appflowy-collaborate/src/ws2/actors/arbiter_pool.rs","line_number":31}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.845645Z","level":"INFO","fields":{"message":"[Access Control]: Policy update processor started"},"target":"access_control::casbin::enforcer_v2","filename":"libs/access-control/src/casbin/enforcer_v2.rs","line_number":141}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.847187Z","level":"INFO","fields":{"message":"No license data found for host: 192.168.191.21"},"target":"appflowy_cloud::biz::license::self_hosted_license","filename":"src/biz/license/self_hosted_license.rs","line_number":83}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.847215Z","level":"INFO","fields":{"message":"Free plan limits - max_users: 1, max_guests: 3"},"target":"appflowy_entity::shared::dto::billing_dto","filename":"libs/appflowy-entity/src/shared/dto/billing_dto.rs","line_number":480}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.847229Z","level":"INFO","fields":{"message":"AppFlowy Self-Hosted"},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":588}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.847466Z","level":"INFO","fields":{"message":"Server started at [::]:8000"},"target":"appflowy_cloud::application","filename":"src/application.rs","line_number":113}
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> Registering configuration options: [
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> 	{ ts-compaction-policy   :              }
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> 	{ ts-num-threads         :            3 }
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> 	{ ts-retention-policy    :            0 }
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> 	{ ts-duplicate-policy    :        block }
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> 	{ ts-chunk-size-bytes    :         4096 }
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> 	{ ts-encoding            :   compressed }
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> 	{ ts-ignore-max-time-diff:            0 }
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.847627Z","level":"INFO","fields":{"message":"Startup state changed: access_control_ready -> ready (component: User ID and UUID Mapping ready)"},"target":"appflowy_cloud::startup_state","filename":"src/startup_state.rs","line_number":199}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.848386Z","level":"INFO","fields":{"message":"starting 12 workers"},"target":"actix_server::builder","filename":"/usr/local/cargo/registry/src/index.crates.io-1949cf8c6b5b557f/actix-server-2.6.0/src/builder.rs","line_number":310}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.848429Z","level":"INFO","fields":{"message":"Actix runtime found; starting in Actix runtime"},"target":"actix_server::server","filename":"/usr/local/cargo/registry/src/index.crates.io-1949cf8c6b5b557f/actix-server-2.6.0/src/server.rs","line_number":191}
appflowy_cloud-1   | {"timestamp":"2026-02-22T14:19:40.848440Z","level":"INFO","fields":{"message":"starting service: \"actix-web-service-[::]:8000\", workers: 12, listening on: [::]:8000"},"target":"actix_server::server","filename":"/usr/local/cargo/registry/src/index.crates.io-1949cf8c6b5b557f/actix-server-2.6.0/src/server.rs","line_number":197}
gotrue-1           | {"args":["remove_duplicate_idx"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_cleanup_indexes"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_mfa_challenge_cleanup_index"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> 	{ ts-ignore-max-val-diff :     0.000000 }
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> ]
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> Detected redis oss
redis-1            | 1:M 22 Feb 2026 14:19:13.939 * <timeseries> Subscribe to ASM events
redis-1            | 1:M 22 Feb 2026 14:19:13.940 * <timeseries> Enabled diskless replication
redis-1            | 1:M 22 Feb 2026 14:19:13.940 * Module 'timeseries' loaded from /usr/local/lib/redis/modules//redistimeseries.so
redis-1            | 1:M 22 Feb 2026 14:19:13.940 * <ReJSON> Created new data type 'ReJSON-RL'
gotrue-1           | {"args":["add_flow_state_to_relay_state"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_mfa_factors_user_id_idx"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_session_refresh_columns"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_sessions_tag"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_id_pkey_identities"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["remove_ip_address_from_saml_relay_state"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_is_anonymous_column"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_issued_at_to_flow_state"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
redis-1            | 1:M 22 Feb 2026 14:19:13.940 * <ReJSON> version: 80600 git sha: unknown branch: unknown
redis-1            | 1:M 22 Feb 2026 14:19:13.941 * <ReJSON> Exported RedisJSON_V1 API
redis-1            | 1:M 22 Feb 2026 14:19:13.941 * <ReJSON> Exported RedisJSON_V2 API
redis-1            | 1:M 22 Feb 2026 14:19:13.941 * <ReJSON> Exported RedisJSON_V3 API
redis-1            | 1:M 22 Feb 2026 14:19:13.941 * <ReJSON> Exported RedisJSON_V4 API
redis-1            | 1:M 22 Feb 2026 14:19:13.941 * <ReJSON> Exported RedisJSON_V5 API
redis-1            | 1:M 22 Feb 2026 14:19:13.941 * <ReJSON> Exported RedisJSON_V6 API
redis-1            | 1:M 22 Feb 2026 14:19:13.941 * <ReJSON> Enabled diskless replication
gotrue-1           | {"args":["add_saml_name_id_format"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_one_time_tokens_table"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_mfa_phone_config"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["add_mfa_factors_column_last_challenged_at"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["drop_uniqueness_constraint_on_phone"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":["alter_users_has_set_password"],"component":"pop","level":"info","msg":"\u003e %s","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":[53],"component":"pop","level":"info","msg":"Successfully applied %d migrations.","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":[1.324125114],"component":"pop","level":"info","msg":"%.4f seconds","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"level":"info","msg":"GoTrue migrations applied successfully","time":"2026-02-22T14:19:31Z"}
redis-1            | 1:M 22 Feb 2026 14:19:13.941 * <ReJSON> Initialized shared string cache, thread safe: true.
redis-1            | 1:M 22 Feb 2026 14:19:13.941 * Module 'ReJSON' loaded from /usr/local/lib/redis/modules//rejson.so
redis-1            | 1:M 22 Feb 2026 14:19:13.941 * <search> Acquired RedisJSON_V6 API
redis-1            | 1:M 22 Feb 2026 14:19:13.941 * Server initialized
redis-1            | 1:M 22 Feb 2026 14:19:13.941 * Ready to accept connections tcp
redis-1            | 1:M 22 Feb 2026 14:19:13.941 # WARNING: Redis does not require authentication and is not protected by network restrictions. Redis will accept connections from any IP address on any network interface.
gotrue-1           | {"level":"info","msg":"received graceful shutdown signal","time":"2026-02-22T14:19:31Z"}
gotrue-1           | Creating admin user for gotrue...
gotrue-1           | {"level":"info","msg":"Go runtime metrics collection started","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"level":"info","msg":"Create schema if not exists: auth","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"component":"pop","level":"info","msg":"Migrations already up to date, nothing to apply","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"args":[0.01071633],"component":"pop","level":"info","msg":"%.4f seconds","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"level":"info","msg":"GoTrue migrations applied successfully","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"component":"api","level":"warning","msg":"DEPRECATION NOTICE: GOTRUE_JWT_ADMIN_GROUP_NAME not supported by Supabase's GoTrue, will be removed soon","time":"2026-02-22T14:19:31Z"}
gotrue-1           | {"level":"info","msg":"GoTrue API started on: :9999","time":"2026-02-22T14:19:31Z"}
admin_frontend-1   |    ▲ Next.js 15.5.7
admin_frontend-1   |    - Local:        http://d75708434dbd:3000
admin_frontend-1   |    - Network:      http://d75708434dbd:3000
admin_frontend-1   |
admin_frontend-1   |  ✓ Starting...
admin_frontend-1   |  ✓ Ready in 581ms
appflowy_web-1     | 2026-02-22 14:19:43,903 INFO spawned: 'nginx' with pid 9
appflowy_web-1     | 2026-02-22 14:19:43,905 INFO spawned: 'bun' with pid 10
appflowy_web-1     | {"level":30,"time":1771769984050,"pid":10,"hostname":"a6e476958562","msg":"Server is running on port 3000"}
appflowy_web-1     | {"level":30,"time":1771769984050,"pid":10,"hostname":"a6e476958562","msg":"Base URL: http://192.168.191.21"}
appflowy_web-1     | 2026-02-22 14:19:45,052 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
appflowy_web-1     | 2026-02-22 14:19:45,052 INFO success: bun entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
appflowy_web-1     | {"level":30,"time":1771770206410,"pid":10,"hostname":"a6e476958562","msg":"Request URL: 192.168.191.21/"}
nginx-1            | 192.168.191.123 - - [22/Feb/2026:14:23:26 +0000] "GET / HTTP/1.1" 302 0 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:147.0) Gecko/20100101 Firefox/147.0"
appflowy_web-1     | {"level":30,"time":1771770206423,"pid":10,"hostname":"a6e476958562","msg":"Request URL: 192.168.191.21/app"}
nginx-1            | 192.168.191.123 - - [22/Feb/2026:14:23:26 +0000] "GET /app HTTP/1.1" 200 1050 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:147.0) Gecko/20100101 Firefox/147.0"
nginx-1            | 192.168.191.123 - - [22/Feb/2026:14:23:26 +0000] "GET /static/css/index-CxVhxRMW.css HTTP/1.1" 200 24377 "http://192.168.191.21:82/app" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:147.0) Gecko/20100101 Firefox/147.0"
nginx-1            | 192.168.191.123 - - [22/Feb/2026:14:27:01 +0000] "GET /console/favicon.ico HTTP/1.1" 200 4299 "http://192.168.191.21:82/console/login" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36"
nginx-1            | 192.168.191.123 - - [22/Feb/2026:14:27:01 +0000] "POST /console/login HTTP/1.1" 200 188 "http://192.168.191.21:82/console/login" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36"
nginx-1            | 192.168.191.123 - - [22/Feb/2026:14:27:01 +0000] "GET /console/reset-password?returnUrl=%2F&_rsc=asqg6 HTTP/1.1" 200 171 "http://192.168.191.21:82/console/login" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36"
nginx-1            | 192.168.191.123 - - [22/Feb/2026:14:27:01 +0000] "GET /console/_next/static/media/logo.a30303d1.svg HTTP/1.1" 200 1278 "http://192.168.191.21:82/console" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36"
nginx-1            | 192.168.191.123 - - [22/Feb/2026:14:27:01 +0000] "GET /console/_next/static/media/Login.4170e13e.png HTTP/1.1" 200 472656 "http://192.168.191.21:82/console/login" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36"
nginx-1            | 192.168.191.123 - - [22/Feb/2026:14:27:10 +0000] "POST /console/login HTTP/1.1" 200 169 "http://192.168.191.21:82/console/login" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36"
nginx-1            | 192.168.191.123 - - [22/Feb/2026:14:27:28 +0000] "POST /console/login HTTP/1.1" 200 169 "http://192.168.191.21:82/console/login" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36"

[MayurSMahajan]

Hey @meetnick I know how frustrating it can be. But I think you are very close.
Based on the logs, I think the nginx port is not the issue here. The login attempts are actually reaching the console and getting responses (HTTP 200), so routing is working fine.

The gotrue container runs a one-time admin user creation script on first boot. So did you set a different custom admin email and passwords before the first run? let me know.

[MayurSMahajan]

I will suggest you do this:

1. Copy your current .env file and change the admin password and email to default: admin@example.com and password. (Keep all the nginx related settings). Save this .env file on your local computer. Also save the docker-compose.yml file if you have made any changes to it.

2. Then wipe all the docker volumes and data:

cd AppFlowy-Cloud

# Stop everything
docker compose down

# Remove all volumes (clean slate)
docker volume prune -f

3. Now ensure that in your .env file, the Admin credentials are default.

4. Restart docker container with latest images

# Pull latest images
docker compose pull

# Start fresh
docker compose up -d

# Watch logs
docker compose logs -f

[MayurSMahajan]

Feel free to dm me on discord if you need my help: mayurmahajan23
Also you might wanna look at these two videos:

Self hosting: (skip all the google cloud steps)
https://youtu.be/tTEps1njGkQ?si=cxX6XFulKlS0ivlV

Since you mentioned you already have a nginx proxy:
https://youtu.be/nsCzM3IT-Us?si=HrfdwKl-mk9aGHeK

[meetnick]

Hello @MayurSMahajan , thank you for your quick and detailed response.

I've spend a little more time debugging/troubleshooting and I actually found the issue.

The issue was fixed after I made explicit the custom nginx port number for FQDN in .env. I still don't now why this did not work on my other machine where I tried with default nginx ports. But anyway that was only a test, what I really need is to run AppFlowy in the same machine as other nginx

[meetnick]

So, since I run nginx on PORT 82, I had to set:
FQDN=<host_ip>:82

This made the trick.

[MayurSMahajan]

I am glad you were able to solve it! Let me know if something comes up.