PersonDirs.xml


<?xml version="1.0"?>

<!--
     PersonDirs.xml makes possible a standard way for the uPortal
     framework and its installed channels to refer to particular person
     attributes.  For example, if a channel wants to display a user's
     email address, it will look for an attribute called "mail", which
     appears as an alias in this file.  This alias maps to the actual
     name of the field containing an email address in your data repository.
     If no data repository at your organization contains a user's email
     address then simply don't fill in a <name> correcponding to the "mail"
     alias.  The requesting channel will simply get a null when requesting
     the attribute value of "mail" indicating that this attribute is not
     available.  Providing this level of indirection for attribute references
     makes it possible for organizations to share channels that refer to
     user's attributes.

     The <PersonDirs> element should contain one or more <PersonDirInfo>
     elements.  Each <PersonDirInfo> element represents a source for
     obtaining person attributes and should contain a set of attribute
     alias/name pairs in addition to settings for obtaining the data
     from either

       1) LDAP
       2) JDBC
       3) Container-managed JDBC DataSource

     This means that it is possible to obtain person attributes from more
     than one source.

     If a particular attribute alias is specified more than
     once, the name value obtained from the last occurance of that attribute
     will be used.

     Author: Howard Gilbert, howard.gilbert@yale.edu
     Version $Revision: 1.2 $
-->

<PersonDirs>

  <PersonDirInfo>

    <!-- Within this <PersonDirInfo> element, set either the LDAP properties,
         the JDBC properties, or a container-defined JDBC resource.
         If you want to obtain person attributes from
         more relational databases AND/OR LDAP directories, add additional
         <PersonDirInfo> elements under <PersonDirs>.
    -->

    <!-- LDAP Properties -->
    <!--
    <url>ldap://yu.yale.edu:389/dc=itstp, dc=yale, dc=edu</url>
    <logonid>cn=bogus,cn=Users,dc=itstp,dc=yale,dc=edu</logonid>
    <logonpassword>foobar</logonpassword>
    <uidquery>(cn={0})</uidquery>
    <usercontext>cn=Users</usercontext>
    -->

    <!-- JDBC Properties for hsql-->
    <!--
    <driver>org.hsqldb.jdbcDriver</driver>
    <url>jdbc:hsqldb:hsql://localhost:8887</url>
    <logonid>sa</logonid>
    <logonpassword></logonpassword>
    <uidquery>SELECT FIRST_NAME||' '||LAST_NAME AS FIRST_LAST, FIRST_NAME, LAST_NAME, EMAIL FROM UP_PERSON_DIR WHERE USER_NAME=?</uidquery>
    -- >

 <!-- JDBC Properties  for mysql -->
  <driver>org.gjt.mm.mysql.Driver</driver>
  <url>jdbc:mysql://localhost/uportal</url>
  <logonid>uportal</logonid>
  <logonpassword>uportal</logonpassword>
  <uidquery>SELECT CONCAT_WS(" ",FIRST_NAME,LAST_NAME) AS FIRST_LAST, FIRST_NAME, LAST_NAME, EMAIL FROM UP_PERSON_DIR WHERE USER_NAME=?</uidquery>

    <!-- DataSource from container -->
    <!--
    <res-ref-name>PersonDb</res-ref-name>
    <uidquery>SELECT FIRST_NAME||' '||LAST_NAME AS FIRST_LAST, FIRST_NAME, LAST_NAME, EMAIL FROM UP_PERSON_DIR WHERE USER_NAME=?</uidquery>
    -->

    <attributes>

      <!-- uPortal channels refer to user attributes using standard
           attribute names found in the eduPerson object class. If
           a name is found for an eduPerson attribute name or "alias",
           it will be stuffed into the org.jasig.portal.security.IPerson object.
           See http://www.educause.edu/eduperson/ for an explanation of each
           of these aliases.
      -->

      <attribute>
        <name></name>
        <alias>eduPersonAffiliation</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>eduPersonNickname</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>eduPersonOrgDN</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>eduPersonOrgUnitDN</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>eduPersonPrimaryAffiliation</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>eduPersonPrincipalName</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>c</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>cn</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>description</alias>
      </attribute>

      <attribute>
        <name>FIRST_LAST</name>
        <alias>displayName</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>facsimileTelephoneNumber</alias>
      </attribute>

      <attribute>
        <name>FIRST_NAME</name>
        <alias>givenName</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>homePhone</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>homePostalAddress</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>initials</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>jpegPhoto</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>l</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>labeledURI</alias>
      </attribute>

      <attribute>
        <name>EMAIL</name>
        <alias>mail</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>mobile</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>o</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>ou</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>pager</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>postalAddress</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>postalCode</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>postOfficeBox</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>preferredLanguage</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>seeAlso</alias>
      </attribute>

      <attribute>
        <name>LAST_NAME</name>
        <alias>sn</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>st</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>street</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>telephoneNumber</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>uid</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>userCertificate</alias>
      </attribute>

      <attribute>
        <name></name>
        <alias>userSMIMECertificate</alias>
      </attribute>

    </attributes>

  </PersonDirInfo>

</PersonDirs>