From Ingres Community Wiki

Contents 1 Introduction 2 Getting Started 2.1 For More Information 3 Available Public AMIs 3.1 Current 3.2 Older 4 Basic Maintenance 4.1 Starting and Stopping Ingres VectorWise 4.2 Enabling Password Authentication for SSH access

Introduction

This page contains information about the Ingres VectorWise Amazon Machine Image (AMI) for the Amazon Elastic Compute Cloud (EC2). The AMI contains all the information needed to create a new instance of a Linux server running VectorWise.

Getting Started

From the AWS Management Console, click 'Sign in' and log in with the e-mail address and password you used when signing up for Amazon EC2.

1. From the Amazon EC2 Console Dashboard, click Instances, then Launch Instance to start the Request Instances Wizard.
2. Click My AMIs and view All Images.
3. Search for an AMI name starting with "ingres-vectorwise" or check below for the latest AMI ID.
4. Choose the Instance Type (large is fine).
5. Create a key pair. Download and save the certificate file in a secure place for later use.
6. Create a security group. On the Configure Firewall page of the wizard, enter a name for your security group and a description. Make sure that the SSH port (port 22) and the Ingres VectorWise ports (ports 27832-27839) are enabled. Note: ports 27832-27839 are the equivalent to listen addresses VW0-VW7. If you re-configure the ingres installation to use other addresses then you will need to add those ports too. (see this page on how to translate Ingres listen addresses to TCP ports)
7. Review the AMI information, then click Launch.

For More Information

• For information about launching the Ingres VectorWise AMI from Amazon Web Services (AWS) please see:

Ingres VectorWise AWS Developer Getting Started Guide

Amazon Web Services

Tips for Securing Your EC2 Instance

Sharing AMIs Safely

• For discussions or questions about the Ingres VectorWise Project or AMI see:

Ingres VectorWise Forums

• If you are new to Ingres or Ingres VectorWise, see:

A short series of tutorials and workshops

• To view the Ingres VectorWise KnowledgeBase, see:

Ingres VectorWise Knowledge Base Documents

Available Public AMIs

Current

AMI ID:	ami-8c42bde5
Name:	ingres-vectorwise-1_6-CentOS-5_5-medium-r3
Description:	Ingres Vectorwise 1.6 on CentOS 5.5
Region:	us-east
State:	Public
Architecture:	x86_64
Size:	20 GB
OS Version:	CentOS 5.5 with all updates as of 1st August, 2011
Ingres VectorWise Version:	VW 1.6.0 (a64.lnx/115)NPTL
Databases:
	name: foodmart
	owner: ingres
AMI ID:	ami-9042bdf9
Name:	ingresvw-centos-large-r6
Description:	Ingres Vectorwise 1.0 on CentOS 5.5
Region:	us-east
State:	Public
Architecture:	x86_64
Size:	50Gb
OS Version:	CentOS 5.5 with all updates as of 9th May 2011
Ingres VectorWise Version:	VW 1.0.0 (a64.lnx/114)NPTL (bld 11405)
Databases:
	name: ontime
	owner: ingres
	description: All US flight data from 1987-2010.
	more info: http://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=236&DB_Short_Name=On-Time

Older

AMI ID:	ami-8c42bde5
Name:	ingres-vectorwise-1_5-CentOS-5_5-medium-r11
Description:	Ingres Vectorwise 1.5 on CentOS 5.5
Region:	us-east
State:	Public
Architecture:	x86_64
Size:	20 GB
OS Version:	CentOS 5.5 with all updates as of May 9th, 2011
Ingres VectorWise Version:	VW 1.5.0 (a64.lnx/141)NPTL

Basic Maintenance

Starting and Stopping Ingres VectorWise

Ingres VectorWise is configured to run as the ingresVW service, which will start up and shut down cleanly with the AMI. To prevent Ingres VectorWise starting and stopping with the AMI, you can disable the ingresVW service using the chkconfig command as root:

[root@ip-10-196-241-203 ~]# chkconfig ingresVW off
[root@ip-10-196-241-203 ~]# chkconfig --list ingresVW
ingresVW       	0:off	1:off	2:off	3:off	4:off	5:off	6:off

To re-enable the service:

[root@ip-10-196-241-203 ~]# chkconfig ingresVW on
[root@ip-10-196-241-203 ~]# chkconfig --list ingresVW
ingresVW       	0:off	1:off	2:on	3:on	4:on	5:on	6:off

To start or stop Ingres VectorWise manually, use the service command as root:

[root@ip-10-196-241-203 ~]# service ingresVW start
Starting Ingres, instance VW
[root@ip-10-196-241-203 ~]# service ingresVW stop 
Stopping Ingres, instance VW

You can check the current status of the Ingres VectorWise processes using the service utility:

[root@ip-10-196-241-203 ~]# service ingresVW status
Ingres VW name server (iigcn)               - running    
Ingres VW recovery server (dmfrcp)          - running    
Ingres VW DBMS server (iidbms)              - 1 running  
Ingres VW Net server (iigcc)                - 1 running  
Ingres VW Data Access server (iigcd)        - 1 running  
Ingres VW Bridge server (iigcb)             - not active 
Ingres VW RMCMD process (rmcmd)             - running    
Ingres VW archiver process (dmfacp)         - running

Enabling Password Authentication for SSH access

By default, the Ingres VectorWise AMIs can only be accessed using the RSA/DSA key pairs used at launch time (for more information, see Ingres VectorWise AWS Developer Getting Started Guide). To enable password-authenticated access over SSH, edit the sshd configuration file:

vi /etc/ssh/sshd_config

Make the following change:

--- /etc/ssh/sshd_config.org	2009-12-08 18:10:09.000000000 -0500
+++ /etc/ssh/sshd_config	2010-06-22 18:56:13.000000000 -0400 
@@ -57,7 +57,7 @@
 # To disable tunneled clear text passwords, change to no here!
 #PasswordAuthentication no
 #PermitEmptyPasswords no
-PasswordAuthentication no
+PasswordAuthentication yes

 # Change to no to disable s/key passwords
 #ChallengeResponseAuthentication yes

Please note, using passwords for user authentication is inherently less secure than using key pairs. For more information, see Tips for Securing Your EC2 Instance.