topic Re: SQL DB extension in Extensions

SQL DB extension

KDalmeida — Tue, 20 Aug 2024 17:43:04 GMT

I'm going through the steps to build an SQL extension and use Dynatrace CLI.

When I run the second command in step 4 "dt extension sign --key secrets/developer.pem"

error message "command not found: dt"

Note: I'm using this doc https://docs.dynatrace.com/docs/extend-dynatrace/extensions20/sign-extension#install-cli

Re: SQL DB extension

rudy_h — Wed, 21 Aug 2024 06:23:52 GMT

Hi,

Have you run the first command? The result should be like this:

dt extension assemble
Building extension.zip from src
Adding file: src\alerts\buffer_cache_hit.json as alerts\buffer_cache_hit.json
Adding file: src\alerts\log_usage.json as alerts\log_usage.json
Adding file: src\dashboards\overview_dashboard.json as dashboards\overview_dashboard.json
Adding file: src\extension.yaml as extension.yaml

If you failed to run the first command, you need run this command first : pip install dt-cli

Re: SQL DB extension

KDalmeida — Wed, 21 Aug 2024 19:43:49 GMT

I did a re-run of all the commands but did not get the extension.zip.sig file.

I have the bundle.zip and the extension.zip files

And when I ran the "dt extension upload bundle.zip" input my tenant url and api token I get error message:

"[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1000)"

Re: SQL DB extension

rudy_h — Thu, 22 Aug 2024 02:15:00 GMT

Hi,

How about step 3? Have you done the following steps:

Re: SQL DB extension

KDalmeida — Thu, 22 Aug 2024 18:55:45 GMT

I found the credential vault and uploaded the root file.

Re: SQL DB extension

KDalmeida — Thu, 22 Aug 2024 19:28:36 GMT

Step 1: command: "pip install dt-cli" works and the installation is completed

Step 2: ran successfully, and certificates and keys were generated. I got all the right output according to the doc.

Step 3: Added root certificate to credential vault in the UI. Uploaded successfully.

Step 4: The first command: "dt extension assemble" ran successfully and created extension.zip file

The second command: "dt extension sign --key secrets/developer.pem" only creates bundle.zip and gives no output.

How can I get the extension.zip.sig file? Please help

Re: SQL DB extension

rudy_h — Fri, 23 Aug 2024 02:08:56 GMT

Hi,

That file is in bundle.zip.

Please run the following step afterward:

If you installed the activegate in your PC, you may simply copy root.pem into the specified directory above.

Re: SQL DB extension

KDalmeida — Mon, 26 Aug 2024 16:43:00 GMT

Hi,

My ActiveGate is AWS and I copied the root.pem file to the path.

I'm still getting this error "[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1000)"

Re: SQL DB extension

rudy_h — Mon, 26 Aug 2024 23:00:23 GMT

Hi,

There are several .pem files in your secrets directory like this:

Are you sure you copy the 2 KB file? Also which file did you upload to the credential vault? Screen shot may help us to identify your fault

Re: SQL DB extension

KDalmeida — Tue, 27 Aug 2024 05:19:31 GMT

These are the files in my secrets directory.

I uploaded the ca.pem file to the credential vault from the UI

I added the ca.pem file to the Activegate host

Re: SQL DB extension

rudy_h — Wed, 28 Aug 2024 02:18:17 GMT

Hi,

Please reupload the certificate into credential vault and give us the screen shot like this one:

Fill the description with your name to check whether it has successfully shown up in the credential vault list

Re: SQL DB extension

KDalmeida — Wed, 28 Aug 2024 14:58:54 GMT

Re: SQL DB extension

rudy_h — Thu, 29 Aug 2024 02:31:33 GMT

Hi,

Please input a description and save it. The description should show up in the credential vault list in the name & description column along with your email address in the Owner column.

Once you confirm it, please make sure that you input the same tenant url (the one you used to access the credential vault) when you run the "dt extension upload bundle.zip"

Sometimes you need to type the tenant url (not copy paste) to make sure they are exactly the same.

Re: SQL DB extension

KDalmeida — Thu, 29 Aug 2024 14:06:29 GMT

Re: SQL DB extension

KDalmeida — Thu, 29 Aug 2024 19:52:23 GMT

I got the extension.zip.sig file but certificate verification is still failing when I run "dt extension upload bundle.zip"

error message "[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1000)"

Re: SQL DB extension

rudy_h — Thu, 29 Aug 2024 22:49:46 GMT

Hi,

Please check your access token:

Please show the expiration date and API v2 scopes

Re: SQL DB extension

KDalmeida — Wed, 04 Sep 2024 15:12:17 GMT

My token is right it has all the required scopes.

Re: SQL DB extension

KDalmeida — Wed, 04 Sep 2024 15:37:28 GMT

Re: SQL DB extension

rudy_h — Thu, 05 Sep 2024 02:53:06 GMT

Hi,

Please check your Python version:

Please call command for windows: python -V

Please call command for linux: python3 --version

If your python does not meet the prerequisite, please upgrade it. Python 3.8 is the minimal version. I am using 3.12.5 and it is doing fine.