cannot use any map field with the directus docker image

[torstenhoegel]

Preflight Checklist

• I have completed all Troubleshooting Steps.
• I'm on the latest version of Directus.
• There's no other issue that already describes my problem.

Describe the Bug

I'm hosting directus instances with docker images. I'm passing an mapbox apikey to every instance, but I just discovered this error after adding a map field to a model.

{
  "errors": [
    {
      "message": "select `ok`.`ll`, st_astext(`ok`.`map`) as `map`, `ok`.`status`, `ok`.`id` from `ok` where not `ok`.`status` = 'archived' order by `ok`.`id` asc limit 25 - SQLITE_ERROR: no such function: st_astext",
      "extensions": {
        "code": "INTERNAL_SERVER_ERROR"
      }
    }
  ]
}

This happens. on all docker based instances I created with v98-100. (haven't tested it with prior versions, though I guess its the same thing)

As found in the Docker Image it uses a SQLite 3 DB which may need some additional config?

ENV DB_CLIENT=sqlite3 DB_FILENAME=/directus/database/database.sqlite EXTENSIONS_PATH=/directus/extensions STORAGE_LOCAL_ROOT=/directus/uploads

To Reproduce

pull directus docker image and run it

Errors Shown

No response

What version of Directus are you using?

v9.0.0-rc.100

What version of Node.js are you using?

NODE_VERSION=16.13.0

What database are you using?

DB_CLIENT=sqlite3

What browser are you using?

chrome/safari/brave

What operating system are you using?

macOS IOS / error is directus related not client side

How are you deploying Directus?

Docker

[azrikahar]

Duplicate of directus/docs#21. This comment should shed some light on this: https://github.com/directus/docs/issues/21

Alternatively since you are using docker, you can opt to use postgis/postgis Docker image which is a PostgreSQL db with PostGIS extensions installed so you can get up and running without any manual modifications 👍