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