Grafana Installation\OracleLinux - Revision history

R00t: /* Grafana Repo */

2016-09-26T15:23:37Z

‎Grafana Repo

2016-09-26T15:23:20Z

‎Grafana Repo

2016-09-24T02:12:34Z

2016-09-24T02:06:04Z

‎Apache Config

2016-09-24T01:28:54Z

‎Network Config

2016-09-23T18:55:33Z

2016-09-23T18:48:41Z

2016-09-23T18:47:53Z

‎Apache Config Prep

2016-09-23T18:37:27Z

2016-09-23T17:12:15Z

@@ Line 71: / Line 71: @@
 sslverify=1
 sslcacert=/etc/pki/tls/certs/ca-bundle.crt</nowiki>
-===Update repo cache===
+Update repo cache
   <nowiki>~$ sudo yum makecache</nowiki>

@@ Line 71: / Line 71: @@
 sslverify=1
 sslcacert=/etc/pki/tls/certs/ca-bundle.crt</nowiki>
-Update repo cache
+===Update repo cache===
-~$ sudo yum makecache
+ <nowiki>~$ sudo yum makecache</nowiki>
 ==Grafana, MySQL, Apache2 Installation==

← Older revision		Revision as of 02:12, 24 September 2016
Line 216:		Line 216:
	<br>		<br>
	'''NOTE:''' In order for the http reverse proxy feature to work, you '''MUST''' use a fqdn. You cannot use an IP address as the ServerName or Hostname		'''NOTE:''' In order for the http reverse proxy feature to work, you '''MUST''' use a fqdn. You cannot use an IP address as the ServerName or Hostname
		+
		+	==SELinux Allow==
		+	By default SELinux will block the reverse proxy from working. You'll see something like this:
		+	<nowiki>~$ sudo vi /var/log/audit/audit.log
		+	type=AVC msg=audit(1265039669.305:14): avc: denied { name_connect } for pid=4343 comm="httpd" dest=7009
		+	scontext=system_u:system_r:httpd_t:s0 tcontext=system_u:object_r:port_t:s0 tclass=tcp_socket
		+	</nowiki>
		+	To test and see if it's an issue with SELinux, you can do a quick test by setting it to permissive, which should maintain until the next reboot.
		+	<nowik>~$ sudo setenforce permissive</nowiki>
		+	If this does the trick, try being more specific
		+	<nowiki>~$ /usr/sbin/setsebool httpd_can_network_connect 1</nowiki>
		+	In order to fix this permanently, you can do
		+	<nowiki>~$ /usr/sbin/setsebool -P httpd_can_network_connect 1</nowiki>
		+	Or you can set SELinux to permissive across the board (semi-disabling)
		+	<nowiki>~$ sudo vi /etc/sysconfig/selinux
		+	Change
		+	SELINUX=enforcing
		+	>>
		+	SELINUX=permissive</nowiki>

@@ Line 208: / Line 208: @@
 <VirtualHost *:80>
   	ProxyPreserveHost On
-  	ProxyPass / http://127.0.0.1:3000/
+  	ProxyPass / http://127.0.0.1:3000/ retry=0 timeout=5
   	ProxyPassReverse / http://127.0.0.1:3000/
   	ServerName grafana.domain.com
@@ Line 214: / Line 214: @@
         ErrorLog logs/servername-error_log
 </VirtualHost></nowiki>

@@ Line 16: / Line 16: @@
 Also for the network config, put your FQDN in the hosts file @ /etc/hosts
   <nowiki>127.0.0.1   server.fqdn.com
-::1   server.fqdn.com</nowiki>
+::1   server.fqdn.com
 ====connect on boot====
 By default the network interface comes turned off on boot.

