I've just installed Ingres Vectorwise on Fedora 14. I did this using the ingres_install command as root, which gave me a nice graphical installer.

Once installed, I su'd to the ingres user, and ran:

$ source .ingVWbash

to install the environment.

From there, I could then run the various ingres commands available in the install's bin directory.

To create a database:

$ createdb test

Issues

• We had to give the ingres os user a password, so we could connect as it
• The accessdb command is used for maintaining users, but ingres uses operating system users to connect as. We had to make sure the Assign Password for User value was set at no.
• We had to turn off the Fedora 14 firewall to be able to connect at all. (There's probably a nicer way of doing this by configuring the firewall!)
• We had trouble logging in, and were getting invalid username password

To solve this, we ran the mkvalidpw command as root, after sourcing the .ingVWbash file from the ingres user's home area.

# pwd
/opt/Ingres/IngresVW/ingres/bin
# ./mkvalidpw
Building the password validation program 'ingvalidpw'.
Could not compile ingvalidpw: Using executable from the distribution instead.
Executable successfully installed.

After we did this (and possibly after a server bounce), we could connect as the ingres user supplying the operating system password.

Bouncing the Server

To bounce the Ingres install:

# cd /etc/init.d
# ./ingresVW stop
# ./ingresVW start

Connection Details

Here's the JDBC connection details used:

Host: hostname
Port: VW7
Username: ingres
Password: linux password for ingres user
dbname: test