Error: SQLITE_CANTOPEN: unable to open database file

[martinbehrens]

Running the following versions on a Centos 7.5.1804 box:

node v6.14.3
charged 0.4.0

Trying to start charged with either ...

charged -t NstxQtqsWHubkdbimZ -l /home/username/.lightning -d /home/username/.charged -w 90 -p 9112 -i xxx.xxx.xxx.xxx
charged -t NstxQtqsWHubkdbimZ -l /home/username/.lightning/ -d /home/username/.charged/ -w 90 -p 9112 -i xxx.xxx.xxx.xxx
charged -t 1127589647 -l /home/username/.lightning -d /home/username/.charged -w 90 -p 9112 -i xxx.xxx.xxx.xxx
charged -t 1127589647 -l /home/username/.lightning -d /home/username/.charged/ -w 90 -p 9112 -i xxx.xxx.xxx.xxx
charged -t 1127589647 -l /home/username/.lightning -d /home/username/.charged -w 90 -p 9112 -i 0.0.0.0

... results in the following error being thrown:

Error: SQLITE_CANTOPEN: unable to open database file
    at Error (native)
/usr/lib/node_modules/lightning-charge/dist/app.js:21
            throw err;
            ^

Error: SQLITE_CANTOPEN: unable to open database file
    at Error (native)

The sqlite.db file can be red and written by any user:

[username@host .charged]$ ls -al
total 20
drwxrwxr-x.  2 username username    23 Jul 10 21:28 .
drwx------. 12 username username  4096 Jul 10 21:33 ..
-rw-rw-rw-.  1 username username 16384 Jul 10 21:02 sqlite.db

[shesek]

The -d/--db-path expects to receive the path to the sqlite file itself, not to the directory containing it. -d /home/username/.charged/sqlite.db should work.

[shesek]

Closing, please report back if you're still having issues.