SSH & Keychain

 

Goal

We want Keychain remembers  password for SSH key, ever after rebooting.

How

Step 1:

ssh-add -K -A

Step 2:

Add two lines in .ssh/config:

UseKeychain yes

AddKeysToAgent yes

Just add the two lines in the global section (not in any Host section)

Pig, Hive & Cassandra Auth

For Pig, Use the following syntax:

R = LOAD 'cql://username:password@KeySpace/Table' USING CqlStorage();

For Hive, Use the following syntax:

hive> set cassandra.input.keyspace.username=username;

hive> set cassandra.input.keyspace.passwd=password;

Tested on DataStax Enterprise 3.1.3