CF2023 java.sqI.SQLException: Timed out trying to establish connection

[SajanM]

We had a new linux vm built (RHEL 9) and installed CF2023. We migrated the settings (.car file) from the existing CF2021 and trying to get it up and running. So far we are good with admin console and app folder migrations. But we could get the datasource connection working.

The issue we are seeing is when trying to verify an oracle datasource. (using macromedia.jd bc.oracle.OracleDnver)

        Connection verification failed for datasource:ptcltst
        java.sqI.SQLException: Timed out trying to establish connection

We have checked network connectivity between the cf 2023 server and the orace database on port 1521 and it successfull but it fails in the admin console with above error. There is nothing being recd at the target oracle db.

When we try the same connection from CF2021 server admin console, we are able to connect and oracle is able to recieve the connection info
20-NOV-2024 15:00:22 * (CONNECT_DATA=(SERVICE_NAME=tstdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=coldfusion))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.xxx.xx)(PORT=49816)) * establish *

Any help is greatly appreciated.

Thanks

Sajan

[SajanM · Accepted solution]

Yes, it was a rhel linux vm issue related to network configuration

getsebool -a | grep httpd
You should see:

httpd_can_network_connect --> on   

(mine was set to off, turned it on and it was able to connect after that)

Thanks

[Charlie Arehart]

Very glad to hear both that it's resolved and how you diagnosed/resolved it. Thanks. 

What you've shared could help others here if they're running Linux, and specifically selinux. 

FWIW,  when I offered in Nov that it might have been instead that  "known issue" of dsn verification failure from the Oct CF update's technote, sadly that doc didn't clarify if the connection failure would look like the "timed out" error you got, so it was just a guess if it might help you. Hope it may still help others, who may find this thread, if they don't share your specific issue.

Still for now I have marked your comment as "the answer", as it does address your specific issue. 🙂 

[BKBK]

Hi @SajanM ,

Thanks for sharing the solution.

Instructive.