Grafana installation configuration Influxdb installation configuration

Grafana installation configuration. txt

Installation
Https://grafana.com/grafana/download
wget https://s3-us-west-2.amazonaws.com/grafana-releases/release/grafana-4.2.0-1.x86_64.rpm
Yum Localinstall grafana-4.2.0-1.x86_64.rpm

Cli
Influx-host ' 192.168.100.74 '-port ' 8086 '-username ' UserA "-password ' Pwda '-database ' DbA '-import-path=grafana_data_d Emo

Example Plugin
GRAFANA-CLI Plugins Install Grafana-example-app
GRAFANA-CLI Plugins Install Raintank-worldping-app

Drawing
Https://www.youtube.com/watch?v=sKNZMtoSHN4&index=7&list=PLDGkOdUX1Ujo3wHw9-z5Vo12YLqXRjzg2

Dashboard API
http://docs.grafana.org/http_api/dashboard/

Generate Dashboard in the application: (Idea, not yet verified)
Manually create a dashboard on the interface, click on the view JSON----settings, you can see a JSON definition of dashboard, and note that the "rows" stored in the chart in Dashbaord
In the app, follow the Create/update dashboard in this API, and fill it out as above, and you should be able to create dashboard with the good one chart.

Switch to HTTPS (requires a SLL certificate to be generated)
OpenSSL Req-new-key https-grafana.key-out HTTPS-GRAFANA.CSR
OpenSSL x509-req-days 365-in https-grafana.csr-signkey https-grafana.key-out https-grafana.crt
Or: OpenSSL req-x509-nodes-days 365-newkey rsa:2048-keyout https-grafana.key-out https-grafana.crt This command should be a replacement for the above two lines. Take a closer look
Find a reference to SSL-generated certificates: Http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.2.18/bk_ambari-user-guide/content/_setup_ Https_for_grafana.html


Admin Password modification: Do not need grafana-cli reset-admin-password what directly on the Web page can be modified

STMP linux server to send mail locally
(only from the server sent to operations and other personnel of the public network mailbox can not be sent to the Linux server Linux servers do not need to configure the public network mail address)

Grafana Brief introduction of small books
Https://xtutu.gitbooks.io/influxdb-handbook

Modify_grafana.ini is the modified configuration can be compared with the newly installed configuration to know which

Attention:
Grafana was elected to connect DataSource in the server because of the need to pass a large number of SQL statements from the browser to the server, at this time if you use a mainstream firewall and open the relevant web security, the firewall will consider these SQL is a malicious injection attack, thereby intercepting the request, Causes this DataSource test to always return 502.
The solution is: on the router to open the VPN, so that the office to connect to the computer room VPN, HTTPS. Of course, it's also possible to turn off web protection for firewalls, but that's not advisable.

Modify Grafana.ini:

protocol = HTTPS
Http_port = 3001
Root_url = http://grafana.proooogram.com:3001
Cert_file =/ETC/GRAFANA/HTTPS-GRAFANA.CRT
Cert_key =/etc/grafana/https-grafana.key
Enabled = True
Host = Localhost:25
User =test
from_address = [email protected]
From_name = Grafana.proooogram
Welcome_email_on_sign_up = True

Grafana_data_demo.txt:

# DDL
CREATE DATABASE IF not EXISTS mydb
CREATE RETENTION POLICY oneday on mydb DURATION 1d REPLICATION 1

# DML
# context-database:pirates
# Context-retention-policy:oneday

Treasures,captain_id=dread_pirate_roberts value=801 1439856000
Treasures,captain_id=flint value=29 1439856000
Treasures,captain_id=sparrow value=38 1439856000
Treasures,captain_id=tetra value=47 1439856000
Treasures,captain_id=crunch value=109 1439858880

==========================================================

INFLUXDB installation configuration. txt

Installation is simple, the main need to understand the concept

Influxdb Brief introduction of small books
Https://xtutu.gitbooks.io/influxdb-handbook

====================

Https://github.com/proooogram/memory_aid.git

Grafana installation configuration Influxdb installation configuration