Stream

Join this community to post or comment

pavan p

Discussion  - 
 
Help needed !!

We are using Grafana along with Influxdb and sensu,

We are able to setup template variable.

for eg:
SELECT mean("value") FROM "memory_total" WHERE "host" =~ /^$Hostname$/ AND $timeFilter GROUP BY time($interval) fill(none)

However, we have new requirement now,

there is one table with too many entries

In one graph, we want to display all hosts metrics.(templating won't make sense for this as we to display this in a single graph) (However, I can't write query for every host, since host changes all the time).

What's the best way to tackle this. (what are the possible values for where host = )

How can we use pattern matching for this

Thanks for any help !!

+Torkel Ödegaard
1
Add a comment...

Frank Burstein

Discussion  - 
 
Hey Folks,

Does anyone have updated material that would help out with properly installing the latest release of grafana on opendaylight boron (tsdr)? I am finding dated instructions that do not line up with the latest grafana release. Any help would be appreciated.

Regards,

Frank
1
Add a comment...
 
Hi, I have a database of events. How to define an average daily count of events for selected time interval in Grafana?
1
Torkel Ödegaard's profile photoOlexij Tkatchenko's profile photo
8 comments
 
I found exactly the same issue described for kibana: https://github.com/elastic/kibana/issues/4646
Add a comment...

haim hazak

Discussion  - 
 
