Adobe 38000827 - Macromedia ColdFusion MX Standard... Instruction Manual

Administering ColdFusion MX

Trademarks
Afterburner, AppletAce, Attain, Attain Enterprise Learning System, Attain Essentials, Attain Objects for Dreamweaver, Authorware,
Authorware Attain, Authorware Interactive Studio, Authorware Star, Authorware Synergy, Backstage, Backstage Designer, Backstage
Desktop Studio, Backstage Enterprise Studio, Backstage Internet Studio, ColdFusion, Design in Motion, Director, Director
Multimedia Studio, Doc Around the Clock, Dreamweaver, Dreamweaver Attain, Drumbeat, Drumbeat 2000, Extreme 3D, Fireworks,
Flash, Fontographer, FreeHand, FreeHand Graphics Studio, Generator, Generator Developer's Studio, Generator Dynamic Graphics
Server, JRun, Knowledge Objects, Knowledge Stream, Knowledge Track, Lingo, Live Effects, Macromedia, Macromedia M Logo &
Design, Macromedia Flash, Macromedia Xres, Macromind, Macromind Action, MAGIC, Mediamaker, Object Authoring, Power
Applets, Priority Access, Roundtrip HTML, Scriptlets, SoundEdit, ShockRave, Shockmachine, Shockwave, Shockwave Remote,
Shockwave Internet Studio, Showcase, Tools to Power Your Ideas, Universal Media, Virtuoso, Web Design 101, Whirlwind and Xtra
are trademarks of Macromedia, Inc. and may be registered in the United States or in other jurisdictions including internationally. Other
product names, logos, designs, titles, words or phrases mentioned within this publication may be trademarks, servicemarks, or
tradenames of Macromedia, Inc. or other entities and may be registered in certain jurisdictions including internationally.
This product includes code licensed from RSA Data Security.
This guide contains links to third-party websites that are not under the control of Macromedia, and Macromedia is not responsible for
the content on any linked site. If you access a third-party website mentioned in this guide, then you do so at your own risk. Macromedia
provides these links only as a convenience, and the inclusion of the link does not imply that Macromedia endorses or accepts any
responsibility for the content on those third-party sites.
Apple Disclaimer
APPLE COMPUTER, INC. MAKES NO WARRANTIES, EITHER EXPRESS OR IMPLIED, REGARDING THE ENCLOSED
COMPUTER SOFTWARE PACKAGE, ITS MERCHANTABILITY OR ITS FITNESS FOR ANY PARTICULAR PURPOSE.
THE EXCLUSION OF IMPLIED WARRANTIES IS NOT PERMITTED BY SOME STATES. THE ABOVE EXCLUSION MAY
NOT APPLY TO YOU. THIS WARRANTY PROVIDES YOU WITH SPECIFIC LEGAL RIGHTS. THERE MAY BE OTHER
RIGHTS THAT YOU MAY HAVE WHICH VARY FROM STATE TO STATE.
Copyright © 1999–2002 Macromedia, Inc. All rights reserved. This manual may not be copied, photocopied, reproduced, translated,
or converted to any electronic or machine-readable form in whole or in part without prior written approval of Macromedia, Inc.
Part Number ZCF60M400
Acknowledgments
Project Management: Stephen M. Gilson
Writing: Michael Stillman
Editing: Linda Adler and Noreen Maher
First Edition: May 2002
Macromedia, Inc.
600 Townsend St.
San Francisco, CA 94103

