Changes between Version 4 and Version 5 of UPDT_unit_changes


Ignore:
Timestamp:
11/18/14 13:55:14 (10 years ago)
Author:
lttoth@…
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UPDT_unit_changes

    v4 v5  
    3232Once the people registry updates are complete, take the following steps to apply the resulting LDIF to the LDAP repository. 
    3333         
    34                 1. ask DBA group to execute the following to  
     34                1. Ask DBA group to execute the following to  
    3535                add world read permission to ldif files in /tmp 
    3636                  * ~oracle/local/production/PMldap_tmp_chmod.ksh 
    37                 1. after the file permissions have been changed, 
     37                1. After the file permissions have been changed, 
    3838                copy the resulting ldif to sxldap owned  
    3939                directory and to iplanet account on eklutna 
    4040                  * cd $HOME/appworx/ 
    4141                  * ./manage_ldif_files.ksh 
    42                 1. after copying the resulting ldif, 
     42                1. After copying the resulting ldif, 
    4343                tell iplanet on eklutna to apply it 
    4444                  * ./apply_ldif_files.ksh 
    45                 1. have DBA group run this script to  
     45                1. Have DBA group run this script to  
    4646                delete ldif from /tmp/ 
    4747                  * ~oracle/local/production/PMldap_tmp_cleanup.ksh 
    4848==== Publicizing Summary Changes==== 
    4949After confirming LDIF applied, 
    50 # email summary of changes to sdedirregistry@email.alaska.edu 
    51  
    52         # changes are listed in ldap_RPTS_dept_<date>.changes file 
    53         cd $HOME/local/ldap/extracts/ 
    54         ls -lrt *dept*changes|tail -1   # check date/time stamp 
    55         awk '{print $1}' $(ls -1rt *dept*changes|tail -1)|sort |uniq -c 
    56  
    57 # compare EDIR structure to BOR structure and send 
    58 # email to Budget Offices soliciting response to unit changes 
    59  
    60         cd $HOME/local/ldap/query 
    61         sqlplus / 
    62                 @compare_edir_structure_to_bor.sql 
    63                 exit 
    64  
    65         # copy and paste screen output to email for budget offices  
    66         # with request for feedback 
    67         Recipients: Phil Harrington <plharrington@alaska.edu>, Lynn Wrightsman <lawrightsman@alaska.edu>, Barbara Hyde <bjhyde@uas.alaska.edu> 
    68         CC:  to !ua-oit-registry@alaska.edu  
    69  
    70         # if the budget office respond with feedback 
    71         # then  
    72                 # move EDIR data to new unit records if applicable 
     501. Email summary of changes to sdedirregistry@email.alaska.edu 
     51        * Changes are listed in ldap_RPTS_dept_<date>.changes file 
     52        * cd $HOME/local/ldap/extracts/ 
     53        * ls -lrt *dept*changes|tail -1 # check date/time stamp 
     54        * awk '{print $1}' $(ls -1rt *dept*changes|tail -1)|sort |uniq -c 
     551. Compare EDIR structure to BOR structure and send 
     561. Email to Budget Offices soliciting response to unit changes 
     57        * cd $HOME/local/ldap/query 
     58        * sqlplus / 
     59                * @compare_edir_structure_to_bor.sql 
     60                * exit 
     61        * copy and paste screen output to email for budget offices with request for feedback 
     62          * Recipients: Phil Harrington <plharrington@alaska.edu>, Lynn Wrightsman <lawrightsman@alaska.edu>, Barbara Hyde <bjhyde@uas.alaska.edu> 
     63          * CC:  to !ua-oit-registry@alaska.edu  
     64        * If the budget office respond with feedback 
     65                * move EDIR data to new unit records if applicable 
    7366                (TBD - see beth in meantime) 
    74  
    75                 # flag to keep, or delete, old unit records if applicable 
    76                 (TBD - see beth in meantime) 
    77          
    78         # Note: No EDIR unit record will be dropped from EDIR unless flagged 
    79         # in the EDIR_STRUCTURE table.  This allows EDIR to reflect units w/o 
    80         # budget that are **not** retained in the BOR structure table. 
    81  
    82 # notify sdtsaa of new/obsolete EDIRroles (associated with unit changes) 
    83 # NOTE: run show scripts before running add/delete scripts in next step 
    84  
    85         # first generate list of new and obsolete edir unit related roles 
    86         # send 2 emails to sdtsaa; one with needed one with obsolete 
     67                * flag to keep, or delete, old unit records if applicable 
     68                (TBD - see beth in meantime)     
     69        * ''Note:'' No EDIR unit record will be dropped from EDIR unless flagged 
     70        * in the EDIR_STRUCTURE table.  This allows EDIR to reflect units w/o 
     71        * budget that are **not** retained in the BOR structure table. 
     721. Notify sdtsaa of new/obsolete EDIRroles (associated with unit changes) 
     73   * First generate a list of new and obsolete EDIR unit related roles 
     74{{{ 
    8775        @show_needed_dlevel_roles.sql 
    8876        @show_needed_unit_roles.sql 
    8977        @show_obsolete_dlevel_roles.sql 
    9078        @show_obsolete_unit_roles.sql 
    91  
    92 # update LDAP_ZUAUSR_ADMIN table, adding needed roles and deleting obsolete roles 
    93 # NOTE: run show scripts before running add/delete scripts 
    94  
     79}}} 
     80   * Run "Show" scripts before running add/delete scripts in the following step 
     81   * Send an email to sdtsaa; see  [[SyncDirectory|Banner/Directory Synchronization]] for detailed instructions. 
     821. Update LDAP_ZUAUSR_ADMIN table, adding needed roles and deleting obsolete roles 
     83    * Run show scripts before add/delete 
     84{{{ 
    9585        @add_needed_dlevel_roles.sql 
    9686        @add_needed_unit_roles.sql 
    9787        @delete_obsolete_dlevel_roles.sql 
    9888        @delete_obsolete_unit_roles.sql 
    99  
     89}}} 
    10090########################################################[[br]] 
    10191LEGACY CHANGE HISTORY - NOTE: All subsequent changes are recorded in TracWiki[[br]]