Table of Contents Previous Next


5 Sample BART System with Local and Remote Database Servers : 5.2 Establishing SSH/SCP Password-Less Connections
 
5.2 Establishing SSH/SCP Password-Less Connections
This section shows how the password-less SSH/SCP connections were established with the authorized public keys files.
5.2.1 Generating a Public Key File for the BART User Account
The BART user account is enterprisedb with the home directory of /opt/PostgresPlus/9.6AS.
Generation of the public key file is as follows. First, create the .ssh subdirectory in the BART user’s home directory:
[root@localhost 9.6AS]# pwd
/opt/PostgresPlus/9.6AS
[root@localhost 9.6AS]# mkdir .ssh
[root@localhost 9.6AS]# chown enterprisedb .ssh
[root@localhost 9.6AS]# chgrp enterprisedb .ssh
[root@localhost 9.6AS]# chmod 700 .ssh
[root@localhost 9.6AS]# ls -la | grep ssh
drwx------ 2 enterprisedb enterprisedb 4096 Apr 23 13:02 .ssh
Make sure there are no groups or other users that can access the .ssh directory.
Generate the public key file.
[user@localhost ~]$ su - enterprisedb
Password:
-bash-4.1$ pwd
/opt/PostgresPlus/9.6AS
-bash-4.1$ ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/opt/PostgresPlus/9.6AS/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /opt/PostgresPlus/9.6AS/.ssh/id_rsa.
Your public key has been saved in /opt/PostgresPlus/9.6AS/.ssh/id_rsa.pub.
The key fingerprint is:
de:65:34:d6:b1:d2:32:3c:b0:43:c6:a3:c0:9f:f4:64 enterprisedb@localhost.localdomain
The key's randomart image is:
+--[ RSA 2048]----+
| . .+ . |
| o .oE+ o o |
| + *o.X + |
| + .+ * |
| S o |
| . . o |
| . . |
| |
| |
+-----------------+
The following are the resulting files. id_rsa.pub is the public key file of BART user account enterprisedb.
-bash-4.1$ ls -l .ssh
total 8
-rw------- 1 enterprisedb enterprisedb 1675 Apr 23 13:04 id_rsa
-rw-r--r-- 1 enterprisedb enterprisedb 416 Apr 23 13:04 id_rsa.pub
5 Sample BART System with Local and Remote Database Servers : 5.2 Establishing SSH/SCP Password-Less Connections

Table of Contents Previous Next