database/index.ts file not using CACHE_STORE environment variable

[rogerjbos]

Describe the bug

I could not get better-sql to work, so I tried switching to CACHE_STORE: filesystem in the .env file, but eliza still tried to use the better-sql. Looking at the database/index.ts file, it looks like it does not respect the setting of CACHE_STORE

To Reproduce

set CACHE_STORE: filesystem in .env file

Expected behavior

Not use better-sql

Screenshots

None

Additional context

Here is the better-sql error if you have any insight on how to fix that as well:

⛔ ERRORS
Error starting agent for character Eliza:
{"tries":["/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/build/better_sqlite3.node","/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/build/Debug/better_sqlite3.node","/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/build/Release/better_sqlite3.node","/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/out/Debug/better_sqlite3.node","/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/Debug/better_sqlite3.node","/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/out/Release/better_sqlite3.node","/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/Release/better_sqlite3.node","/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/build/default/better_sqlite3.node","/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/compiled/23.3.0/darwin/arm64/better_sqlite3.node","/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/addon-build/release/install-root/better_sqlite3.node","/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/addon-build/debug/install-root/better_sqlite3.node","/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/addon-build/default/install-root/better_sqlite3.node","/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/lib/binding/node-v131-darwin-arm64/better_sqlite3.node"]}

Error: Could not locate the bindings file. Tried:
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/build/better_sqlite3.node
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/build/Debug/better_sqlite3.node
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/build/Release/better_sqlite3.node
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/out/Debug/better_sqlite3.node
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/Debug/better_sqlite3.node
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/out/Release/better_sqlite3.node
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/Release/better_sqlite3.node
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/build/default/better_sqlite3.node
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/compiled/23.3.0/darwin/arm64/better_sqlite3.node
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/addon-build/release/install-root/better_sqlite3.node
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/addon-build/debug/install-root/better_sqlite3.node
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/addon-build/default/install-root/better_sqlite3.node
→ /Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/lib/binding/node-v131-darwin-arm64/better_sqlite3.node
at bindings (/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/bindings/bindings.js:126:9)
at new Database (/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/lib/database.js:48:64)
at initializeDatabase (file:///Users/rogerbos/Node_HOME/eliza-starter/src/database/index.ts:15:46)
at startAgent (file:///Users/rogerbos/Node_HOME/eliza-starter/src/index.ts:55:20)
at startAgents (file:///Users/rogerbos/Node_HOME/eliza-starter/src/index.ts:102:19)
at file:///Users/rogerbos/Node_HOME/eliza-starter/src/index.ts:128:1 {
tries: [
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/build/better_sqlite3.node',
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/build/Debug/better_sqlite3.node',
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/build/Release/better_sqlite3.node',
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/out/Debug/better_sqlite3.node',
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/Debug/better_sqlite3.node',
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/out/Release/better_sqlite3.node',
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/Release/better_sqlite3.node',
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/build/default/better_sqlite3.node',
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/compiled/23.3.0/darwin/arm64/better_sqlite3.node',
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/addon-build/release/install-root/better_sqlite3.node',
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/addon-build/debug/install-root/better_sqlite3.node',
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/addon-build/default/install-root/better_sqlite3.node',
'/Users/rogerbos/Node_HOME/eliza-starter/node_modules/.pnpm/[email protected]/node_modules/better-sqlite3/lib/binding/node-v131-darwin-arm64/better_sqlite3.node'
]
}

[github-actions]

Hello @rogerjbos! Welcome to the elizaOS community. Thank you for opening your first issue; we appreciate your contribution. You are now an elizaOS contributor!