Confluence/Installing/Database - Revision history

R00t: /* User/DB Configuration */

2018-09-24T23:43:57Z

‎User/DB Configuration

2018-09-24T23:42:49Z

‎User/DB Configuration

2018-09-24T21:00:54Z

2018-09-24T20:51:43Z

2018-09-24T20:47:03Z

2018-09-24T20:38:08Z

2018-09-24T20:37:27Z

2018-09-24T20:34:49Z

‎User/DB Configuration

2018-09-24T20:34:05Z

‎User/DB Configuration

2018-09-24T20:33:31Z

@@ Line 22: / Line 22: @@
 ~$ sudo -u postgres /usr/pgsql-9.6/bin/psql -c "create user confluence_user with encrypted password 'Password1';"
 ~$ sudo -u postgres /usr/pgsql-9.6/bin/psql -c " grant all privileges on database confluence_db to confluence_user;"</nowiki>
-next let's adjust postgresql so that you can connect to it and authenticate with a password (by default it authenticates based on the current logged in linux user without a password)
+next let's adjust postgresql so that you can connect to it and authenticate with a password (by default it authenticates based on the current logged in linux user without a password)<br/>
   <nowiki>~$ sudo vim /var/lib/pgsql/9.6/data/postgresql.conf
 #uncomment and/or change:

@@ Line 33: / Line 33: @@
 # IPv6 local connections:
 host    all             all             ::1/128                 password
 ...</nowiki>
 restart to implement changes and test connection

@@ Line 24: / Line 24: @@
 next let's adjust postgresql so that you can connect to it and authenticate with a password (by default it authenticates based on the current logged in linux user without a password)
   <nowiki>~$ sudo vim /var/lib/pgsql/9.6/data/postgresql.conf
-#uncomment:
+#uncomment and/or change:
-listen_addresses = 'localhost'
+listen_addresses = '*'
 port = 5432
 authentication_timeout = 1min</nowiki><br/>

@@ Line 45: / Line 45: @@
 =Firewall Configuration=
 by default firewalld may have to be adjusted. Here's a quick example on how to get the correct zone and then set a rule up for the postgresql service.
-  <nowiki>~$ firewall-cmd --get-active-zones
+  <nowiki>~$ sudo firewall-cmd --get-active-zones
-~$ firewall-cmd --get-default-zone
+~$ sudo firewall-cmd --get-default-zone
-~$ firewall-cmd --zone=public --add-service=postgresql</nowiki>
+~$ sudo firewall-cmd --zone=public --add-service=postgresql
 In case you were wondering about the default services and what ports they opened, check out the configuration here:
-  <nowiki>ls /usr/lib/firewalld/services/ </nowiki>
+  <nowiki>~$ ls /usr/lib/firewalld/services/ </nowiki>

← Older revision		Revision as of 20:47, 24 September 2018
Line 42:		Line 42:
	LISTEN 0 128 127.0.0.1:5432 :		LISTEN 0 128 127.0.0.1:5432 :
	LISTEN 0 128 ::1:5432 :::*</nowiki>		LISTEN 0 128 ::1:5432 :::*</nowiki>
		+
		+	=Firewall Configuration=
		+	by default firewalld may have to be adjusted. Here's a quick example on how to get the correct zone and then set a rule up for the postgresql service.
		+	<nowiki>~$ firewall-cmd --get-active-zones
		+	~$ firewall-cmd --get-default-zone
		+	~$ firewall-cmd --zone=public --add-service=postgresql</nowiki>
		+	In case you were wondering about the default services and what ports they opened, check out the configuration here:
		+	<nowiki>ls /usr/lib/firewalld/services/ </nowiki>

@@ Line 41: / Line 41: @@
   <nowiki>~$ ss -nlt | grep 5432
 LISTEN     0      128    127.0.0.1:5432                     *:*
-LISTEN     0      128        ::1:5432                    :::*
+LISTEN     0      128        ::1:5432                    :::*</nowiki>
 </nowiki>

← Older revision		Revision as of 20:37, 24 September 2018
Line 38:		Line 38:
	~$ psql -h localhost -d confluence_db -U confluence_user -W		~$ psql -h localhost -d confluence_db -U confluence_user -W
	Password for user confluence_user:</nowiki>		Password for user confluence_user:</nowiki>
		+	Verify it is listening properly
		+	<nowiki>~$ ss -nlt \| grep 5432
		+	LISTEN 0 128 127.0.0.1:5432 :
		+	LISTEN 0 128 ::1:5432 :::*
		+	</nowiki>

← Older revision		Revision as of 20:33, 24 September 2018
Line 16:		Line 16:
	Verify installation		Verify installation
	<nowiki>~$ sudo -u postgres /usr/pgsql-9.6/bin/psql -c "SELECT version();"</nowiki>		<nowiki>~$ sudo -u postgres /usr/pgsql-9.6/bin/psql -c "SELECT version();"</nowiki>
		+
		+	=User/DB Configuration=
		+	very basic, lets create a user and db
		+	<nowiki>~$ sudo -u postgres /usr/pgsql-9.6/bin/psql -c "create database confluence_db;"
		+	~$ sudo -u postgres /usr/pgsql-9.6/bin/psql -c "create user confluence_user with encrypted password 'Password1';"
		+	~$ sudo -u postgres /usr/pgsql-9.6/bin/psql -c " grant all privileges on database confluence_db to confluence_user;"</nowiki>
		+	next let's adjust postgresql so that you can connect to it and authenticate with a password (by default it authenticates based on the current logged in linux user without a password)
		+	<nowiki>~$ sudo vim /var/lib/pgsql/9.6/data/postgresql.conf
		+	uncomment:
		+	listen_addresses = 'localhost'
		+	port = 5432
		+	authentication_timeout = 1min</nowiki>
		+	<nowiki>~$ sudo vim /var/lib/pgsql/9.6/data/pg_hba.conf
		+	change the following from ident to password authentication:
		+	...
		+	# IPv6 local connections:
		+	host all all ::1/128 password
		+	...</nowiki>
		+	restart to implement changes and test connection
		+	<nowiki>~$ sudo systemctl restart postgresql-9.6
		+	~$ psql -h localhost -d confluence_db -U confluence_user -W
		+	Password for user confluence_user:</nowiki>