在页面上显示cfquery参数的Localhost Coldfusion安装(不使用ODBC) [英] Localhost Coldfusion install showing cfquery parameters on page (Not speaking with ODBC)

问题描述

目标:在本地Coldfusion安装上运行远程服务器的cfquery.

问题/症状:cfquery参数将显示在屏幕上，而不是在远程上运行查询.

事实:

• 正在运行Mac OS X Mojave(10.14.3).
• 已安装Coldfusion.我可以通过 http://localhost:8500/CFIDE/administrator/index访问CF管理员面板.cfm
• 数据源已安装在Coldfusion Admin中，状态为确定"
• 使用Mamp Pro 5.3.它正在运行-可以启动和停止Apache.
• Apache在端口80上运行
• 更新了ODBC Actual SQL Server驱动程序(ActualTech的版本4.2.0).使用驱动程序测试了与服务器的连接，并且该服务器正常工作.
• 远程数据库正在使用端口1433

我肯定还有更多问题要回答，但是希望这是一个不错的开始.我究竟做错了什么?

---

更新:2019年3月17日

感觉卡在了这里.我已经卸载并重新安装了CF2018和MAMP Pro.我已经将wsconfig applet用于Adobe Coldfusion(ACF)作为解决方案

此问题的解决方案与与Mac OS X和Coldfusion/Apache的冲突有关.由于Mac OS X 10.14.4修复了与Apache冲突的"mod_jk"文件，因此Coldfusion 2018现在可以在Mac OS X上运行.

为了解决问题，我需要:

1. 将Mac OS X升级到10.14.4
2. 停止所有其他服务器
3. 安装Coldfusion 2018
4. 设置Coldfusion Apache Connector
5. 设置本地虚拟主机

我确认它可以在另一台计算机上工作，并在此帖子中记录了详细说明: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.

解决方案

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.

这篇关于在页面上显示cfquery参数的Localhost Coldfusion安装(不使用ODBC)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！