Filipino Programmer | Philippines

Below are errors and solutions on the problems I have encountered today. I am deploying a Coldfusion MX application which uses Apache as the web server and MySQL as the database server. First I will list down an important setup steps to follow when installing Coldfusion MX to use Apache as the Web Server.

I will explain the Web Server Selection of the setup process.

You’ll notice that there are no Web Servers/Sites listed here, but don’t worry — this is OK. We have to tell ColdFusion we want to use the Apache Web server. To do this, click the Add button.

 Make sure you select Apache as your Web Server and, if you left the defaults for your Apache installation, you can use “C:\Program Files\Apache Group\Apache2\conf” for the Configuration Directory and “C:\Program Files\Apache Group\Apache2\bin\Apache.exe” as the Directory and file name of server binary.

When you’re done, click the OK button. You screen should now look like this:

Once you’ve made your selection, click the Next button to continue the process. A few more selections will be presented but the next screens are self explanatory.

Below are errors and solutions I have encountered

When running hｔｔ�://localhost/CFIDE/administrator/index.cfm and encounters this error:
Failure Description: Your browser prompts you to save the .cfm file to your computer.
Resolution: First restart Apache service. If failure still exists, check Apache’s httpd.conf file to make sure Coldfusion module is being loaded, to locate the Coldfusion module entry find this string:

LoadModule jrun_module "C:/CFusionMX7/runtime/lib/wsconfig/1/mod_jrun20.so"

also check is the DirectoryIndex has “index.cfm� added on the lists, if not add it. After that just restart the Apache Server.

To connect to a MySQL 4.1 or 5 database from ColdFusion MX:

Download a current, stable version of the MySQL Connector J JDBC driver, available at: http://dev.mysql.com/downloads/
Note: Connector/J version 3.1.11 and higher cannot be used with ColdFusion MX 7 because of MySQL bug 13469. Connector/J 3.1.10 should be used instead for ColdFusion MX 7 until this MySQL bug is fixed. All Connector/J version 3.0 releases and all version 3.2 releases work with ColdFusion MX 7.

1. Extract the mysql-connector-java-3.{n}-bin.jar file from the downloaded archive file.
2. Save the mysql-connector-java-3.{n}-bin.jar file in the　cf_root/WEB-INF/lib directory.
3. Restart the ColdFusion MX server.
4. Add a new data source to the ColdFusion MX Administrator, using the driver option Other.
5. Enter the JDBC URL:
   jdbc:mysql://[host]:[port]/[database]
6. Enter the Driver Class:
   com.mysql.jdbc.Driver
7. Complete username/password, and adjust other data source settings, if needed.
8. Submit the data source for verification.

Bookmark This!