iii
CONTENTS
ABOUT THIS BOOK . . . . . . . . . . . . . . . . . . . . . . . . . . . . V
Developer resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vi
About Macromedia ColdFusion MX documentation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .vii
Printed and online documentation set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .vii
Viewing online documentation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viii
Getting answers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viii
Contacting Macromedia . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viii
CHAPTER 1 Administering ColdFusion . . . . . . . . . . . . . . . . . . . . . . . .1
About the ColdFusion Administrator. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2
Accessing user assistance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2
Administrator layout . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3
Server Settings section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4
Data & Services section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4
Debugging & Logging section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5
Extensions section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5
Security section. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5
CHAPTER 2 Basic ColdFusion MX Administration . . . . . . . . . . . . . 7
Initial administration tasks. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8
Server Settings section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .9
Settings page. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .9
Caching page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .9
Client Variables page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10
Memory Variables page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12
Mappings page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13
Mail Server page. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13
Charting Settings page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15
Java and JVM Settings page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15
Archives and Deployment page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16
Settings Summary page. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16
Data & Services section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17
Data Sources page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17
Verity Collections page. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17
Verity K2 Server page. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .18
Web Services page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .18

iv Contents
Debugging & Logging section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .19
Debugging Settings page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .19
Debugging IP Addresses page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .22
Logging Settings page. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .22
Log Files page. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .23
Scheduled Tasks page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .24
System Probes page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .24
Code Compatibility Analyzer page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .24
Extensions section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .25
Java Applets page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .25
CFX Tags page. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .25
Custom Tag Paths page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .25
CORBA Connectors page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .25
Security section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .27
CF Admin Password page. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .27
RDS Password page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .27
Sandbox Security page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .27
Custom Extensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .28
CHAPTER 3 Data Source Management . . . . . . . . . . . . . . . . . . . . . 29
About JDBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .30
Supplied drivers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .31
Adding data sources. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .32
Adding data sources in the Administrator. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .32
Connecting to DB2 UDB for OS/390. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .36
Connecting to DB2 Universal Database 6.2, 7.2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .37
Connecting to Informix 9.x . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38
Connecting to Microsoft Access. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .39
Connecting to Microsoft SQL Server 7.x, 2000. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .41
Connecting to MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .43
Connecting to ODBC Socket . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .44
Connecting to Oracle R3 (8.1.7), Oracle 9i. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .45
Connecting to other data sources. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46
Connecting to Sybase 11.5, 11.9, 12.0, and 12.5. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47
CHAPTER 4 Administering Security . . . . . . . . . . . . . . . . . . . . . . . . 49
About ColdFusion security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .50
Security and ColdFusion edition differences. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .50
Default security behavior . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .51
Using sandbox security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .53
About directories and permissions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .53
Adding a sandbox. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .55
Configuring a sandbox . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .56
INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59

v
ABOUT THIS BOOK
Administering ColdFusion MX is intended for anyone who needs to configure and manage
their ColdFusion development environment.
Contents
•Developer resources ................................................................................................ vi
•About Macromedia ColdFusion MX documentation............................................. vii
•Getting answers .................................................................................................... viii
•Contacting Macromedia....................................................................................... viii

vi About This Book
Developer resources
Macromedia, Inc. is committed to setting the standard for customer support in developer
education, documentation, technical support, and professional services. The
Macromedia website is designed to give you quick access to the entire range of online
resources. The following table shows the locations of these resources:
Resource Description URL
Macromedia
website
General information about Macromedia
products and services
http://www.macromedia.com
Information on
ColdFusion
Detailed product information on
ColdFusion and related topics
http://www.macromedia.com/coldfusion
Macromedia
ColdFusion
Support Center
Professional support programs that
Macromedia offers
http://www.macromedia.com/support/
coldfusion
ColdFusion
Online Forums
Access to experienced ColdFusion
developers through participation in the
Online Forums, where you can post
messages and read replies on many
subjects relating to ColdFusion
http://webforums.macromedia.com/
coldfusion/
Installation
Support
Support for installation-related issues for
all Macromedia products
http://www.macromedia.com/support/email/
isupport
Training Information about classes, on-site training,
and online courses offered by Macromedia
http://www.macromedia.com/support/training
Developer
Resources
All the resources that you need to stay on
the cutting edge of ColdFusion
development, including online discussion
groups, Knowledge Base, technical
papers, and more
http://www.macromedia.com/desdev/
developer/
Reference Desk Development tips, articles,
documentation, and white papers
http://www.macromedia.com/v1/developer/
TechnologyReference/index.cfm
Macromedia
Alliance
Connection with the growing network of
solution providers, application developers,
resellers, and hosting services creating
solutions with ColdFusion
http://www.macromedia.com/partners/

