MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING..., Manual

Page 1: ...Macromedia Inc Installing and Configuring ColdFusion Server ColdFusion Server 5...

Page 2: ...ation may be reproduced stored in a retrieval system or transmitted in any form or by any means electronic mechanical recording or otherwise without the prior written permission of Macromedia Inc Cold...

Page 3: ...ore You Begin the Installation 5 Required operating system updates 5 Installing SNMP in Windows NT 4 0 Server and Windows 2000 Server 6 Important Network Considerations 7 Upgrading from a previous ver...

Page 4: ...rements 40 Before You Begin the Installation 41 Required operating system patches 41 Installing SNMP in Red Hat 41 Important Network Considerations 42 Upgrading from a previous version 43 Verifying th...

Page 5: ...g Client Variable Data 74 Memory Variables 76 Locking 77 Single threaded sessions 77 Variable scope locking settings 77 Mappings 79 Mail Mail Logging 80 Data Sources 82 Verity Collections 83 Managing...

Page 6: ...s for connecting to Microsoft Access Windows 124 Connecting to Remote Access Data Sources 125 Connecting to Oracle Databases 127 Configuring Oracle 7 3 4 8 0 x options Windows 127 Configuring Oracle 7...

Page 7: ...nded for server administrators and anyone who is new to ColdFusion Server and needs to install and configure ColdFusion Server 5 Contents Intended Audience viii New Features viii Developer Resources x...

Page 8: ...tandard SQL Server analysis and troublshooting Quickly detect and diagnose server errors with built in server reporting and the new Log File Analyzer Powerful business intelligence capabilities Charti...

Page 9: ...alerts and recovery SNMP support Monitor ColdFusion applications from enterprise management systems Expanded integration Expanded Linux support Deploy on additional Linux distributions including SuSE...

Page 10: ...Forum 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 Installation Support...

Page 11: ...com Book Description Installing and Configuring ColdFusion Server Describes system installation and basic configuration for Windows Solaris Linux and HP UX Advanced ColdFusion Administration Describes...

Page 12: ...ms coldfusion com Other developers on the forum can help you figure out how to do just about anything with ColdFusion Server The search facility can also help you search messages from the previous 12...

Page 13: ...support Macromedia offers a range of telephone and Web based support options Go to http www coldfusion com support for a complete description of technical support services You can make postings to the...

Page 14: ...xiv Welcome to ColdFusion Server...

Page 15: ...This chapter explains how to install and configure ColdFusion Server in Windows Contents Windows System Requirements 4 Before You Begin the Installation 5 Installing ColdFusion Server in Windows 10 Co...

Page 16: ...6 512 Free Hard Disk Space MB 200 400 CD ROM Drive x x Web Servers Microsoft Personal Web Server PWS x Microsoft IIS 4 0 5 0 x x iPlanet Netscape Enterprise Server 3 6 4 1 x x Apache Server 1 3 x x x...

Page 17: ...Service Pack 1 http www microsoft com downloads MDAC 2 5 SP1 http www microsoft com data downloads MFC MSVC 6 0 localdrive ColdFusion Image Redistrib MSVCRT setup exe NT Option Pack http www microsof...

Page 18: ...nu select Settings Control Panel Network Service Tab Add SNMP Service 2 The installation begins When prompted insert your Windows installation CD ROM 3 Start the SNMP trap service Note If you chose to...

Page 19: ...NT 4 0 Workstation or Windows 2000 Professional handle only ten TCP IP connections concurrently Macromedia does not recommend using those operating systems in a production environment Use Window NT 4...

Page 20: ...eb server in your browser s Address field and press Enter For example if the file myindex htm is in your Web document root directory load the page in your browser using the localhost URL http 127 0 0...

Page 21: ...letes restart your system To repair update ColdFusion Server Use the Repair update feature to reinstall a component of ColdFusion Server Repairing ColdFusion Server refreshes the Windows registry rese...

Page 22: ...rmation dialog displays Enter your information including the ColdFusion Server license key You can find your ColdFusion Server license key on the product box and the CD ROM packaging The Web Server Se...

Page 23: ...e cluster select Web Server IP Failover ClusterCATS and Application Management together The monitoring alarms and hardware load balancing features cannot be accessed using the ColdFusion Administrator...

