<div dir="ltr"><div> 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. </div> 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". </div><div class="gmail_extra"> <div class="gmail_quote">On Mon, Jan 18, 2016 at 4:32 AM, Avi Miller <<a href="mailto:avi.miller@oracle.com" target="_blank">avi.miller@oracle.com</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">HI, > On 18 Jan 2016, at 9:27 AM, Uğur Engin <<a href="mailto:mail@ugurengin.com">mail@ugurengin.com</a>> wrote: > > Is there any way to change ssl certificate in generally for spacewalk ? Yes: <a href="http://docs.oracle.com/cd/E37670_01/E64575/html/swk22-replace-cert.html" rel="noreferrer" target="_blank">http://docs.oracle.com/cd/E37670_01/E64575/html/swk22-replace-cert.html</a> The process is the same for 2.4. Cheers, Avi -- Oracle <<a href="http://www.oracle.com" rel="noreferrer" target="_blank">http://www.oracle.com</a>> Avi Miller | Product Management Director | <a href="tel:%2B61%20%283%29%208616%203496" value="+61386163496">+61 (3) 8616 3496</a> Oracle Linux and Virtualization 417 St Kilda Road, Melbourne, Victoria 3004 Australia _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" rel="noreferrer" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></blockquote></div> </div>