8
Setting Up the WebDB CGI Executable and WebDB Cartridge to OAS

This chapter discusses how to install and configure the WebDB CGI Executable or the WebDB Cartridge.

You can use either of these plug-ins to replace the PL/SQL Gateway functionality that is provided as part of the WebDB Listener.

This chapter contains the following sections:

• Chapter 8.1, "Setting up the WebDB CGI Executable"

• Chapter 8.2, "Configuring the WebDB Cartridge with OAS"

8.1 Setting up the WebDB CGI Executable

If you plan to use a standard Web server (such as one provided by Netscape or an Apache Web server) instead of the WebDB Listener, you can set up the WebDB CGI executable provided by WebDB for use with these Web servers. The WebDB CGI executable replaces the PL/SQL Gateway which is provided with the WebDB Listener.

Note: The WebDB CGI executable is not installed as part of Oracle WebDB. Thus, if you wish to use it, you must install the WebDB CGI executable manually.

8.1.1 Manually Installing and Configuring the WebDB CGI

Before installing or configuring the WebDB CGI, verify that the following conditions exist:

• Oracle WebDB 2.2 is installed including the PL/SQL packages and PL/SQL Toolkit. The software can be installed remotely on another machine.

• The Oracle Required Support Files (Release 8.0.5.1) are installed in a separate Oracle Home located locally on the machine where you intend to install the WebDB CGI.

  If the WebDB Listener is already installed, you don't need to install the Oracle Required Support Files separately as they are part of the Listener installation. Thus, continue configuration from Step 6.

  Note: You can install WebDB components separately with the Oracle WebDB custom install program. For more information, refer to the appropriate section depending on your environment: "WebDB on Windows NT Custom Install" or "Installing WebDB Listener on Solaris".

To configure the WebDB CGI executable for use with a supported Web server:

1. If these directories don't already exist, create the following directories on your machine to install the WebDB cartridge files:
   • <ORACLE_HOME>\webdb

   • <ORACLE_HOME>\webdb\listener

   • <ORACLE_HOME>\webdb\listener\cfg

   • <ORACLE_HOME>\webdb\images

2. On Windows NT, copy the following files from your WebDB CD into the appropriate Web server's location on your machine:

   Files	From CD	To Your Machine
   wdbcgiw.cmd wdbcgi.exe	\www22	<ORACLE_HOME>\bin
   *.gif and *.jpg	\www22\images	<ORACLE_HOME>\webdb\images
   *.htm, wdsvr.app	\www22	<ORACLE_HOME>\webdb\listener\cfg
   Required Support Files (8.0.5.1)	Custom installation	<ORACLE_HOME>

   On Solaris, copy the following files from your WebDB CD into the appropriate <ORACLE_HOME> location on your machine:

   Files	From CD	To Your Machine
   wdbcgiw wdbcgi	/www22	<ORACLE_HOME>/bin
   *.gif and *.jpg	/www22/images	<ORACLE_HOME>/webdb/images
   *.htm, wdsvr.app	/www22	<ORACLE_HOME>/webdb/listener/cfg
   Required Support Files (8.0.5.1)	Custom installation	<ORACLE_HOME>

3. In the \www22 directory on the Oracle WebDB CD, copy all the *.htm files and the configuration file, wdbsvr.app, to the
   <ORACLE_HOME>\webdb\listener\cfg directory.

4. In the \www22\images directory on the Oracle WebDB CD, copy all the *.gif and *.jpg files to the <ORACLE_HOME>\webdb\images directory on your machine.

5. Open wdbcgiw in a text editor and customize the environment variables by changing the path to point to the actual location of the Oracle WebDB CGI program.

6. Configure your Web server to update the mapping of the /images/ virtual directory to the correct physical directory on the server.

   Note: Make sure that the mapping of this directory matches the location you chose for storing the WebDB images (see Step 1).

7. Restart your Web server.

8. On Windows NT, type the following URL into your Web browser's location or address field:

   http://hostname:port/cgi-bin/wdbcgiw.cmd/admin_/gateway.htm   
   
   

   On Solaris, type the following URL into your Web browser's location or address field:

   http://hostname:port/cgi-bin/wdbcgiw/admin_/gateway.htm 
   
   

   where:

   • hostname is the name of the server on which you installed WebDB.

   • port is the Listener port you specified during WebDB installation.

9. Update the Document Table field with the name of the document table. Use the format, schema.tablename, to indicate the schema in which the document table has been created.

   On Solaris, you may need to set the environment variable, LD_LIBRARY_PATH, to point to the wdbcgiw file. See "Configuring Variables and General Configuration" for more information.

10. Run WebDB by typing the following URL into your Web browser's location or address field:

    On Windows NT:

    http://servername:port/cgi-bin/wdbcgiw.cmd/{DAD}/
    
    

    On Solaris:

    http://servername:port/cgi-bin/wdbcgiw/{DAD}
    
    

11. Test file uploading and downloading by typing the following URL into your Web browser's location or address field:

    On Windows NT:

    http://servername:port/cgi-bin/wdbcgiw.cmd/{DAD}/{schema}.wwv_testdoc.
    
    show_form
    
    

    On Solaris:

    http://servername:port/cgi-bin/wdbcgiw/{DAD}/{schema}.
    
    wwv_testdoc.show_form
    
    

    where

    • schema is the schema where WebDB is installed in the database.

    • DAD is the Data Access Descriptor name.

8.2 Configuring the WebDB Cartridge with OAS

If you plan to use the Oracle Application Server (OAS) 4.0.8 as your Web server, you need to add the WebDB cartridge provided by WebDB to OAS. The WebDB cartridge replaces the PL/SQL Gateway provided as part of the WebDB Listener.

