5 # Import PLC records into the Geni database. It is indended that this tool be
6 # run once to create Geni records that reflect the current state of the
9 # The import tool assumes that the existing PLC hierarchy should all be part
10 # of "planetlab.us" (see the root_auth and level1_auth variables below).
12 # Public keys are extracted from the users' SSH keys automatically and used to
13 # create GIDs. This is relatively experimental as a custom tool had to be
14 # written to perform conversion from SSH to OpenSSL format. It only supports
15 # RSA keys at this time, not DSA keys.
22 from geni.util.cert import *
23 from geni.util.trustedroot import *
24 from geni.util.hierarchy import *
25 from geni.util.record import *
26 from geni.util.genitable import *
27 from geni.util.misc import *
28 from geni.util.config import *
30 # get PL account settings from config module
31 pl_auth = get_pl_auth()
33 # connect to planetlab
35 from geni.util import remoteshell
36 shell = remoteshell.RemoteShell()
39 shell = PLC.Shell.Shell(globals = globals())
42 # Two authorities are specified: the root authority and the level1 authority.
47 #root_auth = "planetlab"
48 #level1_auth = "planetlab.us"
51 root_auth = config.GENI_REGISTRY_ROOT_AUTH
52 level1_auth = config.GENI_REGISTRY_LEVEL1_AUTH
53 if not level1_auth or level1_auth in ['']:
56 keyconvert = 'keyconvert'
58 default_path = "/usr/share/keyconvert/" + keyconvert
59 cwd = os.path.dirname(os.path.abspath(__file__))
60 alt_path = os.sep.join(cwd.split(os.sep)[:-1] + ['keyconvert', 'keyconvert'])
61 geni_path = config.GENI_BASE_DIR + os.sep + "keyconvert/keyconvert"
62 files = [default_path, alt_path, geni_path]
64 print os.path.isfile(path), path
65 if os.path.isfile(path):
71 raise Exception, "Could not find config in " + ", ".join(files)
73 keyconvert_fn = config.GENI_BASE_DIR + os.sep + "keyconvert/keyconvert"
76 if isinstance(str, unicode):
77 return str.encode("ascii", "ignore")
81 def cleanup_string(str):
82 # pgsql has a fit with strings that have high ascii in them, so filter it
83 # out when generating the hrns.
91 str = str.replace(" ", "_")
92 str = str.replace(".", "_")
93 str = str.replace("(", "_")
94 str = str.replace("'", "_")
95 str = str.replace(")", "_")
96 str = str.replace('"', "_")
99 def process_options():
102 (options, args) = getopt.getopt(sys.argv[1:], '', [])
108 global pl_auth, shell
110 # get PL account settings from config module
111 pl_auth = get_pl_auth()
113 # connect to planetlab
115 from geni.util import remoteshell
116 shell = remoteshell.RemoteShell()
119 shell = PLC.Shell.Shell(globals = globals())
123 def get_auth_table(auth_name):
124 AuthHierarchy = Hierarchy()
125 auth_info = AuthHierarchy.get_auth_info(auth_name)
127 table = GeniTable(hrn=auth_name,
128 cninfo=auth_info.get_dbinfo())
130 # if the table doesn't exist, then it means we haven't put any records
131 # into this authority yet.
133 if not table.exists():
134 report.trace("Import: creating table for authority " + auth_name)
139 def get_pl_pubkey(key_id):
140 keys = shell.GetKeys(pl_auth, [key_id])
142 key_str = keys[0]['key']
144 if "ssh-dss" in key_str:
145 print "XXX: DSA key encountered, ignoring"
148 # generate temporary files to hold the keys
149 (ssh_f, ssh_fn) = tempfile.mkstemp()
150 ssl_fn = tempfile.mktemp()
152 os.write(ssh_f, key_str)
155 if not os.path.exists(keyconvert_fn):
156 report.trace(" keyconvert utility " + str(keyconvert_fn) + " does not exist");
159 cmd = keyconvert_fn + " " + ssh_fn + " " + ssl_fn
163 # this check leaves the temporary file containing the public key so
164 # that it can be expected to see why it failed.
165 # TODO: for production, cleanup the temporary files
166 if not os.path.exists(ssl_fn):
167 report.trace(" failed to convert key from " + ssh_fn + " to " + ssl_fn)
172 k.load_pubkey_from_file(ssl_fn)
174 print "XXX: Error while converting key: ", key_str
177 # remove the temporary files
185 def person_to_hrn(parent_hrn, person):
186 # the old way - Lastname_Firstname
187 #personname = person['last_name'] + "_" + person['first_name']
189 # the new way - use email address up to the "@"
190 personname = person['email'].split("@")[0]
192 personname = cleanup_string(personname)
194 hrn = parent_hrn + "." + personname
197 def import_person(parent_hrn, person):
198 AuthHierarchy = Hierarchy()
199 hrn = person_to_hrn(parent_hrn, person)
201 # ASN.1 will have problems with hrn's longer than 64 characters
205 report.trace("Import: importing person " + hrn)
207 table = get_auth_table(parent_hrn)
209 person_record = table.resolve("user", hrn)
210 if not person_record:
212 if 'key_ids' in person:
213 key_ids = person["key_ids"]
216 # get the user's private key from the SSH keys they have uploaded
218 pkey = get_pl_pubkey(key_ids[0])
220 # the user has no keys
221 report.trace(" person " + hrn + " does not have a PL public key")
224 # if a key is unavailable, then we still need to put something in the
225 # user's GID. So make one up.
227 pkey = Keypair(create=True)
229 person_gid = AuthHierarchy.create_gid(hrn, create_uuid(), pkey)
230 person_record = GeniRecord(name=hrn, gid=person_gid, type="user", pointer=person['person_id'])
231 report.trace(" inserting user record for " + hrn)
232 table.insert(person_record)
234 key_ids = person["key_ids"]
237 pkey = get_pl_pubkey(key_ids[0])
238 person_gid = AuthHierarchy.create_gid(hrn, create_uuid(), pkey)
239 person_record = GeniRecord(name=hrn, gid=person_gid, type="user", pointer=person['person_id'])
240 report.trace(" updating user record for " + hrn)
241 table.update(person_record)
243 def import_slice(parent_hrn, slice):
244 AuthHierarchy = Hierarchy()
245 slicename = slice['name'].split("_",1)[-1]
246 slicename = cleanup_string(slicename)
249 report.error("Import_Slice: failed to parse slice name " + slice['name'])
252 hrn = parent_hrn + "." + slicename
253 report.trace("Import: importing slice " + hrn)
255 table = get_auth_table(parent_hrn)
257 slice_record = table.resolve("slice", hrn)
259 pkey = Keypair(create=True)
260 slice_gid = AuthHierarchy.create_gid(hrn, create_uuid(), pkey)
261 slice_record = GeniRecord(name=hrn, gid=slice_gid, type="slice", pointer=slice['slice_id'])
262 report.trace(" inserting slice record for " + hrn)
263 table.insert(slice_record)
265 def import_node(parent_hrn, node):
266 AuthHierarchy = Hierarchy()
267 nodename = node['hostname'].split(".")[0]
268 nodename = cleanup_string(nodename)
271 report.error("Import_node: failed to parse node name " + node['hostname'])
274 hrn = parent_hrn + "." + nodename
276 # ASN.1 will have problems with hrn's longer than 64 characters
280 report.trace("Import: importing node " + hrn)
282 table = get_auth_table(parent_hrn)
284 node_record = table.resolve("node", hrn)
286 pkey = Keypair(create=True)
287 node_gid = AuthHierarchy.create_gid(hrn, create_uuid(), pkey)
288 node_record = GeniRecord(name=hrn, gid=node_gid, type="node", pointer=node['node_id'])
289 report.trace(" inserting node record for " + hrn)
290 table.insert(node_record)
292 def import_site(parent_hrn, site):
293 AuthHierarchy = Hierarchy()
294 sitename = site['login_base']
295 sitename = cleanup_string(sitename)
297 hrn = parent_hrn + "." + sitename
299 report.trace("Import_Site: importing site " + hrn)
301 # create the authority
302 if not AuthHierarchy.auth_exists(hrn):
303 AuthHierarchy.create_auth(hrn)
305 auth_info = AuthHierarchy.get_auth_info(hrn)
307 table = get_auth_table(parent_hrn)
309 auth_record = table.resolve("authority", hrn)
311 auth_record = GeniRecord(name=hrn, gid=auth_info.get_gid_object(), type="authority", pointer=site['site_id'])
312 report.trace(" inserting authority record for " + hrn)
313 table.insert(auth_record)
315 if 'person_ids' in site:
316 for person_id in site['person_ids']:
317 persons = shell.GetPersons(pl_auth, [person_id])
320 import_person(hrn, persons[0])
322 report.trace("Failed to import: %s" % persons[0])
323 if 'slice_ids' in site:
324 for slice_id in site['slice_ids']:
325 slices = shell.GetSlices(pl_auth, [slice_id])
328 import_slice(hrn, slices[0])
330 report.trace("Failed to import: %s" % slices[0])
331 if 'node_ids' in site:
332 for node_id in site['node_ids']:
333 nodes = shell.GetNodes(pl_auth, [node_id])
336 import_node(hrn, nodes[0])
338 report.trace("Failed to import: %s" % nodes[0])
340 def create_top_level_auth_records(hrn):
341 parent_hrn = get_authority(hrn)
342 print hrn, ":", parent_hrn
345 auth_info = AuthHierarchy.get_auth_info(parent_hrn)
346 table = get_auth_table(parent_hrn)
348 auth_record = table.resolve("authority", hrn)
350 auth_record = GeniRecord(name=hrn, gid=auth_info.get_gid_object(), type="authority", pointer=-1)
351 report.trace(" inserting authority record for " + hrn)
352 table.insert(auth_record)
360 print "Base Directory: ", config.GENI_BASE_DIR
362 AuthHierarchy = Hierarchy()
363 TrustedRoots = TrustedRootList()
365 print "Import: creating top level authorities"
367 if not AuthHierarchy.auth_exists(root_auth):
368 AuthHierarchy.create_auth(root_auth)
370 create_top_level_auth_records(root_auth)
372 if not AuthHierarchy.auth_exists(level1_auth):
373 AuthHierarchy.create_auth(level1_auth)
374 create_top_level_auth_records(level1_auth)
375 import_auth = level1_auth
377 import_auth = root_auth
379 print "Import: adding", root_auth, "to trusted list"
380 root = AuthHierarchy.get_auth_info(root_auth)
381 TrustedRoots.add_gid(root.get_gid_object())
385 sites = shell.GetSites(pl_auth)
387 import_site(import_auth, site)
389 if __name__ == "__main__":