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
7 from sfa.trust.gid import create_uuid
8 from sfa.trust.certificate import convert_public_key, Keypair
10 from sfa.storage.alchemy import dbsession
11 from sfa.storage.model import RegRecord, RegAuthority, RegSlice, RegNode, RegUser, RegKey
13 from sfa.plc.plshell import PlShell
15 def _get_site_hrn(interface_hrn, site):
16 # Hardcode 'internet2' into the hrn for sites hosting
17 # internet2 nodes. This is a special operation for some vini
19 hrn = ".".join([interface_hrn, site['login_base']])
20 if ".vini" in interface_hrn and interface_hrn.endswith('vini'):
21 if site['login_base'].startswith("i2") or site['login_base'].startswith("nlr"):
22 hrn = ".".join([interface_hrn, "internet2", site['login_base']])
28 def __init__ (self, auth_hierarchy, logger):
29 self.auth_hierarchy = auth_hierarchy
32 def record_options (self, parser):
33 self.logger.debug ("PlImporter no options yet")
36 def run (self, options):
37 # we don't have any options for now
39 interface_hrn = config.SFA_INTERFACE_HRN
40 root_auth = config.SFA_REGISTRY_ROOT_AUTH
41 shell = PlShell (config)
43 # create dict of all existing sfa records
44 records_by_hrn_type = {}
45 records_by_type_pointer = {}
47 records = dbsession.query(RegRecord)
48 for record in records:
49 records_by_hrn_type[ (record.hrn, record.type,) ] = record
50 if record.pointer != -1:
51 records_by_type_pointer [ (record.type, record.pointer,) ] = record
54 # retrieve only required stuf
55 sites = shell.GetSites({'peer_id': None, 'enabled' : True},
56 ['site_id','login_base','node_ids','slice_ids','person_ids',])
59 sites_dict[site['login_base']] = site
62 persons = shell.GetPersons({'peer_id': None, 'enabled': True},
63 ['person_id', 'email', 'key_ids', 'site_ids'])
65 for person in persons:
66 persons_dict[person['person_id']] = person
67 key_ids.extend(person['key_ids'])
69 # Get all plc public keys
70 keys = shell.GetKeys( {'peer_id': None, 'key_id': key_ids})
72 for key in keys: keys_by_id[key['key_id']] = key
74 # create a dict person_id -> [ (plc)keys ]
75 keys_by_person_id = {}
76 for person in persons:
78 for key_id in person['key_ids']:
79 pubkeys.append(keys_by_id[key_id])
80 keys_by_person_id[person['person_id']] = pubkeys
83 nodes = shell.GetNodes( {'peer_id': None}, ['node_id', 'hostname', 'site_id'])
86 nodes_dict[node['node_id']] = node
89 slices = shell.GetSlices( {'peer_id': None}, ['slice_id', 'name'])
92 slices_dict[slice['slice_id']] = slice
94 # special case for vini
95 if ".vini" in interface_hrn and interface_hrn.endswith('vini'):
96 # create a fake internet2 site first
97 i2site = {'name': 'Internet2', 'login_base': 'internet2', 'site_id': -1}
98 site_hrn = _get_site_hrn(interface_hrn, i2site)
99 # import if hrn is not in list of existing hrns or if the hrn exists
100 # but its not a site record
101 if (site_hrn, 'authority') not in records_by_hrn_type:
102 urn = hrn_to_urn(site_hrn, 'authority')
103 if not self.auth_hierarchy.auth_exists(urn):
104 self.auth_hierarchy.create_auth(urn)
105 auth_info = self.auth_hierarchy.get_auth_info(urn)
106 auth_record = RegAuthority()
107 auth_record.type='authority'
108 auth_record.hrn=site_hrn
109 auth_record.gid=auth_info.get_gid_object()
110 auth_record.pointer=site['site_id']
111 auth_record.authority=get_authority(site_hrn)
112 dbsession.add(auth_record)
114 self.logger.info("PlImporter: Imported authority (vini site) %s"%auth_record)
118 site_hrn = _get_site_hrn(interface_hrn, site)
120 # import if hrn is not in list of existing hrns or if the hrn exists
121 # but its not a site record
122 if (site_hrn, 'authority') not in records_by_hrn_type:
124 urn = hrn_to_urn(site_hrn, 'authority')
125 if not self.auth_hierarchy.auth_exists(urn):
126 self.auth_hierarchy.create_auth(urn)
127 auth_info = self.auth_hierarchy.get_auth_info(urn)
128 auth_record = RegAuthority()
129 auth_record.type='authority'
130 auth_record.hrn=site_hrn
131 auth_record.gid=auth_info.get_gid_object()
132 auth_record.pointer=site['site_id']
133 auth_record.authority=get_authority(site_hrn)
134 dbsession.add(auth_record)
136 self.logger.info("PlImporter: imported authority (site) : %s" % auth_record)
138 # if the site import fails then there is no point in trying to import the
139 # site's child records (node, slices, persons), so skip them.
140 self.logger.log_exc("PlImporter: failed to import site. Skipping child records")
143 # import node records
144 for node_id in site['node_ids']:
145 if node_id not in nodes_dict:
147 node = nodes_dict[node_id]
148 site_auth = get_authority(site_hrn)
149 site_name = get_leaf(site_hrn)
150 hrn = hostname_to_hrn(site_auth, site_name, node['hostname'])
153 if (hrn, 'node') not in records_by_hrn_type:
155 pkey = Keypair(create=True)
156 urn = hrn_to_urn(hrn, 'node')
157 node_gid = self.auth_hierarchy.create_gid(urn, create_uuid(), pkey)
158 node_record = RegNode ()
159 node_record.type='node'
161 node_record.gid=node_gid
162 node_record.pointer =node['node_id']
163 node_record.authority=get_authority(hrn)
164 dbsession.add(node_record)
166 self.logger.info("PlImporter: imported node: %s" % node_record)
168 self.logger.log_exc("PlImporter: failed to import node")
172 for slice_id in site['slice_ids']:
173 if slice_id not in slices_dict:
175 slice = slices_dict[slice_id]
176 hrn = slicename_to_hrn(interface_hrn, slice['name'])
177 if (hrn, 'slice') not in records_by_hrn_type:
179 pkey = Keypair(create=True)
180 urn = hrn_to_urn(hrn, 'slice')
181 slice_gid = self.auth_hierarchy.create_gid(urn, create_uuid(), pkey)
182 slice_record = RegSlice ()
183 slice_record.type='slice'
185 slice_record.gid=slice_gid
186 slice_record.pointer=slice['slice_id']
187 slice_record.authority=get_authority(hrn)
188 dbsession.add(slice_record)
190 self.logger.info("PlImporter: imported slice: %s" % slice_record)
192 self.logger.log_exc("PlImporter: failed to import slice")
195 for person_id in site['person_ids']:
196 if person_id not in persons_dict:
197 self.logger.warning ("PlImporter: skipping person %s"%person_id)
199 person = persons_dict[person_id]
200 hrn = email_to_hrn(site_hrn, person['email'])
204 previous_record = records_by_hrn_type.get( (hrn, 'user',) )
205 if not previous_record:
206 previous_record = records_by_type_pointer.get ( ('user', person_id,) )
207 # if user's primary key has changed then we need to update the
208 # users gid by forcing an update here
212 sfa_keys = previous_record.reg_keys
213 if person_id in keys_by_person_id:
214 plc_keys = keys_by_person_id[person_id]
215 update_record = False
216 def key_in_list (key,sfa_keys):
217 for reg_key in sfa_keys:
218 if reg_key.key==key['key']: return True
221 if not key_in_list (key,sfa_keys):
224 if not previous_record or update_record:
227 if 'key_ids' in person and person['key_ids']:
228 # randomly pick first key in set
231 pkey = convert_public_key(pubkey['key'])
233 self.logger.warn('PlImporter: unable to convert public key for %s' % hrn)
234 pkey = Keypair(create=True)
236 # the user has no keys. Creating a random keypair for the user's gid
237 self.logger.warn("PlImporter: person %s does not have a PL public key"%hrn)
238 pkey = Keypair(create=True)
239 urn = hrn_to_urn(hrn, 'user')
240 person_gid = self.auth_hierarchy.create_gid(urn, create_uuid(), pkey)
242 previous_record.gid=person_gid
243 if pubkey: previous_record.reg_keys=[RegKey (pubkey['key'], pubkey['key_id'])]
244 self.logger.info("PlImporter: updated person: %s" % previous_record)
246 new_record = RegUser (hrn=hrn, gid=person_gid,
247 pointer=person['person_id'],
248 authority=get_authority(hrn),
249 email=person['email'])
250 if pubkey: new_record.reg_keys=[RegKey (pubkey['key'], pubkey['key_id'])]
251 dbsession.add (new_record)
253 self.logger.info("PlImporter: imported person: %s" % new_record)
255 self.logger.log_exc("PlImporter: failed to import person.")
257 # remove stale records
258 system_records = [interface_hrn, root_auth, interface_hrn + '.slicemanager']
259 for record in records:
260 record_hrn=record.hrn
261 if record_hrn in system_records:
263 if record.peer_authority:
267 # dont delete vini's internet2 placeholdder record
268 # normally this would be deleted becuase it does not have a plc record
269 if ".vini" in interface_hrn and interface_hrn.endswith('vini') and \
270 record_hrn.endswith("internet2"):
275 if isinstance (record, RegAuthority):
277 site_hrn = interface_hrn + "." + site['login_base']
278 if site_hrn == record_hrn and site['site_id'] == record.pointer:
282 elif isinstance (record, RegUser):
283 login_base = get_leaf(get_authority(record_hrn))
284 username = get_leaf(record_hrn)
285 if login_base in sites_dict:
286 site = sites_dict[login_base]
287 for person in persons:
288 tmp_username = person['email'].split("@")[0]
289 alt_username = person['email'].split("@")[0].replace(".", "_").replace("+", "_")
290 if username in [tmp_username, alt_username] and \
291 site['site_id'] in person['site_ids'] and \
292 person['person_id'] == record.pointer:
296 elif isinstance (record, RegSlice):
297 slicename = hrn_to_pl_slicename(record_hrn)
299 if slicename == slice['name'] and \
300 slice['slice_id'] == record.pointer:
304 elif isinstance (record, RegNode):
305 login_base = get_leaf(get_authority(record_hrn))
306 nodename = Xrn.unescape(get_leaf(record_hrn))
307 if login_base in sites_dict:
308 site = sites_dict[login_base]
310 tmp_nodename = node['hostname']
311 if tmp_nodename == nodename and \
312 node['site_id'] == site['site_id'] and \
313 node['node_id'] == record.pointer:
321 record_object = records_by_hrn_type[(record_hrn, type)]
322 self.logger.info("PlImporter: deleting record: %s" % record)
323 dbsession.delete(record_object)
326 self.logger.log_exc("PlImporter: failded to delete record")
329 # self.logger.info('Import: saving current pub keys')
330 # save_keys(keys_filename, person_keys)