Page 24: ...ble click the service that you want to configure The window for that service opens 3 In the Startup Type frame select either the Automatic or Manual option 4 To save the configuration click OK SiteMin...

Page 25: ...hat you want to configure and select Properties 2 In the Properties dialog select the General tab In the Startup Type drop down menu choose either Manual or Automatic 3 Click OK Running ColdFusion Ser...

Page 26: ...b servers Internet Information Services IIS Apache Web server Netscape iPlanet Enterprise Web Server O Reilly WebSite Professional Internet Information Services IIS The following procedure uses Window...

Page 27: ...ab under the Internet Information Services tree right click your Web site and select Properties The Properties dialog box displays 3 Click the Home Directory tab then Configuration Note If the Configu...

Page 28: ...Click Browse and go to c cfusion bin iscf dll Enter cfm in the Extension text box and verify that the Script engine check box is selected Click OK 7 Repeat Step 6 substituting dbm for the extension No...

Page 29: ...guring Netscape iPlanet Web servers for ColdFusion Server requires modifying two files obj conf and mime types in the Netscape iPlanet Web server directory such as c netscape server4 https yourserver...

Page 30: ...WebSite Professional for ColdFusion Server 1 Select Start Programs WebSite Professional Server Properties The WebSite Pro Server Properties dialog box displays 2 In the Mapping tab click Associations...

Page 31: ...s page of the ColdFusion Administrator and ensure that the Enable Performance Monitoring checkbox is selected Tip You can find a copy of the MIB definition in CFusion cfam Database lhmib mib Using HTT...

Page 32: ...e Windows 2000 Professional operating system To change the ColdFusion Server user account 1 Start the MMC by selecting Start Programs Administrative Tools Computer Management a In the Tree tab expand...

Page 33: ...g ColdFusion Server and configuring your installation you must perform some initial administration tasks using the ColdFusion Administrator ColdFusion Server s Web based control console For more infor...

Page 34: ...22 Chapter 1 Installing ColdFusion Server in Windows...

Page 35: ...his chapter explains how to install and configure ColdFusion Server in Solaris Contents Solaris System Requirements 24 Before You Begin the Installation 25 Installing ColdFusion Server in Solaris 29 C...

Page 36: ...nimum RAM MB 256 Recommended RAM MB 512 Free Hard Disk Space MB 350 CD ROM Drive x Web Server iPlanet Netscape Enterprise Server 3 6 4 1 x Apache Server 1 3 x x ColdFusion Server provides a precompile...

Page 37: ...e sun com Operating System Patch Description Solaris 2 6 105181 17 or higher Kernel patch 105591 09 or higher LibC Shared library patch for C 105210 25 or higher LibC Shared library patch for C C 1055...

Page 38: ...wnload 1 Uninstall the following components from your system pkgrm SUNWsacom pkgrm SUNWmibii pkgrm SUNWsadmi pkgrm SUNWsasnm 2 Install the SEA Runtime by performing the following steps a Uncompress th...

Page 39: ...ldFusion Server automatically However keep in mind the following important instructions when upgrading from a previous release of ColdFusion Server If you are upgrading from ColdFusion Server 4 0 or e...

Page 40: ...ument root directory load the page in your browser using the localhost URL http 127 0 0 1 myindex htm If your Web server is not running you will receive an error message Uninstalling ColdFusion Server...

Page 41: ...sing the coldfusion 50 solaris tar gz command to a directory on your local disk Using gunzip uncompress the ColdFusion Server tar file with the following command coldfusion 50 solaris tar gz 3 Untar t...

Page 42: ...tall ColdFusion Server documentation and examples The documentation is installed in the cfdocs directory under the Web root directory Warning Because of potential security concerns the ColdFusion Serv...

Page 43: ...ing and stopping ColdFusion Server processes manually in Solaris opt coldfusion bin start opt coldfusion bin stop Process Purpose cfexec Starts stops the other processes and manages page scheduling cf...

Page 44: ...s ColdFusion Server also provides the following scripts to start and stop ColdFusion Server during system startup and shutdown Script Function etc init d coldfusion Starts or stops ColdFusion Server e...

Page 45: ...The Netscape iPlanet plug in coldfusion35 so for ColdFusion Server is in the opt coldfusion webserver nsapi directory The following procedure assumes that you installed the Netscape iPlanet server in...

Page 46: ...Apache 1 3 x versions and it may not work with later versions if Apache Group changes MODULE_MAGIC_NUMBER_MAJOR src src include ap_mmn h in the Apache source The module provided with ColdFusion Server...

Page 47: ...tory in the ColdFusion Server installation cd opt coldfusion webserver apache src 5 Run the apxs command to build mod_coldfusion so by entering this command make 6 Run the apxs command to add the modu...

Page 48: ...names are invalid the MIB does not work correctly and the MIB log file grows very large Do not delete or comment out the trap section of allaire_mib acl 3 Restart the SNMP process by entering the fol...

Page 49: ...client side database libraries to your LD_LIBRARY_PATH environment variable Examples are provided in the start script to help you After editing the start script you must stop and restart ColdFusion Se...

Page 50: ...t After installing ColdFusion Server and configuring your installation you must perform some initial administration tasks using the ColdFusion Administrator ColdFusion Server s Web based control conso...

Page 51: ...This chapter explains how to install and configure ColdFusion Server in Linux Contents Linux System Requirements 40 Before You Begin the Installation 41 Installing ColdFusion Server in Linux 44 Confi...

Page 52: ...anet Netscape Enterprise Server 4 1 x x Apache Server 13 6 x x All Linux distributions must be running glibc 2 1 3 11 or later gcc egcs libstdc 2 9 and 2 2 kernel or later For performance reasons the...

Page 53: ...hird party system management tools These tools let you manage diverse components of your enterprise from a management station in your network If you want to use ColdFusion Server MIB features you must...

Page 54: ...mpd conf_macromedia into snmpd conf to make ColdFusion MIB information accessible After finishing the ColdFusion Server installation you must configure your system to use MIB features For more informa...

Page 55: ...g ColdFusion Server 5 these libraries are removed from your system Copy the libraries to a safe location before the uninstall Warning Before proceeding with the upgrade backup your ColdFusion Server W...

Page 56: ...cd command go to the resulting directory 5 cd coldfusion 50 linux 6 Run the ColdFusion Server installation script by entering the following command cfinstall The ColdFusion Server installation script...

Page 57: ...or this option provides ColdFusion application reporting statistics and the ability to archive and deploy ColdFusion applications Monitors Alarms and Load Balancer Integration Accessed through the Col...

Page 58: ...ion bin cfam stop Note To run the scripts you must be logged in with root privileges Process Purpose cfexec Starts and stops the other processes and manages page scheduling cfserver The main ColdFusio...

Page 59: ...usion Starts and stops ColdFusion Server etc rc1 d K19coldfusion Stops ColdFusion Server during system shutdown etc rc3 d S90coldfusion Starts ColdFusion Server during system startup etc rc4 d S90cold...

Page 60: ...iPlanet plug ins for ColdFusion Server are installed in the installdir coldfusion webserver nsapi directory The following procedure assumes that you installed the Netscape iPlanet server in usr netsc...

Page 61: ...e the Apache Readme file at opt coldfusion webserver apache readme Follow the appropriate procedure according to your Linux distribution to configure Red Hat and Apache and SuSE Cobalt with Apache To...

Page 62: ..._static c AddModule mod_vhost_alias c AddModule mod_so c AddModule mod_setenvif c AddModule mod_coldfusion c c Save the file 4 Create a symbolic link from the EAPI version of the ColdFusion Server mod...

Page 63: ...Go to the Debug Options page of the ColdFusion Administrator and ensure Enable Performance Monitoring is selected 4 Start the SNMP Server enter the following command as root etc rc d init d snmpd star...

Page 64: ...e changes to take effect Then you can proceed to the ColdFusion Administrator to set up your data sources Note For more information see Managing Data Sources on page 109 In Linux you must use certain...

Page 65: ...g ColdFusion Server and configuring your installation you must perform some initial administration tasks using the ColdFusion Administrator ColdFusion Server s Web based control console For more infor...

Page 66: ...54 Chapter 3 Installing ColdFusion Server in Linux...

