Ever wanted to install Ingres direct from the package manager of favourite Linux distro? Well now you can, via the command line or the GUI. Bellow are the steps for getting Ingres installed into openSUSE using zypper:
There are multiple ways to install software in openSUSE via the command line. Traditionally all software is installed via YaST (Yet another Setup Tool). In openSUSE 10.2 and 10.3 the underlying install mechanism for YaST is libzypp. In this run through I will show how to install Ingres using the command line interface to libzypp, zypper. The following assumes the root account is to be used:
- (Optional) Check the current state of your repositories:
# zypper sl
# | Enabled | Refresh | Type | Alias | Name
--+---------+---------+--------+-----------------------+----------------------
1 | Yes | Yes | yast2 | OpenSuSE 10.3 debug | OpenSuSE 10.3 debug
2 | Yes | Yes | rpm-md | openSUSE-10.3-Updates | openSUSE-10.3-Updates
3 | Yes | Yes | yast2 | OpenSuSE 10.3 Non-OSS | OpenSuSE 10.3 Non-OSS
4 | No | No | rpm-md | Packman | Packman
5 | Yes | Yes | yast2 | OpenSuSE 10.3 | OpenSuSE 10.3
6 | Yes | Yes | rpm-md | VideoLan | VideoLan
7 | Yes | Yes | rpm-md | SuSE_Tools | SuSE Tools
- Add the Ingres repository:
# zypper sa http://downloads.ingres.com/Ingres2006/int.lnx Ingres
* Adding repository 'Ingres'
Repository 'Ingres' successfully added:
Enabled: Yes
Autorefresh: Yes
URL: http://downloads.ingres.com/Ingres2006/int.lnx - Verify the new repository has been added:
# zypper sl
# | Enabled | Refresh | Type | Alias | Name
--+---------+---------+--------+-----------------------+----------------------
1 | Yes | Yes | yast2 | OpenSuSE 10.3 debug | OpenSuSE 10.3 debug
2 | Yes | Yes | rpm-md | openSUSE-10.3-Updates | openSUSE-10.3-Updates
3 | Yes | Yes | rpm-md | Ingres | Ingres
4 | Yes | Yes | yast2 | OpenSuSE 10.3 Non-OSS | OpenSuSE 10.3 Non-OSS
5 | No | No | rpm-md | Packman | Packman
6 | Yes | Yes | yast2 | OpenSuSE 10.3 | OpenSuSE 10.3
7 | Yes | Yes | rpm-md | VideoLan | VideoLan
8 | Yes | Yes | rpm-md | SuSE_Tools | SuSE Tools
- Refresh/download the Ingres repository data:
# zypper ref Ingres
Refreshing 'Ingres'
repomd.xml is unsigned, continue? [yes/no]: yes
* Building repository 'Ingres' cache
Specified repositories have been refreshed. - Get a listing of the Ingres installables:
# zypper se ingres
* Reading installed packages [100%]
S | Repository | Type | Name | Version | Arch
--+------------+---------+-----------------+-----------+-----
| Ingres | package | ingres2006 | 9.2.0-114 | i386
| Ingres | package | ingres2006-abf | 9.2.0-114 | i386
| Ingres | package | ingres2006-dbms | 9.2.0-114 | i386
| Ingres | package | ingres2006-ice | 9.2.0-114 | i386
| Ingres | package | ingres2006-net | 9.2.0-114 | i386
| Ingres | package | ingres2006-odbc | 9.2.0-114 | i386
| Ingres | package | ingres2006-rep | 9.2.0-114 | i386
| Ingres | package | ingres2007-star | 9.2.0-114 | i386
- Installed the desired Ingres packages. For instance if you just require the DBMS server, Ingres/NET and ODBC:
# zypper install ingres2006-dbms ingres2006-net ingres2006-odbc
* Reading repository 'OpenSuSE 10.3 debug' cache
* Reading repository 'openSUSE-10.3-Updates' cache
* Reading repository 'Ingres' cache
* Reading repository 'OpenSuSE 10.3 Non-OSS' cache
* Reading repository 'OpenSuSE 10.3' cache
* Reading repository 'VideoLan' cache
* Reading repository 'SuSE Tools' cache
* Reading installed packages [100%]
The following NEW packages are going to be installed:
ingres2006-dbms ingres2006 ingres2006-net ingres2006-odbc
Overall download size: 24.1 M. After the operation, additional 92.4 M will be used.
Continue? [yes/no]: yes
Downloading package ingres2006-9.2.0-114.i386, 14.3 M (61.4 M unpacked)
Downloading: ingres2006-9.2.0-114.i386.rpm
* Downloading
* Installing: ingres2006-9.2.0-114 [100%]
Downloading package ingres2006-dbms-9.2.0-114.i386, 6.8 M (21.8 M unpacked)
Downloading: ingres2006-dbms-9.2.0-114.i386.rpm
* Downloading
* Installing: ingres2006-dbms-9.2.0-114 [100%]
Downloading package ingres2006-net-9.2.0-114.i386, 1.8 M (4.8 M unpacked)
Downloading: ingres2006-net-9.2.0-114.i386.rpm
* Downloading [100%]
* Installing: ingres2006-net-9.2.0-114 [100%]
Downloading package ingres2006-odbc-9.2.0-114.i386, 1.3 M (4.3 M unpacked)
Downloading: ingres2006-odbc-9.2.0-114.i386.rpm
* Downloading [100%]
* Installing: ingres2006-odbc-9.2.0-114 [100%]
The ingres2006 package has also been selected for installation since it is a depenency for the other pacakges being installed. - Verify Ingres is installed correctly:
# /etc/init.d/ingresII start
Starting Ingres, instance II
done
# . ~ingres/.ingIIbash
# sql iidbdb
INGRES TERMINAL MONITOR Copyright 2007 Ingres Corporation
Ingres 2006 Release 3 Linux Version II 9.2.0 (int.lnx/114)NPTL login
Fri Nov 9 01:51:02 2007
continue
* select dbmsinfo('_version')\g
Executing . . .
┌────────────────────────────────────────────────────────────────┐
│col1 │
├────────────────────────────────────────────────────────────────┤
│II 9.2.0 (int.lnx/114)NPTL │
└────────────────────────────────────────────────────────────────┘
(1 row)
continue
* \q
Ingres 2006 Release 3 Version II 9.2.0 (int.lnx/114)NPTL logout
Fri Nov 9 01:51:31 2007
- That’s it. Every time a new Ingres release is posted the repository it will be reommended for installation via upgrade. Determine if an update is available using
zypper lu -t package.
Preventing upgrades
If you wish to keep the installed Ingres version at the current level it is possible to prevent updates. The file, /etc/zypp/locks contains a list of packages that zypper is to ignore. To ignore any Ingres update:
# echo ingres* >> /etc/zypp/locks
Add a comment below if you have any questions.
