https://community.splunk.com/t5/Splunk-Search/Can-t-connect-to-SQLite-database/m-p/126263#M184334 <P>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.</P> <P>I've created a database connection that looks like: </P> <P>[vFeed]<BR /><BR /> database = /opt/vFeed/vfeed.db<BR /> host = localhost<BR /><BR /> isolation_level = DATABASE_SETTING<BR /><BR /> type = sqlite<BR /><BR /> disabled = 0<BR /> username = root </P> <P>When I try and browse the schema, I get the following error: </P> <P>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.</P> <P>I'm not seeing any error messages. </P> <P>What am I doing wrong here?</P> <P>Thx.</P> <P>Craig</P> Mon, 28 Sep 2020 19:24:51 GMT responsys_cm 2020-09-28T19:24:51Z https://community.splunk.com/t5/Splunk-Search/Can-t-connect-to-SQLite-database/m-p/126263#M184334 <P>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.</P> <P>I've created a database connection that looks like: </P> <P>[vFeed]<BR /><BR /> database = /opt/vFeed/vfeed.db<BR /> host = localhost<BR /><BR /> isolation_level = DATABASE_SETTING<BR /><BR /> type = sqlite<BR /><BR /> disabled = 0<BR /> username = root </P> <P>When I try and browse the schema, I get the following error: </P> <P>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.</P> <P>I'm not seeing any error messages. </P> <P>What am I doing wrong here?</P> <P>Thx.</P> <P>Craig</P> Mon, 28 Sep 2020 19:24:51 GMT https://community.splunk.com/t5/Splunk-Search/Can-t-connect-to-SQLite-database/m-p/126263#M184334 responsys_cm 2020-09-28T19:24:51Z https://community.splunk.com/t5/Splunk-Search/Can-t-connect-to-SQLite-database/m-p/126264#M184335 <P>The database file is vfeed.db. Renaming it vfeed.sqlite and placing it in the /opt/splunk/var/dbx folder solved the problem.</P> Sat, 04 Apr 2015 17:32:16 GMT https://community.splunk.com/t5/Splunk-Search/Can-t-connect-to-SQLite-database/m-p/126264#M184335 responsys_cm 2015-04-04T17:32:16Z