sfa/importer/plimporter.py

   1 import os
   2
   3 from sfa.util.config import Config
   4 from sfa.util.xrn import Xrn, get_leaf, get_authority, hrn_to_urn
   5 from sfa.util.plxrn import hostname_to_hrn, slicename_to_hrn, email_to_hrn, hrn_to_pl_slicename
   6
   7 from sfa.trust.gid import create_uuid
   8 from sfa.trust.certificate import convert_public_key, Keypair
   9
  10 from sfa.storage.alchemy import dbsession
  11 from sfa.storage.model import RegRecord, RegAuthority, RegUser, RegSlice, RegNode
  12
  13 from sfa.plc.plshell import PlShell
  14
  15 def load_keys(filename):
  16     keys = {}
  17     tmp_dict = {}
  18     try:
  19         execfile(filename, tmp_dict)
  20         if 'keys' in tmp_dict:
  21             keys = tmp_dict['keys']
  22         return keys
  23     except:
  24         return keys
  25
  26 def save_keys(filename, keys):
  27     f = open(filename, 'w')
  28     f.write("keys = %s" % str(keys))
  29     f.close()
  30
  31 def _get_site_hrn(interface_hrn, site):
  32     # Hardcode 'internet2' into the hrn for sites hosting
  33     # internet2 nodes. This is a special operation for some vini
  34     # sites only
  35     hrn = ".".join([interface_hrn, site['login_base']])
  36     if ".vini" in interface_hrn and interface_hrn.endswith('vini'):
  37         if site['login_base'].startswith("i2") or site['login_base'].startswith("nlr"):
  38             hrn = ".".join([interface_hrn, "internet2", site['login_base']])
  39     return hrn
  40
  41
  42 class PlImporter:
  43
  44     def __init__ (self, auth_hierarchy, logger):
  45         self.auth_hierarchy = auth_hierarchy
  46         self.logger=logger
  47
  48     def record_options (self, parser):
  49         self.logger.debug ("PlImporter no options yet")
  50         pass
  51
  52     def run (self, options):
  53         # we don't have any options for now
  54         config = Config ()
  55         interface_hrn = config.SFA_INTERFACE_HRN
  56         root_auth = config.SFA_REGISTRY_ROOT_AUTH
  57         shell = PlShell (config)
  58
  59         # create dict of all existing sfa records
  60         existing_records = {}
  61         existing_hrns = []
  62         key_ids = []
  63         for record in dbsession.query(RegRecord):
  64             existing_records[ (record.hrn, record.type,) ] = record
  65             existing_hrns.append(record.hrn)
  66
  67         # Get all plc sites
  68         sites = shell.GetSites({'peer_id': None})
  69         sites_dict = {}
  70         for site in sites:
  71             sites_dict[site['login_base']] = site
  72
  73         # Get all plc users
  74         persons = shell.GetPersons({'peer_id': None, 'enabled': True},
  75                                    ['person_id', 'email', 'key_ids', 'site_ids'])
  76         persons_dict = {}
  77         for person in persons:
  78             persons_dict[person['person_id']] = person
  79             key_ids.extend(person['key_ids'])
  80
  81         # Get all public keys
  82         keys = shell.GetKeys( {'peer_id': None, 'key_id': key_ids})
  83         keys_dict = {}
  84         for key in keys:
  85             keys_dict[key['key_id']] = key['key']
  86
  87         # create a dict of person keys keyed on key_id
  88         keys_filename = config.config_path + os.sep + 'person_keys.py'
  89         old_person_keys = load_keys(keys_filename)
  90         person_keys = {}
  91         for person in persons:
  92             pubkeys = []
  93             for key_id in person['key_ids']:
  94                 pubkeys.append(keys_dict[key_id])
  95             person_keys[person['person_id']] = pubkeys
  96
  97         # Get all plc nodes
  98         nodes = shell.GetNodes( {'peer_id': None}, ['node_id', 'hostname', 'site_id'])
  99         nodes_dict = {}
 100         for node in nodes:
 101             nodes_dict[node['node_id']] = node
 102
 103         # Get all plc slices
 104         slices = shell.GetSlices( {'peer_id': None}, ['slice_id', 'name'])
 105         slices_dict = {}
 106         for slice in slices:
 107             slices_dict[slice['slice_id']] = slice
 108
 109         # special case for vini
 110         if ".vini" in interface_hrn and interface_hrn.endswith('vini'):
 111             # create a fake internet2 site first
 112             i2site = {'name': 'Internet2', 'abbreviated_name': 'I2',
 113                         'login_base': 'internet2', 'site_id': -1}
 114             site_hrn = _get_site_hrn(interface_hrn, i2site)
 115             # import if hrn is not in list of existing hrns or if the hrn exists
 116             # but its not a site record
 117             if site_hrn not in existing_hrns or \
 118                (site_hrn, 'authority') not in existing_records:
 119                 urn = hrn_to_urn(site_hrn, 'authority')
 120                 if not self.auth_hierarchy.auth_exists(urn):
 121                     self.auth_hierarchy.create_auth(urn)
 122                 auth_info = self.auth_hierarchy.get_auth_info(urn)
 123                 auth_record = RegAuthority()
 124                 auth_record.type='authority'
 125                 auth_record.hrn=site_hrn
 126                 auth_record.gid=auth_info.get_gid_object()
 127                 auth_record.pointer=site['site_id']
 128                 auth_record.authority=get_authority(site_hrn)
 129                 dbsession.add(auth_record)
 130                 dbsession.commit()
 131                 self.logger.info("PlImporter: Imported authority (vini site) %s"%auth_record)
 132
 133         # start importing
 134         for site in sites:
 135             site_hrn = _get_site_hrn(interface_hrn, site)
 136
 137             # import if hrn is not in list of existing hrns or if the hrn exists
 138             # but its not a site record
 139             if site_hrn not in existing_hrns or \
 140                (site_hrn, 'authority') not in existing_records:
 141                 try:
 142                     urn = hrn_to_urn(site_hrn, 'authority')
 143                     if not self.auth_hierarchy.auth_exists(urn):
 144                         self.auth_hierarchy.create_auth(urn)
 145                     auth_info = self.auth_hierarchy.get_auth_info(urn)
 146                     auth_record = RegAuthority()
 147                     auth_record.type='authority'
 148                     auth_record.hrn=site_hrn
 149                     auth_record.gid=auth_info.get_gid_object()
 150                     auth_record.pointer=site['site_id']
 151                     auth_record.authority=get_authority(site_hrn)
 152                     dbsession.add(auth_record)
 153                     dbsession.commit()
 154                     self.logger.info("PlImporter: imported authority (site) : %s" % auth_record)
 155                 except:
 156                     # if the site import fails then there is no point in trying to import the
 157                     # site's child records (node, slices, persons), so skip them.
 158                     self.logger.log_exc("PlImporter: failed to import site. Skipping child records")
 159                     continue
 160
 161             # import node records
 162             for node_id in site['node_ids']:
 163                 if node_id not in nodes_dict:
 164                     continue
 165                 node = nodes_dict[node_id]
 166                 site_auth = get_authority(site_hrn)
 167                 site_name = get_leaf(site_hrn)
 168                 hrn =  hostname_to_hrn(site_auth, site_name, node['hostname'])
 169                 if len(hrn) > 64:
 170                     hrn = hrn[:64]
 171                 if hrn not in existing_hrns or \
 172                    (hrn, 'node') not in existing_records:
 173                     try:
 174                         pkey = Keypair(create=True)
 175                         urn = hrn_to_urn(hrn, 'node')
 176                         node_gid = self.auth_hierarchy.create_gid(urn, create_uuid(), pkey)
 177                         node_record = RegNode ()
 178                         node_record.type='node'
 179                         node_record.hrn=hrn
 180                         node_record.gid=node_gid
 181                         node_record.pointer =node['node_id']
 182                         node_record.authority=get_authority(hrn)
 183                         dbsession.add(node_record)
 184                         dbsession.commit()
 185                         self.logger.info("PlImporter: imported node: %s" % node_record)
 186                     except:
 187                         self.logger.log_exc("PlImporter: failed to import node")
 188
 189
 190             # import slices
 191             for slice_id in site['slice_ids']:
 192                 if slice_id not in slices_dict:
 193                     continue
 194                 slice = slices_dict[slice_id]
 195                 hrn = slicename_to_hrn(interface_hrn, slice['name'])
 196                 if hrn not in existing_hrns or \
 197                    (hrn, 'slice') not in existing_records:
 198                     try:
 199                         pkey = Keypair(create=True)
 200                         urn = hrn_to_urn(hrn, 'slice')
 201                         slice_gid = self.auth_hierarchy.create_gid(urn, create_uuid(), pkey)
 202                         slice_record = RegSlice ()
 203                         slice_record.type='slice'
 204                         slice_record.hrn=hrn
 205                         slice_record.gid=slice_gid
 206                         slice_record.pointer=slice['slice_id']
 207                         slice_record.authority=get_authority(hrn)
 208                         dbsession.add(slice_record)
 209                         dbsession.commit()
 210                         self.logger.info("PlImporter: imported slice: %s" % slice_record)
 211                     except:
 212                         self.logger.log_exc("PlImporter: failed to  import slice")
 213
 214             # import persons
 215             for person_id in site['person_ids']:
 216                 if person_id not in persons_dict:
 217                     continue
 218                 person = persons_dict[person_id]
 219                 hrn = email_to_hrn(site_hrn, person['email'])
 220                 if len(hrn) > 64:
 221                     hrn = hrn[:64]
 222
 223                 # if user's primary key has changed then we need to update the
 224                 # users gid by forcing an update here
 225                 old_keys = []
 226                 new_keys = []
 227                 if person_id in old_person_keys:
 228                     old_keys = old_person_keys[person_id]
 229                 if person_id in person_keys:
 230                     new_keys = person_keys[person_id]
 231                 update_record = False
 232                 for key in new_keys:
 233                     if key not in old_keys:
 234                         update_record = True
 235
 236                 if hrn not in existing_hrns or \
 237                    (hrn, 'user') not in existing_records or update_record:
 238                     try:
 239                         if 'key_ids' in person and person['key_ids']:
 240                             key = new_keys[0]
 241                             try:
 242                                 pkey = convert_public_key(key)
 243                             except:
 244                                 self.logger.warn('unable to convert public key for %s' % hrn)
 245                                 pkey = Keypair(create=True)
 246                         else:
 247                             # the user has no keys. Creating a random keypair for the user's gid
 248                             self.logger.warn("PlImporter: person %s does not have a PL public key"%hrn)
 249                             pkey = Keypair(create=True)
 250                         urn = hrn_to_urn(hrn, 'user')
 251                         person_gid = self.auth_hierarchy.create_gid(urn, create_uuid(), pkey)
 252                         person_record = RegUser ()
 253                         person_record.type='user'
 254                         person_record.hrn=hrn
 255                         person_record.gid=person_gid
 256                         person_record.pointer=person['person_id']
 257                         person_record.authority=get_authority(hrn)
 258                         dbsession.add (person_record)
 259                         dbsession.commit()
 260                         self.logger.info("PlImporter: imported person: %s" % person_record)
 261                     except:
 262                         self.logger.log_exc("PlImporter: failed to import person.")
 263
 264         # remove stale records
 265         system_records = [interface_hrn, root_auth, interface_hrn + '.slicemanager']
 266         for (record_hrn, type) in existing_records.keys():
 267             if record_hrn in system_records:
 268                 continue
 269
 270             record = existing_records[(record_hrn, type)]
 271             if record.peer_authority:
 272                 continue
 273
 274             # dont delete vini's internet2 placeholdder record
 275             # normally this would be deleted becuase it does not have a plc record
 276             if ".vini" in interface_hrn and interface_hrn.endswith('vini') and \
 277                record_hrn.endswith("internet2"):
 278                 continue
 279
 280             found = False
 281
 282             if type == 'authority':
 283                 for site in sites:
 284                     site_hrn = interface_hrn + "." + site['login_base']
 285                     if site_hrn == record_hrn and site['site_id'] == record.pointer:
 286                         found = True
 287                         break
 288
 289             elif type == 'user':
 290                 login_base = get_leaf(get_authority(record_hrn))
 291                 username = get_leaf(record_hrn)
 292                 if login_base in sites_dict:
 293                     site = sites_dict[login_base]
 294                     for person in persons:
 295                         tmp_username = person['email'].split("@")[0]
 296                         alt_username = person['email'].split("@")[0].replace(".", "_").replace("+", "_")
 297                         if username in [tmp_username, alt_username] and \
 298                            site['site_id'] in person['site_ids'] and \
 299                            person['person_id'] == record.pointer:
 300                             found = True
 301                             break
 302
 303             elif type == 'slice':
 304                 slicename = hrn_to_pl_slicename(record_hrn)
 305                 for slice in slices:
 306                     if slicename == slice['name'] and \
 307                        slice['slice_id'] == record.pointer:
 308                         found = True
 309                         break
 310
 311             elif type == 'node':
 312                 login_base = get_leaf(get_authority(record_hrn))
 313                 nodename = Xrn.unescape(get_leaf(record_hrn))
 314                 if login_base in sites_dict:
 315                     site = sites_dict[login_base]
 316                     for node in nodes:
 317                         tmp_nodename = node['hostname']
 318                         if tmp_nodename == nodename and \
 319                            node['site_id'] == site['site_id'] and \
 320                            node['node_id'] == record.pointer:
 321                             found = True
 322                             break
 323             else:
 324                 continue
 325
 326             if not found:
 327                 try:
 328                     record_object = existing_records[(record_hrn, type)]
 329                     self.logger.info("PlImporter: deleting record: %s" % record)
 330                     dbsession.delete(record_object)
 331                     dbsession.commit()
 332                 except:
 333                     self.logger.log_exc("PlImporter: failded to delete record")
 334
 335         # save pub keys
 336         self.logger.info('Import: saving current pub keys')
 337         save_keys(keys_filename, person_keys)
 338