Splunk DB Connect Error:Unable to initialize modular input "server"

[Roy_9]

Hello,

We are seeing the below error after our linux upgrade, Could someone please help us fix this issue?

Unable to initialize modular input "server" defined in the app "splunk_app_db_connect": Introspecting scheme=server: script running failed (exited with code 127).

When i saw this issue last time, i have set the JAVA_HOME path in splunk-launch.conf file, it worked then but we are seeing this error again 

Please help me out.

Thanks

[Roy_9 · Accepted solution]

Just figured out the issue, Posting it here where it may help anyone with same situation.

Whenever linux patching is getting done, it is also updating our Java version,

So I went ahead and set the JAVA_HOME path again.

Steps followed:

1.found the java installation path on our linux box using the below command.

$(dirname $(dirname $(readlink -f $(which javac))))

2.Executed the below command after getting the path.

JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.312.b07-1.el7_9.x86_64

3. Updated the JAVA_HOME path in splunk-launch.conf file

/opt/splunk/etc/splunk-launch.conf

 Modify the following line to suit the location of your Splunk install.
# If unset, Splunk will use the parent of the directory containing the splunk
# CLI executable.
#
# SPLUNK_HOME=/opt/splunk-home
JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.312.b07-1.el7_9.x86_64

4. Updated the same JAVA_HOME path in the UI of Splunk DB connect-Configuration-Settings-JRE Installation path

5. Did a Splunk restart and it worked.

Happy Splunking