An Ingres Blog / Install Ingres via openSUSE’s zypper

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.