Forum Stats

  • 3,837,476 Users
  • 2,262,262 Discussions
  • 7,900,294 Comments

Discussions

Tell us about your experience with the "Oracle Enterprise Manager App for Grafana ”

13468918

Answers

  • User_4HR1Z
    User_4HR1Z Member Posts: 7
    edited Sep 23, 2020 3:56AM

    Hello,

    since we are using RHEL7, curl ist at version 7.29 and does not understand --data-raw, but I think --data works for that test.

    (Updating curl would be another project...)

    added --insecure and -v and got a 401

    * About to connect() to address_of_oem port 7799 (#0)

    *   Trying ip_of_oem...

    * Connected to address_of_oem (ip_of_oem) port 7799 (#0)

    * Initializing NSS with certpath: sql:/etc/pki/nssdb

    * skipping SSL peer certificate verification

    * SSL connection using TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256

    * Server certificate:

    *       subject: CN=address_of_oem

    *       start date: Sep 01 10:15:28 2020 GMT

    *       expire date: Aug 31 10:15:28 2030 GMT

    *       common name: address_of_oem

    *       issuer: CN=address_of_oem,C=US,ST=CA,L=EnterpriseManager on address_of_oem,OU=EnterpriseManager on address_of_oem,O=EnterpriseManager on address_of_oem

    * Server auth using Basic with user '***'

    > POST /em/websvcs/restful/grafana/v1/enablestatus HTTP/1.1

    > Authorization: Basic Z3JhZmFuYTo=

    > User-Agent: curl/7.29.0

    > Host: address_of_oem:7799

    > Accept: */*

    > Content-Type: application/json

    > Cookie: grafana_session=tef%sddeq123t

    > Content-Length: 2

    >

    * upload completely sent off: 2 out of 2 bytes

    < HTTP/1.1 401 Unauthorized

    < Date: Wed, 23 Sep 2020 07:45:43 GMT

    < X-Content-Type-Options: nosniff

    < X-XSS-Protection: 1; mode=block

    < Content-Length: 0

    < X-ORACLE-DMS-ECID: 005fzP5JVWZBX7mqwonZ6G00046B0000XQ

    < X-ORACLE-DMS-RID: 0:1

    < X-ORCL-EMOA: true

    <

    * Connection #0 to host address_of_oem left intact

    Stefan

  • ganessub-Oracle
    ganessub-Oracle Member Posts: 38 Employee
    edited Sep 23, 2020 5:54AM

    Okay...Can you check the EM role of the user....In EM, goto Setup>Security>Administrators and select the EM user which is having issue and click View. And tell me the Roles and Target and  Resource Privs what you see for that EM user.

    Since the REST call is not working ,it looks to me not Grafana issue, but some authentication/authorisation issue.

  • User_4HR1Z
    User_4HR1Z Member Posts: 7
    edited Sep 24, 2020 3:37AM

    Good morning,

    attached a view from my database colleagues - trying to translate...

    Roles: EM_USER (permission to access EM), PUBLIC

    Permissions: Connect to any destination, show any destination

    permissions.png

    Thanks a lot,

    Stefan

  • User_4HR1Z
    User_4HR1Z Member Posts: 7
    edited Sep 30, 2020 8:32AM

    Problem solved !

    Do not use a : in your password !

    Stefan

    Murtaza Husain-Oracle
  • This is great! BTW, just to confirm this special character ":" was in EM password i’d assume?

  • User_4HR1Z
    User_4HR1Z Member Posts: 7

    Yes. A normal OEM login via website is possible, but curl command (tested also with pwd in '...' and enter pwd via prompt) and Grafana plugin do not work. Maybe escaping : with \ could help, but simply use other special chars like _ 😀

    Stefan

    Murtaza Husain-Oracle
  • tuckerl
    tuckerl Member Posts: 4 Blue Ribbon

    Any idea on an ETA for an EM plug-in available for Grafana 7.x versions?

    Thanks,

    -lance

  • Hi Lance,

    Our current App/plug-in is certified with Grafana v7.1.1 considering you are on Oracle Enterprise Manager 13c Release 4 Update 6. See the latest certification matrix on https://www.oracle.com/enterprise-manager/downloads/grafana-downloads.html

    Thanks,

    Murtaza

    tuckerl
  • User_O96FN
    User_O96FN Member Posts: 3 Red Ribbon


    Hello 

    This feature seems to be very cool, but we are trying to install it without success.


    Here is my configuration:


    OEM:

    Oracle Enterprise Manager Cloud Control 13c Release 4

    grafana:

    grafana-7.1.1

    oracle-emcc-app-1.0.2



    We did the installation.

    Connection from grafana to OEM source seems to be correct.

    But all dashboards are empty.

    On Grafana side, we can see red flag with following message: "Internal Server Error"

    On OMS, we can see emoms.trc a trace each time we are going on a new dashboard


    [[ACTIVE] ExecuteThread: '51' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR em.Grafana logp.251 - Error

    java.lang.NullPointerException

        at oracle.sysman.db.restfulapi.grafana.GrafanaController.getRowLimit(GrafanaController.java:485)

        at oracle.sysman.db.restfulapi.grafana.GrafanaController.fetchTimeSeriesForMetrics(GrafanaController.java:523)

        at sun.reflect.GeneratedMethodAccessor2738.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

    .....


    Could you help us with an advice?

  • Hello,

    Please ensure your OMS is successfully upgraded with Oracle Enterprise Manager Cloud Control 13c Release 4.

    Moreover, verify the patch deploy log to ensure there were no runtime errors.