[Openroad-users] install ingres on Debian

[Paul White]

Can anyone provide some tips for installing OpenROAD on Debian?

We are installing 4.1sp3 on ubuntu (similar to debian).
Our first problem is a failure to run mklicense because there is no rpm
installer on this box.

We are currently trying to set up alien which converts the .rpm file to a
.deb format.
I'm sure we'll get it sorted. Michael's notes below have been helpful. Also
this link http://opensource.ingres.com/projects/ingres/forum/10/754190543741

Paul




-----Original Message-----
From: info-ingres  On Behalf Of michael
Sent: Wednesday, 14 June 2006 8:20 PM
To: info-ingres
Subject: [Info-ingres] Re: install ingres on Debian

Michael Touloumtzis wrote:
> On Tue, 13 Jun 2006 03:45:28 -0400, m-angel wrote:
> > hi , i'll like install ingres on debian , with dpkg extract the
> > binaries files but the  config files are missing  , can somebody help
me?
>
> It might be possible to do the install with "alien". See:
> http://opensource.ingres.com/projects/ingres/forum/10/754190543741

We have succesfully used alien to install Ingres on Debian.

I only have notes to hand for a Net install on Debian. (We do have full
installs running on Debian as well. Just not in production, so it's not
documented very well)

These are some highlights from my notes for a Net install:

- sudo apt-get install alien
- Convert all the .rpms to .debs (I didn't note the command line, but it's
not hard to figure out from the alien man page)
- read through the ingres_express_install, there is a line at the bottom
which reads something like this:
PKGLST='dbms net abf c2audit das esql ice jdbc odbc ome qr_run rep star
tuxedo vision spatial'

This lists the order in which the install script installs the rpms.

(The install script also does a bunch of mucking about to generate an .rpm
in /tmp/ which is the GPL license module. As it's debian you're talking
about you are probably ok with the GPL and the .debs generated by alien
aren't dependent on it, so don't worry about trapping it's creation in /tmp)

The first step is to install the core ingres package:
sudo dpkg -i ingres2006_9.0.4-104_i386.deb Then install any modules you
need:
eg. for a Net only install on debian
sudo ingres2006-net_9.0.4-104_i386.deb
ingres2006-odbc_9.0.4-104_i386.deb
for a fuller install, just install in the same order as PKGLST.

(Alien and dpkg might be clever enough to install everything in the right
order if you just do sudo dpkg -i *.deb, but I haven't actually tried that
yet).

- ls /opt/Ingres/ -- should contain IngresII

- create an Ingres user and give it ownership of everything in /opt/Ingres/
sudo /usr/sbin/adduser ingres  sudo chown -R ingres:ingres
/opt/CA/IngresII/.

- grab a .ingIIbash file from a rpm system and stick it in
/opt/Ingres/IngresII/.ingIIbash

The basic packages you need are installed, now you need to run the ingres
setup scripts that are appropriate for the install


- as root source /opt/Ingres/IngresII/.ingIIbash and then run mkvalidpw
(requires gcc)  (This builds a setuid binary ingres uses to verify that
passwords are correct if you want to use unix authentication so it may be
optional for you).

- log in as ingres and source /opt/Ingres/IngresII/.ingIIbash (you might
want to add it to your profile)

- because we only do a net install on ingres we run iisuodbc and iisunet If
you are doing a full install you will want to at least run iisudbms

- as ingres run ingstatus, you should see whatever you installed is there
but not running.

ingres at deb5:~$ ingstatus
Ingres II name server (iigcn)               - not active
Ingres II Net server (iigcc)                - not active
Ingres II Data Access server (iigcd)        - not active
Ingres II JDBC server (iijdbc)              - not active


- run ingstart to start the install for the first time. (fingres
crossed)

You will also need to create and install an /etc/init.d/ script or similar.
Using /etc/init.d/skeleton as a base and examining the ingres startup script
on a rpm type system should get that sorted for you pretty quickly.

You will definitely need to spend a while getting to grips with cbf and what
all the bits and pieces in it do, out of the box Ingres on linux is still
pretty dire.

It has been a while since I did a full ingres install on Debian, and my
notes only cover a net install so there may be a step or two I've missed.
For instance, I can't remember off the top of my head if iisudbms creates a
log file, if it doesn't you will need to create one in cbf before running
ingstart or bad things will happen.

I haven't actually done an in place upgrade of Ingres on a debian system.
We only currently use the Net components in production I haven't needed to
do it yet.
(We just remove the old net install and do a new one, with things like
response files it's almost all scriptable.)

If you are doing a full install based on .debs generated by alien, and you
know you will need to ugprade it in place then you are going to have to
figure out how to do it beforehand and test it lots on a separate test
system.


As the other Michael said in response to you earlier, a tar bar release
would be much nicer.

Some day it might be as simple as adding a line to /etc/apt/sources.list and
using apt.
For us it was easier to just use CentOS in production rather then building
and testing our own repository.

Hopefully this should be enough to get you started anyway.

Michael