[Spacewalk-list] spacewalk ssl certificate

[Uğur Engin]

Hi Avi,

That's steps are ok, but when i try to restore new certicate to the
database, so i am getting an exception as follow.

rhn-ssl-dbstore -v --ca-cert=/root/ssl-build/RHN-ORG-TRUSTED-SSL-CERT -vvv
Public CA SSL certificate:  /root/ssl-build/RHN-ORG-TRUSTED-SSL-CERT

ERROR: unhandled exception occurred:
Traceback (most recent call last):
  File "/usr/bin/rhn-ssl-dbstore", line 39, in <module>
    sys.exit(abs(mod.main() or 0))
  File
"/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/rhn_ssl_dbstore.py",
line 85, in main
    satCerts.store_rhnCryptoKey(values.label, values.ca_cert,
verbosity=values.verbose)
  File
"/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/satCerts.py",
line 673, in store_rhnCryptoKey
    verbosity=verbosity)
  File
"/usr/lib/python2.7/site-packages/spacewalk/satellite_tools/satCerts.py",
line 614, in _checkCertMatch_rhnCryptoKey
    h.execute(rhn_cryptokey_id=rhn_cryptokey_id)
  File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 151, in execute
    return self._execute_wrapper(self._execute, *p, **kw)
  File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 290, in _execute_wrapper
    retval = function(*p, **kw)
  File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py",
line 205, in _execute
    return self._execute_(args, kwargs)
  File
"/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
line 309, in _execute_
    self._real_cursor.execute(self.sql, params)
psycopg2.IntegrityError: update or delete on table "rhncryptokey" violates
foreign key constraint "rhn_csssl_cacertid_fk" on table
"rhncontentsourcessl"
DETAIL:  Key (id)=(1) is still referenced from table "rhncontentsourcessl".




On Mon, Jan 18, 2016 at 4:32 AM, Avi Miller <avi.miller at oracle.com> wrote:

> HI,
>
> > On 18 Jan 2016, at 9:27 AM, Uğur Engin <mail at ugurengin.com> wrote:
> >
> > Is there any way to change ssl certificate in generally for spacewalk ?
>
> Yes:
> http://docs.oracle.com/cd/E37670_01/E64575/html/swk22-replace-cert.html
>
> The process is the same for 2.4.
>
> Cheers,
> Avi
>
> --
> Oracle <http://www.oracle.com>
> Avi Miller | Product Management Director | +61 (3) 8616 3496
> Oracle Linux and Virtualization
> 417 St Kilda Road, Melbourne, Victoria 3004 Australia
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20160118/111d754f/attachment.htm>