Page 67: ...This chapter explains how to install and configure ColdFusion Server in HP UX Contents HP UX System Requirements 56 Before You Begin the Installation 57 Installing ColdFusion Server in HP UX 60 Confi...

Page 68: ...inimum RAM 128 MB Recommended RAM 128 MB Free Hard Disk Space 120 MB CD ROM Drive x Web Server iPlanet Netscape Enterprise Server 3 51 4 1 x Apache Server 1 3 x x ColdFusion Server provides a precompi...

Page 69: ...figuration file locations They will be needed during the installation Note the HP UX username under which ColdFusion Server will run It will be needed during the installation Note where you want to in...

Page 70: ...is written to the CD ROM using the RockRidge format This format is supported by HP UX using the Portable File System PFS commands not the standard HP UX mount umount commands For more information on t...

Page 71: ...t it using the following command usr sbin pfs_umount SD_CDROM Uninstalling ColdFusion Server 5 Use the cfremove utility to remove an installed version of ColdFusion Server To uninstall ColdFusion Serv...

Page 72: ...l 5 When prompted enter the ColdFusion Server registration ID license key Note You can find your ColdFusion Server license key on the product box and the CD ROM packaging 6 After entering the install...

Page 73: ...script for configuring the Apache Web server or see Configuring Web servers manually on page 62 ColdFusion Server processes The ColdFusion Server installation creates the following processes in HP UX...

Page 74: ...ns for ColdFusion Server are installed in the opt coldfusion webserver nsapi directory The following procedure assumes that you installed the Netscape iPlanet server in usr netscape server4 on the sys...

Page 75: ...rsion of Apache is built with EAPI run the following command httpd V If the output contains the line D EAPI you are running an EAPI version of Apache 3 ColdFusion Server includes a version of the Cold...

Page 76: ...API sl b In the section AddModule add the following line AddModule mod_coldfusion c c Save the file 8 Restart Apache Configuring databases After the install is completed but before you can set up a da...

Page 77: ...nformix 7and 9 Yes Tested Informix 9 and with 2 40 client Clientless driver available for Informix9 Yes Tested Informix 9 and with 2 40 client Cannot be used simultaneously with ODBC connections IBM D...

Page 78: ...After installing ColdFusion Server and configuring your installation you must perform some initial administration tasks using the ColdFusion Administrator ColdFusion Server s Web based control consol...

Page 79: ...inistration tasks Contents Initial Administration Tasks 68 The ColdFusion Administrator 69 Server Settings 70 Caching 71 Client Variables 72 Memory Variables 76 Locking 77 Mappings 79 Mail Mail Loggin...

Page 80: ...rmation use the Debug Settings pages of the Administrator For more information see Debug Settings on page 88 Set up e mail E mail lets ColdFusion Server and ColdFusion applications send automated mail...

Page 81: ...n Server 5 ColdFusion Administrator or In any operating system open the administrator by entering http hostname CFIDE administrator index cfm in a Web browser where hostname is the name of the server...

Page 82: ...unresponsive requests at which the service is restarted The service restarts within the time specified in Timeout Request above Restart when requests terminate abnormally Enable this option if you wan...

Page 83: ...ched database connection inactive time to n minutes Enable this option by entering a value to limit the time that ColdFusion Server allows a cached database connection to remain inactive before discon...

Page 84: ...dvantage Disadvantage 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 li...

Page 85: ...following table If you do not want to make changes return to the Client Variables screen using one of the arrows on the page 4 Click Submit Changes Option Description Purge data for clients that rema...

Page 86: ...les Creating client variable tables Use this example ColdFusion page as a model for creating client variable database tables in your own database However keep in mind that not all databases support th...

Page 87: ...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...

Page 88: ...able in the Memory Variables page you cannot use them in a ColdFusion application You can specify maximum and default timeout values for session and application variables Unless you define a timeout v...

Page 89: ...s is enabled in the Administrator you do not need to the use the cflock tag for session scope variables In addition single threaded sessions can prove valuable to debugging a ColdFusion application If...

Page 90: ...e attribute of the cflock tag to specify locks If you specify the name attribute with full checking enabled ColdFusion Server responds with an error on a variable accessed within the scope of a cflock...

