I have a VPS with limited resources. So, I decided to use telegraf with sqlite3. As that seems less resource intensive. I’m having trouble with what seems like permissions. This is under Debian system version 12.

When I run telegraf with root permission (sudo), it runs fine. However, when I run via systemclt – using sudo to start – it fails to write to the database.

It’s a sqlite3 database. I’ve given read and write permission to the file. I’ve given ownership of the file to telegraf. Telegraf is both a user and a group. Yet, I see same error message, database is readonly. What am I missing?