Failed to open database

[byeuji]

Hi all,

Note sure if this repo is still watched, but trying to use this plugin in webmin for querying a sqlite db a discord bot updates and reads from on my server. It's a simple *.sqlite file (data.sqlite).

When I try to do a basic query (like list the table names from the sqlite_schema), I get the following error:
Failed to open database : file is encrypted or is not a database(1) at dbdimp.c line 57

In the "Database to query" box, I'm specifying the path from root to the database file (/path/to/data.sqlite)

Googling around, it looks like this might be a password error, but I can't seem to find if/where this plugin is specifying a password.
The database I'm accessing does not have encryption or a password. Similarly, the UI for this plugin is very simple and I don't see where I could specify a password for the access even if I wanted to.

This is the query I'm trying to run against it:

SELECT name FROM sqlite_schema
WHERE type='table'
ORDER BY name;

But even running a simple query that works in DB Browser for SQLite gives the same error. Not sure where I'm going wrong here.

[jcameron]

Are you writing your own Webmin module in Perl that will use an sqlite database, or just using this module as a query tool?

[byeuji]

I'm just using it as a query tool in Webmin.

[jcameron]

Can you query this same database file using the sqlite shell command?