Appwrite 1.9.0 doctor fails tho database is connected

So i was testing in a local environment the upgrade for 1.9.0, and after getting everything into a running state, i checked the logs that shows :

TypeScript

  └── Creating database: logs...
database.setup · 242.7ms · cb9c5ddc

  database.name                logs
  database.collections_created 1
  level                        info

────────────────────────────────────────────────────────────
  └── Creating database: appwrite...
database.setup · 4.66s · d1f8335c

  database.name                appwrite
  database.collections_created 29
  level                        info

────────────────────────────────────────────────────────────
http.server.start · 0ms · 60fd514b

  server.workers      96
  server.payload_size 12582912
  server.master_pid   1
  server.manager_pid  7
  level               info

────────────────────────────────────────────────────────────

But doctor shows :

TypeScript

👩‍⚕️ Running Appwrite Doctor for version 1.9.0 ...

[Settings]
🔴 Hostname is not valid (localhost:8080)
🔴 CNAME record target is not valid (localhost)
🔴 A record target is not valid ()
🔴 AAAA record target is not valid ()
🟢 Using a unique secret key for encryption
🟢 App environment is set for production
🔴 Abuse protection is disabled
🟢 Console access limits are enabled
🔴 HTTPS force option is disabled
🔴 HTTPS force option is disabled for function/site domains
🔴 Logging adapter is misconfigured

[Connectivity]
🔴 Console.DB.(console)...........................disconnected
🔴 Projects.DB.(database_db_main).................disconnected
🟢 Cache(cache_redis_main)...........................connected

Warning: foreach() argument must be of type array|object, null given in /usr/src/code/src/Appwrite/Platform/Tasks/Doctor.php on line 178
🟢 PubSub(pubsub)....................................connected
🔴 SMTP...........................................disconnected

[Volumes]
🟢 Uploads Volume is readable
🟢 Uploads Volume is writeable
🟢 Cache Volume is readable
🟢 Cache Volume is writeable
🟢 Config Volume is readable
🟢 Config Volume is writeable
🟢 Certs Volume is readable
🟢 Certs Volume is writeable

[Disk Space]
🟢 Uploads Volume has 291.02GB free space (70.12% used)
🟢 Cache Volume has 291.02GB free space (70.12% used)
🟢 Config Volume has 291.02GB free space (70.12% used)
🟢 Certs Volume has 291.02GB free space (70.12% used)

Failed to check for a newer version

which is strange since the db shows :

TypeScript

current_db: appwrite
table_count: 70
table_name                table_rows
_console__metadata        32
_console__metadata_perms  32
_console_buckets_perms    4
_console_buckets          2
logsV1__metadata_perms    1
logsV1__metadata          1
_console_stats_perms      0
_console_targets          0
_console_projects_perms   0
_console_bucket_1_perms   0
_console_vcsComments_perms 0
_console_targets_perms    0
logsV1_stats_perms        0
_console_tokens           0
_console_bucket_2         0

That means it can connect to MariaDB and executes queries. but doctors shows it's not.

TL;DR

Developers are facing connectivity issues with Appwrite 1.9.0 Doctor tool despite the database being connected. The logs show successful database creation and execution of queries, but the Doctor tool still indicates the console and project db as disconnected. The error messages include invalid hostname and record targets, misconfigured logging adapter, and SMTP disconnection. A warning about the foreach() argument type is also displayed. The issue remains unresolved.

also tested with mongo and it's the same, the app works, i can create projects but the doctor shows the console and project db as disconnected