Back
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
Appwrite 1.9.0 doctor is failing even though the database is connected. The database logs display successful creation and connection, but the doctor tool indicates various connection issues, including SMTP and database disconnections. Despite the doctor's warnings, the developers confirmed that the database can connect to MariaDB and execute queries successfully. The doctor tool seems to be mistakenly flagging connectivity problems.