Search code examples
coldfusionodbcmamp

Localhost Coldfusion install showing cfquery parameters on page (Not speaking with ODBC)

Goal: Run cfquery of remote server on local Coldfusion install.

Problem/Symptoms: The cfquery parameters are printing onto the screen, instead of running query on remote.Example of cfquery parameter printout on screen

Example of cfquery parameter printout on screen

Facts:

  • Running Mac OS X Mojave (10.14.3).
  • Coldfusion is installed. I can access the CF Admin panel at http://localhost:8500/CFIDE/administrator/index.cfm
  • Data Source is installed in Coldfusion Admin and status is "OK"
  • Using Mamp Pro 5.3. It's running -- can start and stop Apache.
  • Apache is running on port 80
  • Updated ODBC Actual SQL Server drivers (Version 4.2.0 from ActualTech). Tested connection to server with driver and it is working.
  • Remote database is using port 1433

I'm sure there are more questions to answer, but hopefully that's a decent start. What am I doing wrong?

Update: 3/17/2019

Feeling stuck here. I've uninstalled and reinstalled CF2018 and MAMP Pro. I've used the wsconfig applet for Adobe Coldfusion (ACF) as described by Brian Lang and I've also tried the manual approach as described by Adobe.

Update: 4/19/2019

I may have figured this out, now that there is a release of Mac OS 10.14.4. Going to test it on another computer to confirm that the process works and that I have all the steps documented, then will share answers.

Solution

  • The solution to this problem had to do with a conflict with Mac OS X and Coldfusion/Apache. Because Mac OS X 10.14.4 fixed the "mod_jk" file that was conflicting with Apache, Coldfusion 2018 can now run on Mac OS X.

    In order to solve the problem, I needed to:

    1. upgrade Mac OS X to 10.14.4
    2. stop all other servers
    3. install Coldfusion 2018
    4. set up Coldfusion Apache Connector
    5. set up local virtual host

    I confirmed that it worked on another computer, and have documented detailed instructions in this post: https://www.steckinsights.com/configuring-coldfusion-2018-with-apache-on-mac-os-x-mojave/

    Fair warning: I think that the mod_jk issue in Mac OS 10.14.3 and prior was the issue, but there were so many different aspects I tested in the process, that there may be unique issues related to your particular computer's configuration. I hope hope this helps anyone out there having issues.