Hi,
we would like to create network weather map, which will show live network traffic (similar to what cacti has. Another example : https://network-weathermap.com.
Is it something we can find in Grafana currently and if not is it in the product road map ?

Regards,
Haim 
1
Torkel Ödegaard's profile photohaim hazak's profile photo
2 comments
 
+ Torkel Ödegaard - thank you, I will 
Add a comment...
 
Just trying to connect my elasticsearch instance on aws.ec2

I am providing the url I use to connect kibana, but grafana is failing to connect saying unknown error.

my url is like http://elasticsearch-domain.com:80

this is not working with either direct or proxy
1
Add a comment...

Igor Bannicov

Discussion  - 
 
Hi all!

The situation is following: trying to create an integration between Windows Active Directory, JIRA and Grafana. All the data is kept in InfluxDB. Now, in order to may personalize the JIRA dashboard output, I would need to use the logged in username for doing some queries.

Question is: is it possible to have the username in a template variable?

Thank you in advance and sorry, if the question was already asked - didn't find any info on this.
1
Add a comment...

pavan p

Discussion  - 
 
Little help needed,

We tried to add Influxdb data source to Grafana.

However it's not working, i believe influxdb table might not be in proper format.

I'm attaching the table along with this post,

Please confirm whether db is good

Thanks for any help !!
1
Torkel Ödegaard's profile photopavan p's profile photo
9 comments
pavan p
 
+Torkel Ödegaard We did get multiple graphs from single query

SELECT mean("used_percent") FROM "mem" WHERE "host" =~ /^$Host$/ AND $timeFilter GROUP BY time($interval) fill(null)

However it's not showing any data on the graph
Add a comment...
 
Integration of logstash + elastic search + grafana.

When I am trying to merge elastic search 5.1.1 with Grafana 3.1.1 am getting the below error? Do Grafana 3.x supports elastic search 5.x. Kindly help!
{
"error": {
"root_cause": [
{
"type": "illegal_argument_exception",
"reason": "No search type for [count]"
}
],
"type": "illegal_argument_exception",
"reason": "No search type for [count]"
},
"status": 400
}
1
Saranya Duraisamy's profile photo
 
Although updated from 3.1.1 to Grafana v4.1.0-beta1 where it was mentioned that elastic 5. support is incorporated still am facing the same error. Can anyone suggest what corrections i have to make ???
Add a comment...
 
Is there a way to use WSO2 Identity Server to manage the login part of Grafana? Oauth, or so?
I would like to implement SSO with Grafana, but can't find how.
Thanks for your help.
WSO2 provides the only 100% open source enterprise platform that helps to build, integrate, analyse and manage your APIs, applications, and Web services on-premises, in the cloud and on mobile devices.
1
Add a comment...

Dean Dugger

Discussion  - 
 
Trying to add deluge bitorrent stats to grafana. There's a stats plugin for deluge, how would I go about scraping info from that and sending it to influxdb via bash/cron?

1
Add a comment...

Jonny Daenen

Discussion  - 
 
"Now delay" is not enough for accurate stats:

The issue is the following: I have a time series (in InfluxDB) that I group by 10s. The data arrives at ~1sample/s. The side effect is that the last interval is always "filling up". Using "now delay" only shifts the problem and still exhibits this behaviour as the samples after now()-xs are removed.

This also causes problems in "stat" visualizations that display the "current" value (i.e. the one of the last interval): there are continuous drops and increases. I managed to solve this issue for the stat visualization by using a time offset in my query: group by time(10s,now()). The standard time series visualization cannot be solved this way as it causes continuous jumps. 
1
Add a comment...

Yuvaraj D

Discussion  - 
 
Hi,

My requirement is to install grafana as a Azure WebApp.Can any one help me out for installing grafana as a WebApp..?
1
Add a comment...

Andrew Stickler

Discussion  - 
 
Hi - I have a Grafana dashboard with a template variable that has about 100 different values. I am noticing some performance problems with the system and wondered whether Grafana is trying to load the data in the dashboard panels for all the template values, rather than just for the currently selected template.
P.S. this is with a Graphite data source.
1
Torkel Ödegaard's profile photoAndrew Stickler's profile photo
2 comments
 
OK thanks - i'll look elsewhere for the performance issues then.
Add a comment...
 
Hi all,
I'm pretty new to Grafana and I'm trying to get my hands dirty with API...how can I modify the metrics of an existing dashboard?
1
Torkel Ödegaard's profile photoGabriele Gerbino's profile photo
2 comments
 
Hi +Torkel Ödegaard, I'm posting here because I have not found the information I needed there
Add a comment...
 
hi I am a new user. just installed grafana using homebrew. then I accessed it using http://localhost:3000
but I can't seem to find the add dashboard or connect services button. Can someone please just point me in the right direction. I want to connect elasticsearch.
1
Srinivas Mangipudi's profile photoTorkel Ödegaard's profile photo
2 comments
Add a comment...
 
Hi,

I have used Grafana(v 3.1.1) with an elastic search data source(v2.4.0) to display live system statistics. However the accuracy of the values such as the minimum and maximum when given a larger relative time period is noticeably low. Min and Max values from now -2m (to now) shows correct statistics while a larger time period such as 5 minutes show a significant difference in the data. Elastic Search querying proves that the values exist in the data source.

Is there a way to improve the levels of accuracy in the data displayed and is there a way to reduce the refresh interval to less than 5 minutes?

Thanks!

1
Add a comment...

Le Cyberian

Discussion  - 
 
Alerts for SMTP over TLS (Gmail) fails

Hi Guys,

I am trying to use Gmail SMTP to send out alerts for Grafana using 4.0.2 on Ubuntu 16.04 LTS

Everything works normal including slack alerts etc. However email doesnt sems to be quiet informative in the logging.

Logs in error:

t=2016-12-28T16:24:28+0100 lvl=info msg="Sending notification" logger=alerting.notifier type=email id=0 isDefault=false
t=2016-12-28T16:24:28+0100 lvl=info msg="Sending alert notification to" logger=alerting.notifier.email addresses=[user@gmail.com]
t=2016-12-28T16:24:29+0100 lvl=eror msg="Failed to send alert notification email" logger=alerting.notifier.email error="535 5.7.8 Username and Password not accepted. Learn more at\n5.7.8 https://support.google.com/mail/?p=BadCredentials w197sm61127112wmd.11 - gsmtp"

settings in grafana.ini

[smtp]
enabled = true
from_address = user@gmail.com
host = smtp.gmail.com:587
user = user@gmail.com
pass = passwordhere

I have checked password manually it works fine, i tried using single and double quotes for password (it does not contain special characters) does not work

Insecure Applications is enabled for the account that is used for sending emails.

Help would be appreciated, thanks!
2
Add a comment...
 
Anyone here to help a noob?

I'm trying to install Grafana on a Raspberry Pi. I tought I had succes with a install with no error's but can't seem to get the server started. I get this respons:

initscript does not exist: /etc/init.d/grafana-servergrafana-server

And that is correct. there is no file in this place. But where can I find a copy to install???

1
Torkel Ödegaard's profile photoJohan van Hulten's profile photo
2 comments
 
Thanks. Got it from this website: http://engineer.john-whittington.co.uk/2016/11/raspberry-pi-data-logger-influxdb-grafana/. But got it working now, got a version of GitHub...
Add a comment...
 
Does anyone know how to change an alert state?
1
Add a comment...

Adrianus G

Discussion  - 
 
Is there a way to change the output of multi-value template? I want to use it in an ES query like "term: (multi-value as strings separated by ','')". Currently the template is "{string list}".
Thanks
1
Add a comment...