Page 91: ...ore in your cfinclude and cfmodule tags In order for ColdFusion Server to find those pages you must add a mapping for store that points to e store To add a mapping 1 In the Logical Path text box enter...

Page 92: ...ColdFusion Applications book To configure a mail server 1 On the ColdFusion Administrator Mail page enter a mail server for sending dynamic SMTP mail messages You can enter an Internet address such a...

Page 93: ...ble describes the e mail log files Setting Description Error Log Severity From the drop down list box select the type of SMTP related error message to write to a log file The options are Warning Infor...

Page 94: ...tion see Managing Data Sources on page 109 Create and manage native data sources The Native Data Sources page lets you establish modify and delete native data source connections for ColdFusion Server...

Page 95: ...st of multiple words and spaces 2 In the Path field specify a path for the collection files 3 From the drop down Language list box select a language for the collection 4 Click an option 5 Click Submit...

Page 96: ...corresponding Verity Language Pack The Verity Language Packs are included on the ColdFusion Server CD ROM 8 Click Submit Changes ColdFusion Server populates the collection with data from the specified...

Page 97: ...Verity Collections table 2 Click Optimize A message prompts you to verify the process which can occur over several minutes 3 Click OK When the optimization is complete a confirmation statement display...

Page 98: ...Document Type Format or Program Version Text HTML CFML DBM SGML XML ANSI ASCII Plain Text Not applicable Word processing Adobe Acrobat PDF All Applix Words 4 2 Lotus AMI Pro 2 3 Lotus AMI Pro Write P...

Page 99: ...Verity Collections 87 Presentation Corel Presentations 7 0 8 0 Lotus Freelance 96 97 Microsoft PowerPoint 4 0 95 97 2000 Document Type Format or Program Version Not Supported in Linux...

Page 100: ...ms that do not support the NT Performance Monitor a command line utility cfstat displays the same information Enable CFML Stack Trace Displays the CFML tags that were executing at the time of the exce...

Page 101: ...and debugging options are active debug output displays for all users To allow debug output to an IP address 1 On the Debugging IPs page enter an IP address Click Add 2 To add the IP address of the co...

Page 102: ...onthly You can run a scheduled task daily at a specified interval or between specified dates You create scheduled tasks and set automation options on these pages On the Automation Settings page you se...

Page 103: ...For the task to execute successfully the date and time must be set at least 15 minutes in the future Recurring Runs the scheduled task according to the frequency specified in the drop down list You c...

Page 104: ...e scheduled task 2 A verification message warns you that deleting the task cannot be undone Click Yes The scheduled task disappears Setting Description Username Specifies whether the server to which t...

Page 105: ...is Linux and HP UX Initial Heap Size JVM initial heap memory size Max Heap Size JVM maximum heap memory size Load JVM When Starting ColdFusion Loads the JVM when ColdFusion Server starts up If not sel...

Page 106: ...subclass Must be relative to the code base URL The class extension is optional Code Base Base URL of the applet directory that contains the applet components The applet class files must be located wit...

Page 107: ...er and manage ColdFusion custom tags built with C and Java You build CFX tags Using C as a dynamic link library DLL in Windows as shared objects so sl on Solaris Linux and HP UX Using Java interfaces...

Page 108: ...FX Tags page To delete a CFX tag registration In the Registered CFX Tags table click the Delete Applet icon in the Controls column of the row for the CFX tag you want to delete The CFX tag disappears...

Page 109: ...ter CORBA connectors before using them in your ColdFusion applications ColdFusion Server loads Orb libraries dynamically using a connector which does not tie ColdFusion customers to a specific Orb ven...

Page 110: ...ect the Load ORB on Startup check box Click Submit CORBA Settings To modify a CORBA connector registration 1 In the Registered CORBA Connectors table on the CORBA Connections page click a CORBA Connec...

Page 111: ...Security it requires custom development For more information see Basic Security on page 100 For more information about implementing security measures in your ColdFusion applications see Developing Co...

Page 112: ...3 Click Submit Changes Tag Restrictions You use the Tag Restrictions page of the Administrator to enable and disable tags and tag attributes and to specify a directory where tag restrictions are not...

