manualshive.com logo in svg

MACROMEDIA COLFUSION MX 7 - INSTALLING AND USING COLDFUSION..., Manual

Share
Download
MACROMEDIA COLFUSION MX 7 - INSTALLING AND USING COLDFUSION... Manual Download Page 43

43

CHAPTER 3

Data Source Management

A data source is a complete database configuration that uses a JDBC driver to communicate with 
a specific database. In Macromedia ColdFusion MX 7, you must configure a data source for each 
database that you want to use. After you configure a data source, ColdFusion can then 
communicate with that data source through JDBC.

This chapter describes the configuration options for ColdFusion MX 7 data sources. For basic 
information on data sources and connecting to databases, see 

Getting Started Building 

ColdFusion MX Applications

.

Contents

About JDBC  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44

Adding data sources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45

Connecting to DB2 Universal Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47

Connecting to Informix . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49

Connecting to Microsoft Access. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50

Connecting to Microsoft Access with Unicode. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52

Connecting to Microsoft SQL Server. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53

Connecting to MySQL  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56

Connecting to ODBC Socket  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57

Connecting to Oracle. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59

Connecting to other data sources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60

Connecting to Sybase. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62

Connecting to JNDI data sources  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63

Summary of Contents for COLFUSION MX 7 - INSTALLING AND USING COLDFUSION...

Page 1: ...COLDFUSION MX7 Configuring and Administering ColdFusion MX ...

Page 2: ... 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 Copyright 1999 2005 Macromedia Inc All rights reserved U S Patents Pending This manual may not be copied photocopied reproduced translated or converted to any electronic or machine readable form in whole or in part without writt...

Page 3: ... section 34 Security section 35 Packaging and Deployment section 36 Enterprise Manager section 37 Custom Extensions section 38 Administrator API 39 CHAPTER 3 Data Source Management 43 About JDBC 44 Adding data sources 45 Connecting to DB2 Universal Database 47 Connecting to Informix 49 Connecting to Microsoft Access 50 Connecting to Microsoft Access with Unicode 52 Connecting to Microsoft SQL Serv...

Page 4: ...stances 91 About multiple server instances 92 Defining additional server instances 93 Enabling application isolation 94 Enabling clustering for load balancing and failover 99 Defining remote server instances to the ColdFusion MX Administrator 101 PART II Administering Verity CHAPTER 8 Introducing Verity and Verity Tools 105 Collections and the ColdFusion MX Verity architecture 105 About Verity Spi...

Page 5: ...erity Utilities 141 Overview of Verity utilities 141 Using the mkvdk utility 142 Using the rck2 utility 153 Using the rcvdk utility 154 Using the didump utility 158 Using the browse utility 160 Using the merge utility 162 INDEX 165 ...

Page 6: ...6 Contents ...

Page 7: ...y Search Server as well as creating managing and troubleshooting Verity collections To see this manual go to www macromedia com go livedocs_cfmx7docs_configadmin ColdFusion MX Developer s Guide Describes how to develop your dynamic web applications including retrieving and updating your data and using structures and forms This manual includes two volumes To see this manual go to www macromedia com...

Page 8: ...ortable Document Format PDF files Go to the documentation home page for ColdFusion MX on the Macromedia website www macromedia com In addition you can view the documentation in LiveDocs which lets you add comments to pages and view the latest comments added by Macromedia by going to www macromedia com go livedocs_cfmx7docs ...

Page 9: ...ploying your applications and configuring security for your applications The following chapters are included Chapter 1 Administering ColdFusion MX 11 Chapter 2 Using the ColdFusion MX Administrator 13 Chapter 3 Data Source Management 43 Chapter 4 Web Server Management 65 Chapter 5 Deploying ColdFusion Applications 79 Chapter 6 Administering Security 85 Chapter 7 Using Multiple Server Instances 91 ...

Page 10: ......

Page 11: ...on MX configurations see About the ColdFusion MX 7 installation in Chapter 1 Preparing to Install ColdFusion MX 7 in Installing and Using ColdFusion MX The default location for the ColdFusion MX Administrator login page is http servername portnumber CFIDE administrator index cfm Where servername is the fully qualified domain name of your web server Common values for servername are localhost or 127...

Page 12: ... the ColdFusion MX Administrator on page 13 About web server administration ColdFusion MX applications require a web server to process ColdFusion Markup Language CFML pages The server and multiserver configurations provide a built in web server along with support for external web servers such as Apache IIS and Sun ONE Web Server formerly known as iPlanet For more information see Chapter 4 Web Serv...

Page 13: ...sion of performing Administrator functionality programmatically through the Administrator application programming interface API Contents Initial administration tasks 14 Accessing user assistance 14 Server Settings section 15 Data Services section 24 Debugging Logging section 26 Extensions section 32 Event Gateways section 34 Security section 35 Packaging and Deployment section 36 Enterprise Manage...

Page 14: ...ge For more information see Mappings page on page 20 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 For more information see Debugging Settings and Debugging IPs pages on page 26 Set up e mail E mail ...

Page 15: ...ng Settings page Java and JVM Settings page ColdFusion Archives page Settings Summary page Settings page The Settings page of the ColdFusion MX 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 options Option Description Maximum number of simultaneous requests n...

Page 16: ... Handler Specify a page to execute when ColdFusion MX cannot find a requested page This specification is relative to the web root Note If the user is running Microsoft Internet Explorer with Show Friendly HTTP error messages enabled in advanced settings the default Internet Explorer will only display this page if it contains more than 512 bytes Site wide Error Handler Specify a page to execute whe...

Page 17: ...he Client Variables page using the Application cfc file or the cfapplication tag For more information see ColdFusion MX Developer s Guide Save Class Files Select this option to save to disk the class files generated by the ColdFusion bytecode compiler During the development phase it is typically faster if you disable this option Cache web server paths not available in J2EE configuration Select thi...

Page 18: ...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 Cookie data is limited to 4 KB Netscape Navigator allows only 20 cookies from one h...

Page 19: ...emory Variables page of the ColdFusion MX 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 You can specify maximum and default timeout values for session and application varia...

Page 20: ...hat points to C 2002 newpages headers for example add a mapping for headers that points to C 2002 newpages headers In the ColdFusion pages located in C CFusionMX7 wwwroot you reference these header pages using headers in your cfinclude and cfmodule tags Note ColdFusion mappings are different from web server virtual directories For information on creating a virtual directory to access a given direc...

Page 21: ...Edition only Enter zero or more backup servers for sending SMTP mail messages You can enter an Internet address such as mail company com or the IP address of the mail server such as 127 0 0 1 Separate multiple servers with a comma If the mail server requires authentication prepend the mail server with the username and password as follows username password mailserveraddress To use a port number oth...

Page 22: ...ry faster but messages do not persist You can override this setting in the cfmail tag Maximum number of messages spooled to memory Enterprise Edition only Enter the maximum number of messages ColdFusion MX will spool to memory before switching to disk spooling Option 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 ...

Page 23: ...ags can locate and render PDF and FlashPaper reports This page contains the following sections Register New Font with ColdFusion Lets you browse to a directory that contains fonts or select a specific font User Defined Fonts Displays the fonts that have been registered explicitly Current System Fonts Displays fonts stored in platform specific system font directories For more information on font ma...

Page 24: ...th The absolute file path to the location of the Java virtual machine JVM root directory The default is cf_root runtime jre Minimum JVM Heap Size The JVM initial heap size Maximum Memory Size The JVM maximum heap size The default value is 512 MB Class Path The file paths to the directories that contain the JAR files used by ColdFusion MX Specify either the fully qualified name of a directory that ...

Page 25: ...gical pointers to the document files For more information about building search interfaces see Chapter 24 Building a Search Interface in ColdFusion MX Developer s Guide ColdFusion lets you manage your collections from the Administrator You can index optimize purge or delete Verity collections that are connected to ColdFusion You use the icons in the Actions column to perform the following actions ...

Page 26: ... you register a web service you can shorten your code and change a web service s URL without editing your code For more information see Chapter 36 Using Web Services in ColdFusion MX Developer s Guide Debugging Logging section The Debugging Logging section contains the following pages Debugging Settings and Debugging IPs pages Debugging IP Addresses page Logging Settings page Log Files page Schedu...

Page 27: ...d a specified time limit General Debug Information Show general information about the ColdFusion MX version template time stamp user locale user agent user IP and host name Database Activity Shows the database activity for the SQL Query events and Stored Procedure events in the debugging output Exception Information Shows all ColdFusion exceptions raised for the request in the debugging output Tra...

Page 28: ...ng for ColdFusion MX to process them Lower values which you can achieve with efficient CFML are better Req Run g Number of running requests The number of requests that ColdFusion MX is currently actively processing Req TO ed Number of timed out requests The total number of ColdFusion requests that have timed out Lower values which you can achieve by aggressive caching removing unnecessary dynamic ...

Page 29: ...stat 20 Debugging IP Addresses page You use the Debugging IP Addresses page to restrict debugging output to one or more IP addresses You can add and remove IP addresses Note If you do not specify IP addresses and debugging options are active ColdFusion MX displays debugging output for all users Switch Description Comment n Suppress column headers Useful for saving output to a file s Display output...

Page 30: ... newest Log slow pages taking longer than n seconds Logs the names of pages that take longer than the specified interval to process Logging slow pages can help you diagnose potential problems or bottlenecks in your ColdFusion applications Entries are written to the server log file Log all CORBA calls Logs all CORBA calls Enable logging for scheduled tasks Logs ColdFusion Executive task scheduling ...

Page 31: ...ine help System Probes page System probes help you evaluate the status of your ColdFusion applications Like scheduled tasks they access a URL at a specified interval but they can also check for the presence or absence of a string in the URL If the URL contents are unexpected or if an error occurred while accessing the URL the probe can send an e mail alert to the address specified on the System Pr...

Page 32: ...ministrator uses universal datagram protocol UDP multicast to collect license and version information from all ColdFusion instances running within the subnet Extensions section You use the Extensions section of the Administrator to configure ColdFusion MX to work with other technologies such as Java and CORBA The Extensions section contains the following pages Java Applets page CFX Tags page Custo...

Page 33: ...lications You must also restart the server when you finish configuring the CORBA connector ColdFusion MX loads object request broker ORB libraries dynamically using a connector which does not restrict ColdFusion developers to a specific ORB vendor The connectors depend on the ORB runtime libraries provided by the vendor A connector for Borland Visibroker is embedded within ColdFusion MX Make sure ...

Page 34: ...igure the types of gateways available on your system After you configure a type you can create any number of gateway instances of that type The following table describes the event gateway types that ship with ColdFusion MX Option Description Enable ColdFusion Event Gateway Service Specifies whether the service is enabled Changing this setting restarts the service Event Gateway Processing Threads S...

Page 35: ...Administrator access to trusted users XMPP Used to send and receive instant messages through the Extensible Messaging and Presence Protocol XMPP Samples Sample gateway types including the following DirectoryWatcher Watches a directory for file changes JMS Acts as a Java Messaging Service consumer or producer Socket Listens on a TCP IP port Option Description Gateway ID A name for the event gateway...

Page 36: ...ctory you override the sandbox settings inherited from the parent directory Use sandbox security to control access to the following Data sources Tags Functions Files and directories IP addresses and ports Note If you have enabled sandbox security and want to use the Administrator API you must enable access to the CFIDE adminapi directory Packaging and Deployment section The Packaging and Deploymen...

Page 37: ...his EAR or WAR file a J2EE administrator can deploy your ColdFusion MX application to a J2EE application server Tip If you are creating a cluster of server instances when running the multiserver configuration use this page to create the WAR or EAR file to be used when creating each of the servers in the cluster You can create a J2EE archive regardless of whether you are running ColdFusion MX in th...

Page 38: ...manage clusters of JRun servers each containing the same ColdFusion MX application Custom Extensions section You can extend the functionality of the ColdFusion MX 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 To extend the Administrator 1 Create a file that contains the HTML ...

Page 39: ...ng simple values such as true or false debug settings the Administrator API uses get and set property methods To view the methods method arguments and documentation for the Administrator API CFCs use the CFC Explorer For example to view datasource cfc when running in the server configuration open a browser to http localhost 8500 CFIDE adminapi datasource cfc CFC Description administrator cfc Conta...

Page 40: ...l the desired CFC method this example enables debugging myObj setDebugProperty propertyName enableDebug propertyValue true Examples The following example adds a SQL Server data source cfscript Login is always required This example uses two lines of code adminObj createObject component cfide adminapi administrator adminObj login admin Instantiate the data source object myObj createObject component ...

Page 41: ...arguments for a data source stDSN structNew stDSN driver MSSQLServer stDSN name northwind_MSSQL stDSN host 10 1 147 73 stDSN port 1433 stDSN database northwind stDSN username sa Optional and advanced arguments stDSN login_timeout 29 stDSN timeout 23 stDSN interval 6 stDSN buffer 64000 stDSN blob_buffer 64000 stDSN setStringParameterAsUnicode false stDSN description Northwind SQL Server stDSN pooli...

Page 42: ...42 Chapter 2 Using the ColdFusion MX Administrator Create a DSN myObj setMSSQL argumentCollection stDSN cfscript Optionally dump the stDSN structure cfoutput cfdump var stDSN cfoutput ...

Page 43: ...e configuration options for ColdFusion MX 7 data sources For basic information on data sources and connecting to databases see Getting Started Building ColdFusion MX Applications Contents About JDBC 44 Adding data sources 45 Connecting to DB2 Universal Database 47 Connecting to Informix 49 Connecting to Microsoft Access 50 Connecting to Microsoft Access with Unicode 52 Connecting to Microsoft SQL ...

Page 44: ...iver type unless your application requires DBMS specific features 2 Native API partly Java driver Converts JDBC calls to database specific calls Advantages Better performance than Type 1 driver Disadvantages The vendor s client database libraries must reside on the same computer as ColdFusion ColdFusion MX includes a type 2 driver for use with Microsoft Access Unicode databases 3 JDBC Net pure Jav...

Page 45: ...s database connections for example in the cfquery tag During a query the data source tells ColdFusion which database to connect to and what parameters to use for the connection The ColdFusion MX Administrator organizes all the information about a ColdFusion MX server s database connections in a single easy to manage location In addition to adding new data sources you can use the Administrator to s...

Page 46: ...e network name or IP address of the server that hosts the database and enter any required Port value for example the bullwinkle server on the default port 7 If your database requires login information enter your Username and Password Tip The omission of required username and password information is a common reason why a data source fails to verify 8 Optional Enter a Description 9 Optional Click Sh...

Page 47: ...ee a list of DB2 versions that ColdFusion MX supports go to www macromedia com go sysreqscf Note DB2 UDB refers to all versions of DB2 running on Windows UNIX and Linux s390 platforms Use the settings in the following table to connect ColdFusion MX to DB2 Setting Description CF Data Source Name The data source name DSN used by ColdFusion MX to connect to the data source Database The name of the da...

Page 48: ...nections ColdFusion establishes a connection to a data source for every operation that requires one Enable this option to improve performance by caching the data source connection Max Pooled Statements Enables reuse of prepared statements that is stored procedures and queries that use the cfqueryparam tag Although you tune this setting based on your application start by setting it to the sum of th...

Page 49: ...dFusion application does not supply a user name for example in a cfquery tag Password The password that ColdFusion MX passes to the JDBC driver to connect to the data source if a ColdFusion application does not supply a password for example in a cfquery tag Description Optional A description for this connection Connection String A field that passes database specific parameters such as login creden...

Page 50: ...ed The default value is 64000 bytes BLOB Buffer The default buffer size used if the BLOB option is not selected The default value is 64000 bytes Allowed SQL The SQL operations that can interact with the current data source Setting Description CF Data Source Name The data source name DSN used by ColdFusion MX to connect to the data source Database File The file that contains the database System Dat...

Page 51: ...imits the number of database connections for the data source If you enable this option use the Restrict Connections To field to specify the maximum Restrict Connections To Specifies the maximum number of database connections for the data source To use this restriction you must enable the Limit Connections option Maintain Connections ColdFusion MX establishes a connection to a data source for every...

Page 52: ...usion page times out Max Buffer Size The size of the internal buffer in kilobytes used by Microsoft Access to transfer data to and from the disk Can be any integer value divisible by 256 Connection String A field that passes database specific parameters such as login credentials to the data source Limit Connections Specifies whether ColdFusion MX limits the number of database connections for the d...

Page 53: ... option is not selected The default value is 64000 bytes Allowed SQL The SQL operations that can interact with the current data source Setting Description CF Data Source Name The data source name DSN used by ColdFusion MX to connect to the data source Database The database to which this data source connects Server The name of the server that hosts the database that you want to use If the database ...

Page 54: ...bles reuse of prepared statements that is stored procedures and queries that use the cfqueryparam tag Although you tune this setting based on your application start by setting it to the sum of the following Unique cfquery tags that use the cfqueryparam tag Unique cfstoredproc tags Timeout min The number of minutes that ColdFusion MX maintains an unused connection before destroying it Interval min ...

Page 55: ...ect the Security tab Ensure that the SQL Server and Windows radio button is clicked 8 Click OK To set up the database in the ColdFusion MX Administrator 1 Open the ColdFusion MX Administrator 2 Click Data Services Data Sources 3 Type northwind in the Data Source Name field and select Microsoft SQL Server in the Driver drop down list box 4 Click Add 5 Type Northwind in the Database Name field 127 0...

Page 56: ...emoving the user name and password from the ColdFusion data source Connecting to MySQL To see a list of MySQL versions that ColdFusion MX supports go to www macromedia com go sysreqscf Use the settings in the following table to connect ColdFusion MX to MySQL data sources Setting Description CF Data Source Name The data source name DSN used by ColdFusion MX to connect to the data source Database Th...

Page 57: ...imes 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 source If not selected ColdFusion MX retrieves the number of characters specified in the Long Text Buffer setting BLOB Select to return the entire contents of any BLOB Image columns in the database for this data source If not selected ColdFusion MX retr...

Page 58: ...peration that requires one Enable this option to improve performance by caching the data source connection Timeout min The number of minutes that ColdFusion MX maintains an unused connection before destroying it Interval min The time in minutes that the server waits between cycles to check for expired data source connections to close Disable Connections If selected suspends all client connections ...

Page 59: ...or this connection Connection String A field that passes database specific parameters such as login credentials to the data source Limit Connections Specifies whether ColdFusion MX limits the number of database connections for the data source If you enable this option use the Restrict Connections To field to specify the maximum Restrict Connections To Specifies the maximum number of database conne...

Page 60: ...ta Source Name The data source name DSN used by ColdFusion MX to connect to the data source JDBC URL The JDBC connection URL for this data source Driver Class The fully qualified class name of the driver For example com inet tds TdsDriver The JAR file that contains this class must be in a directory defined in the ColdFusion classpath Driver Name Optional The name of the driver Username The user na...

Page 61: ...formance by caching the data source connection Timeout min The number of minutes that ColdFusion MX maintains an unused connection before destroying it Interval min The time in minutes that the server waits between cycles to check for expired data source connections to close Disable Connections If selected suspends all client connections Login Timeout sec The number of seconds before ColdFusion MX...

Page 62: ...ing the client connectivity wizard both of these approaches worked in earlier ColdFusion versions Port The number of the TCP IP port that the server monitors for connections Username The user name that ColdFusion MX passes to the JDBC driver to connect to the data source if a ColdFusion application does not supply a user name for example in a cfquery tag Password The password that ColdFusion MX pa...

Page 63: ...rce connections to close Disable Connections If selected suspends all client connections Login Timeout sec The number of seconds before ColdFusion MX 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 source If not selected ColdFusion MX retrieves the number of characters specified in the Long Text Buf...

Page 64: ...following SECURITY_PRINCIPAL myusername SECURITY_CREDENTIALS mypassword CLOB Select to return the entire contents of any CLOB Text columns in the database for this data source If not selected ColdFusion MX retrieves the number of characters specified in the Long Text Buffer setting BLOB Select to return the entire contents of any BLOB Image columns in the database for this data source If not selec...

Page 65: ...sing the built in web server 66 Using an external web server 67 Web server configuration 68 Multihoming 74 About web servers in ColdFusion MX The web server is a critical component in your ColdFusion MX environment and understanding how ColdFusion interacts with web servers can help you administer your site ColdFusion MX provides the following web server options Built in web server A lightweight a...

Page 66: ...operating systems If you enable the built in web server during the installation process and the port is already in use the installer automatically finds the next highest available port and configures the built in web server to use that port To determine the port number used by the built in web server open the cf_root runtime servers coldfusion SERVER INF jrun xml file in a text editor and examine ...

Page 67: ... specific plug in modules as the following table describes Web server Connector details Apache The Web Server Configuration Tool adds the following elements to the Apache httpd conf file A LoadModule directive defines the connector An AddHandler directive tells Apache to route requests for ColdFusion pages through the connector For Apache 1 3 x the connection module is mod_jrun so for Apache 2 x t...

Page 68: ...t the Web Server Configuration Tool using the wsconfig exe Windows or wsconfig UNIX command The Web Server Configuration Tool window appears 4 Click the Add button 5 Select the Configure Web Server for ColdFusion MX Applications check box 6 In the Server drop down list box select the server or cluster name that you want to configure Individual server names in a cluster do not appear Clustering sup...

Page 69: ...tions wsconfig options The following table describes the options Option Description ws Specifies the web server as follows IIS Apache SunOne iPlanet NES The web server name you supply is not case sensitive dir Specifies the path to the configuration directory Apache conf or NES iPlanet config site Specifies the IIS website name case sensitive Specify All or 0 to configure the connector at a global...

Page 70: ...is implicitly specified Always use this option when configuring a web server for use with ColdFusion MX upgrade Upgrades existing configured connectors with newer modules from a newer wsconfig jar file service Specifies the Apache Windows service name The default value is Apache bin Specifies the path to the Apache server binary file apache exe in Windows httpd on UNIX script Specifies the path to...

Page 71: ...tl dir opt apache2 conf coldfusion v Configure Apache on UNIX 2 cf_root runtime bin wsconfig server coldfusion ws Apache bin usr bin httpd script usr bin httpd dir etc httpd conf coldfusion v Configure Apache in Windows cf_root runtime bin wsconfig exe server coldfusion ws apache dir c program files apache group apache2 conf coldfusion v Configure Netscape on UNIX cf_root runtime bin wsconfig serv...

Page 72: ... contains information for the associated JRun server The connector creates this file automatically The default filename is jrunserver store verbose Creates more detailed web server log file entries for the connector Enabling this option can cause the web server s log files to fill quickly Specify true or false the default value is false In Apache and Sun ONE Web Server the connector writes to the ...

Page 73: ... the jrun dll file jrun_iis6 dll on IIS 6 The following is a typical jrun ini file verbose false scriptpath JRunScripts jrun dll serverstore C CFusionMX7 runtime lib wsconfig 1 jrunserver store bootstrap 127 0 0 1 51011 apialloc false ssl false ignoresuffixmap true errorurl optionally redirect to this URL on errors proxyretryinterval number of seconds to wait before trying to reconnect to unreacha...

Page 74: ... fn send file Service method TRACE fn service trace AddLog fn flex log name access Object The following is a typical magnus conf file for Netscape iPlanet or Sun ONE Web Server Init fn load modules shlib C CFusionMX7 runtime lib wsconfig 1 jrun_nsapi dll funcs jruninit jrunfilter jrunservice Init fn jruninit serverstore C CFusionMX7 runtime lib wsconfig 1 jrunserver store bootstrap 127 0 0 1 51011...

Page 75: ... ensure that Cache Web Server Paths is disabled in t he Caching page of the ColdFusion MX Administrator When you use the multiserver configuration set the cacheRealPath attribute to false for the ProxyService in the jrun_root servers servername SERVER INF jrun xml file The procedures you perform to enable multihoming differ for each web server IIS When you use IIS you run the IIS Administrator to ...

Page 76: ... store log VirtualHost VirtualHost 127 0 0 1 ServerAdmin admin yoursite com DocumentRoot C Program Files Apache Group Apache2 htdocs3 ServerName myemployee ErrorLog logs error employee log VirtualHost 3 Test each virtual host to ensure that HTML pages are served correctly 4 Run the Web Server Configuration Tool as follows GUI Specify Apache for the Web Server specify the directory that contains th...

Page 77: ... servers for use by ColdFusion MX For more information see your Sun ONE Web Server documentation 2 Configure DNS for each virtual website as described in your web server documentation 3 Test each virtual server to ensure that HTML pages are served correctly 4 Run the Web Server Configuration Tool as follows GUI Specify Netscape Enterprise Server Sun ONE for the web server specify the directory tha...

Page 78: ...78 Chapter 4 Web Server Management ...

Page 79: ...ation Archive WAR file for easy deployment to a J2EE application server For more information see Packaging applications in J2EE archive files on page 80 Cfcompile utility The cfcompile utility lets you precompile your application s ColdFusion pages into Java class files In addition you can compile ColdFusion pages to bytecode and save this bytecode in files with the CFM CFC or CFR extension For mo...

Page 80: ...he multiserver and J2EE configurations you deploy the ColdFusion application in enterprise application archive EAR or web application archive WAR format on a J2EE application server You then create your ColdFusion MX application configuring resources such as data sources and storing CFM CFC and CFR files in the web application root or in the web server root In earlier ColdFusion MX releases your J...

Page 81: ...fmx you display the Administrator using the URL http hostname cfmx CFIDE administrator index cfm Most J2EE application servers allow one application in each server instance to use a forward slash for the context root The Remote Development Services RDS web application is not required if you use a context root of Serial Number Specifies a ColdFusion MX Enterprise Edition serial number If you do not...

Page 82: ...ity server settings using the ColdFusion MX Administrator or the Administrator API Serial number J2EE deployment is a ColdFusion MX Enterprise feature To upgrade to the Enterprise Edition enter a serial number using the ColdFusion MX Administrator or the Administrator API For more information on the Administrator API see Administrator API on page 39 Using the cfcompile utility You can use the cfco...

Page 83: ...ve screen of the ColdFusion MX Administrator lets you create an EAR or WAR file that contains bytecode versions of your application s CFML files Parameter Description webroot Fully qualified path to the web server root for example C Inetpub wwwroot or C CFusionMX7 wwwroot directory to compile Fully qualified path to the directory where the files to be compiled are located This directory must be un...

Page 84: ...84 Chapter 5 Deploying ColdFusion Applications ...

Page 85: ...e ColdFusion MX Administrator and a password for Remote Development Services RDS which allows developers to develop CFML pages remotely You implement runtime security in your CFML pages and in the ColdFusion MX Administrator ColdFusion MX has the following runtime security categories User security Programmatically determine the logged in user and allow or disallow restricted functionality based on...

Page 86: ...st unauthorized modifications of ColdFusion MX and Macromedia highly recommends using passwords You can disable or change the Administrator password on the Security CF Admin Password page RDS password protection If you configured password protection for RDS access when you installed ColdFusion you are prompted for the password when you attempt to access ColdFusion MX from Macromedia Dreamweaver MX...

Page 87: ... a sandbox for the rnd directory the rnd sandbox settings also apply to the dev and qa directories the wwwroot and sales directories maintain their original settings and the rnd settings override the wwwroot directory settings for the rnd directory and its subdirectories This hierarchical arrangement of security permits the configuration of personalized sandboxes for users with different security ...

Page 88: ...cify the actions that ColdFusion tags and functions can perform on files and directories outside the sandbox The following table shows the relationship between the permissions of a file and a directory Adding a sandbox Enterprise Edition only ColdFusion MX Enterprise Edition lets you define multiple security sandboxes To add a sandbox 1 Open the Security Sandbox Security page in the ColdFusion MX ...

Page 89: ...s sandbox can access all data sources Note If ALL DATASOURCES is in the Enabled Datasources column any data source that you add is enabled If you move ALL DATASOURCES to the Disabled Datasources column any new data source is disabled 4 Click the CFTags tab 5 To disable tags in the left column of the CFTags tab highlight the tags and click the right arrow By default ColdFusion pages in this sandbox...

Page 90: ...es for example cfmail cfpop cfldap cfhttp and so on You can specify an IP address a server name such as www someservername com or a domain name such as someservername com You can optionally specify a port restriction Note This behavior differs from other tabs such as CFTags where you select items to disable If you set any values in this tab external resource tags executed in this sandbox can acces...

Page 91: ... to automatically deploy the ColdFusion MX application on those instances Additionally you can combine the Administrator driven server instance creation with the ColdFusion MX Administrator J2EE Archive feature to deploy a ColdFusion MX application that contains all of your application s CFM files including CFCs and CFRs settings including data source definitions and the ColdFusion web application...

Page 92: ...configuration nor are they available in the J2EE configuration even if you deploy on JRun Note You can also manually deploy ColdFusion MX on multiple server instances using your J2EE application server s server creation and deployment facilities as documented in the ColdFusion MX 6 1 documentation Expanded archive considerations ColdFusion MX must run from an expanded directory structure The Insta...

Page 93: ...usion MX Administrator for the cfusion server in a browser http hostname 8300 CFIDE administrator 3 Select Enterprise Manager Instance Manager 4 Click Add New Instance 5 Specify the following in the Add New ColdFusion Server area Server name Optional Directory that contains the server instance The ColdFusion MX Administrator fills in the default automatically jrun_root servers servername Optional ...

Page 94: ... the jrun command which specifies a customized jvm config file This is explained in the Starting and stopping JRun servers section in Installing and Using ColdFusion MX Note These instructions describe creating multiple server instances on a single computer To create multiple server instances on separate computers each computer requires a separate license of ColdFusion MX Enterprise Edition To ach...

Page 95: ...ion between the website and the server instance differ for each web server This section contains the following sections Configuring application isolation in IIS Configuring application isolation in Apache Configuring application isolation in Sun ONE Web Server Tip To enhance performance when using an external web server with multiple server instances place all static content HTML files and images ...

Page 96: ... two other directories jrun_root lib wsconfig mystore and jrun_root lib wsconfig myemp in this example These directories can be empty 3 Open the jrun_root servers servername SERVER INF jrun xml file for each of your server instances locate the ProxyService service ensure that the deactivated element is set to false and note the value of the port element for example service class jrun servlet jrpp ...

Page 97: ...sion server instance copy the entire IfModule mod_jrun20 c directive from its original location outside the VirtualHost directive to the last element in the VirtualHost directive 7 Delete the Apialloc Ssl Ignoresuffixmap and AddHandler elements in the IfModule directive for each virtual host Modify the Serverstore and Bootstrap elements to point to the appropriate proxy port from the jrun xml file...

Page 98: ...e 10 Optional Store the application s ColdFusion files in your external web server root directory 11 Test the applications under each virtual host Note Remember that the web server connector doesn t serve static content such as HTML and images Place these files under the web root or create a web server mapping to the ColdFusion web application root Configuring application isolation in Sun ONE Web ...

Page 99: ...ight not continue to function appropriately when the Trial version reverts to the Developer version after 30 days To implement session failover for the server instances in a cluster you must enable session replication for each server instance Session replication coordinates session information in real time among the server instances in a cluster Enabling session replication lets JRun automatically...

Page 100: ... on each server instance using the CF Admin icon on the Instance Manager Ensure that required resources such as data sources and Verity collections are defined appropriately If you are using session replication go to the Memory Variables page and enable J2EE sessions You must do this for all server instances in the cluster If J2EE sessions are not enabled in the ColdFusion MX Administrator session...

Page 101: ...r Instance area of the Instance Manager page Note To define a remote server instance it must be running You cannot start or stop servers remotely To define a remote server instance to ColdFusion 1 Open the ColdFusion MX Administrator for the cfusion server in a browser http hostname 8300 CFIDE administrator 2 Select Enterprise Manager Instance Manager 3 Specify the following in the Add Remote Cold...

Page 102: ...102 Chapter 7 Using Multiple Server Instances ...

Page 103: ... for configuring the Verity K2 Server search engine as well as creating managing and troubleshooting Verity collection The following chapters are included Chapter 8 Introducing Verity and Verity Tools 105 Chapter 9 Indexing Collections with Verity Spider 109 Chapter 10 Using Verity Utilities 141 PART II ...

Page 104: ......

Page 105: ...rts simultaneous indexing of distributed enterprise repositories and handles hundreds of concurrent queries and users The Verity search system takes advantage of the latest advances in hardware and software technology and provides the following features Multithreaded architecture Support for Verity knowledge retrieval features including topics Continuous operation support High scalability Category...

Page 106: ...erity K2 domain This service starts three processes k2server exe k2index exe and k2admin exe UNIX The cf_root bin cfmxsearch control script cf_webapp_root WEB INF cfusion bin cfmxsearch in the multiserver configurations starts and stops Verity When you call this script with the start argument it calls verity_root k2 platform_dir bin k2adminstart with the appropriate user context and environment wh...

Page 107: ...ver with restrictions in the following areas ColdFusion MX can only interact with one Verity Server at a time Verity Server has the following document search limits limits are for all collections registered to Verity Server 10 000 documents for ColdFusion MX Developer Edition 125 000 documents for ColdFusion MX Standard Edition 250 000 documents for ColdFusion MX Enterprise Edition Note Each row i...

Page 108: ...108 Chapter 8 Introducing Verity and Verity Tools ...

Page 109: ...uments throughout your enterprise Verity Spider lets you index more than two hundred of the most popular application document formats including Microsoft Office WordPerfect ASCII text HTML SGML XML and PDF Adobe Acrobat documents Another advantage of this method is that the index created by vspider includes dynamic content The cfindex tag and indexing a collection through the Macromedia ColdFusion...

Page 110: ...is greatly improved over previous versions because of low memory requirements flow control and the help of multithreading and efficient Domain Name System DNS lookups Flow control When indexing websites Verity Spider distributes requests to web servers in a round robin manner This means that one URL is fetched from each web server in turn With flow control a faster website can finish before a slow...

Page 111: ...e indexing jobs are running To optimize performance try staggering your indexing jobs to avoid overloading your server The Verity Spider command The vspider executable file which starts the Verity Spider utility is located in the platform bin directory as follows Server and multiserver configuration The vspider exe Window or vspider UNIX file is located in cf_root verity k2 platform bin server con...

Page 112: ...ation on Linux this directory is cf_root verity k2 _ilnx21 bin Using a command file For simpler reuse and archiving of your indexing commands use the cmdfile option for abstraction By using an ASCII text file to store a task s options you avoid the potential problem of using special characters in an option s parameter value For example the processbif option requires the use of and therefore any ta...

Page 113: ...are also deleted from the persistent store and the collection The exception to this rule is when you use the nooptimize option with the refresh option In this case any document deleted from the repository is marked for deletion in the collection It will be removed from the collection and the persistent store when the next indexing task is run for the collection When you rerun an existing indexing ...

Page 114: ... to the collection to create or update Note You receive an error if you specify a filename with an extension of CLM Meta collections are not supported help Displays Verity Spider syntax options jobpath Syntax jobpath path Specifies the location of the Verity Spider databases and the indexing job related files and directories The following are the job related directories and their contents log All ...

Page 115: ...hrough the file system use the prefixmap option with the abspath option to map the absolute file paths to URLs See also prefixmap detectdupfile Type File system only Enables checksum based detection of duplicates when indexing file systems By default a document checksum is not computed on indexed files By using the detectdupfile option a checksum is computed based on the CRC 32 algorithm The check...

Page 116: ...SCII text that maps file extensions to MIME types This lets you make custom associations and override defaults The following is the format for the control file file_ext_no_dot mime type abc application word nocache Type Web crawling only Used with the noindex or nosubmit options this option disables the caching of files during website indexing This has the effect of decreasing the demands on your ...

Page 117: ...collection is not updated See also nocache and nosubmit For more information on the mkvdk utility see Using the mkvdk utility on page 142 nosubmit Specifies that Verity Spider gathers document locations without submitting them The document locations are stored in a bulk insert file BIF which is not submitted to the collection This option is typically used in conjunction with a separate indexing pr...

Page 118: ...s This is only required when you run the indexing job from a command line Quotation marks are not necessary within a command file the cmdfile option See also regexp prefixmap Type File system only Syntax prefixmap path_and_filename Specifies a control file simple ASCII text that maps file system paths to web aliases In conjunction with the abspath option this option is typically used to create a U...

Page 119: ...ion mark for single characters as the following table shows Regular expressions allow for more powerful and flexible matching of alphanumeric strings for example to match ab11 or ab34 but not abcd or ab11cd you could use the following regular expression ab 0 9 0 9 The full extent to which regular expressions can be employed is beyond the scope of this description For more information on regular ex...

Page 120: ...exing job directories and files one of which is the temp directory Networking options The following sections describe the Verity Spider networking options agentname Type Web crawling only Syntax agentname string Specifies the value for the agent name field that is part of the HTTP request Since web servers can be configured to return different versions of the same page depending on the requesting ...

Page 121: ...d by default and the proxyauth option is available for proxy server authentication Therefore the header option is maintained only for backwards compatibility and possible future enhancements Note Misuse of this option causes spider failure If this happens rerun the indexing task with modified header values hostcache Syntax hostcache num_hostnames Specifies the number of host names to cache to avoi...

Page 122: ...hen you run the indexing job from a command line Quotation marks are not necessary within a command file the cmdfile option Note You must have valid Verity Spider licensing capability to use this option proxy Type Web crawling only Syntax proxy proxyhost port Specifies host and port for proxy server Note You must have valid Verity Spider licensing capability to use this option See also proxyauth f...

Page 123: ...auth Syntax auth path_and_filename Specifies an authorization file to support authentication for secure paths Use the auth option to specify the authorization file The file contains one record per line Each line consists of server realm username and password separated by whitespace The following is a sample authorization file This is the Authorization file for HTTP s Basic Authentication server re...

Page 124: ...e on which ColdFusion MX is installed Contact Verity Sales for licensing options regarding the use of Verity Spider for external websites followdup Specifies that Verity Spider follows links within duplicate documents although only the first instance of any duplicate documents is indexed You might find this option useful if you use the same home page on multiple sites By default only the first ins...

Page 125: ...4 0 every document can have robot directives embedded in the META field Use this option to ignore them Use this option with discretion nofollow Type Web crawling only Syntax nofollow exp Specifies that Verity Spider cannot follow any URLs that match the exp expression If you do not specify an exp value for the nofollow option Verity Spider assumes a value of where no documents are followed You can...

Page 126: ...included for example neither www spider com 80 nor C would be included in determining the path length All elements following the host name are included The actual filename if present is included for example world html would be included in determining the path length Any directory paths between the host and the actual filename are included Example For the following URL the path length would be four...

Page 127: ...trings for hosts You cannot use wildcard expressions This lets you index by alias such as when multiple web servers are running on the same host You can use regular expressions Normally when Verity Spider resolves host names it uses DNS lookups to convert the names to canonical names of which there can be only one per machine This allows for the detection of duplicate documents to prevent results ...

Page 128: ...his is only required when you run the indexing job from a command line Quotation marks are not necessary within a command file the cmdfile option To use regular expressions also specify the regexp option To specify a file path or URL that you want followed but not indexed use the indexclude option For document types use the mimeexclude option instead for example specify mimeexclude application pdf...

Page 129: ... also regexp indexclude Syntax indexclude exp_1 exp_n Specifies that the files and paths in URLs that match the expressions are not indexed They are however still followed If you use backslashes you must double them so that they are properly escaped for example C test docs path You can use wildcard expressions where the asterisk is for text strings and the question mark is for single characters fo...

Page 130: ...n following anything that does not match the specified expressions the indinclude option allows Verity Spider to follow anything while only indexing that which matches the specified expressions Example If you want to index all documents that include search in the URL at http web verity com you cannot use the following vspider collection collname start http web verity com include search This is bec...

Page 131: ...dex desired documents if the starting URL is not followed For the mime variable you can include the asterisk wildcard for text strings for example text In Windows include double quotation marks around the argument to protect the special character On UNIX use single quotation marks This is only required when you run the indexing job from a command line Quotation marks are not necessary within a com...

Page 132: ... for example C test docs path To use regular expressions also specify the regexp option Example 1 To skip all HTML documents that contain the word personnel in the Title element while still parsing those documents for links to other documents use the following indskip title personnel Example 2 To avoid indexing directory listing pages while still parsing the document and path links except for the ...

Page 133: ...value is always sent but you want to specify your own value with a custom meta tag If you use the n override flag the value for the custom meta tag is used only if there is no value for the valid field returned by the server If a value for the valid field exists it is given precedence Note If you have several entries mapping to the same valid field only the last entry takes effect mimeexclude Synt...

Page 134: ...ocuments smaller than the value specified by the mindocsize option are ignored The default is to index documents of any sizes skip Type Web crawling only Syntax skip HTML_tag exp Specifies that Verity Spider not index any HTML document that contains the text of exp within the given HTML_tag For multiple HTML_tag and exp combinations use multiple instances of the skip option You can use wildcard ex...

Page 135: ...s the path to the Verity home directory cf_root verity k2 common Note This option is typically not needed as long as the PATH environment variable is set correctly datefmt Syntax datefmt format Specifies the Verity import date format to use Valid values are MDY the default DMY YMD USA and EUR For descriptions of these values see Date format options on page 147 language Syntax language name Specifi...

Page 136: ...pes Message type Description information Licensing information written to info log Included with all arguments warning Warning messages written to warning log Included with all arguments error Error messages written to error log Included with all arguments badkey Messages regarding keys that could not be indexed due to invalid documents written to badkey log Included with all arguments progress Cu...

Page 137: ...y you should not leave a collection unoptimized for too long as search times can slow significantly In brief optimizing a collection means creating a small number of large partitions which can greatly reduce search times Loglevel arguments Description summary Includes the following message types information warning error badkey progress summary Use this option only if you do not want skip type mes...

Page 138: ...an use the MIME type criteria options mimeinclude indmimeinclude mimeexclude and indmimeexclude to include or exclude MIME types Syntax restrictions When you specify MIME type criteria keep in mind the restrictions described in the following sections Using the wildcard character The asterisk wildcard character does not operate as a regular expression for the value of the MIME type criteria Instead...

Page 139: ...ng mimeinclude text MIME types and file system indexing When you index a file system Verity Spider reads filenames and evaluates your MIME type criteria against an internal compiled list of known MIME types and associated file extensions You cannot edit this list However you can use the mimemap option to create a custom MIME type mapping When you encounter MIME types being dropped check whether Ve...

Page 140: ...teria include indinclude mimeinclude or indmimeinclude to specify them for example include txt 1st log Setting MIME Types Known MIME types for file system indexing The following table lists the MIME types that Verity Spider recognizes when indexing file systems Format MIME type Extension HTML text html htm html ASCII text plain txt text pl eml ASCII source files text plain c h cpp cxx PDF applicat...

Page 141: ...tilities are included with Macromedia ColdFusion MX for performing a variety of operations on Verity collections Verity utility Description For more information mkvdk Create and maintain collections See Using the mkvdk utility on page 142 rck2 Search K2 Server collections See Using the rck2 utility on page 153 rcvdk Search collections and display documents See Using the rcvdk utility on page 154 d...

Page 142: ... the following command mkvdk help The mkvdk utility syntax The following is the basic syntax of the mkvdk command mkvdk collection path option dockey Multiple options and dockeys can be included as needed If dockey is a list of files it should consist of an at sign followed by the filename that contains a simple list of files for example filelist For more information about the options for the mkvd...

Page 143: ...tting started with the Verity mkvdk utility The following is the basic mkvdk syntax mkvdk collection path option filespec Where Square brackets indicate optional items An ellipsis indicates repetition of the previous item Thus filespec indicates an optional series of filespec items filespec represents a document filename or a list of document filenames If filespec is a list of files it should cons...

Page 144: ...ection The following command creates a collection in path_2 using the style files in path_1 and submits and indexes the document s in filespec mkvdk create style path_1 collection path_2 filespec Building the word list The following command builds the word list in the collection residing in the path directory mkvdk words collection path Option Description create Creates a collection in the specifi...

Page 145: ... data when using topics mode mode Sets the indexing mode Values are case insensitive The following are the valid settings Generic FastSearch NewsfeedIdx NewsfeedOpt BulkLoad ReadOnly Any custom mode defined in the style plc file The default is Generic mode common Specifies the path of the Verity common directory If you do not use this option the Verity engine looks for the common directory in the ...

Page 146: ... displays is 8859 This is NOT the name of the character set of documents being indexed it is only the name of the character set that your display can handle properly The character set of the document is set in the style dft file using the charmap option Valid options are 850 and 8859 The default is no mapping locale name Specifies the name of the Verity locale to be used by the mkvdk utility The l...

Page 147: ...cluding many textual date formats and the numeric date formats listed in the following table Service level keyword options The following table describes the valid keywords for the servlev keyword Format variable Description MDY Dates written as month day year US format the default DMY Dates written as day month year European format YMD Dates written as year month day ISO international format YDM D...

Page 148: ...table in The mkvdk utility syntax on page 142 logfile filename Saves messages in the specified file loglevel num Indicates which message types to route to the optional log file Valid values are determined by adding numbers together that correspond to the desired message types The default value is 15 For more information see the table in The mkvdk utility syntax on page 142 Option Description extra...

Page 149: ... in the worklist file nosubmit Specifies that a work list which is generated by the mkvdk utility automatically when you use the extract option will not be submitted to the indexing engine and will be saved in the collection directory in a file called worklist in the Verity bulk submit file format This option allows the mkvdk utility to process field extraction separately from other indexing tasks...

Page 150: ...tself It leaves the collection directory structure intact To specify a different wait period use the purgewait option instead of the purge option If you do not use the purgewait option the default is 600 seconds purgeback Used with the purge option performs a purge in the background purgewait sec Specifies to the purge option how many seconds to wait If you do not specify sec the default is 600 no...

Page 151: ...perating system commands such as the rm command on UNIX to remove the collection directory structure and control files Optimization keywords The following table describes the optimization keywords for the optimize option Keyword Description maxclean Performs the most comprehensive housekeeping possible and removes out of date collection files Macromedia recommends this optimization only when you a...

