Ibaraki DoujiOriginal post
Rank 4: Virtual Machine
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 :
└── 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 :
👩⚕️ 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 :
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.
Summary
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.