About Macromedia ColdFusion MX documentation vii
About Macromedia ColdFusion MX documentation
The ColdFusion documentation is designed to provide support for the complete
spectrum of participants. The print and online versions are organized to let you quickly
locate the information that you need. The ColdFusion online documentation is provided
in HTML and Adobe Acrobat formats.
Printed and online documentation set
The ColdFusion documentation set consists of the following titles:
Book Description
Installing ColdFusion
MX
Describes system installation and basic configuration for Windows
NT, Windows 2000, Solaris, Linux, and HP-UX.
Administering
ColdFusion MX
Describes how to use the ColdFusion Administrator to manage the
ColdFusion environment, including connecting to your data
sources and configuring security for your applications,
DevelopingColdFusion
MX Applications with
CFML
Describes how to develop your dynamic web applications,
including retrieving and updating your data, using structures, and
forms.
Getting Started
Building ColdFusion
MX Applications
Contains an overview of ColdFusion features and application
development procedures. Includes a tutorial that guides you
through the process of developing an example ColdFusion
application.
Using Server-Side
ActionScript in
ColdFusion MX
Describes how Macromedia Flash movies executing on a client
browser can call ActionScript code running on the ColdFusion
server. Includes examples of server-side ActionScript and a syntax
guide for developing ActionScript pages on the server.
Migrating ColdFusion 5
Applications
Describes how to migrate a ColdFusion 5 application to
ColdFusion MX. This book describes the code compatibility
analyzer that evaluates your ColdFusion 5 code to determine any
incompatibilities within it.
CFML Reference Provides descriptions, syntax, usage, and code examples for all
ColdFusion tags, functions, and variables.
CFML Quick
Reference
A brief guide that shows the syntax of ColdFusion tags, functions,
and variables.
Working with Verity
Tools
Describes Verity search tools and utilities that you can use for
configuring the Verity K2 Server search engine, as well as creating,
managing, and troubleshooting Verity collections.
Using ClusterCATS Describes how to use Macromedia ClusterCATS, the clustering
technology that provides load-balancing and failover services to
assure high availability for your web servers.

