[collectd] regarding the collectd dbi plugin for sqlite3

Dhananjay Joshi dhananjayingroup at gmail.com
Tue Nov 24 05:31:16 CET 2020


Hi,
I have integrated all the dependent libs such as libdbi and libdbd-sqlite3
for collectd dbi plugin , written custom query to extract data from DB file.
currently dbi plugin fails to access the database file , giving the below
errors.

dbi plugin: cdbi_connect_database (HMDatabase.db): dbi_conn_connect failed:
dbi_conn_error failed with status -3
[2020-11-24 04:27:16] read-function of plugin `dbi:HMDatabase.db' failed.
Will suspend it for 20.000 seconds.
[2020-11-24 04:27:36] dbi plugin: cdbi_connect_database (HMDatabase.db):
dbi_conn_connect failed: dbi_conn_error failed with status -3
[2020-11-24 04:27:36] read-function of plugin `dbi:HMDatabase.db' failed.
Will suspend it for 40.000 seconds.

This is due to to the permission of accessibility issue. I have made the
permissions and owner as root for both collectd daemon and db file , but
still the same issue.

anything that I am missing here.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.verplant.org/pipermail/collectd/attachments/20201124/14d296b4/attachment.html>


More information about the collectd mailing list