Issues Connecting to Databases

Communities CommandBox CLI
1

Hi all!

I’m not sure exactly when (maybe a recent OS update – Tahoe 26.0.1) but I can no longer connect to any other database in the CF admin on my local machine. I know these connections are valid as I’m able to connect via DBeaver just fine and the production server as well. I’m not sure if some config in Command box is the issue or something else but I figured I’d reach out here and see if anyone else has ran across this.

I only have the following in my server.json file:

{
    "app":{
        "cfengine":"adobe@2023"
    },
    "jvm":{
        "javaVersion":"openjdk11_jre_aarch64_mac_hotspot_jdk-11.0.24+8"
    }
}

The only thing that stands out when starting the server is the following:

[INFO ] Runwar:   - Binding HTTP on 127.0.0.1:50202
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by runwar.Server (file:/Users/{myusername}/.CommandBox/lib/runwar-5.0.8.jar) to method com.apple.eawt.Application.getApplication()
WARNING: Please consider reporting this to the maintainers of runwar.Server
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
[INFO ] Runwar: ******************************************************************************
[INFO ] Runwar: Configuring Servlet

Here is my java version, if that helps:

openjdk version "11.0.24" 2024-07-16
OpenJDK Runtime Environment Temurin-11.0.24+8 (build 11.0.24+8)
OpenJDK 64-Bit Server VM Temurin-11.0.24+8 (build 11.0.24+8, mixed mode)

Here is what the log tells me (which is not a lot to go on):

[INFO ] Nov 14, 2025 12:52:58 PM Information [XNIO-1 task-1] - Session rotated successfully.
[ERROR] SQLException while attempting to connect: org.postgresql.util.PSQLException: Connection to {ipaddress} refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections..
[ERROR] Connection to {ipaddress} refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
[ERROR] Connection to {ipaddress} refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
[INFO ] Nov 14, 2025 12:53:05 PM Error [XNIO-1 task-4] - Connection to {ipaddress} refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
[ERROR] SQLException while attempting to connect: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: {ipaddress}. Reason: No route to host (Host unreachable).
[ERROR] [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: {ipaddress}. Reason: No route to host (Host unreachable)
[ERROR] [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: {ipaddress}. Reason: No route to host (Host unreachable)
[INFO ] Nov 14, 2025 12:53:20 PM Error [XNIO-1 task-4] - [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: {ipaddress}. Reason: No route to host (Host unreachable)

Any ideas where I should poke around to find where this is failing?

Thanks in advance!
-Shawn

2

Issue seems related to the {ipaddress} placeholder not being replaced. Can you confirm if your datasource definitions are getting created as expected? There may have been some recent CFConfig changes which could have affected this.

3

Also, not that it should affect your problem, but note that cf2023 is intended to run atop Java 17 rather than 11 (which 2021 supported…and cf2025 is designed to run on Java 21).

Brad, have you guys considered adding something to Commandbox to warn of that on starting a server? Did you decide against it intentionally. (Not meaning to side-track the discussion here. A brief answer would be fine.)

4

I’ve thought about it, but never implemented it. Mostly due to annoyance of not having a great way of being able to tell what a given version of java.exe is on the hard drive without having to invoke it directly, which leads to having to guess if it’s -version or --version and then manually parsing the output that comes back.
I did do a super basic version of this check in the commandbox-boxlang module, so it is possible, it’s just annoying.

1 Like
5

Fair enough…though I was thinking more for when people do specify the javaversion, as Shawn did.

6

Sure, but then it would only work in half of scenarios, and I hate features that only half work :wink:

7

I ran into a similar issue after a recent macOS update. After trying several approaches, reinstalling CommandBox and re-authorizing it under Settings > Privacy & Security resolved the problem for me.

1 Like
8

Thanks for the response! I manually removed the ip address when posting. Probably being overly cautious since it’s internal but it’s force of habit. The actual address is there in the log.

9

Well, if the host and port are correct, but the connection is being refused, this sounds like a question you should be asking your network admin :slight_smile: Also check out @Ancient_Programmer 's advice. I could see anti-virus having a similar effect of blocking network connections.

10

Okay, I seem to remember changing the Java version to match the CF install at one point but it probably got blasted on some previous update. I’ll try using JVM to match. Thanks!

11

This is what I expected may be the issue. I don’t see Commandbox listed in my Applications anywhere, however. Maybe that’s because I used Homebrew to install? I’ll keep poking around the Mac security settings and see if I can find something that works. Thanks!

12

In this particular instance, the network admin is a bit of a luddite. At least that’s what I tell him in the mirror every day :slightly_smiling_face:

1 Like
13

Okay, I just circled back got it working now. +1 to @Ancient_Programmer for confirming my suspicion. I thought I had given iTerm permissions to everything but I needed to kill it and reopen it to get the changes to take. Thanks everyone for all of the help/suggestions!

1 Like