DLXS Authentication and Authorization System

1. Change to the directory where SQL scripts are supplied with the command (e.g.) cd /usr/local/dlps_auth/sql .
2. Carefully edit the file create_tablespace.sql , substituting the correct local customizations for Oracle data file locations as needed.
3. Carefully edit the file create_tables.sql , substituting the correct system administrator email address for sysadmin@your.domain on line 133.
   
4. Start the SQL monitor with the command sqlplus system (you will be prompted for the Oracle system password).
5. Create the schema and tablespace with the command @create_tablespace .
6. Set a new password for the dlps_auth user, exit from the SQL monitor, and restart the SQL monitor with the command sqlplus dlps_auth (you will be prompted for the new dlps_auth password).
7. Create all required tables with the command @create_tables .
8. Create the unique identifier and timestamp triggers with the command @create_triggers.
9. Define the primary keys with the command @key .
10. Create the auxiliary indexes with the command @index .
11. Define the stored procedures with the command @dlps_auth .

1. Starting on line 345, the function change_passwd contains user interface logic that lets a user select one of two Kerberos realms, and is specific to the UM environment. This section will probably need modification based on your local authentication environment.
2. Starting on line 686, the confirmation email message that is sent when a user successfully changes his/her password will need modification as is appropriate to your environment.
3. On line 1437, the domain name associated with the cookie that is used for persistent authentication should be changed to your local domain.

1. Carefully edit the file Makefile, substituting the installation paths of Kerberos, OpenSSL, and Oracle as appropriate.
2. Compile the module with the command make .
3. Install the module into your Apache installation with the command make install.

1. Carefully edit the configuration file (e.g.) /usr/local/dlps_auth/etc/dlps_auth.conf , substituting the appropriate local values, as indicated below:
1. Set DLPSAuthOracleHome to your Oracle installation home directory.
2. Set DLPSAuthOracleTNSName to the global TNS name of your Oracle server.
3. Set DLPSAuthOraclePassword to the password you assigned for the dlps_auth user in Step 2.6.
4. Set DLPSAuthEncryptionKey to 16 random characters.
5. Set DLPSAuthEnterPasswordServer to the server name you'll use to host the login page.
6. Set DLPSAuthCookieLifetime to the number of seconds you'd like authentication to persist, or 0 if you'd like authentication to expire when the user's browser is closed.
7. Set DLPSAuthChangePasswordServer to the server name you'll use to host the login page.
8. Set DLPSAuthPasswordResultsServer to the server name you'll use to host the login page.
9. Set DLPSAuthDefDestOnAuthenSuccess to a URL that the system should redirect users to after successful authentication if, for some reason, it is unable to determine the referring page.
10. Set DLPSAuthDelayOnAuthenSuccess to the number of seconds to display the page that informs the user that he/she authenticated successfully (before redirecting him/her back to the referring page).
11. Set DLPSAuthDocumentRoot to the directory containing the HTML templates, e.g. /usr/local/dlps_auth/html/templates .
    
12. Set DLPSAuthHelpContact to the email address that should receive replies to password change confirmation emails from users.
13. Set DLPSAuthSysAdminContact to the email address that should receive bounced delivery attempts to password confirmation emails
2. Reference this configuration file in your Apache configuration file with the directive (e.g.) Include /usr/local/dlps_auth/etc/dlps_auth.conf .
   
3. Restart Apache with the command apachectl restart , and check the error log to ensure that the server restarted successfully. If it didn't, you can easily remove the system from your configuration by placing a # character in front of the Include directive above and restarting Apache.

controls!

Adding access controls

In the database, an access control is made up of three parts: 1) a collection record, which is essentially one or more server names and directory paths; 2) a user or institution record; and 3) an access record indicating the user or institution and the collection. In this way, collections, users, and institutions can be defined, and access permissions can be given in any combination.

The following sequence of example SQL commands will demonstrate the routine tasks associated with maintaining access controls in the database.

Example: Creating a collection record