Page 113: ...d access to server resources within ColdFusion Studio using Remote Development Services RDS and to change the password Warning Enabling Use ColdFusion Studio Authentication in the Advanced Security pa...

Page 114: ...The site archiving features let you easily back up and deploy site configuration information files and or applications For more information see the Advanced ColdFusion Administration book Monitor reso...

Page 115: ...message for reporting purposes enabling users to report problems This setting can be overridden in the Application cfm file Log Directory Directory to which error log files are written Log Slow Pages...

Page 116: ...Files table click the View Search Log File icon The Log Viewer displays In the Log Viewer page the log file displays You can filter the log by keyword severity application thread ID and time frame or...

Page 117: ...ing in the ColdFusion Remote Development Services RDS This service provides remote HTTP based access to files and databases application log Records every ColdFusion Server error reported to a user App...

Page 118: ...ages related to the security server proxy cfadmin log Records Administrator operations install log Records installation information server stdout Records the standard output of the cfserver process rd...

Page 119: ...n Progress Timed Out Requests Throughput Settings Summary Settings Change Log When you click on a report the right pane of the Server Reports page displays your choices The Settings Summary and Settin...

Page 120: ...lists the options Click Update to apply your changes Parameter Option Timeframe Anytime Specified Range used in conjunction with Dates option Today Last Two Days Last Three Days One Week Two Weeks One...

Page 121: ...e and configure ColdFusion data sources for SQL Server Access and Oracle databases For details on how to configure data sources for other databases see Advanced ColdFusion Server Administration Conten...

Page 122: ...dFusion Administrator Note On the Win32 platform you can also configure ODBC data sources with the ODBC Data Source Administrator The specific databases that you can configure for ColdFusion depend on...

Page 123: ...ASE FoxPro DataDirect Connect ODBC MERANT 3 7 P P P E E IBM DB2 UDBc DataDirect Connect ODBC MERANT 3 7 E E E E Informix 7 x 9 xd DataDirect Connect ODBC MERANT 3 7 E E E E Informix Dynamic Server for...

Page 124: ...x 6 2 and 7 0 SuSE Linux 7 0 Cobalt RAQ3 XTR and RAQ4 Linux b P ColdFusion Professional Edition E ColdFusion Enterprise Edition c DB2 for Windows NT and DB2 Common Server requires either IBM DB2 Clien...

Page 125: ...to connect to other databases see Advanced ColdFusion Server Administration The following sections apply to all databases and operating systems Section and location Description Choosing the Correct D...

Page 126: ...32 platforms The main role of the odbc ini file is to map a data source name DSN to a particular ODBC driver and options For detailed information about options specific to your ODBC drivers see the do...

Page 127: ...data source to ColdFusion 1 Open the ColdFusion Administrator 2 Under Data Sources click a link to specify a type of data source to add ODBC OLE DB available only on Windows NT 2000 Native The Data So...

Page 128: ...a source The information that you enter depends on the platform on which you installed ColdFusion and on the driver you specify For information about options for your driver see the section for your s...

Page 129: ...ck Create to create the data source ColdFusion automatically verifies that it can connect to the data source If ColdFusion cannot verify the data source the Status displays Failed You can run a cfquer...

Page 130: ...number of simultaneous connections to allow for the current data source Note If you enable Limit Connections without specifying a limit for simultaneous connections ColdFusion defaults to unlimited co...

Page 131: ...the columns in your select statement with the long text fields referenced last ColdFusion retrieves the column with the long text field and subsequent columns in the select statement as unbound data...

Page 132: ...ne a username and password for a data source edit the properties for the data source To verify a ColdFusion data source 1 Open the ColdFusion Administrator 2 Under Data Sources click the link that spe...

Page 133: ...to use If the SQL Server database is local and you are using the Microsoft SQL Server driver enclose the word local in parentheses local Use Trusted Connection Allows SQL Server to authenticate users...

Page 134: ...options when you configure a ColdFusion data source Option Description Data Source Name A name for your ODBC data source Description Descriptive information about the data source Database Name The nam...

Page 135: ...on about using OLE DB drivers with ColdFusion data sources see Advanced ColdFusion Server Administration Note OLE DB and ODBC connections to Access function identically at the programmatic level but O...

