Grafana Installation - Revision history

R00t at 14:56, 21 September 2016

2016-09-21T14:56:55Z

R00t at 14:55, 21 September 2016

2016-09-21T14:55:47Z

R00t at 03:17, 1 July 2016

2016-07-01T03:17:06Z

R00t at 18:40, 30 June 2016

2016-06-30T18:40:44Z

R00t: /* Configure Grafana */

2016-06-30T18:34:22Z

‎Configure Grafana

R00t at 18:33, 30 June 2016

2016-06-30T18:33:58Z

R00t: /* Setup MySQL */

2016-06-30T18:30:09Z

‎Setup MySQL

R00t: Created page with "==Add Repository== echo 'deb https://packagecloud.io/grafana/stable/debian/ wheezy main' | sudo tee -a /etc/apt/sources.list ==Add Key== curl https..."

2016-06-30T18:29:51Z

Created page with "==Add Repository== <nowiki>echo 'deb https://packagecloud.io/grafana/stable/debian/ wheezy main' | sudo tee -a /etc/apt/sources.list</nowiki> ==Add Key== <nowiki>curl https..."

New page

==Add Repository==
<nowiki>echo 'deb https://packagecloud.io/grafana/stable/debian/ wheezy main' | sudo tee -a /etc/apt/sources.list</nowiki>
==Add Key==
<nowiki>curl https://packagecloud.io/gpg.key | sudo apt-key add -</nowiki>
==Install Grafana, MySQL, Apache==
<nowiki>sudo apt-get update && sudo apt-get install grafana mysql-server apache2 -y</nowiki>
'''Note:''' Remember to document the MySQL root password.
==Setup MySQL==
<nowiki>~$ mysql -u root -p
~$ mysql> CREATE USER 'grafana'@'localhost' IDENTIFIED BY 'THISpasswordSHOULDbeCHANGED';
~$ mysql> CREATE DATABASE grafanadatabase;
~$ mysql> GRANT ALL PRIVILEGES ON grafana.* TO 'grafana'@'localhost' IDENTIFIED BY 'grafanauserpassword' WITH GRANT OPTION;
~$ mysql> exit</nowiki>
verify permissions have been granted
<nowiki>~$ mysql -u grafana -p
~$ mysql> SHOW GRANTS;
+---------------------------------------------------------------------------------------------------------------+
| Grants for grafana@localhost |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'grafana'@'localhost' IDENTIFIED BY PASSWORD '*2K21458K438UYE85A38B9Y7Y78DAEBF4T8689YK4' |
| GRANT ALL PRIVILEGES ON `grafanadatabase`.* TO 'grafana'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)</nowiki>

← Older revision		Revision as of 14:56, 21 September 2016
Line 1:		Line 1:
−	[[Grafana_Installation\|Ubuntu Installation]] \| [[Grafana_Installation\~~CentOS~~\|~~CentOS~~ Installation]]	+	[[Grafana_Installation\|Ubuntu Installation]] \| [[Grafana_Installation\OracleLinux\|OracleLinux Installation]]

	=Ubuntu 14.04 Installation=		=Ubuntu 14.04 Installation=

← Older revision		Revision as of 14:55, 21 September 2016
Line 1:		Line 1:
		+	[[Grafana_Installation\|Ubuntu Installation]] \| [[Grafana_Installation\CentOS\|CentOS Installation]]
		+
	=Ubuntu 14.04 Installation=		=Ubuntu 14.04 Installation=
	==Add Repository==		==Add Repository==

← Older revision		Revision as of 03:17, 1 July 2016
Line 1:		Line 1:
		+	=Ubuntu 14.04 Installation=
	==Add Repository==		==Add Repository==
	<nowiki>echo 'deb https://packagecloud.io/grafana/stable/debian/ wheezy main' \| sudo tee -a /etc/apt/sources.list</nowiki>		<nowiki>echo 'deb https://packagecloud.io/grafana/stable/debian/ wheezy main' \| sudo tee -a /etc/apt/sources.list</nowiki>

← Older revision		Revision as of 18:40, 30 June 2016
Line 49:		Line 49:
	secret_key = somelongrandomstringkey		secret_key = somelongrandomstringkey
	</nowiki>		</nowiki>
		+
		+	==Configure Apache2==
		+	===Enable proxy modules===
		+	<nowiki>~$ sudo a2enmod proxy proxy_http xml2enc</nowiki>
		+	===Create apache site config===
		+	Edit <code> /etc/apache2/sites-available/granfana.conf</code> or whatever you name the conf file.
		+	<nowiki>~$ sudo vi /etc/apache2/sites-available/granfana.conf
		+	<VirtualHost *:80>
		+	ProxyPreserveHost On
		+	ProxyPass / http://127.0.0.1:3000/
		+	ProxyPassReverse / http://127.0.0.1:3000/
		+	ServerName grafana.domain.com
		+	</VirtualHost></nowiki>
		+	===Enable site===
		+	<nowiki>~$ sudo a2ensite grafana.conf</nowiki>
		+	==Start Grafana==
		+	<nowiki>~$ sudo update-rc.d grafana-server defaults 95 10
		+	~$ sudo service grafana-server start</nowiki>
		+	==Restart Apache==
		+	<nowiki>~$ sudo service apache2 restart</nowiki>
		+	==Login==
		+	You should now be able to go to the site and log in.<br \>
		+	'''NOTE:''' Don't forget to setup your DNS! <br \>
		+	The default user/pass was admin:admin. I tried changing this in the grafana.ini config file, but it didn't work, so I just logged in with the default and changed it through the web portal.

@@ Line 24: / Line 24: @@
 ==Configure Grafana==
-Edit <code>/etc/grafana/grafana.ini</code>
+Edit <code>/etc/grafana/grafana.ini</code> and fill in the nessesary components.
   <nowiki>~$ sudo vi /etc/grafana/grafana.ini

← Older revision		Revision as of 18:33, 30 June 2016
Line 22:		Line 22:
	+---------------------------------------------------------------------------------------------------------------+		+---------------------------------------------------------------------------------------------------------------+
	1 row in set (0.00 sec)</nowiki>		1 row in set (0.00 sec)</nowiki>
		+
		+	==Configure Grafana==
		+	Edit <code>/etc/grafana/grafana.ini</code>
		+	<nowiki>~$ sudo vi /etc/grafana/grafana.ini
		+
		+	[database]
		+	[database]
		+	# Either "mysql", "postgres" or "sqlite3", it's your choice
		+	type = mysql
		+	host = 127.0.0.1:3306
		+	name = grafanadatabase
		+	user = grafana
		+	password = grafanauserpassword
		+
		+	[server]
		+	protocol = http
		+	http_addr = 127.0.0.1
		+	http_port = 3000
		+	domain = grafana.domain.com
		+	enforce_domain = true
		+	root_url = %(protocol)s://%(domain)s/
		+
		+	[security]
		+	admin_user = admin
		+	admin_password = SecureAdminPass
		+	secret_key = somelongrandomstringkey
		+	</nowiki>

@@ Line 13: / Line 13: @@
 ~$ mysql> exit</nowiki>
 verify permissions have been granted
-<nowiki>~$ mysql -u grafana -p
+ <nowiki>~$ mysql -u grafana -p
 ~$ mysql> SHOW GRANTS;
 +---------------------------------------------------------------------------------------------------------------+