viii About This Book
Viewing online documentation
All ColdFusion documentation is available online in HTML and Adobe Acrobat Portable
Document Format (PDF) files. To view the HTML documentation, open the following
URL on the web server running ColdFusion: http://web_root/cfdocs/dochome.htm.
ColdFusion documentation in Acrobat format is available on the ColdFusion product
CD-ROM.
Getting answers
One of the best ways to solve particular programming problems is to tap into the vast
expertise of the ColdFusion developer communities on the ColdFusion Forums. Other
developers on the forum can help you figure out how to do just about anything with
ColdFusion. The search facility can also help you search messages from the previous 12
months, allowing you to learn how others have solved a problem that you might be
facing. The Forums is a great resource for learning ColdFusion, but it is also a great place
to see the ColdFusion developer community in action.
Contacting Macromedia
Corporate
headquarters
Macromedia, Inc.
600 Townsend Street
San Francisco, CA 94103
Tel: [phone]
Fax: [phone]
Web: http:// www.macromedia.com
Technical support Macromedia offers a range of telephone and web-based
support options. Go to http://www.macromedia.com/support/
coldfusionfor a complete description of technical support
services.
You can make postings to the ColdFusion Support Forum
(http://webforums.macromedia.com/coldfusion) at any time.
Sales Toll Free: 888.939.2545
Tel: [phone]
Fax: [phone]
E-mail: [e-mail]
Web: http://www.macromedia.com/store

1
CHAPTER 1
Administering ColdFusion
This chapter presents an overview of the ColdFusion Administrator and how you can use
it to manage your development environment. For procedures, see the Administrator’s
online Help.
Contents
•About the ColdFusion Administrator ...................................................................... 2
•Accessing user assistance .......................................................................................... 2
•Administrator layout................................................................................................ 3

2 Chapter 1 Administering ColdFusion
About the ColdFusion Administrator
The ColdFusion Administrator provides a browser-based interface for managing your
ColdFusion environment. You can configure many settings to provide optimal levels of
security and functionality. The available options are based on your edition of
ColdFusion: Standard, Professional, or Enterprise.
The default location for the ColdFusion Administrator login page is:
http://servername/cfide/Administrator/index.cfm
In the previous URL, servername is the fully qualified domain name of your web server.
Common values for servername are localhost or 127.0.0.1 (each refers to the web server
on the local computer).
If you are using the ColdFusion built-in web server, include the port numer as part of the
servername. The default port number is 8500: http://servername:8500/cfide/
Administrator/index.cfm.
If your ColdFusion Administrator is on a remote computer, use the DNS name or IP
address of the remote host.
To access the ColdFusion Administrator, enter the username and password that you used
when you installed ColdFusion.
Accessing user assistance
You can obtain assistance from the ColdFusion Administrator in the following ways:
•Online Help You access the context-sensitive online Help by clicking the
question-mark icon on any ColdFusion Administrator page. The online Help has
procedural and brief overview content for the ColdFusion Administrator page that
you are viewing. This information appears in a new browser window and contains
standard Contents, Index, and Search tabs.
•Documentation Click the link to access the entire ColdFusion documentation set,
which is available as HTML files.
•Examples The example applications provide samples for you to learn about
ColdFusion.
•Knowledge Base You can access the collection of articles about ColdFusion from
the Macromedia website.
•Support Forums You can browse (or post to) the searchable online collection of
ColdFusion questions and answers at the Macromedia website.

Administrator layout 3
Administrator layout
The home page of the ColdFusion Administrator includes links to Documentation, the
Macromedia Servers TechNotes Knowledge Base, Release Notes, Version Information,
online Help, and Code Examples:
The tasks that you perform in the ColdFusion Administrator are grouped into the
following sections. Each section contains links to pages for managing aspects of the
system:
•Server Settings Manage whitespace, client and memory variables, locking, and
mappings. Register a mail server and configure mail logging. Configure your JVM,
the ColdFusion charting and graphing engine, and create and manage archives.
•Data & Services Configure data sources, Verity collections, and the Verity K2
Server. Define mappings to web services.
•Debugging & Logging Manage options that can assist you in troubleshooting your
ColdFusion applications. Manage scheduled tasks, system probes, and a variety of log
files and server statistics. Run the Code Compatibility Analyzer to assist you in
migrating older ColdFusion applications.
•Extensions Configure and register Java Applets, CORBA ORBs, and CFX Tags.
•Security Control passwords for ColdFusion Administrator and Remote Data
Source (RDS) access. Restrict the use of resources, such as data sources.

4 Chapter 1 Administering ColdFusion
For more information about each section, see Chapter 2, “Basic ColdFusion MX
Administration” on page 7.
Server Settings section
The Server Settings section contains the following areas:
•Settings Manage the number of simultaneous requests, request timeouts,
whitespace, and handlers.
•Caching Manage caching options for memory, database connection time, the
number of cached queries, and using a trusted template cache.
•Client Variables Configure an external data source, the operating system registry,
or web browser cookies to store client variables. These can use and store information
about a client browsing your site to provide customized page content.
•Memory Variables Specify timeout values for Application and Session variables.
These variables are stored in RAM and maintain information throughout a
ColdFusion session.
•Mappings Create logical aliases for physical directories on your server. One of your
first tasks after installing ColdFusion is to configure the mapping for your web server.
•Mail Server Configure the mail server that ColdFusion uses to send dynamic mail
messages using SMTP (Simple Mail Transfer Protocol).
•Charting Specify caching and thread settings for the ColdFusion charting and
graphing engine.
•Java and JVM Settings Manage Java Virtual Machine settings such as paths, heap
sizes, and implementation options.
•Archives and Deployment Create and deploy application archives.
•Settings Summary View the status of all ColdFusion configuration settings. You
can navigate to a particular area of the ColdFusion Administrator by clicking its
name.
Data & Services section
The Data & Services section contains the following pages:
•Data Sources Create and manage your data sources. You can specify login
parameters, connection information, and restrict certain SQL operations. For more
information, see Chapter 3, “Data Source Management” on page 29.
•Verity Collections Create and manage your Verity collections. Search engines for
your ColdFusion applications use these indexes of various files within specified
directories.
•Verity K2 Server Configure the Host Name and Port settings for your K2 Server.
This specialized server is optimized for high-performance Verity searches.
•Web Services Define a mapping to the location of a web service.

Administrator layout 5
Debugging & Logging section
The Debugging & Logging section contains the following pages:
•Debugging Settings Enable and configure information to help you diagnose
ColdFusion page failures. You can return information on items such as template
stack, database activity, and variable values.
•Debugging IP Addresses Control which IP addresses receive debug messages.
•Logging Settings Specify the directory for your log files, and whether to write
some ColdFusion log messages to the operating system’s logging facility (such as
EventLog for Windows and syslog for UNIX).
•Log Files Search, view, download, schedule, archive, or delete a file from a list of all
available log files.
•Scheduled Tasks Add, edit, or delete scheduled tasks. These tasks are helpful for
such items as daily reports, inventories, and statistical reports.
•System Probes Manage probes that monitor your application’s status. If a
potential problem is detected, a system probe can send an alert e-mail message and
execute a recovery script.
•Code Analyzer Evaluate application code for potential incompatibilities between
ColdFusion MX and ColdFusion Server 5.
Extensions section
The Extensions section contains the following pages:
•Java Applets Register, edit, or delete Java applets. You must register a Java applet
prior to adding it to your CFFORM forms using the cfapplet tag.
•CFX Tags Register, edit, or delete C++ and Java custom tags.
•Custom Tag Paths Register the paths that contain your custom tags.
•CORBA Connectors Register, edit, or delete CORBA connectors. You can also
specify ORB initialization options.
Security section
The Security section contains the following pages:
•CF Admin Password Set the password for the administrator
•RDS Password Set the password for Dreamweaver MX and CF Studio users
connecting to ColdFusion.
•Sandbox Security Restrict access to ColdFusion resources such as data sources,
tags, functions, files and directories, and IP addresses.
For more information, see Chapter 4, “Administering Security” on page 49.

6 Chapter 1 Administering ColdFusion

7
CHAPTER 2
Basic ColdFusion MX Administration
This chapter explains the basic ColdFusion MX administration tasks, following the
sturcture of the ColdFusion Administrator sections.
Contents
•Initial administration tasks....................................................................................... 8
•Server Settings section ............................................................................................. 9
•Data & Services section ......................................................................................... 17
•Debugging & Logging section............................................................................... 19
•Extensions section.................................................................................................. 25
•Security section...................................................................................................... 27
•Custom Extensions................................................................................................ 28

8 Chapter 2 Basic ColdFusion MX Administration
Initial administration tasks
Immediately after installing ColdFusion MX, you might have to perform some or all of
the administrative tasks described in the following table:
Task Description
Establish
database
connections
ColdFusion applications require data source connections to query and
write to databases. To create, verify, edit, and delete database
connections, use the Data Sources pages in the Administrator.
For more information, see Chapter 3, “Data Source Management” on
page 29.
Specify directory
mappings
Directory mappings redirect relative file paths to physical directories on
your server. To specify server-wide directory aliases, use the Mappings
page in the Administrator.
For more information, see “Mappings page” on page 13.
Configure
debugging
settings
Debugging information provides important data about CFML page
processing. To choose the debugging information to display, and to
designate an IP address to receive debugging information, use the
Debugging & Logging section of the Administrator.
For more information, see “Debugging Settings page” on page 19.
Set up e-mail E-mail lets ColdFusion MX and ColdFusion applications send
automated mail messages. To configure an e-mail server and mail
options, use the Mail Server page of the Administrator.
For more information, see “Mail Server page” on page 13.
Change
passwords
You might have to change the passwords that you set for the
ColdFusion Administrator and ColdFusion Studio during ColdFusion
MX installation. To change passwords, use the Basic Security pages of
the Administrator.
For more information, see “CF Admin Password page” on page 27 and
“RDS Password page” on page 27.
Configure Java
settings
Java and Java applets require configuring Java settings, such as JVM
paths. To change Java settings, use the Java and JVM Settings page of
the Administrator.
For more information, see “Extensions section” on page 25.
Restrict tag
access
Some CFML tags might present a potential security risk for your server.
To disable certain tags and tag attributes system-wide, use the Tag
Restrictions page of the Administrator.
For more information, see “Administering Security” on page 49.

Server Settings section 9
Server Settings section
The Server Settings section lets you manage client and memory variables, mappings,
charting, and archiving. You also configure mail and Java settings in this section.
Settings page
The Settings page of the ColdFusion Administrator contains configuration options that
you can set or enable to manage ColdFusion MX. These options can significantly affect
server performance. The following table describes the settings:
Caching page
The Caching page of the Administrator contains configuration options that you can set
or enable to cache templates, queries, and data sources. These options can significantly
affect server performance. The following table describes the settings:
Setting Description
Limit simultaneous
requests
Enter a number to limit simultaneous requests to ColdFusion MX.
When the server reaches the limit, requests are queued and handled
in the order received. Limiting the number of simultaneous requests
can improve performance.
Timeout requests
after [n] seconds
Enable this option to prevent unusually lengthy requests from using
up server resources. Enter a limit to the time that ColdFusion MX
waits before terminating a request. Requests that take longer than
the timeout period are terminated.
Use UUID for
cftoken
Specify whether to use a universally unique identifier (UUID), rather
than a randon number, for a cftoken.
Enable Whitespace
Management
Enable this option to compress runs of spaces, tabs and carriage
return/line feeds. Compressing whitespace can significantly
compact the output of a ColdFusion page.
Missing Template
Handler
Specify a template to execute when ColdFusion MX cannot find a
requested page.
Site-wide Error
Handler
Specify a page to execute when ColdFusion MX encounters an error
while processing a request.
Setting Description
Template cache size
(number of
templates)
Enable this option to limit the memory reserved for template
caching. For best performance, set this to a value that is large
enough to contain your application’s commonly accessed
ColdFusion pages, yet small enough to avoid excessive reloading.
You can experiment with a range of values on your development
server; a suitable starting point is one page per MB of JVM size.

10 Chapter 2 Basic ColdFusion MX Administration
Client Variables page
Client variables let you store user information and preferences between sessions. Using
information from client variables, you can customize page content for individual users.
You enable client variable default settings in ColdFusion MX on the Client Variables
page of the Administrator. ColdFusion MX lets you store client variables in the following
ways:
•In a data source
If your data source uses a bundled JDBC driver, ColdFusion can automatically create
the necessary tables. If your data source uses the ODBC Socket or a third-party
JDBC driver, you must manually create the necessary CDATA and CGLOBAL
database tables. For more information, see Developing ColdFusion MX Applications
with CFML.
•As cookies in users’ web browsers
•In the operating system registry
Caution: Macromedia recommends that you do not store client variables in the registry
because it can critically degrade performance of the server. If you do use the registry to
store client variables, you must allocate sufficient memory and disk space.
You can override settings specified in the Client Variables page using the attributes of the
cfapplication tag. For more information, see Developing ColdFusion MX Applications
with CFML.
Trusted cache Enable this option if you want ColdFusion MX to use cached
templates without checking whether they changed. For sites that
are not updated frequently, using this option minimizes file system
overhead.
Limit the maximum
number of cached
queries on the server
to [n] queries
Enable this option by entering a value to limit the maximum number
of cached queries that the server maintains. Cached queries allow
retrieval of result sets from memory rather than through a database
transaction. Because queries reside in memory, and query result set
sizes differ, you must provide a limit for the number of cached
queries. You enable cached queries with the cachedwithin or
cachedafter attributes of the cfquery tag.
Setting Description

Server Settings section 11
The following table compares these storage options:
Migrating client variable data
To migrate your client variable data to another data source, you should know the
structure of the database tables that store this information. Client variables stored
externally use two small database tables, like those shown in the following tables:
Storage type Advantages Disadvantages
Data source •Can use existing data
source
•Portable: not tied to the
host system or operating
system
•Requires database transaction to
read/write variables
•More complex to implement
Browser cookies •Simple implementation
•Good performance
•Can be set to expire
automatically
•Client-side control
•Users can configure browsers to
disallow cookies
•ColdFusion MX limits a cookie’s
data to 4 KB
•Netscape Navigator allows only 20
cookies from one host; ColdFusion
MX uses three cookies to store
read-only data, leaving only 17
cookies available
System registry •Simple implementation
•Good performance
•Registry can be exported
easily to other systems
•Server-side control
•Possible restriction of the registry’s
maximum size limit on Windows in
the Control Panel
•Integrated with the host system: not
practical for clustered servers
•Solaris, Linux, and HP-UX registries
are text files. Their registries deliver
slow performance and low
scalability.
CDATA Table
Column Data type
cfid CHAR(64), TEXT, VARCHAR, or equivalent
app CHAR(64), TEXT, VARCHAR, or equivalent
data MEMO, LONGTEXT, LONG VARCHAR, or equivalent
CGLOBAL Table
Column Data type
cfid CHAR(64), TEXT, VARCHAR, or equivalent
data MEMO, LONGTEXT, LONG VARCHAR, or equivalent
lvisit TIMESTAMP, DATETIME, DATE, or equivalent

12 Chapter 2 Basic ColdFusion MX Administration
Creating client variable tables
Use the following sample ColdFusion page as a model for creating client variable
database tables in your own database. However, keep in mind that not all databases
support the same column data type names. For the proper data type, see your database
documentation.
Tip: The ColdFusion Administrator can create client variable tables for data sources that
use bundled JDBC drivers. For more information, see the online Help.
Sample table creation page
<!---- Create the Client variable storage tables in a datasource.
This example applies to Microsoft Access databases --->
<cfquery name="data1" datasource="#DSN#">
CREATE TABLE CDATA
(
cfid char(20),
app char(64),
data memo
)
</cfquery>
<cfquery name="data2" datasource="#DSN#">
CREATE UNIQUE INDEX id1
ON CDATA (cfid,app)
</cfquery>
<cfquery name="global1" datasource="#DSN#">
CREATE TABLE CGLOBAL
(
cfid char(20),
data memo,
lvisit date
)
</cfquery>
<cfquery name="global2" datasource="#DSN#">
CREATE INDEX id2
ON CGLOBAL (cfid)
</cfquery>
<cfquery name="global2" datasource="#DSN#">
CREATE INDEX id3
ON CGLOBAL (lvisit)
</cfquery>
Memory Variables page
You use the Memory Variables page of the ColdFusion Administrator to enable
application and session variables server-wide. By default, application and session variables
are enabled when you install ColdFusion MX. If you disable either type of variable in the
Memory Variables page, you cannot use them in a ColdFusion application.