[Spacewalk-list] Error when updating SSL certificates

[Matthew Madey]

I've recently converted my old SHA-1 certificate to SHA-2 using the
directions outlined here: https://access.redhat.com/solutions/10809

However, during one of the steps, to import the new cert into the database,
I'm getting the below error. Any ideas on how I can rectify this?

# rhn-ssl-dbstore --ca-cert=/root/ssl-build/RHN-ORG-TRUSTED-SSL-CERT

ERROR: Cannot insert certificate into DB!

Exception reported from spacewalk-qa.ourcompany.com
Time: Wed Dec 28 13:15:15 2016
Exception type <class
'spacewalk.satellite_tools.satCerts.CaCertInsertionError'>

Exception Handler Information
Traceback (most recent call last):
  File
"/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/rhn_ssl_dbstore.py",
line 84, in main
    satCerts.store_rhnCryptoKey(values.label, values.ca_cert,
verbosity=values.verbose)
  File
"/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satCerts.py",
line 170, in store_rhnCryptoKey
    "...the traceback: %s" % fetchTraceback()), sys.exc_info()[2])
  File
"/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satCerts.py",
line 157, in store_rhnCryptoKey
    verbosity=verbosity)
  File
"/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satCerts.py",
line 97, in _checkCertMatch_rhnCryptoKey
    h.execute(rhn_cryptokey_id=rhn_cryptokey_id)
  File
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 151, in execute
    return self._execute_wrapper(self._execute, *p, **kw)
  File
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 133, in _execute_wrapper
    raise_with_tb(sql_base.SQLError(*ret), sys.exc_info()[2])
  File
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 113, in _execute_wrapper
    retval = function(*p, **kw)
  File
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 205, in _execute
    return self._execute_(args, kwargs)
  File
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 167, in _execute_
    self._real_cursor.execute(*(None, ), **params)
CaCertInsertionError: ...the traceback: Exception reported from
spacewalk-qa.ourcompany.com
Time: Wed Dec 28 13:15:15 2016
Exception type <class 'spacewalk.server.rhnSQL.sql_base.SQLError'>

Exception Handler Information
Traceback (most recent call last):
  File
"/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satCerts.py",
line 157, in store_rhnCryptoKey
    verbosity=verbosity)
  File
"/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satCerts.py",
line 97, in _checkCertMatch_rhnCryptoKey
    h.execute(rhn_cryptokey_id=rhn_cryptokey_id)
  File
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 151, in execute
    return self._execute_wrapper(self._execute, *p, **kw)
  File
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 133, in _execute_wrapper
    raise_with_tb(sql_base.SQLError(*ret), sys.exc_info()[2])
  File
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 113, in _execute_wrapper
    retval = function(*p, **kw)
  File
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 205, in _execute
    return self._execute_(args, kwargs)
  File
"/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 167, in _execute_
    self._real_cursor.execute(*(None, ), **params)
SQLError: (2292, 'ORA-02292: integrity constraint
(SWLKAP01.RHN_CSSSL_CACERTID_FK) violated - child record found\n', 'delete
from rhnCryptoKey where id=:rhn_cryptokey_id')
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20161228/d2ff2284/attachment.htm>