topic Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java. in All Apps and Add-ons

DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

Branden — Thu, 24 Oct 2019 22:53:16 GMT

Hi. I'm trying to configure DBConnect on my Splunk instance (Splunk 7.2.4 on RHEL). I can't make any progress because of this error:

OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

That is the correct location of java. It's Oracle java version 1.8.0_231.

JAVA_HOME is set:

echo $JAVA_HOME
/usr/java/latest

The splunk user ('splunk') has full rights to access this installation of java.

-rwxr-xr-x. 1 root root 8534 Oct  5 06:15 /usr/java/latest/bin/java

As you can see, it has wide-open read/execute permissions, and I've manually verified that the splunk user can use java.

I then ran this command:

/opt/splunk//bin/splunk cmd python -c "import os; print(os.environ)"

And see that JAVA_HOME is set:

{'USER': 'splunk', 'LOGNAME': 'splunk', 'JAVA_HOME': '/usr/java/latest', .......

What am I missing here? I've seen similar posts with this question, but no good solutions.

Thank you in advance.

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

richgalloway — Thu, 24 Oct 2019 23:01:00 GMT

What do you get when you run which java? It's possible DBX doesn't like links so if /usr/java/latest is a link try setting $JAVA_HOME in DBX to the real java location.

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

Branden — Thu, 24 Oct 2019 23:07:40 GMT

Thank you for your response.
I thought of that, so I tried the actual path (/usr/java/jdk1.8.0_231-amd64/jre) but it still didn't work.

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

gaurav_maniar — Fri, 25 Oct 2019 12:25:21 GMT

Hi,
In the DBConnect > Configuration > Settings > General, apart for JRE Installation Path are correct,

JVM Option - -Ddw.server.applicationConnectors[0].port=9998
Task Server Port - 9998

and they try to Save & Restart RPC service.

If still, it doesn't work, provide some more error logs.

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

chrisbaniqued — Wed, 30 Sep 2020 02:45:53 GMT

Any luck on this? Encountering the same issue.

Error shows:

Cannot communicate with task server, please check your settings.
OSError: [Errno 2] No such file or directory validate java command: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el7_7.x86_64/jre/bin/java

I changed the server port from default 9998 to 9995 and hit save but it doesn't seem to be making the changes.

JRE Installation Path(JAVA_HOME)
/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el7_7.x86_64/jre

JVM Options
-Ddw.server.applicationConnectors[0].port=9995

Task Server Port
9995

Splunk DB Connect Version: 3.2.0
Splunk Enterprise Version: 8.0

Running alternatives --config java Java installed shows -

java-1.8.0-openjdk.x86_64 (/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el7_7.x86_64/jre/bin/java)

java -version shows

openjdk version "1.8.0_232" OpenJDK Runtime Environment (build 1.8.0_232-b09) OpenJDK 64-Bit Server VM (build 25.232-b09, mixed mode)`

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

DD_MBennett — Tue, 29 Oct 2019 03:44:16 GMT

What version of DB Connect are you using?

I had the exact same issue today after I updated to the latest version.
I rolled back to version 3.1.4 and everything worked perfectly again.

I suspect there is an issue with DB Connect version 3.2.0.

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

Branden — Tue, 29 Oct 2019 13:45:17 GMT

I think this ended up being a red herring. Even though the error was appearing, I clicked through and things still worked as expected. Strange... So it looks like the error was a false positive.

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

chrisbaniqued — Tue, 29 Oct 2019 18:00:57 GMT

Yeah, I suspect it's the new DB Connect version. When I upgraded it, I got errors. I had 3.2 on SplEnt 8.0. When I rolled back everything is working again.

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

RDAVISS — Wed, 30 Oct 2019 18:23:55 GMT

First time user of DB connect here, we had the same problem on version 3.2 and reverted back to 3.1.4. The java path is now recognized (had to restart splunkd though.)

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

aokur_splunk — Thu, 21 Nov 2019 20:28:11 GMT

agreed this is what it worked as well

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

aagro — Fri, 22 Nov 2019 11:52:19 GMT

Same problem, I roll back Splunk DB Connect, below the details about my environment:

Splunk Enterprise 8
Splunk DB Connect 3.1.3
JAVA jdk1.8.0_181

Suppose bugs.

Regards,
Antonio

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

falcalde — Wed, 30 Sep 2020 03:27:11 GMT

Have you managed to solve this problem? I have SplEnt 8.0.1 and db_connect 3.2.0, and exactly same problem.
- Folder permissions Ok
- Path OK
- JAVA_HOME OK
- OpenJDK 8 (splunk db connect says it is supported)

I am lost.
TY.

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

RDAVISS — Mon, 30 Dec 2019 16:04:58 GMT

I created a ticket with splunk support and they logged it as a defect with the latest version of DB connect. So a future release should resolve it. You can always revert to the previous version until then.

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

falcalde — Thu, 02 Jan 2020 13:25:47 GMT

Ok thanks for the answer. Previous version works fine. Upvoted

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

graether — Thu, 02 Jan 2020 14:08:48 GMT

FWIW, my problem was caused not by the new DB connect version, but likely by using a Splunk App Repo on Windows, where executables might have lost there executable "x" right. Then no JDBC related java process was startet. When I reinstalled the DB connect App purely on Linux from scratch, installed the driver, restarted the Heavy Forwarder, then it was working, although the Configuration.General GUI still shows issues.

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

Ranazar — Fri, 03 Jan 2020 19:11:56 GMT

Yeah, reverting to 3.1.4 fixed it for me.

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

skalliger — Wed, 08 Jan 2020 10:31:36 GMT

Yep, I'll add to that. Did not work with DBX 3.2 on Splunk 7.3.x. I had to revert back to 3.1.4, too. SH was running on RHEL.

Skalli

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

tvergov — Thu, 16 Jan 2020 06:54:51 GMT

Looks like this is still the case. I hope someone from dev part to see and fix.
Meantime let us know if there is some nice workaround.

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

falcalde — Thu, 16 Jan 2020 12:56:04 GMT

The only workaround that worked for me was using db_connect version 3.1.4

Re: DBConnect: OSError: [Errno 2] No such file or directory validate java command: /usr/java/latest/bin/java.

teunlaan — Wed, 30 Sep 2020 03:47:31 GMT

To "fix" it:
Use splunk_app_db_connect/bin/dbx2/jre_validator.py form version 3.1.4
OR change the code of the 3.2.0 version line 23:

      if isinstance(command, basestring):