topic Re: Need help on SQL DB2 extension in Extensions

Help on SQL DB2 extension

venkata_s_matta — Tue, 20 Aug 2024 13:21:53 GMT

Hello Everyone,

I am new to building the custom extension 2. 0

I created the YAML as per the documentation and I am trying to build the extension, i am getting the below error messages in VSCODE

Property minDynatraceVersion is not allowed.

Property author is not allowed.

Property sqlDb2 is not allowed.

Could you please help me here how to point to the right schemas here?

Re: Need help on SQL DB2 extension

TomásSeroteRoos — Mon, 05 Aug 2024 11:20:58 GMT

Sounds like you loaded in a older version of the schema. Can you try running the VSCode Load schemas command and selecting one of the newer ones? Make sure to download it when prompted.

Re: Need help on SQL DB2 extension

venkata_s_matta — Mon, 05 Aug 2024 14:08:13 GMT

Thank you. I can build and upload. When I configure it, I get the below error please let me know if I miss anything when I upload it

Failed to assign monitoring configuration to ActiveGate. Reason: Cannot extract extension from C:\ProgramData\dynatrace\remotepluginmodule\/agent/runtime\extensions\download\custom_my.sql.pcg: checking signature failed

Re: Need help on SQL DB2 extension

TomásSeroteRoos — Mon, 05 Aug 2024 14:13:46 GMT

Did you follow the instructions here to upload your root certificate to the ActiveGate? VSCode takes care of most stuff for you, but uploading the certificate you'll probably have to do manually.

You can check the path of the root certificate generated by the VSCode extension in the extension settings.

Re: Need help on SQL DB2 extension

venkata_s_matta — Mon, 05 Aug 2024 20:36:27 GMT

When i did pip show dt-cli from PowerShell

Output :

Name: dt-cli
Version: 1.6.18
Summary: Dynatrace CLI
Home-page: https://github.com/dynatrace-oss/dt-cli
Author: Vagiz Duseev
Author-email: vagiz.duseev@dynatrace.com
License: Apache-2.0
Location: C:\Users\vsm754\AppData\Roaming\Python\Python312\site-packages
Requires: asn1crypto, click-aliases, cryptography, jsonschema, PyYAML, requests, typer, wheel

but for the dt ext genca

Output:
dt : The term 'dt' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:1
+ dt ext genca
+ ~~
+ CategoryInfo : ObjectNotFound: (dt:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException

Please help me what i am missing here.

Re: Need help on SQL DB2 extension

TomásSeroteRoos — Tue, 06 Aug 2024 05:38:09 GMT

Seems like you are trying to sign the extension again, which you shouldn't need to do since the VSCode extension already does that for you. What you should do is fetch the certificate VSCode generated, which is by default in a path which looks like this:

c:\Users\<username>\AppData\Roaming\Code\User\workspaceStorage\<UUID>\DynatracePlatformExtensions.dynatrace-extensions\certificates\ca.pem

You can find the exact path in the VSCode extension settings.

Alternatively, run the VSCode "Distribute certificate" command and go fetch it from the AG/OA certificate directory so that you can then upload it to the host/AG you are trying to deploy the extension on, as per the instructions the docs I linked above.

Re: Need help on SQL DB2 extension

venkata_s_matta — Mon, 12 Aug 2024 14:45:37 GMT

Thankyou it's work