folk.zone Wiki

a public knowledge base

Site Tools


troubleshooting:writefreely_sqlite_readonly

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

troubleshooting:writefreely_sqlite_readonly [2026/10/07 05:36] – created - external edit 127.0.0.1troubleshooting:writefreely_sqlite_readonly [2026/10/23 15:46] (current) – external edit 127.0.0.1
Line 26: Line 26:
 ===== Root Cause ===== ===== Root Cause =====
  
-The SQLite database file (''writefreely.db'') was owned by UID 1000 (the host user ''brennan''), but the WriteFreely process inside the container runs as UID 5000 (''writefreely''). The file permissions were ''644'', so the process could read but not write the file.+The SQLite database file (''writefreely.db'') was owned by UID 1000 (the host user), but the WriteFreely process inside the container runs as UID 5000 (''writefreely''). The file permissions were ''644'', so the process could read but not write the file.
  
 Critically, WriteFreely opens its SQLite connection at startup. If the file is not writable at that moment, the connection is established in read-only mode and stays that way for the lifetime of the process. Fixing the file permissions alone (without restarting the container) has no effect on the existing connection. Critically, WriteFreely opens its SQLite connection at startup. If the file is not writable at that moment, the connection is established in read-only mode and stays that way for the lifetime of the process. Fixing the file permissions alone (without restarting the container) has no effect on the existing connection.
Line 43: Line 43:
  
 <code bash> <code bash>
-cd /home/brennan/homelab/server+cd ~/homelab/server
 docker compose restart folkzone-write docker compose restart folkzone-write
 </code> </code>
Line 57: Line 57:
 ===== See Also ===== ===== See Also =====
  
-  * [[folkzone:troubleshooting:start|Homelab Troubleshooting Index]]+  * [[troubleshooting:start|Homelab Troubleshooting Index]]
   * [[start|Return to wiki home]]   * [[start|Return to wiki home]]
  
troubleshooting/writefreely_sqlite_readonly.1791373009.txt.gz · Last modified: by 127.0.0.1