Re: Informix (ESQL) on Linux install

On Wed, 29 Jul 1998 21:09:49 GMT, xkahn2@my-dejanews.com wrote: >In article <6p7v2j$950$1@nnrp1.dejanews.com>, > yeunw000@my-dejanews.com wrote: > >> Probably you want to do the following while logged in as root: >> >> #create the informix user and make a directory to hold the server >> >> adduser informix >> mkdir /usr/local/informix >> cd /usr/local/informix >> unzip /your-path-to-zip-file/informix_se___esql_c_bundle_for_linux.zip >> >> #go to the newly created directory, remember to export the INFORMIXDIR >> #environment variable or 'installse' complains, and run the install program >> >> cd /usr/local/informix/LINUX_se_bundle724UC5/SE >> export INFORMIXDIR=/usr/local/informix/LINUX_se_bundle724UC5/SE>> ./installse >> >> This is as far as I've gotten. There's still quite a bit of documentation to >> read. >> >> Hope that's helpful. > > > Hmm... I'd figured this part out myself. I have all three free >packages. I've been testing the SE package, and it works great. So then I >decided to test ESQL. Hmm... I have it installed alright... Here's the >directory structure: > >drwxr-xr-x 10 informix informix 1024 Jul 23 20:08 ESQLC >drwxr-xr-x 7 informix informix 1024 Jul 23 20:07 ICONNECT >-r--r--r-- 1 informix informix 709 Jul 14 11:20 README.TXT >-r--r--r-- 1 informix informix 694 Jul 14 11:20 README.UNX >drwxr-xr-x 11 informix informix 1024 Jul 27 20:20 SE > > I go into ESQLC, and run ./bin/esqldemo7 ... It complains about not >finding .../SE/demo/esqlc/mkstores! Uh oh... So I change INFORMIXDIR... >Nope. That gets me closer, but it's a false lead. Obviously I missed >something important. What is it? I think all this is wrong. I couldn't find a clear and consice description of how to install this animal. Here's however how I did it and that seems to work. It's based on the traditional way of installing Informix products on other Unix machines. If Informix, the IIUG or anyone else wants to use this (possibly with some modifications) to post on their web site, include with the product or whatever they are of course free to do so. I do however want to hear about any changes to learn more about how to do this. Do all the following while you are loged in as root: 1. Download or install the distribution files in some temporary directory. Not the one where you plan to install the product. If you downloaded from the Informix site you need to unzip the files. If you have the CD you can use them directly off that. You end up with 3 tar files called ESQL.TAR, SE.TAR and CONNECT.TAR. If you unziped them they are probably in three similarly named directories (ESQLC, SE and ICONNECT respectively). 2. Create a group called informix 3. Create a user called informix and let this user be a member of the informix group and no other. I usually set the home directory of the informix user to the directory where the Informix programs will be installed. 4. If it isn't allready done above: Create the directory where you want the Informix programs to be installed. Probably something like /usr/local/informix or wherever it's common to install local binaries and supporting files on Linux. 5. Set informix as owner and group on this directory and mode 755. 6. Set the INFORMIXDIR environement variable to the full path of this directory. I.e. like this if you used the above directory: export INFORMIXDIR=/usr/local/informix 7. Change to this directory. Now you need to install each product in a spesific order. The rule is TEN where: T = Tools (ESQL/C in this case) E = Engine (SE in this case) N = Network (I-Connect in this case). Do as follows: 8. Use tar to install the files for ESQL/C: tar xvf /your_path_to_this_file/ESQL.TAR 9. Type: ./installesql Then do as you are told including typing in the exact Serial number and key that you got when you downloaded the product. 10. Remember you are still supposed to be in the same directory, the one defined by INFORMIXDIR above. Use tar again to install the SE engine: tar xvf /your_path_to_this_file/SE.TAR 11. Type: ./installse Then do as you are told including typing in the exact Serial number and key that you got when you downloaded the product. 12. Remember you are still supposed to be in the same directory, the one defined by INFORMIXDIR above. Use tar again to install the I-Connect product: tar xvf /your_path_to_this_file/CONNECT.TAR 13. Type: ./installconn Then do as you are told including typing in the exact Serial number and key that you got when you downloaded the product. 14. Change to the etc subdirectory of the INFORMIXDIR directory you are still in. Copy the sqlhosts file found there to another name: cp sqlhosts sqlhosts.org Now you must edit the sqlhosts file. Towards the end it contains the following two lines: demo_on onipcshm on_hostname on_servernamedemo_se seipcpip se_hostname sqlexec Delete the first of these two lines. That's for the Informix Dynamic server which isn't ported yet. (If you have one on installed on another machine you can define it here for remote access, but don't do that until the SE engine works localy. Do delete that line now.) On the last remaining line you change only the se_hostname entry to the real name of your machine. You may also want to change the seipcpip for two reasons: a. This entry means that the communication between your programs and the database engine will be via unnamed pipes. For some reason that may not work on your version of Linux. b. The alternative is to write sesoctcp instead for this entry. That means tcp/ip will be used for communication between your programs and the database engine even when both run on the same machine. Save this file with the same name and location ($INFORMIXDIR/etc/sqlhosts). If you used seipcpip in the second position on the line above you are now finished with the basic installation of the programs from Informix. You still have to set up users properly though. If you used sesoctcp for tcp/ip based connection to the engine you also have to change the /etc/service file. You then add the following line to that file: sqlexec 1526/tcp # Informix SE If this is the last line in that file you should make sure there is at least one blank line after it. In some cases there have been a bug where the communication didn't work without that blank line. If sqlexec should allready have an entry in the /etc/services file you may change sqlexec to anything you want, but must then also change it in the last position in the line in the sqlhosts file. If port number 1526 should allready be in use (it exists on some other line in the /etc/services file) you can use any other port number. Later if you want to communicate from other machines you have to use the same port number there. It's common to use port numbers from 1526 and up for Informix engines. Now you have finished installing the base product. You should not ever create a database while you