insert into aa_coll (uniqueIdentifier,

commonName,

description,

dlpsClass, dlpsSource,
         
dlpsAuthenMethod, dlpsAuthzType,
         
dlpsPartlyPublic,

manager,
         
lastModifiedTime, lastModifiedBy,
         
dlpsDeleted)
         
values ('jbt',

'Journal of Bobbles and Trinkets',
         
'An online resource focusing on the
         
study of buttons, plastic toys,
         
do-nothing machines, and the like',
         
'local', 'local',
         
'any', 'n',
         
'f',

0,
         
SYSDATE, 'root', 'f');

Example: Associating a server and directory with a collection

<br>

         </BR>
         insert into aa_coll_obj (dlpsServer,<br>
         </BR>
         dlpsPath,<br>
         </BR>
         coll,<br>
         </BR>

         lastModifiedTime, lastModifiedBy,<br>
         </BR>
         dlpsDeleted)<br>
         </BR>
         values ('www.your.domain',<br>
         </BR>
         '/usr/local/apache/htdocs/jbt%',<br>

         </BR>
         'jbt',<br>
         </BR>
         SYSDATE, 'root', 'f');<br>
         </BR>
         <br>
         </BR>
         

        </BR>

dlpsServer

                 </BR>

dlpsPath

                 is stored; note the "%" wildcard at the end of the path, which
                 allows the access control to be applied to all contained files
                 and directories

                 </BR>

coll

                 </BR>

lastModifiedTime

                 </BR>

lastModifiedBy

                 record

                 </BR>

dlpsDeleted<br>
                  </BR>
                  

                 either 't' (true) or 'f' (false)

                 </BR>

At this point, any attempt to access this resource, which is non-public and yet has no access permissions, should result in a prompt for authentication.

Example: Creating an institution record

<br>
         </BR>
         insert into aa_inst (uniqueIdentifier,<br>
         </BR>
         organizationName, manager,<br>
         </BR>
         lastModifiedTime, lastModifiedBy,<br>

         </BR>
         dlpsDeleted)<br>
         </BR>
         values (1000,<br>
         </BR>
         'University of Michigan', 0,<br>
         </BR>

         SYSDATE, 'root', 'f');

        </BR>

                 </BR>

                 </BR>

                 </BR>

                 </BR>

                 collection entry

                 </BR>

                 </BR>

                 </BR>

                 </BR>

                 record

                 </BR>

                 </BR>

                 either 't' (true) or 'f' (false)

                 </BR>

Example: Associating an IP address range with an institution

<br>
         </BR>
         insert into aa_network (dlpsCIDRAddress,<br>
         </BR>

         dlpsAddressStart, dlpsAddressEnd,<br>
         </BR>
         dlpsAccessSwitch, inst,<br>
         </BR>
         lastModifiedTime, lastModifiedBy,<br>
         </BR>
         dlpsDeleted)<br>

         </BR>
         values ('141.211.0.0/15',<br>
         </BR>
         2379415552,2379546623,<br>
         </BR>
         'allow', 1000,<br>
         </BR>

         SYSDATE, 'root', 'f');

        </BR>

dlpsCIDRAddress

                 </BR>

dlpsAddressStart

                 </BR>

dlpsAddressEnd

                 </BR>

dlpsAccessSwitch

                 is to be allowed or denied: either 'allow' or 'deny'

                 </BR>

inst

                 </BR>

lastModifiedTime

                 </BR>

lastModifiedBy

                 record

                 </BR>

dlpsDeleted

                 either 't' (true) or 'f' (false)

                 </BR>

The system allows multiple IP address ranges to be associated with each institution.

Example: Permitting an institution to a collection

<br>
         </BR>
         insert into aa_may_access (inst, coll,<br>

         </BR>
         lastModifiedTime, lastModifiedBy,<br>
         </BR>
         dlpsDeleted)<br>
         </BR>
         values (1000, 'jbt',<br>
         </BR>

         SYSDATE, 'root', 'f');<br>
         </BR>
         

        </BR>

inst

                 </BR>

coll

                 </BR>

