Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

old outside cert gives integrity error #340

Open
ahelsing opened this issue May 20, 2015 · 0 comments
Open

old outside cert gives integrity error #340

ahelsing opened this issue May 20, 2015 · 0 comments

Comments

@ahelsing
Copy link
Member

A cert that appears to be valid, but which is not listed in the DB, can result in odd errors.

  • Download a cert from a dev or staging server for use with Omni
  • re import the DB on that server
  • use that previously downloaded cert to, say, do createslice:
15:08:58 ERROR   : Error from server creating slice. Code 101: [SERVER] SERVER_ERROR ((IntegrityError) insert or update on table "sa_slice" violates foreign key constraint "sa_slice_owner_id_fkey"
DETAIL:  Key (owner_id)=(379bb0ac-1ffb-4dc0-abd9-3604f21f7856) is not present in table "ma_member".
 'INSERT INTO sa_slice (slice_id, owner_id, project_id, creation, expiration, slice_name, slice_urn, slice_email, certificate, slice_description, private_key) VALUES (%(slice_id)s, %(owner_id)s, %(project_id)s, %(creation)s, %(expiration)s, %(slice_name)s, %(slice_urn)s, %(slice_email)s, %(certificate)s, %(slice_description)s, %(private_key)s) RETURNING sa_slice.id' {'private_key': None, 'creation': datetime.datetime(2014, 11, 20, 20, 8, 58, 314112), 'slice_name': 'ahtest', 'slice_id': '1ba52cb3-0e64-45a1-9dbd-29844d3b26c3', 'slice_urn': 'urn:publicid:IDN+ch1.gpolab.bbn.com:ahtest+slice+ahtest', 'expiration': datetime.datetime(2014, 11, 27, 20, 8, 58, 314112), 'certificate': '-----BEGIN CERTIFICATE-----\nMIICzzCCAjigAwIBAgIBAzANBgkqhkiG9w0BAQQFADCBoTEbMBkGA1UEChMSY2gx\nLmdwb2xhYi5iYm4uY29tMRIwEAYDVQ
,,,

Imported from trac ticket #340, created by ahelsing on 11-20-2014 at 15:13, last modified: 11-20-2014 at 15:13

@ahelsing ahelsing added this to the unscheduled milestone May 20, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant