MACROMEDIA 38000827 - Macromedia ColdFusion MX Standard Edition Administration 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.

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,

Developing ColdFusion

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: 415.252.2000

Fax: 415.626.0554

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: 617.219.2100

Fax: 617.219.2101

E-mail: sales@macromedia.com

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 --->

CREATE TABLE CDATA

(

cfid char(20),

app char(64),

data memo

)

</cfquery>

CREATE UNIQUE INDEX id1

ON CDATA (cfid,app)

</cfquery>

CREATE TABLE CGLOBAL

(

cfid char(20),

data memo,

lvisit date

)

</cfquery>

CREATE INDEX id2

ON CGLOBAL (cfid)

</cfquery>

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.

Page is loading ...

MACROMEDIA 38000827 - Macromedia ColdFusion MX Standard Edition Administration Manual

This manual is also suitable for

MACROMEDIA 38000827 - Macromedia ColdFusion MX Standard Edition Administration Manual

Related papers

Other documents