lastModifiedTime

                 </BR>

lastModifiedBy

                 record

                 </BR>

dlpsDeleted

                 either 't' (true) or 'f' (false)

                 </BR>

At this point, the resource will be accessible from the UM campus, but any attempt to access it from elsewhere should result in a prompt for authentication. However, as no users currently exist, it will not be possible to authenticate.

Example: Creating a user

<br>
         </BR>
         insert inst aa_user (userid,<br>
         </BR>
         givenName, initials, surname,<br>

         </BR>
         rfc822Mailbox,<br>
         </BR>
         dlpsKey, userPassword,<br>
         </BR>
         lastModifiedTime, lastModifiedBy,<br>
         </BR>

         dlpsDeleted)<br>
         </BR>
         values ('cufarley',<br>
         </BR>
         'Charles', 'U.', 'Farley',<br>
         </BR>
         'cufarley@your.domain',<br>

         </BR>
         '123-45-6789', '!none',<br>
         </BR>
         SYSDATE, 'root', 'f');<br>
         </BR>
         

        </BR>

userid

                 </BR>

givenName

                 </BR>

initials

                 </BR>

surname

                 </BR>

rfc822Mailbox

                 </BR>

dlpsKey

                 establish or change their password using the self-serve user
                 interface; this should be known only to the user

                 </BR>

userPassword

                 realm; this should be initially set to '!none', and will be
                 set by the user

                 </BR>

lastModifiedTime

                 </BR>

lastModifiedBy

                 record

                 </BR>

dlpsDeleted

                 either 't' (true) or 'f' (false)

                 </BR>

Example: Associating a user with an institution

<br>

         </BR>
         insert into aa_is_member_of_inst (userid, inst,<br>
         </BR>
         lastModifiedTime, lastModifiedBy,<br>
         </BR>
         dlpsDeleted)<br>
         </BR>

         values ('cufarley', 1000,<br>
         </BR>
         SYSDATE, 'root', 'f');<br>
         </BR>
         

userid

                 </BR>

inst

                 </BR>

lastModifiedTime

                 </BR>

lastModifiedBy

                 record

                 </BR>

dlpsDeleted

                 either 't' (true) or 'f' (false)

                 </BR>

At this point, after being prompted for authentication, the user may authenticate and will be given access to the resource.

Example: Permitting a user to a collection

Access to collections may be given to individual users directly instead of via association with an institution. The following commands would modify the database to remove the association of the user with the institution, and explicitly permit the user to the collection. (Compare with Permitting an institution to a collection, above.)

<br>
         </BR>
         delete from aa_is_member_of_inst<br>

         </BR>
         where userid = 'cufarley' and inst = 1000;<br>
         </BR>
         <br>
         </BR>
         insert into aa_may_access (userid, coll,<br>
         </BR>
         lastModifiedTime, lastModifiedBy,<br>

         </BR>
         dlpsDeleted)<br>
         </BR>
         values ('cufarley', 'jbt',<br>
         </BR>
         SYSDATE, 'root', 'f');

Example: Creating a DLXS text class collection record

Collections served by DLXS class middleware use a special mode of the system called "delegated authorization", which will be explained in more detail in the next example. First, though, to trigger this mode, DLXS class collections must specify both their class (e.g. text or image) and the appropriate authorization type flag, as shown below:

<br>
         </BR>
         insert into aa_coll (uniqueIdentifier,<br>

         </BR>
         commonName,<br>
         </BR>
         description,<br>
         </BR>
         dlpsClass, dlpsSource,<br>
         </BR>

         dlpsAuthenMethod, dlpsAuthzType,<br>
         </BR>
         dlpsPartlyPublic,<br>
         </BR>
         manager,<br>
         </BR>
         lastModifiedTime, lastModifiedBy,<br>

         </BR>
         dlpsDeleted)<br>
         </BR>
         values ('jbt-text',<br>
         </BR>
         'Journal of Bobbles and Trinkets',<br>
         </BR>

         'An online resource focusing on the<br>
         </BR>
         study of buttons, plastic toys,<br>
         </BR>
         do-nothing machines, and the like',<br>
         </BR>
         'text', 'local',<br>

         </BR>
         'any', 'd',<br>
         </BR>
         'f',<br>
         </BR>
         0,<br>
         </BR>

         SYSDATE, 'root', 'f');

           a collection record. above:

        </BR>

                 </BR>

                 classes)

                 </BR>

                 </BR>

                 or 'd' (delegated)

                 </BR>

        

        </BR>

Example: Permitting an institution to a DLXS text class collection

When a permission is given to a collection that is set for delegated authorization, as above, the system behaves in a completely different way. Instead of acting as a gatekeeper, the system instead collects all pertinent authorization information and passes that information via environment variables to the DLXS middleware. The DLXS middleware will then use that information to decide which collections to present to the user.

This mode is necessary because DLXS middleware supports searching across multiple collections. Because any given user may have different access permissions based on institutional associations or explicit permissions, it is impossible to simply grant or deny access on a global basis. Instead, the DLXS middleware must be supplied with a customized list of authorized collections on a per-transaction basis in order to present the user with all of the material they are permitted to access, and none of the material for which they are not. The authorization type is referred to as "delegated" because the system is "delegating" the authorization decision to the DLXS middleware.

For a description of the information that is passed from the system to the DLXS middleware and how it is used, see <a href="../auth/index.html">DLXS Authentication and Authorization</a>.

As you can see below, the command required to add the permission is the same regardless of the authorization type:

<br>
         </BR>
         insert into aa_may_access (inst, coll,<br>

         </BR>
         lastModifiedTime, lastModifiedBy,<br>
         </BR>
         dlpsDeleted)<br>
         </BR>
         values (1000, 'jbt-text',<br>
         </BR>

         SYSDATE, 'root', 'f');

        </BR>

        </BR>

inst

                 </BR>

coll

                 </BR>

lastModifiedTime

                 </BR>

lastModifiedBy

                 record

                 </BR>

dlpsDeleted

        

        </BR>

Appendix: Features of the UM Digital Library Services Installation

Our local installation of this system includes the following:

• Oracle configuration. Two Oracle 9i servers are installed in two different, and distant, parts of campus. These servers use replication features of Oracle to stay in near-real-time synchronization; if a change is made on one server, that change will be replicated to the other server in less than one minute. All Oracle client software has been configured with connect-time and session failover capabilities so that the Oracle server which is physically closest is preferred under normal circumstances, but the other will be chosen in the event of a failure. One server is Sun hardware running Solaris, and the other is Intel hardware running Linux.
• Apache web server configuration. Apache, equipped with mod_ssl and the DLXS authentication and authorization system, is running alongside Oracle on each server. Each Apache installation is configured with a copy of a server certificate for the name "login.umdl.umich.edu" and has identical appearance in all respects.
• Load balancing and failover. A DNS-based system has been put in place to dynamically direct users' browsers to the Apache server that is physically closest under normal circumstances, to the least loaded server under heavy usage conditions, or to the only available server in the event of a failure. A user accessing the server "login.umdl.umich.edu" may transparently hit either server.
  
• Locally-hosted text and image resources. Servers that are dedicated to serving text and image content are equipped with the DLXS authentication and authorization system if they host any non-public content. The database is maintained with records which restrict access to these materials as needed. At the time of this writing, there are approximately 500 active institutions records in the database for institutions with subscriptions to resources hosted by DLS.
• Library web server. The library's main web server also has the system installed, and restricted access to materials such as course reserves and staff-only areas of the website is provided through the system via IP address range or password authentication, as appropriate.
• Library catalog. The Web-accessible interface to the library's catalog has been enhanced to honor the authentication cookie used by the system, and uses that to enable saved record sets, patron self-service functions, and other functions requiring authentication.
• Library proxy server. The library's proxy server, EZProxy, was enhanced with a small custom script to honor the authentication cookie used by the system to initialize a proxy session. UM affiliates who have authenticated for other reasons are automatically granted a proxy session.