topic Re: CA certificate missing in database in Application Development and Automation Discussions

CA certificate missing in database

Former Member — Fri, 18 May 2007 18:52:07 GMT

Hi,

Any idea about "CA certificate missing in database" message when importing CA certificate response.

Regards,

Gökhan

Re: CA certificate missing in database

Former Member — Sat, 19 May 2007 06:32:19 GMT

Hello Gökhan,

Please check oss note 508307.

Regards.

Ruchit

Re: CA certificate missing in database

Former Member — Tue, 22 May 2007 10:43:56 GMT

Hi Ruchit,

Besides 508307, I was also using 510007 and 695674.

695674 tells how to import CA root via keytool, which requires keystore password.

Do you know does it have the same effect if I try to import the CA's root certificate via STRUST -> Certificate -> Import?

Because evenif I try to import the CA's root certificate via STRUST, I'm still receiving the same message of "CA certificate missing in database" when trying to import CSR response.

Regards,

Gökhan

Re: CA certificate missing in database

Former Member — Tue, 22 May 2007 11:49:27 GMT

STRUST is for the ABAP stack only.

You have to import the CA certificate in the "Trusted CA" list in the Key Storage Service first.

Re: CA certificate missing in database

Former Member — Wed, 30 May 2007 21:49:20 GMT

Hi,

First of all thanks for your contributions.

One of my colleague helped me with the solution of the problem.

I was getting the error when I was directly copying and pasting the csr response at transaction STRUST.

The tricky point was to import csr response after saving to a text file. But only .crt extension is allowed !

Wish all less buggy days,

Gökhan

Re: CA certificate missing in database

Former Member — Tue, 24 Jul 2007 15:59:56 GMT

Hi Gökhan,

in an ABAP system you first need to create an entry in table STRUSTCERT using SE16 in the customer namespace (like ZCUSTOMER) for category "CA".

Then you import the root CA certificate using Cerificate -> Import in trx STRUST and export it immediately to target "Database", category "root CA" and overwrite the entry created before.

Now your SAP system knows the new CA.

Best regards, Lutz

Re: CA certificate missing in database

Former Member — Thu, 28 May 2009 16:30:48 GMT

I'm not trying to be ignorant, but how can I create an entry in STRUSTCERT in a customer namespace? I have tried adding my company CA to STRUSTCERT, but it still says that the issuer certificate is not in the database when I import a certificate request response from the CA.

If I attempt to load the CA cert by importing the local file and then exporting to the database, I receive a "Choose the key from the allowed namespace".

Re: CA certificate missing in database

martijndeboer — Fri, 29 May 2009 19:15:58 GMT

Hi,

To include the CA certificate in the database, do the following.

1) Import the CA certificate from menu Certificate->Import

2) Press the "Export Certificate" Button (left from Add to Cert. List)

3) In the popup, select tab database and enter the requested data

No need to modify tables with SE16...

Regards,

Martijn

Re: CA certificate missing in database

former_member568822 — Thu, 15 Oct 2009 12:02:20 GMT

Hi Derek,

Did you manage to solve you problem? I have a same problem with you, please let me know if you manage to solve it.

Thanks

Re: CA certificate missing in database

Former Member — Tue, 05 Oct 2010 15:15:41 GMT

With certificates : database, add the company name, like MyCompany, with the letter of you custom namespace.

In our case this should be ZMyCompany, and category root CA.

Re: CA certificate missing in database

Former Member — Mon, 04 Jun 2012 20:06:39 GMT

Thanks for example Ann. I was really trying to insert the certificate in Database and got stuck with

"Choose the key from the allowed namespace" tried various values but when i entered Zmycompany. it worked. it is no where mentioned in help.sdn.com

Re: CA certificate missing in database

Former Member — Fri, 05 Aug 2016 19:29:04 GMT

go to strust --> first import Root CA and all intermediate CA's

from Menu ---> Certificate ---> Export select each cert of the above certs and in the popup select Database tab and provide a Trust Center and Description and select Root CA for root cert and Serv for Intermediate CA and Enter it will export cert to db automatically.

once you repeat the same for all Root CA and Inter CA import the CSR response.

Thanks

Venkatesh