Remove An Aggregate

In order to remove an aggregate from the service registry, the steps in Add An Aggregate must, in essence, be reversed. It will be helpful to read that page if you are not familiar with the various changes needed to add an aggregate.

1. Remove from aggregate data
2. Remove from Makefile
3. Remove from RPM spec
4. Remove from database
5. Update portal data

Remove from aggregate data

Find the appropriate line or lines in geni-ch/data/sr/aggdata.csv and remove them from the file.

Remove from Makefile

Find the appropriate line or lines in geni-ch/data/Makefile.am and remove them from the file.

Remove from RPM spec

Find the appropriate line or lines in geni-ch/geni-chapi.spec and remove them from the file.

Remove from database

Note: these steps could be automated by generating a remove sql script at the same time the add sql script is generated by geni-ch/data/sr/generate-sql.

Remove from service_registry_attributes

Replace INSERT-URN-HERE with the actual URN.

delete from service_registry_attribute
  where service_id = (select id from service_registry
          where service_urn = 'INSERT-URN-HERE');

Remove from service_registry

Replace INSERT-URN-HERE with the actual URN.

delete from service_registry
  where service_urn = 'INSERT-URN-HERE';

(optional) Remove CA cert from service registry

If the aggregate has a CA certificate in the service registry, remove it. If no CA certificate is present in the service registry, this step is not necessary.

This command uses the aggregate short name instead of the URN.

delete from service_registry
  where service_type = 7
    and short_name = 'INSERT-SHORT-NAME-HERE';

Update portal data

Update Jacks context

See the portal's Jacks context wiki page.

Update map data

See the portal's update map wiki page.