search

matrix-org / dendrite

Dendrite is a second-generation Matrix homeserver written in Go!
https://matrix-org.github.io/dendrite/
Apache License 2.0
5.75k stars 676 forks source link

SQLite is not working #3435

Open paigeadelethompson opened 1 month ago

paigeadelethompson commented 1 month ago

followed the documentation @ https://matrix-org.github.io/dendrite/installation/manual/database and it don't work

monolith-1  | time="2024-09-28T13:21:13.627063518Z" level=panic msg="failed to connect to room server db" error="near \"SEQUENCE\": syntax error"
monolith-1  | panic: (*logrus.Entry) 0xc0002682a0
  database:
    connection_string: file:dendrite_component.db
    max_open_conns: 5
    max_idle_conns: 5
    conn_max_lifetime: -1

tried file:/// and it dont work

manchelsi commented 3 weeks ago

Note that Dendrite cannot share a single SQLite database across multiple components. Each component must be configured with its own SQLite database filename. You will have to remove the global.database section from your Dendrite config and add it to each individual section instead in order to use SQLite.