Table of Contents Previous Next


6 Sample BART System with Local and Remote Database Servers : 6.2 SSH/SCP Password-Less Connections : 6.2.2 Set Up Access between Local Advanced Server and BART Host

Even when the Advanced Server database is on the same host as the BART user account, and the Advanced Server database cluster owner is also the BART user account (enterprisedb is this case), a password-less SSH/SCP connection must be established from the same user account to itself.
On the BART host where the public key file was just generated as shown in Section 6.2.1, create the authorized keys file by appending the public key file to any existing authorized keys file.
Log into the BART host as the BART user account and append the public key file, id_rsa.pub onto the authorized_keys file in the same .ssh directory.
The authorized_keys file must have file permission 600 as set by the following chmod 600 command, otherwise the password-less connection fails:
Test the password-less connection. Use the ssh command to verify that you can access the same user account as you are currently logged in as (enterprisedb) without being prompted for a password:
On the remote host 192.168.2.24, create the public key file for the remote database server user account, enterprisedb, for access to the BART user account, enterprisedb, on the BART host 192.168.2.22.
Create the .ssh directory for user account enterprisedb on the remote host:
Copy the generated public key file, id_rsa.pub, to the BART user account, enterprisedb, on the BART host, 192.168.2.22:
Log into the BART host as the BART user account and append the temporary public key file, /tmp/tmp.pub onto the authorized_keys file owned by the BART user account.
The authorized_keys file must have file permission 600 as set by the following chmod 600 command, otherwise the password-less connection fails:

6 Sample BART System with Local and Remote Database Servers : 6.2 SSH/SCP Password-Less Connections : 6.2.2 Set Up Access between Local Advanced Server and BART Host

Table of Contents Previous Next