Wednesday, 9 June 2010

Install and configure the Amazon RDS Command Line Tools

On Windows XP

1. Ensure that JAVA version 1.5 or higher is installed on your system: (java -version). Java SE 1.6 works.
2. Download the latest deployment zip file from here and unzip in "c:\program files\amazon\aws\rdscli" on windows.
3. Set the following environment variables:
3.1 AWS_RDS_HOME - The directory where the deployment files were copied to
        check with: dir %AWS_RDS_HOME%\bin should list rds-describe-db-instances ...)
3.2 JAVA_HOME = "C:\Program Files\Java\jre6" (Java Installation home directory).
3.3 EC2_REGION = eu-west-1
3.4 EC2_URL =
4. Add "%AWS_RDS_HOME%\bin" to your path.

Provide the command line tool with your AWS user credentials. There are two ways you can provide credentails: AWS keys, or using X.509 certificates.

Using AWS Keys:
1. Create a credential file: The deployment includes a template file %AWS_RDS_HOME%/credential-file-path.template. Edit a copy of this file to add your information.

2. There are several ways to provide your credential information:
      a. Set the following environment variable: AWS_CREDENTIAL_FILE=<the file created in 1> e.g. AWS_CREDENTIAL_FILE = %AWS_RDS_HOME%\credential-file-path.template
      b. Alternatively, provide the following option with every command --aws-credential-file <the file created in 1>
      c. Explicitly specify credentials on the command line: --I ACCESS_KEY --S SECRET_KEY
Using X.509 Certs:
1. Save your cetificate and private keys to files: e.g. my-cert.pem and my-pk.pem.

2. There are two ways to provide the certificate information to the command line tool:
    a.  Set the following environment variables:
    b.  Specify the files directly on command-line for every command:
        <command> --ec2-cert-file-path=/path/to/my-cert.pem --ec2-private-key-file-path=/path/to/my-pk.pem

Check that your setup works properly, run the following command:
   $ rds --help
      You should see the usage page for all RDS commands.
   $ rds-describe-db-instances --headers
      You should see a header line. If you have database instances already configured, you will see a description line for each database instance.


Anonymous said...

This guide was a great help for me - thanks!

Steve Hersh said...

Thanks for the great giude. Really helped me get going.

Nerdboy said...

Thanks - why Amazon don't provide instructions this concise I have no idea!

Janaka Abeywardhana said...

Thanks everybody, happy that you are finding this useful.

Anonymous said...

when I run rds --help I get an error "The sytem cannot find the path specified".

The environmenta variables are set correctly.

Anonymous said...

I am getting a "The system cannot find the path specified" when I run "rds --help" in a CMD window. I have setup the variables exactly as desrcibed and checked the paths, on a Windows & laptop.

Any ideas were Im going wrong?

Janaka Abeywardhana said...

Is the RDS cli install location set on your PATH? if not have you changed dir to the install path - sorry about the back to basics approach?

Anonymous said...

yes the PATH system vaible is present "%AWS_RDS_HOME%\bin". I can "dir %AWS_RDS_HOME%\bin " to this location which shows me the directory listing as expected. I loaded CMD as an Administrator.

geekwithlasers said...

me too. in my xp windows is ok. but when i try to acess using win7 i get a error like 'The sytem cannot find the path specified', why ?

Steve said...

So frustrating... I get the "The sytem cannot find the path specified" on Win7 as well. Argh.