How to Install the Caterpillar University Relations Package
Note: This documentation is intended to aid in the installation of the Caterpillar University Relations Package to be served by the Netscape Enterprise Server and use iHTML 2.1 Lite.
Step 1: Unzip the cur.zip archive.
Do this by double clicking on the cur.zip file and then choosing where you want to extract the archive. The archive contains the directory
cat_university_relations. Assuming you have a directory called
C:\projects\www, you would choose to extract the archive to this directory. If you would like to extract the archive to somewhere else, that is fine, just substitute that location for
C:\projects\www anywhere in this documentation.
Step 2: Install iHTML Lite 2.1.
Step 3: Set up the ODBC data source to be used with the database you are going to query.
- To start the ODBC Data Source Administrator, click on the start menu, click run, and then type
odbcad32. This launches the ODBC Data Source Administrator.
- Click on the System DSN tab.
- Click the Add... button. This will pop up a Create New Data Source window. Choose the Microsoft Access Driver (*.mdb) in this window and click the Finish button. This will close the Create New Data Source window and pop up a new ODBC Microsoft Access 97 Setup window.
- For the demo database installation, type
curDSN in the Data Source Name field of the ODBC Microsoft Access 97 Setup window. From now on, "this installation" will mean for the demo database install. Note, you can choose any name for this data source, but you must change all of the references to
curDSN in any of the
*.html files that access the database in the Caterpillar University Relations Package to use this new data source instead of
curDSN You should really never need to do this. What you will most likely want to do is use a different database than the demo database. This is easily done by simply changing the configuration of the
curDSN data source to point to the database you want to use instead of the demo database.
- In the Database area, click on the Select... button. This will pop up a Select Database window. Choose the database that you want this DSN to point to. This is the database you will be querying from the Caterpillar University Relations pages. For this installation, choose
C:\projects\www\cat_university_relations\databases\db1.mdb. Once you have selected the database, click the OK button to close the Select Database window. You should now see the name and full path of the database you just selected to the right of the word Database: in the ODBC Microsoft Access 97 Setup window.
- Now, click on the Advanced... button in the ODBC Microsoft Access 97 window. This will pop up a new Set Advanced Options window.
- In the Default Authorization area of this new window, there are two entry fields, Login name: and Password:. Enter the login name and password that you want the database to be accessed as. For this installation, enter
ahlerkd for the login name and leave the password field blank. You may want to set up a special user that will be used only by this data source for its access to the database. But either way, you must specify a valid login name and password in these fields if your database is secure. If the database is not secure, then the login name and password are not needed. Click on the OK button once you have entered the login name and password. This will close the Set Advanced Options window.
- Lastly, click the Database: toggle button in the System Database area of the ODBC Microsoft Access 97 Setup window. Once you do this, the System Database... button will become active.
- Now click on the System Database... button that just became active in the ODBC Microsoft Access 97 Setup window. This will pop up a Select System Database window. This window allows you to choose the workgroup file this DSN will use to open the database. The default file is usually located at
C:\WINNT\system32\system.mdw. But if you are using a different workgroup file for security on your database, then you need to specify that different workgroup file instead. For example, this could be some file with the extension
mda or some other file with the extension
mdw. For this installation, choose
C:\projects\www\cat_university_relations\databases\univ.mda. (Note: To find out which workgroup file you are using, click the start button, click run, and type
- Once you have selected the proper file from the Select System Database window, click the OK button. This will close the Select System Database window.
- Now, click the OK button in the ODBC Microsoft Access 97 Setup window to close the window.
- Now click the OK button in the ODBC Data Source Administrator window to close the window. Your ODBC data source should now be set up correctly.
Step 4: Set up the permissions on the
cat_university_relations directory and subdirectories and files.
- Right click on the
cat_university_relations directory. Choose Properties from the popup menu. This will pop up a Properties window.
- Click the Security tab in this new window. Click the Permissions button. This will open a Directory Permissions window.
- If the SYSTEM group is a listed name and it is listed as having permissions (RX)(RX) or any super set of those, then you can skip to
- In the Directory Permissions window, check the Replace Permissions on Subdirectories box and the Replace Permissions on Existing Files box.
- If the SYSTEM group is already in the Name list, then skip the next 2 bullet. Click the Add... button in the Directory Permissions window. This will pop up an Add Users and Groups window. Click the Show Users button in this window.
- Now, find the SYSTEM user and click it. The user SYSTEM should appear in the Add Names: text box.
- Click the OK button in the Add Users and Groups window to close the window.
- In the Directory Permissions window, change the type of access for the SYSTEM user.
- Click on the SYSTEM user. From the Type of Access: pull down menu, choose Read.
- Click the OK button in the Directory Permissions window. This will pop up a dialog box asking if you want to replace the security information on all existing subdirectories, choose Yes.
- Now click the OK button in the Properties window. This will close the window.
Step 5: Add a virtual directory to the Netscape Enterprise Server.
- Start the Netscape Enterprise Server Administrator (This is what runs inside a web browser).
- Under the title, Netscape Enterprise Server 3.0, you should see one or more servers listed. Click on the name of the server you wish to add this virtual directory to.
- Once you have done this, you are taken to the configuration screen for that server.
- Click the Content Management button in the top menubar.
- Now, in the left hand column, click on the Additional Document Directories link.
- This will display a form for adding new directories as well as list all current additional directories.
- In the URL Prefix field, type
cur. What this means is that if you get to the home directory of the web server you selected earlier by the URL:
http://www.catinfo.com/, then to get to the Caterpillar University Relations pages, you would simply enter the URL:
- In the Map to Directory field, type
- Click the OK button.
- You are now asked to Save or Undo these changes. Click the Save and Apply button.
- You can now close this Netscape Enterprise Server Administrator.
Step 6: You should now be set up and ready to go.
- To test your installation, open the URL:
http://[server name]/cur where [server name] is how you access your server from the web. This should bring up the Caterpillar Unversity Relations title page. From here, click on the Strategic Partners button at the bottom of the page. This will take you to the Strategic Partners page. Click on the University Of Illinois at Urbana-Champaign link. Next, click on the Cat Reps Providing University Support link. This is a database query, so if you get a page with a table containing Board/Consortium and Representative entries, then your database query worked.
- If You could not access the Catperillar University Relations title page, try the URL:
http://[server name]/cur/index.html. If this worked, then you may need to change the permissions on the
C:\projects and the
C:\projects\www directories to include (RX)(RX) permissions, or a super set of these, for group SYSTEM.
- If the query to your database does not work, make sure that you do not have the database open with MS Access or you will get an error. If you have other errors while trying to access the database, or other errors in general, then you should contact a help person to help you further.