Re: Informix SE for Linux

> > Re: Informix SE for Linux > > From: Jonathan Leffler <jleffler@earthlink.net> > Reply to: jleffler@earthlink.net > Date: Fri, 21 Aug 1998 21:01:23 -0700 > Organization: EarthLink Network, Inc. > Newsgroups: > comp.databases.informix > Followup to: newsgroup(s) > References: > <35DD8DDC.F2B83342@planningsystems.com> >Jason Hanks wrote: >> Hello.. I've downloaded the Informix SE/Esql-C/Connect bundle for >> linux off of the Informix home page.. I tried to install it but there >> are NO kind of install documentation.. Could someone give me some >> instructions or point me in the direction of some install directions?? > >There are probably other summaries available elsewhere, but here goes: > >* Create a group informix (unless it already exists) >* Create a user informix (unless it already exists) with login group > informix. No other user should be in group informix. >* Create a directory where you are going to install the software, > which is going to be $INFORMIXDIR. Traditionally, the location is > /usr/informix; I never use that directory -- I'd rather leave it as > a symlink to the working directory so that I can upgrade by > switching symlinks. This should probably be the home directory for > user informix. >* Run the installation as root (for pre 9.x versions of Informix) and > in $INFORMIXDIR (it needs to be set at install time). >* You should have 3 product tar files if you have the SE & ESQL/C and > Connect. For each product, extract the software from the tar file. > Each product comes with a script installXYZ (where XYZ might be > se, esql, connect or whatever). Run this script; it will need a > carriage return, the licence number, the activation key and another > carriage return as input, either because you type it or because you > redirect from a file. Given that the product versions are identical, > installation order is not critical, but for good practice, I'd do > ESQL/C followed by SE -- I think that ESQL/C includes all the files > which are part of I-Connect other than the files lists, install > script and copyright files, so I probably wouldn't install I-Connect > as a separate product. I'd install I-Connect before SE if I did > install it. >* Ensure that $INFORMIXDIR/bin is on $PATH. >* Set $INFORMIXDIR if it is not /usr/informix. >* Check whether you need to set $LD_LIBRARY_PATH or equivalent; if you > do, include $INFORMIXDIR/lib and $INFORMIXDIR/lib/esql on the path. >* Decide whether you need to run sqlexecd (beware zombies; see also the > nozombie program I posted recently) -- may need a service added to > /etc/services or equivalent. >* Go! DB-Access (dbaccess) is a good starting point. > >-- >Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) >Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN >#include <disclaimer.h> I have installed Informix-SE on a minimal Debian system. Here are a few notes to make it work. 1) The first attempt to run dbaccess will complain about not finding your terminal. Solution: Add a tag 'linux' to the first 'ansi' entry found in $INFORMIXDIR/etc/termcap and copy the file to /etc 2) Second attempt with error 25596 "The INFORMIXSERVER is not listed..." Solution: Edit $INFORMIXDIR/etc/sqlhosts and copy the line that start with 'demo-se' and change demo-se to the name of your own instance (eg: test). Also change the 'on_hostname' to your own host name (get it by excuting 'hostname'). ( Note: I did not need to edit '/etc/services'.) 3) Compiling the demo 'unload.ec' will complain about a crypt not found. Solution 1: Compile with '-lcrypt' since one is supplied with Debian. Solution 2: Edit the script $INFORMIXDIR to include the 'libcrypt' library when compiling. Here is a 'diff' output of my own changes. ( Note: I did not test the -static compile yet.) # start of diff 113a114 > LOCLIB=/usr/lib/libcrypt.a 121a123 > LOCLIB=-lcrypt 363c365 < for library in $A $B $COMB $SLIB $ALIB $COMB $GLSLIB $SYSNLIB $SYSLIB $GLXLIB --- > for library in $A $B $COMB $SLIB $ALIB $COMB $GLSLIB $SYSNLIB $SYSLIB $GLXLIB $LOCLIB 368c370 < for library in $A $B $SLIB $ALIB $GLIB $OLIB $GLSLIB $SYSNLIB $SYSLIB $CHKAPI $GLXLIB --- > for library in $A $B $SLIB $ALIB $GLIB $OLIB $GLSLIB $SYSNLIB $SYSLIB $CHKAPI $GLXLIB $LOCLIB 446c448 < exec $CC $INCLUDE -I$INFDIR/incl/esql $A $BO $COMB $SLIB $ALIB $COMB $GLSLIB $SYSNLIB $SYSLIB $GLXLIB --- > exec $CC $INCLUDE -I$INFDIR/incl/esql $A $BO $COMB $SLIB $ALIB $COMB $GLSLIB $SYSNLIB $SYSLIB $GLXLIB $LOCLIB 448c450 < exec $CC $INCLUDE -I$INFDIR/incl/esql $A $BO -L$LPATH -L$LPATH/esql $SLIB $ALIB $GLIB $OLIB $GLSLIB $SYSNLIB $SYSLIB $CHKAPI $GLXLIB --- > exec $CC $INCLUDE -I$INFDIR/incl/esql $A $BO -L$LPATH -L$LPATH/esql $SLIB $ALIB $GLIB $OLIB $GLSLIB $SYSNLIB $SYSLIB $CHKAPI $GLXLIB $LOCLIB # end of diff output I hope this will help somebody. Pierre Deom (pdeom@ix.netcom.com)