Skip to main content
H
HKCC
New Participant
January 2, 2024
Question

Cannot Configure MongoDB Datasource

  • January 2, 2024
  • 2 replies
  • 3487 views

ColdFusion 2023 Licensed Standard Edition (also tried on Enterprise Edition trial).

 

We have a MongoDB NoSQL Database we wish to access from ColdFusion. We have a known-good connection string to the database which we can use with NoSQLBooster and MongoDBCompass on the server. What I cannot get to work is the datasource in ColdFusion. I can configure a datasource using 3rd party JDBC drivers, but these come with a hefty annual fee. ColdFusion advertises support for MongoDB, so cannot justify this unbudgeted expense.

 

In earlier versions of ColdFusion it was necessary to download and install MongoDB separately. I've attempted to follow the instructions to use cfpm.bat with the 'install cfmongodb' command but the server responds with 'cfmongodb (2023.0.05.330608) package is already installed'. Support for MongoDB appears to be present.

 

The message returned by CF Admin NoSQL Datasources is:

  • Data source could not be verified. Unable to connect to the MongoDB datasource with host hkcc-pro<snip>/, port 27017. To connect successfully, enter a valid host and port

 

The hostname is the same as we use with NoSQLBooster and MongoDBCompas.

 

 

Can anyone provide guidance on how to get a MongoDB database configured in CF 2023?

 

 

This topic has been closed for replies.

2 replies

D
Dave Watts
Community Expert
January 2, 2024

The most likely problem, I think, is DNS name resolution failure. I recommend trying with the IP address instead of the hostname, or putting the name and address in your hosts file.

 

Dave Watts, Eidolon LLC

Dave Watts, Eidolon LLC
Charlie Arehart
Charlie Arehart
Community Expert
January 2, 2024

FWIW, they had noted, "The hostname is the same as we use with NoSQLBooster and MongoDBCompas".  But if you may be proposing the dns lookup on the server may be a different result, it's possible. The diagnostics I proposed might tell us either way. 

/Charlie (troubleshooter, carehart. org)
D
Dave Watts
Community Expert
January 2, 2024

I don't know what kind of server registration if any exists in those tools, but chances are you're correct.

 

Dave Watts, Eidolon LLC

Dave Watts, Eidolon LLC
Charlie Arehart
Charlie Arehart
Community Expert
January 2, 2024

First, when you say those two query tools work fine, are you running them on the same machine that's running cf? If not, you may find they'd fail also (if installed there), which would seem to indicate a firewall/network config issue on either end: either the db server/service not allowing the call in from the cf machine, or the cf machine/network config not allowing the call out to that db host or port.

 

Even if you don't want to/can't install those tools, there are other ways you could simply check the port connectivity from the the cf machine (without installing those query tools), such as using old school telnet or other options I offer in a blog post on alternatives to that.

 

Let us know if those get you going, or not. 

 

Finally, FWIW, while the cfpm tool is indeed one way to view or change CF's packages, note that you can also do that from within the cf admin. It's at the bottom of the same page used for applying cf updates. (You didn't mention it, so I just want to make sure you or other readers are aware.)

/Charlie (troubleshooter, carehart. org)
    H
    HKCCAuthor
    New Participant
    January 3, 2024

    Hi Charlie. Thank you for your suggestions.

     

    Yes, the tools run successfully on the server where ColdFusion 2023 Enterprise Trial is running. See attachment beginning 01. (the tools also run successfully on another server with licensed ColdFusion 2023 Standard).

     

    Test-NetConnection tests to all 3 hosts in the MongoDB SRV record are successful. See attachment beginning 12.

     

    Noted your comment about using the CF admin interface in place of cfpm.

     

    Thanks again for your reply.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices