Chapter 4 Configuring Web Servers and Web sites

Configuring a CGI or WIN-CGI server

This section provides a detailed explanation for setting up a CGI or WIN-CGI server to run with PowerDynamo.

Steps 1 and 2 are part of the PowerDynamo installation procedure. These steps are not necessary if you configured the Web server during installation. You must still complete steps 3 through 5.

For more information, see "Configuring Web servers during installation".

Step 1: Edit the System Path in the System Properties window

In Step two of Configuring a CGI or WIN-CGI server, you will be copying DLLs to the directory of the CGI or WIN-CGI Web server. For the server to find these DLLs, you must edit your computer's system path to include the directory containing the DLLs. Figure 4-4 shows the System Properties window.

   The DLL directory must be added to the system path, not the user path.

Step 2: Install the Application Server

Each Web server has a method for defining directories where programs executable by the Web server are located. You must install the Application Server software into a directory defined as executable by the Web server.

Installing the required software

• If you haven't done so already, install PowerDynamo onto the Web server machine using the standard software installation. This provides you with tools such as the Personal Web Server and Sybase Central that are necessary in later stages of the configuration.
• Copy the required DLLs into the directory of the Web server machine.

Required files for CGI servers

The PowerDynamo Application Server for CGI Web servers includes the following files:

• dycsrv03.exe
• dycgi03.exe
• dyhtml03.dll
• dyscr03.dll
• dydbg03.dll (optional)
• dydom03.dll
• dys03ent.dll
• dyu03ent.dll
• dyxdfl03.dll
• dyxdb03.dll
• dycom03.dll (optional)
• dycls03.dll
• dyzip03.dll
• dyperf03.dll (optional)

The following Powersoft Power++ runtime libraries are installed into your Windows SYSTEM directory or your Windows NT system32 directory:

• mthr110.dll
• plbr110.dll
• clbr110.dll

Required files for WIN-CGI servers

The PowerDynamo Application Server for WIN-CGI Web servers includes the following files:

• dycsrv03.exe
• dycwin03.exe
• dyhtml03.dll
• dyscr03.dll
• dydbg03.dll (optional)
• dydom03.dll
• dys03ent.dll
• dyu03ent.dll
• dyxdfl03.dll
• dyxdb03.dll
• dycom03.dll (optional)
• dycls03.dll
• dyzip03.dll
• dyperf03.dll (optional)

The following Powersoft Power++ runtime libraries are installed into your Windows SYSTEM directory or your Windows NT system32 directory:

• mthr110.dll
• plbr110.dll
• clbr110.dll

Configuring a CGI or WIN-CGI server

For more information on setting up your CGI or WIN-CGI directory, consult your Web server documentation. It is important that the directory is set up for the correct type of server.

CGI Web servers allow you to describe a set of executable directories. Each directory has an alias, which is an URL prefix corresponding to that directory. The default alias for most CGI Web servers is /cgi-bin.

CGI Web servers support one of two types of CGI:

• CGI
• WIN-CGI

Determine which type of CGI your Web server uses.

CGI Helper
In order for a Web site to interface with PowerDynamo through CGI you must run the Dynamo CGI Helper along with the Web site server itself.

This is a sample URL call for a CGI server:

http://server/cgi-bin/dycgi03.exe/Site/Contents.stm

This is a sample URL call to a WIN-CGI server:

http://server/cgi-win/dycwin03.exe/Site/Contents.stm

Step 3: Create an ODBC System Data Source Name (DSN)

Creating a System DSN is the same as creating a DSN except a System DSN is available to all users on a machine as well as services.

   Note If you are connecting to a file-based Web site, or using an Open Client connection, this step is not necessary. If you are using Windows 95, create a data source; you do not need a system DSN.

To create an ODBC System Data Source Name:

1. Start the ODBC Administrator from the Utilities folder in Sybase Central.
   
   
2. Select the System DSN tab. Click Add.
   
   
3. From the Create New Data Source window, select the appropriate ODBC driver; for example, Adaptive Server Anywhere 6.0. Click Finish.
   
   
4. Enter the:
   
   
   • Data Source Name
   • User Id
   • Password
   • Database name
   • Database file
   
   
   Click OK.
   
   

Creating an ODBC data source to connect to an Adaptive Server Enterprise database
When you are creating an ODBC data source for an Adaptive Server Enterprise database the Select Method must be set to 0 - Cursor for Dynamo to work. The Select method setting is located within the ODBC Administrator -> ODBC Sybase Driver Setup -> Performance Tab

To ensure that the ODBC data source is available:

1. If you are using Adaptive Server Enterprise as the data server, ensure the appropriate client library software and ODBC driver have been installed.
   
   
2. If you are using Adaptive Server Anywhere as the data server, copy the Web site database file and transaction log file into an appropriate directory on the Web server machine and ensure that the database engine together with the Adaptive Server Anywhere ODBC driver and its attendant libraries are accessible on the machine.
   
   
3. If you are using the Adaptive Server Anywhere network server as the data server, install the Adaptive Server Anywhere client together with the Adaptive Server Anywhere ODBC driver and its attendant libraries on the Web server machine.
   
   

Step 4: Create a connection profile

You should create a connection profile for your Web site to store connection information in the registry in encrypted form. This information is used by Sybase Central, the Personal Web Server, and the Dynamo Application Servers.

Note
If you are connecting to a file-based Web site, or using an Open Client connection, see "Creating a connection profile for your Web site".

To create an ODBC connection profile for your Web site:

1. From Sybase Central, select Tools ->Connection Profiles.
   
   
2. Click New.
   
   
3. Enter a name for the connection profile, and select PowerDynamo from the list of available types. Click OK.
   
   
4. Select an ODBC data source from the drop-down list. If appropriate, enter a user ID and password, and any additional parameters and descriptions. Click OK to create the connection profile.
   
   

Step 5: Configure the Application Server

Once the site Web server receives an URL from a Web client, it passes it to the Dynamo Application Server, which locates and processes the document. You must add a mapping to the Application Server so it can locate the document. Use the Configuration folder found within the Utilities folder of Sybase Central to add a mapping to the Application Server.

Dynamo configuration

To add a new mapping using the Dynamo Configuration folder:

1. In the left pane of Sybase Central, open the Utilities folder.
   
   
2. In the right pane of Sybase Central, open the Configuration folder.
   
   
3. Double-click the Mappings folder.
   
   
4. Double-click Add Mapping.
   
   
5. Enter a URL prefix, the Dynamo site type, the resource to access on your machine and the maximum size of the document cache.
   
   
6. Restart the server for these changes to take effect.
   
   

For a more detailed description of how to configure the Dynamo sites using Sybase Central and the Configuration folder, see "Configuring Web sites".

Copyright © 1999 Sybase, Inc. All rights reserved.