Adobe 38000827 Administration Guide

Adobe 38000827 - Macromedia ColdFusion MX Standard Edition Manual

Adobe 38000827 manual content summary:

  • Adobe 38000827 | Administration Guide - Page 1
    Administering ColdFusion MX
  • Adobe 38000827 | Administration Guide - Page 2
    M Logo & Design, Macromedia Flash, Macromedia Xres, Macromind, Macromind If you access a third-party website mentioned in this guide, then you do so at your own risk. Macromedia 1999-2002 Macromedia, Inc. All rights reserved. This manual may not be copied, photocopied, reproduced, translated,
  • Adobe 38000827 | Administration Guide - Page 3
    2 Administrator layout 3 Server Settings section 4 Data & Services section 4 Debugging & Logging section 5 Extensions section 5 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
  • Adobe 38000827 | Administration Guide - Page 4
    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
  • Adobe 38000827 | Administration Guide - Page 5
    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 v
  • Adobe 38000827 | Administration Guide - Page 6
    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
  • Adobe 38000827 | Administration Guide - Page 7
    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 guides Flash syntax guide for brief guide that and troubleshooting Verity
  • Adobe 38000827 | Administration Guide - Page 8
    Adobe Acrobat Portable Document Format (PDF) you to learn how others have solved a problem that you might be facing. The Forums 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
  • Adobe 38000827 | Administration Guide - Page 9
    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 •
  • Adobe 38000827 | Administration Guide - Page 10
    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. 2 Chapter
  • Adobe 38000827 | Administration Guide - Page 11
    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
  • Adobe 38000827 | Administration Guide - Page 12
    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
  • Adobe 38000827 | Administration Guide - Page 13
    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 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
  • Adobe 38000827 | Administration Guide - Page 14
    6 Chapter 1 Administering ColdFusion
  • Adobe 38000827 | Administration Guide - Page 15
    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 7
  • Adobe 38000827 | Administration Guide - Page 16
    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
  • Adobe 38000827 | Administration Guide - Page 17
    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
  • Adobe 38000827 | Administration Guide - Page 18
    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 , see Developing ColdFusion MX Applications with CFML. 10 Chapter 2 Basic ColdFusion MX Administration
  • Adobe 38000827 | Administration Guide - Page 19
    The following table compares these storage options: Storage type Advantages Data source • Can use existing data source • Portable: not tied to the host system or operating system Browser cookies • Simple implementation • Good performance • Can be set to expire automatically • Client-side control
  • Adobe 38000827 | Administration Guide - Page 20
    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
  • Adobe 38000827 | Administration Guide - Page 21
    Server page You use the Mail Server page of the ColdFusion Administrator to specify a mail server to send automated e-mail messages. ColdFusion MX supports the Simple Mail Transfer Protocol (SMTP) for sending e-mail messages and the Post Office Protocol (POP) for retrieving e-mail messages from your
  • Adobe 38000827 | Administration Guide - Page 22
    Mail Connection Settings area Select preferences for handling mail logs, as described in the following table: Setting Mail Server Server Port Connection Timeout (seconds) Spool Interval (seconds) Verify Mail Server Connection Description Lets you enter a valid mail server for sending dynamic SMTP
  • Adobe 38000827 | Administration Guide - Page 23
    Charting Settings page The ColdFusion charting and graphing engine lets you produce highly customizable business graphics, in a variety of formats, using the cfchart tag. You use the Charting page in the Administrator to control characteristics of the engine. The following table describes the
  • Adobe 38000827 | Administration Guide - Page 24
    Archives and Deployment page The Archives and Deployment page includes tools that let you archive and deploy ColdFusion applications, configuration settings, data source information, and other types of information to back up your files quickly and easily. The complete list of archivable information
  • Adobe 38000827 | Administration Guide - Page 25
    MX, data sources, and Verity search and indexing features. The following table describes some common tasks that you can perform in the Data & Services section of the Administrator: Task Description Create and manage The Data Sources page lets you establish, edit, and delete JDBC JDBC data sources
  • Adobe 38000827 | Administration Guide - Page 26
    and scalable architecture. For more information on configuring and using K2 Server with ColdFusion, see Working with Verity Tools. Web Services page You can use web services to produce and consume remote application functionality over the Internet. The ColdFusion Administrator lets you register web
  • Adobe 38000827 | Administration Guide - Page 27
    Settings page The Debugging Settings page provides the following debugging options: Setting Description Enable Debugging Enables the ColdFusion debugging service. Select Debugging Output Format Select a format of: • classic.cfm - The format available in ColdFusion 5 and earlier. It provides
  • Adobe 38000827 | Administration Guide - Page 28
    NT Performance Monitor application to display information about a running ColdFusion Application Server. Shows performance information on platforms that do not support the NT Performance Monitor.For more information, see "Using the cfstat utility" on page 20. * Restart ColdFusion MX after changing
  • Adobe 38000827 | Administration Guide - Page 29
    Metric abbreviation AvgReq Time AvgDB Time Bytes In/Sec Bytes Out/Sec Metric name Description Average request time A running average of the time, in milliseconds, that ColdFusion spends to process a request (including queued time). Lower values, which you can achieve with efficient CFML, are
  • Adobe 38000827 | Administration Guide - Page 30
    names of pages that take longer than the specified interval to taking longer than process. Logging slow pages can help you diagnose potential problems [n] seconds or bottlenecks in your ColdFusion applications. Entries are written to server.log. 22 Chapter 2 Basic ColdFusion MX Administration
  • Adobe 38000827 | Administration Guide - Page 31
    Administrator lets you perform operations on log files, such as searching, viewing, downloading, archiving, and deleting. Click on a Log File icon, located in the Records errors occurring in the ColdFusion Remote Development Services (RDS). This service provides remote HTTP-based access to files and
  • Adobe 38000827 | Administration Guide - Page 32
    Scheduled Tasks page You use the Scheduled Tasks page to schedule the execution of local and remote web pages and to generate static HTML pages. The scheduling facility is useful for applications that do not require user interactions or customized output. ColdFusion developers use this facility to
  • Adobe 38000827 | Administration Guide - Page 33
    Extensions section You use the Extensions section of the Administrator to configure ColdFusion MX to work with other technologies, such as Java and CORBA. This section contains the Java Applets, CFX Tags, Custom Tag Paths, and CORBA Connectors pages. Java Applets page The Java Applets page of the
  • Adobe 38000827 | Administration Guide - Page 34
    jar VisibrokerConnector (embedded) Note: Macromedia will provide implementations of the connectors for some of the popular ORBs. For those that are not supported, Macromedia will make the source available under NDA to a select group of third-party candidates and/or ORB vendors. The following lines
  • Adobe 38000827 | Administration Guide - Page 35
    RDS Password page to enable and disable password-restricted access to server resources from Dreamweaver MX or ColdFusion Studio using Remote Development Services (RDS), and to change the password. Sandbox Security page The Sandbox Security page has two areas-Enable ColdFusion Security and Sandbox
  • Adobe 38000827 | Administration Guide - Page 36
    Custom Extensions You can extend the functionality of the ColdFusion Administrator by adding links to other web applications and sites. These links appear under the Custom Extensions section in the left navigation pane of the Administrator. Note: You must create a link for the Custom Extensions
  • Adobe 38000827 | Administration Guide - Page 37
    CHAPTER 3 Data Source Management This chapter describes the configuration options for ColdFusion data sources. For basic information on data sources and connecting to databases, see Developing ColdFusion MX Applications with CFML. Contents • About JDBC...30 • Adding data sources 32 • Connecting to
  • Adobe 38000827 | Administration Guide - Page 38
    About JDBC JDBC is a Java API (Application Programming Interface, an interface between application programs and the operating system) that you use to execute SQL statements. JDBC enables an application, such as ColdFusion, to interact with a variety of relational databases, without using interfaces
  • Adobe 38000827 | Administration Guide - Page 39
    Supplied drivers The following table shows the database drivers supplied with ColdFusion and where you can find more information: Driver DB2 UDB for OS/390 DB2 Universal Database 6.2, 7.2 Informix 9.x Microsoft Access Microsoft SQL Server 7.x, 2000 MySQL ODBC Socket Oracle R3 (8.1.7), Oracle 9i
  • Adobe 38000827 | Administration Guide - Page 40
    and exampleapps. This procedure should not be necessary to work with these data sources. To add a data source: 1 In the ColdFusion Administrator, select Data & Services > Data Sources. 2 Under Add New Data Source, enter a Data Source Name; for example, MyTestDSN. 32 Chapter 3 Data Source Management
  • Adobe 38000827 | Administration Guide - Page 41
    3 Select a Driver from the drop-down list box; for example, Microsoft SQL Server. 4 Click Add. A form for additional DSN information appears. The available fields in this form depend on the Driver that you selected. 5 In the Database field, enter the name of the database; for example, Northwind. 6
  • Adobe 38000827 | Administration Guide - Page 42
    ) Click Show Advanced Settings to specify any ColdFusion-specific settings; for example, to configure which SQL commands will interact with this data source. 10 Create Submit to create the data source. ColdFusion automatically verifies that it can connect to the data source. 34 Chapter 3 Data Source
  • Adobe 38000827 | Administration Guide - Page 43
    that the Microsoft Access or ODBC Socket driver uses to connect to the data source at runtime. Note: The connectstring tag attribute is not supported in ColdFusion MX. Adding data source notes and considerations When adding data sources to ColdFusion MX, keep these guidelines in mind: • Data source
  • Adobe 38000827 | Administration Guide - Page 44
    Connecting to DB2 UDB for OS/390 Use the settings in the following table to connect ColdFusion to DB2 UDB for OS/390 data sources: Setting Description CF Data Source Name The data source name (DSN) used by ColdFusion to connect to the data source. Server The name of the server that hosts the
  • Adobe 38000827 | Administration Guide - Page 45
    Connecting to DB2 Universal Database 6.2, 7.2 Use the settings in the following table to connect ColdFusion to DB2 Universal Database 6.2, 7.2 data sources: Setting Description CF Data Source Name The data source name (DSN) used by ColdFusion to connect to the data source. Database The name
  • Adobe 38000827 | Administration Guide - Page 46
    Connecting to Informix 9.x Use the settings in the following table to connect ColdFusion to Informix 9.x data sources: Setting Description CF Data Source Name The data source name (DSN) used by ColdFusion to connect to the data source. Database The database to which this data source connects.
  • Adobe 38000827 | Administration Guide - Page 47
    Connecting to Microsoft Access Use the settings in the following table to connect ColdFusion to Microsoft Access data sources: Setting CF Data Source Name Database File System Database File Use Default Username Description Default Username Default Password Username Password Page Timeout Max Buffer
  • Adobe 38000827 | Administration Guide - Page 48
    Setting Description Disable Connections If selected, suspends all client connections. Login Timeout (sec) The number of seconds before ColdFusion times out the data source connection login attempt. CLOB Select to return the entire contents of any CLOB/Text columns in the database for this data
  • Adobe 38000827 | Administration Guide - Page 49
    Connecting to Microsoft SQL Server 7.x, 2000 Use the settings in the following table to connect ColdFusion to Microsoft SQL Server 7.x, 2000 data sources: Setting CF Data Source Name Database Server Port Username Password Description Select Method Description The data source name (DSN) used by
  • Adobe 38000827 | Administration Guide - Page 50
    Setting Description BLOB Select to return the entire contents of any BLOB/Image columns in the database for this data source. If unchecked, ColdFusion retrieves the amount specified in the Blob Buffer setting. LongText Buffer (chr) The default buffer size, used if Enable Long Text Retrieval(CLOB
  • Adobe 38000827 | Administration Guide - Page 51
    Connecting to MySQL Use the settings in the following table to connect ColdFusion to MySQL data sources: Setting Description CF Data Source Name The data source name (DSN) used by ColdFusion to connect to the data source. Database The database to which this data source connects. Server The
  • Adobe 38000827 | Administration Guide - Page 52
    Connecting to ODBC Socket Use the settings in the following table to connect ColdFusion to ODBC Socket data sources: Setting Description CF Data Source Name The data source name (DSN) used by ColdFusion to connect to the data source. ODBC DSN Select the ODBC DSN to which you want ColdFusion
  • Adobe 38000827 | Administration Guide - Page 53
    Connecting to Oracle R3 (8.1.7), Oracle 9i Use the settings in the following table to connect ColdFusion to Oracle R3 (8.1.7), Oracle 9i data sources: Setting Description CF Data Source Name The data source name (DSN) used by ColdFusion to connect to the data source. SID Name The Oracle
  • Adobe 38000827 | Administration Guide - Page 54
    Connecting to other data sources Use the settings in the following table to connect ColdFusion to data sources that do not appear in the drop-down list of drivers: Setting Description CF Data Source Name The data source name (DSN) used by ColdFusion to connect to the data source. JDBC URL The
  • Adobe 38000827 | Administration Guide - Page 55
    Connecting to Sybase 11.5, 11.9, 12.0, and 12.5 Use the settings in the following table to connect ColdFusion to Sybase 11.5, 11.9, 12.0, and 12.5 data sources: Setting CF Data Source Name Database Server Port Username Password Description Select Method Description The data source name (DSN) used
  • Adobe 38000827 | Administration Guide - Page 56
    Setting Description BLOB Select to return the entire contents of any BLOB/Image columns in the database for this data source. If unchecked, ColdFusion retrieves the amount specified in the Blob Buffer setting. LongText Buffer (chr) The default buffer size, used if Enable Long Text Retrieval(CLOB
  • Adobe 38000827 | Administration Guide - Page 57
    CHAPTER 4 Administering Security ColdFusion security lets you secure a number of ColdFusion MX resources with password access and perform sandbox security. This chapter describes configuration options for ColdFusion security. Contents • About ColdFusion security 50 • Using sandbox security 53 49
  • Adobe 38000827 | Administration Guide - Page 58
    About ColdFusion security Security is especially important in web-based applications, such as those you develop in ColdFusion. You implement security throughout your ColdFusion environment, in ColdFusion Markup Language (CFML) and in the ColdFusion Administrator. ColdFusion has two main security
  • Adobe 38000827 | Administration Guide - Page 59
    In the Enterprise Edition of ColdFusion MX, when you click the Security > Sandbox Security page link, it opens the following page: Default security behavior The ColdFusion Administrator installs with secure access enabled. The password that you enter during installation is saved as the default. When
  • Adobe 38000827 | Administration Guide - Page 60
    ColdFusion Administrator password protection Password protection for accessing the ColdFusion Administrator helps guard against unauthorized modifications of ColdFusion MX, and Macromedia highly recommends using passwords. You can disable password protection by clearing the check box on the Security
  • Adobe 38000827 | Administration Guide - Page 61
    Using sandbox security Sandbox security uses the location of your ColdFusion pages to control access to ColdFusion resources. A sandbox is a designated directory of your site to which you apply security restrictions. By default, a subdirectory (or child directory) inherits the sandbox settings of
  • Adobe 38000827 | Administration Guide - Page 62
    The following table shows the relationship between file path and the affected files or directories: File path C:\foo\bar.txt C:\pat\- C:\pat\* C:\pat\ Affected files or directories C:\foo\bar.txt C:\pat\riots\c.txt C:\pat\riots2\d.txt C:\pat\a.txt C:\pat\riots\ C:\pat\riots2\ C:\pat\a.txt C:\pat\
  • Adobe 38000827 | Administration Guide - Page 63
    Adding a sandbox The Root Security Content is the default sandbox for your ColdFusion MX server. If your security requirements are minimal and you do not need additional sandboxes, configure the default sandbox so that the child directories will inherit its security settings. To add a sandbox: 1
  • Adobe 38000827 | Administration Guide - Page 64
    Configuring a sandbox You use the ColdFusion Administrator to configure a sandbox. To configure a sandbox: 1 Open the Security > Sandbox Security page in the ColdFusion Administrator. 2 In the list of Defined Directory Permissions, click the name or the Edit icon for the directory that you want to
  • Adobe 38000827 | Administration Guide - Page 65
    together with the file-based permissions of the operating system. To restrict a user from browsing another user's directory, you must use file-based permissions. 10 To enable files or directories, in the File Path box, enter or browse to the files or directories to enable; for example, C:\pix. Using
  • Adobe 38000827 | Administration Guide - Page 66
    11 Select the permissions. For example, select the Read check box for ColdFusion pages within the mytestapps sandbox to read files in the C:\pix directory. Note: This behavior differs from other tabs, such as CFTags, where you select items to disable. 12 Click Add Files/Paths. The file path and its
  • Adobe 38000827 | Administration Guide - Page 67
    Admin Password page 27 CFX Tags page 25 Charting page 15 Client Variables page 10 Code Compatibility Analyzer page 24 CORBA Connectors page 25 Custom Extensions section 28 Custom Tag Paths page 25 Data & Services section 17 Data Sources page 17 Debugging & Logging section 19 Debugging IP Addresses
  • Adobe 38000827 | Administration Guide - Page 68
    directories, security 57 I Informix, connecting to 38 installation, support vi IP/Port, security 58 J Java and JVM Settings ColdFusion Administrator 17 Verity K2 Server page, ColdFusion Administrator 18 W Web Services page, ColdFusion Administrator 18 R RDS Password page, ColdFusion Administrator 27
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68

Administering ColdFusion MX