Page 136: ...bat file If you receive an Operation must use an updateable query error message when you attempt to run a ColdFusion template that updates or deletes from an Access database see Knowledge Base Article...

Page 137: ...a Domain User Account that has permission to run ColdFusion and has permission to read and write to the mdb file The following steps describe how you can set up ColdFusion to access the remote data s...

Page 138: ...data source pointing to the remote database In the Database File field of the Create Data Source page type do not browse to the name of your database in Universal Naming Convention UNC format Note The...

Page 139: ...a Solaris server you can configure an Oracle data source using a native driver Native drivers Oracle 7 3 4 and 8 0 x options UNIX The following table describes ColdFusion native driver options for Or...

Page 140: ...uses If the libclntsh so file was built in the CFHOME lib using a script that you downloaded from http www coldfusion com the LD_LIBRARY_PATH variable should contain an entry for CFHOME lib before the...

Page 141: ...cle7 Set library search path NOTE Add your database client library directory to the FRONT of this list Example LD_LIBRARY_PATH ORACLE_HOME lib SYBASE lib usr dt lib lib usr openwin lib CFHOME lib This...

Page 142: ...onfig is correct but the connection test fails then seek assistance from your Oracle 8 database administrator DBA You should first check the basic connection information hostname SID username and pass...

Page 143: ...environment The error occurred while processing an element with a general identifier of cfquery occupying document position 3 1 to 3 50 This problem might occur with the Oracle 7 3 4 native driver in...

Page 144: ...ORACLE_HOME The library path set in LD_LIBRARY_PATH To install the Oracle 8 Client 1 Install the Oracle 8 Client software 2 Select the Database Administrator or Application User option This example us...

Page 145: ...racle 8 database resides The following figure shows the default for the port number 5 After entering a host name enter the Database SID which identifies your specific Oracle database instance The defa...

Page 146: ...nt ones for a successful connection Host string Enter the exact database alias that you created using the Oracle Net8 Easy Config utility ColdFusion Login username and password These options display w...

Page 147: ...tware based load balancing features included with ColdFusion Server 5 Enterprise Edition Read the following sections to learn more about preparing your server for clustering and post installation task...

Page 148: ...uration Protocol DHCP You must assign a unique IP address to each Web server Understanding DNS servers When you enter a URL into a Web browser the browser can locate the Web site that you want to visi...

Page 149: ...ation from the local DNS server s table However if a user enters a URL for a site that the browser on that computer has never visited the local DNS server must access the primary DNS server on the Int...

Page 150: ...usterCATS load management and failover features automatically take over and ensure that your Web applications remain up and running Using ClusterCATS with round robin DNS For high volume sites you sho...

Page 151: ...ding or receiving packets from the network another member assumes its IP address and therefore its HTTP requests and picks up all HTTP traffic originally addressed to the failed server Server failover...

Page 152: ...me as the IP of your Web server setting up your site for ClusterCATS dynamic IP addressing can involve reinstalling your Web server software and resetting your TCP IP settings You must carefully consi...

Page 153: ...work protocols and click OK 6 Close the Network dialog box Windows NT prompts you to restart your computer Click No You restart your system at the end of this procedure 7 Open the Devices icon in the...

Page 154: ...e certain that the addresses you are translating which should correspond to the outside DNS but not the round robin entries contain forward and reverse DNS entries corresponding to FQHN Modify the DNS...

Page 155: ...either server with a Web browser Hit the round robin name and test its ability to serve Note If you are using static IP addresses with ClusterCATS fail over the failing server encounters an IP conflic...

Page 156: ...ewall with a direct connection to the Internet You must open and configure the appropriate communication ports on your firewalls to allow server to server communication in a distributed setting and se...

Page 157: ...for each Web server in the cluster should be the same on all cluster members for example set the default document to default jsp Considering domain controllers Windows NT only If you are using Window...

Page 158: ...threshold no new sessions can start on that server If another server in the cluster has the capacity to handle additional users requests are redirected to that server The load management activation t...

Page 159: ...Explorer pages For more information see Advanced ColdFusion Administration Administrative authentication Password protect administrative access to your cluster members using domain accounts Windows NT...

Page 160: ...148 Appendix Preparing Your Server for ClusterCATS...