Requesting Data Access
For data access, we provide a connection to the database through an SSH tunnel. Access through this SSH tunnel is protected by an IP whitelist and Public Key Cryptography. In order to gain access to the data, you will need to contact email@example.com with a request for data access and provide us with your public IP address and public key.
Finding Your Public IP Address
To find your public key for your current network, you can simply visit http://www.whatismypublicip.com/.
If you want to whitelist another network then you will need to get the public IP from your Internet Service Provider.
Generating A Public Key
When generating the keys, you will generate a public and private key pair. The public key will be provided to Intilery Support to enable us to authorise your private key on the server. The corresponding private key should be kept by yourself to authenticate your connection later.
NOTE: You should keep your private key safe and not share it with anybody. Intilery Staff will never ask you to send a private key.
For Mac/Linux OS
To generate the key pair on Mac or Linux you should run the following commands in the terminal.
ssh-keygen -t rsa -b 4096 -C "A useful comment to help you identify key"
This will then prompt for a filename to save the generated key pair
Generating public/private rsa key pair. Enter file in which to save the key (/home/xxxxxx/.ssh/id_rsa):
Give it a name which means something to you so you can easily identify your key when needed.
It will then ask you for a passphrase, this passphrase is required every time you use the generated key as part of an SSH connection.
It is recommended you specify a password comprised of random words joined together rather than a random string of characters and symbols. For example, BananaTurtleTreeClown would offer higher levels of entropy than u&97FHO!.
Once you have done this you should see a message similar to the following:
Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in keyname. Your public key has been saved in keyname.pub. The key fingerprint is: c2:af:82:78:52:dc:39:f4:9c:a4:22:5d:cb:2d:89:a7 YOUR COMMENT The key's randomart image is: +--[ RSA 4096]----+ | | | | | | | o.. | | o * Xo.S | |. * @ =o | | + = o . | |o E . . | | o .. | +-----------------+
You should now run:
ssh-keygen -y -f /path/to/private/key
And will see output that similar to the following:
This is your public key, you should copy this output and send it to firstname.lastname@example.org along with your public IP address.
For Windows OS
To generate the key pair on Windows we recommend downloading and using PuTTYgen.
In the PuTTYgen window, click the 'generate' button and then follow the instruction to move the mouse to generate randomness.
Once the key is generated, you should copy the text in the box labelled "Public key for pasting into OpenSSH authorized_keys file" and send it to email@example.com along with your public IP address.
It is recommended you specify a password comprised of random words joined together rather than a random string of characters and symbols. For example, BananaTurtleTreeClown would offer higher levels of entropy than u&97FHO! (harder for a computer to guess and easier for you to remember!). Then you should save your private key, this will generate a PuTTY compatible .ppk key file for you. This will be used for your connection later.