Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Tell us about your experience with the "Oracle Enterprise Manager App for Grafana ”
Answers
-
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
-
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.
-
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
Thanks a lot,
Stefan
-
-
This is great! BTW, just to confirm this special character ":" was in EM password i’d assume?
-
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
-
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
-
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.