My SQLite db file is Data.db and it's located at /home/myUser/.
So the first thing I got when I restarted the splunk app were some "Invalid key in stanza" errors.
1. Invalid key in stanza [mydb] in .... jdbcUrlFormat (value: jdbc:SQLite:<database>)
2. Invalid key in stanza [rpcstart://default] in ... javahome (value: /user/java/jdk1.8.0_122/jre)
3. Invalid key in stanza [rpcstart:://default] in .. useSSL (value : 0)
Note that I didn't write those last two stanzas.
On the splunk server, there is no errors:
Splunk DB Connect->Configuration->Settings:
The JRE installation path is correct.
There is a JVM Option (-Ddw.server.applicationConnectors.port=9998)
Task server Port = 9998
Splunk DB Connect->Configuration->Drivers:
I can see the SQLite as a Driver Name, but on the Installed column shows as "NO".
I can see mydb as a connection which is good.
Data Lab -> SQL Explorer
If I try to select mydb as a connection, the field turns red with the "invalid database connection" message.
So this is the issue. How can I access my SQLite db from Splunk DB Connect?
Splunk DB Connect version = 3.1.1'
Linux Machine (RedHat)
Java version "1.8.0_112"
Java(TM) SE Runtime Environment (build 1.8.0_112-b15)
Java HotSpot(TM) 64-Bit Server VM (build 25.112-b15, mixed mode)