For additional instructions about adding the WebDB cartridge to OAS, see the "Oracle Application Server Administration Guide".

Note: The WebDB cartridge is not installed as part of Oracle WebDB. Thus, if you wish to use it, you must install the WebDB cartridge manually.

8.2.1 Prerequisites

Before installing or configuring the WebDB cartridge, verify that the following conditions exist:

• Oracle WebDB 2.2 is installed including the PL/SQL packages and PL/SQL Toolkit. The software can be installed remotely on another machine.

  Note: You can install these components separately with the Oracle WebDB custom install program. For more information, refer to the appropriate sections depending on your environment: "WebDB on Windows NT Custom Install" or "Installing WebDB Listener on Solaris".

8.2.2 Manually Installing the WebDB Cartridge

The Oracle WebDB cartridge must be installed in the same Oracle Home as for the Oracle Application Server; for example, <OAS_HOME>.

To manually install the WebDB cartridge:

1. Create the following directories on your machine to install the WebDB cartridge files:
   • <OAS_HOME>\webdb

   • <OAS_HOME>\webdb\listener

   • <OAS_HOME>\webdb\listener\cfg

   • <OAS_HOME>\webdb\images

2. Copy the appropriate file from the \www22 directory on the Oracle WebDB CD into the directory containing your Oracle Application Server installation:

   Environment	File	To Your Machine
   Windows NT	wdbctx.dll	<ORACLE_HOME>\bin
   Solaris	wdbctx.so	<ORACLE_HOME>/bin

3. In the \www22 directory on the Oracle WebDB CD, copy all the *.htm files and the configuration file, wdbsvr.app, to the
   <OAS_HOME>\webdb\listener\cfg directory.

4. In the \www22\images directory on the Oracle WebDB CD, copy all the *.gif and *.jpg files to the <OAS_HOME>\webdb\images directory on your machine.

5. Set up the environment variable, WV_GATEWAY_CFG, to point to the gateway configuration file, wdbsvr.app. For example,

   Windows NT

   set WV_GATEWAY_CFG=<OAS_HOME>\webdb\listener\cfg\wdbsvr.app
   
   

   Solaris

   setenv WV_GATEWAY_CFG <OAS_HOME>/webdb/listener/cfg/wdbsvr.app
   

8.2.3 Adding the WebDB Cartridge to OAS

To add the WebDB cartridge to OAS:

1. In your Web browser, display the top-level administration page for Oracle Application Server. At the top of the navigational tree, you should see Website40 Site (or whatever you named the site when you installed the OAS server).

2. Click the plus sign (+) to display the components on the site. You should see Oracle Application Server, HTTP Listeners, and Applications.

3. Click Applications to display the applications in the right frame of the browser window.

   Note: Do not click the plus sign (+) next to Applications. Doing so displays the applications for the site in the navigational tree instead of displaying applications in the right frame.

4. Click the + button in the right frame to display the Add Application dialog box.

5. In the Add Application dialog box, specify the following:

   Field	Specify
   Application Type	CWeb
   Configure Mode	Manually

6. Click Apply. The Add Application dialog box displays again.

7. In the dialog box, specify the following:

   Field	Specify
   Application Name	WebDB
   Display Name	WebDB
   Application Version	2.2

8. Click Apply. A Success dialog box displays.

9. In the Success dialog box, click Add Cartridge To This Application. The Add C-Web Cartridge dialog box displays.

10. In the Add C-Web Cartridge dialog box, specify the following:

    Field	Specify
    Cartridge Name	wdbctx
    Display Name	WebDB Cartridge
    Cartridge Shared Object	the full path to the wdbctx.so file on Solaris (wdbctx.dll file on Windows NT); for example: /private/wdbsvr/lib/wdbctx.so.
    Entry Point (Shared Object)	wwwre_Entry
    Virtual Path	/wdbctx
    Physical Path	This field shows <ORACLE_HOME>/bin as the physical path. Leave this field as it is.

11. Click Apply.

12. Navigate to the Web Parameters page located in the WebDB Configuration folder under the Applications node.

13. On the Web Parameters page, make sure that the Application MIME Types field is blank by removing any listed file extensions such as jpeg or gif.

14. Click Apply.

15. Configure your server's Listener to update the mapping of the /images/virtual directory to the correct physical directory on your server.

    Note: Make sure that the mapping of this directory matches the location you chose for storing the WebDB images.

16. Click Apply.

17. Click Website40 Site at the top of the OAS navigational tree.

18. Select the ALL radio button in the right frame of the browser window.

19. Click |<< to reload the server for the new configuration to take effect.

20. Type the following URL into your Web browser's location or address field:

    http:/servername:port/admin_/gateway.htm  
    
    

21. On the PL/SQL Gateway Settings page, adjust the settings in fields contained in the Database Access Descriptor (DAD) section. You can click the small help icon on the upper right corner of the page to view information about fields.

    Note: Remember to update the Document Table field with the name of the document table. Use the format, schema.tablename, to indicate the schema in which the document table has been created.

22. Click Apply.

23. Run WebDB by typing the following URL into your Web browser's location or address field:

    http://hostname:port/wdbctx
    
    

24. Test file uploading and downloading by typing the following URL into your Web browser's location or address field:

    http://hostname:port/wdbctx/DAD/{schema}.wwv_testdoc.show_form
    

    where

    • hostname is the name of the server on which you installed WebDB.

    • port is the port you specified during installation of WebDB.

    • DAD is the Database Access Descriptor name you defined in Step 18.

    • schema is the schema where WebDB is installed in the database.