All my nginx logs get stored in elastic search.I am using grafana to derive patterns from this log.
Results for query "grafana mysql"
I try to install the grafana and followed the instruction
git clone https://github.com/grafana/grafana.
How do you configure Grafana authentication to go through Okta?I've been trying to setup Grafana's auth.
Does grafana support MongoDB as a data source (given that all the MongoDB documents are structured and have a time field)?There is no support for mongoDB at the moment.
I am trying to configure a session timeout for user inactivity on Grafana dashboard.I would like to know what the default timeout is for user inactivity.
Does anyone have created dashboard for Grafana with collectd and Prometheus.All dashboard on grafana site for Prometheus isn't created for collectd collector.
I need to customize Grafana.I have created 2 organization and some users.
In Grafana I have a table that is populated by a MySQL query like this:
SELECT col1, col2 FROM Table
WHERE StartDate = subdate(current_date, 1);
Effectively this gives me the results from the rows related to yesterday.I want to have a date picker that defaults to yesterday, but that a user can select any date they want.
I am doing some tests with a MySQL data-source and make use of the timefilter inside the SQL query:
// my query goes here.WHERE $__timeFilter(time_start);
which generates something like the following:
WHERE time_start >= FROM_UNIXTIME(1505207821) AND time_start <= FROM_UNIXTIME(1505229421);
Are there any variables that can give me access to the 2 timestamps that define the time range?
My question is different ways to connect mongodb with grafana
Link for reference?Right now grafana doesn't support MongoDB as a data source Using mongoDB as back-end repository
But they offer a workaround grafana simple json data source
I need to monitor Mysql using Prometheus and Grafana;
Added mysqld exporter in the client server
while starting the mysqld in the client server it reports as :
time="2017-09-05T11:42:53Z" level=info msg="Error scraping slave state: dial tcp [::1]:3306: getsockopt: connection refused" file="mysqld_exporter.go" line=824
time="2017-09-05T11:42:53Z" level=info msg="Error scraping table schema: dial tcp [::1]:3306: getsockopt: connection refused" file="mysqld_exporter.
I'm trying to create a template variable in grafana, but I'm getting this error:
Template variables could not be initialized: a.marketplace_out_products_history;
I'm using MySQL as data source.
I also have a mysql database version 5.when I want to start grafana-server service, it gives me this error:
Fail to initialize orm engine" logger=sqlstore error="Sqlstore::Migration
failed err: this user requires old password authentication.
Using Grafana with InfluxDB, I have a custom tag coming in for "Organization".Right now I have a dashboard row that repeats based on hostname.
I have Grafana set up in a Docker container (grafana/grafana image from Docker repo) with port 3000 forwarded to my localhost.1'
Originally I also have link to Graphite and some volumes and environment configuration (GF_SECURITY_ADMIN_PASSWORD only) but I suppose it does not matter.
I'm using a postgresql database on grafana that I want to visualize.Thanks to plugin I can now set a postgres db as datasource on grafana.
I did a Grafana-docker deployment with persistent storage as said in their GitHub for doing tests for my company.I would recommend the following solution:
$ docker volume create grafana-storage
$ docker volume ls
DRIVER VOLUME NAME
This is created in /var/lib/docker/volumes/grafana-storage on UNIX.
I want to integrate grafana into my react web application for analytics purpose.I want something through which I can redirect to grafana dashboard with credentials by surpassing the grafana login page , means direct dashboard page should be displayed of logged in user of grafana.
please consider me as a beginner.For this, how to set alerts in grafana dashboard?
I have installed grafana via docker.Is it possible to export and run grafana-cli on my host?