Page 152: ...s in collections A VDB consists of simple tables with rows and columns that relate to each other by row position VDB tables are not relational and their architecture supports quick and efficient searching over textual data A VDB consists of segments that are packed into a single file One of the advantages of having one packed VDB file is optimized search performance The fewer files that need to be...

Page 153: ...ou search collections associated with a Verity server The rck2 executable file which starts the rck2 utility is located in the platform bin directory For more information on the specific location of this directory see Location of Verity utilities on page 142 The rck2 syntax Use the following syntax to start rck2 from the command line rck2 server servername port portno For example c cfusionmx7 veri...

Page 154: ...e desc title asc m maxdocs The maximum number of documents to return in the results list c collections The list of collections to search Multiple collections must be specified in a space separated list For example c coll1 coll2 coll3 f fields The list of fields to retrieve For example f k2dockey title date s query text The query or question to be used to process the search The query can be express...

Page 155: ...and must include the pathname to a collection directory as an argument After you press Return the rcvdk utility reports whether the attach command was successful for example RC a z doc1 c public Collection file_walking collbldg html Attaching to collection z doc1 c public Collection file_walking collbldg html Successfully attached to 1 collection RC The rcvdk utility lets you attach to one or more...

Page 156: ...08_cbg4 htm 7 0 93 d search97 s97is locale english doc collbldg cbgix htm 8 0 92 d search97 s97is locale english doc collbldg 08_cbg6 htm 9 0 90 d search97 s97is locale english doc collbldg 08_cbg htm 10 0 90 d search97 s97is locale english doc collbldg 04_cbg1 htm 11 0 90 d search97 s97is locale english doc collbldg 01_cbg1 htm 12 0 87 d search97 s97is locale english doc collbldg f_cbg htm 13 0 8...

Page 157: ...the search again in order to see the results list with the fields you requested For example RC expert Expert mode enabled RC fields title 20 RC s universal filter Search update finished 100 Retrieved 18 18 85 RC r Retrieved 18 18 85 Number title 1 Using the Universal Filter 2 Using the Zone Filter 3 The Zone Filter 4 Overview 5 Table of Contents 6 Universal Filter Configuration Using the 7 Index 8...

Page 158: ... the Verity engine the zone list is a list of all zones and the zone attribute list is a list of the zone attributes found by the Verity engine The didump executable which starts the didump application is located in the platform bin directory For more information on the specific location of this directory see Location of Verity utilities on page 142 For example c cfusionmx7 verity k2 _nti40 bin di...

Page 159: ...list with the didump utility The zone list contains a list of the zones identified by the zone filter You can search the zones listed using the Verity IN operator in a query To view the contents of the zone list use the didump utility with the zones flag plus the pathname to a partition like the following didump zones z collbldg html parts 00000003 did This partition is for a collection containing...

Page 160: ...2 4 href 01_cbg htm 282870 3 1 1 href 01_cbg htm 282872 6 2 2 href 01_cbg1 htm 8 2 3 href 01_cbg1 htm 286513 7 2 2 href 01_cbg1 htm 286520 3 1 1 The columns in the display indicate the following Size The number of bytes used by the Verity engine to store information about the zone attribute Doc The number of unique documents in which the zone attribute appears Word The total number of occurrences ...

Page 161: ...ields Display all fields in specified record number Dispatch Compound field options n No dispatch d Dispatch s Dispatch as stream Action for help Displaying fields You can use several options to control the display of field information To display all the document fields 1 At the Action prompt enter 2 Press Return twice to display the fields for the first document record 3 Press Return to view the ...

Page 162: ...large collection you can also discard older collections to reclaim limited disk storage space The merge executable which starts the merge application is located in the _nti40 bin directory For more information on the specific location of this directory see Location of Verity utilities on page 142 For example c cfusionmx7 verity k2 _nti40 bin merge common c cfusionmx7 lib common To obtain help for ...

Page 163: ...n and splits it into the number of segments specified by the number option The name of the first new collection is generated by appending the first two letters in the alphabet aa to the directory name given for newCollection Each subsequent filename is generated by incrementing one of the appended letters up to zz for a maximum of 676 partitions For example if the value of number is 3 and the valu...

Page 164: ...164 Chapter 10 Using Verity Utilities ...

Page 165: ... and deploying 80 overview 79 CF Admin Password page ColdFusion MX Administrator 35 cfcompile utility overview 82 sourceless distribution 83 cfform tag multihoming 75 scriptsrc attribute 75 cfform js file 75 CFIDE scripts directory 75 cfstat utility 28 CFX Tags page ColdFusion MX Administrator 33 Charting page ColdFusion MX Administrator 23 client variables about 17 alternative to session variable...

Page 166: ...e mkvdk utility 150 creating with the mkvdk utility 144 deleting with the mkvdk utility 151 indexing with Verity Spider 111 maintaining with the mkvdk utility 150 merging with the merge utility 162 repairing with the mkvdk utility 150 searching with the rcvdk utility 155 setup options for the mkvdk utility 144 splitting with the merge utility 162 structure of 105 collections Verity defined 25 mana...

Page 167: ...perties stored in 71 I ignoresuffixmap property 72 IIS about configuration 67 application isolation configuration 95 multihoming 75 sample configuration file 73 Informix connecting to 49 Instance Manager page ColdFusion MX Administrator 38 IP Port security 90 iPlanet application isolation configuration 98 configuration overview 67 multihoming 77 ISAPI filter 67 iSeries data source 61 J J2EE applic...

Page 168: ...Microsoft SQL Server connecting to 53 migrating client variable data 18 mkvdk utility bulk insert and delete using 149 getting started 143 inserting documents into collections 144 log file 142 mkvdk executable 142 optimization keywords 151 optimized databases VDBs 152 processing documents with 146 service level keywords 147 squeezing deleted documents 152 syntax 142 mkvdk utility collections backi...

Page 169: ...ng 156 RDS Password page ColdFusion MX Administrator 36 RDS password security 86 recvtimeout property 72 replication session 100 root security context 89 S sandbox adding 88 configuring 89 security Administrator API access 36 security using 86 sandbox security about 86 adding a sandbox 88 restricted resources 87 Sandbox Security page ColdFusion MX Administrator 36 scriptpath property 72 security a...

Page 170: ...exing 140 multiple parameter values 138 syntax restrictions 138 unknown types indexing 139 web crawling and 139 wildcards using 138 Verity Spider options content 128 core 114 locale 135 logging 136 maintenance 137 networking 120 path and URL 123 processing 115 Verity utilities about 107 relationships with CFML 107 virtual hosts application isolation 96 multihoming 74 virtual mappings built in web ...

Reviews:

No comments

Brands by name

Popular brands

Load more brands