Splunk Search

Can't connect to SQLite database

responsys_cm
Builder

I'm using the DB Connect V1 app in Splunk 6.2 on an Ubuntu Linux server. I have a local sqlite database. I can use the sqlite3 command to connect to it successfully.

I've created a database connection that looks like:

[vFeed]

database = /opt/vFeed/vfeed.db
host = localhost

isolation_level = DATABASE_SETTING

type = sqlite

disabled = 0
username = root

When I try and browse the schema, I get the following error:

The internal search "| dbinfo database="vFeed" type=schemas | sort -default | eval label=if(isnull(default),schema,schema+" (default)")" for the "Splunk.Module.SearchSelectLister" module failed.

I'm not seeing any error messages.

What am I doing wrong here?

Thx.

Craig

Tags (1)
0 Karma

responsys_cm
Builder

The database file is vfeed.db. Renaming it vfeed.sqlite and placing it in the /opt/splunk/var/dbx folder solved the problem.

0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...