Name

DB.DBA.AMAZON_IMPORT_KEY_PAIR — Uploads public key to Amazon.

Synopsis

DB.DBA.AMAZON_IMPORT_KEY_PAIR ( in aws_access_key varchar ,
in key_name varchar ,
in public_key_material varchar ,
in secret_key varchar ,
in http_proxy varchar (default null) );

Description

Uploads public key to Amazon

Parameters

aws_access_key

Amazon Access Key ID.

key_name

New name of key, which will be used on Amazon lists.

public_key_material

base64 encoded public key.

secret_key

AWS Security Token.

http_proxy

Proxy server, can be null or empty.

Examples

Example24.241.Simple Use

create procedure simple_test()
{
  declare access_key, sec_token, key_name varchar;
  declare pub_key, fingers, fingerPrint any ;

  access_key  := 'AKIAJI7ZL427TI5EDF5A'; -- amazon manager site access key
  ec_token    := 'CGI/UMaXf2LRUctaj/HGJ57UNy/t7fNCshh8wpJg'; -- amazon manager site secret token
  key_name    := 'my_key';
  pub_key     := encode_base64 (cast (xenc_pubkey_DER_export (key_name) as varchar));
  pub_key     := encode_base64(pub_key);
  fingers     := xtree_doc(DB.DBA.AMAZON_IMPORT_KEY_PAIR (access_key, key_name,   pub_key, sec_token));
  fingerPrint := xpath_eval('/ImportKeyPairResponse/keyFingerprint', fingers, 0);

  if (fingerPrint is not null)
    return 1;
  else
    return 0;
}
;