← Older revision		Revision as of 18:55, 23 September 2016
Line 189:		Line 189:
	httpd.conf should have an include statement to pull in all conf files from <code>/etc/httpd/conf.d/*.conf</code> like so:		httpd.conf should have an include statement to pull in all conf files from <code>/etc/httpd/conf.d/*.conf</code> like so:
	<nowiki>Include conf.d/*.conf</nowiki>		<nowiki>Include conf.d/*.conf</nowiki>
		+
		+	==Apache Config==
		+	make a backup of the default httpd.conf
		+	~$ sudo cp /etc/httpd/conf/httpd.conf /etc/httpd/conf/httpd.conf.default
		+	make sure that the following is in your httpd.conf and is NOT commented out
		+	Include conf.d/*.conf
		+	also in httpd.conf make sure to specify your host's name
		+	ServerName server.fqdn.com
		+	Make a new conf file just for this site under /etc/httpd/conf.d/<br>
		+	edit grafana.conf
		+	<nowiki>~$ sudo vi /etc/httpd/conf.d/grafana.conf
		+	add:
		+	<VirtualHost *:80>
		+	ProxyPreserveHost On
		+	ProxyPass / http://127.0.0.1:3000/
		+	ProxyPassReverse / http://127.0.0.1:3000/
		+	ServerName grafana.domain.com
		+	TransferLog logs/servername-access_log
		+	ErrorLog logs/servername-error_log
		+	</VirtualHost></nowiki>

← Older revision		Revision as of 18:48, 23 September 2016
Line 1:		Line 1:
		+	[[Grafana_Installation\|Ubuntu Installation]] \| [[Grafana_Installation\OracleLinux\|OracleLinux Installation]]
	==Overview==		==Overview==
	Grafana Installation on Oracle Linux 6.8		Grafana Installation on Oracle Linux 6.8

@@ Line 148: / Line 148: @@
 public_ol6_latest Oracle Linux 6Server Latest (x86_64)                                    36,466
 repolist: 36,659</nowiki>
+===Adding EPEL repos===
 So let's add the EPEL repos:
   <nowiki>~$ wget http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
@@ Line 163: / Line 163: @@
 public_ol6_latest Oracle Linux 6Server Latest (x86_64)                                    36,466
 repolist: 48,880</nowiki>

← Older revision		Revision as of 18:37, 23 September 2016
Line 133:		Line 133:
	secret_key = somelongrandomstringkey		secret_key = somelongrandomstringkey
	</nowiki>		</nowiki>
		+
		+	==Apache Config Prep==
		+	Before we can move on to the apache config, we need to make sure we can install the appropriate mods. If you have not added the epel repos, then you probably wont find these:
		+	<nowiki>~$ sudo yum info mod_proxy_html
		+	Loaded plugins: security, ulninfo
		+	Error: No matching Packages to list</nowiki>
		+	You can confirm you don't have the EPEL repos also:
		+	<nowiki>~$ yum repolist
		+	Loaded plugins: security, ulninfo
		+	grafana 14/14
		+	repo id repo name status
		+	grafana grafana 14
		+	public_ol6_UEKR4 Latest Unbreakable Enterprise Kernel Release 4 for Oracle Linux 6Server 179
		+	public_ol6_latest Oracle Linux 6Server Latest (x86_64) 36,466
		+	repolist: 36,659</nowiki>
		+
		+	So let's add the EPEL repos:
		+	<nowiki>~$ wget http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm
		+	~$ rpm -ivh epel-release-6-8.noarch.rpm
		+	~$ yum repolist
		+	Loaded plugins: security, ulninfo
		+	epel/metalink \| 13 kB 00:00
		+	epel \| 4.3 kB 00:00
		+	epel/primary_db \| 5.9 MB 00:00
		+	repo id repo name status
		+	epel Extra Packages for Enterprise Linux 6 - x86_64 12,221
		+	grafana grafana 14
		+	public_ol6_UEKR4 Latest Unbreakable Enterprise Kernel Release 4 for Oracle Linux 6Server 179
		+	public_ol6_latest Oracle Linux 6Server Latest (x86_64) 36,466
		+	repolist: 48,880</nowiki>

← Older revision		Revision as of 17:12, 23 September 2016
Line 106:		Line 106:
	+---------------------------------------------------------------------------------------------------------------+		+---------------------------------------------------------------------------------------------------------------+
	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> and fill in the nessesary components.
		+	<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>