Re: HELP: Problems creating demo database --- sqlhosts error

Eddie, The only problem I can see is that the values you have set in the sqlhosts file are "eddie-db1" and "store7". These are the only two values that you can set the INFORMIXSERVER environment variable to, but you have it set to "cypres". Just alter the INFORMIXSERVER to be store7 or eddie-db1 and rerun the script. Good luck, Tracy } } I'm trying to install and demo the INFORMIX-OnLine Dynamic Server } version 7.1. I followed the instructions in the installation guides } and thought I had installed I-SQL V6.02, I-ESQL V7.11 and the } OnLine Server V7.10 correctly. As suggested in the adminstartion } guide, I next attempted to create the "store7" demonstartion data } base..... without success. The following lists the output I received } when executing the dbaccessdemo7 script. Does any INFORMIX admin/guru } spot my (most likely obvious) mistake? } } -------------------- START SCRIPT OUTPUT ----------------------- } } DBACCESS Demonstration Database Installation Script } } /usr/informix/bin/dbaccessdemo7[121]: test: Specify a parameter } with this command. } } Dropping existing stores7 database .... } } Creating stores7 database .... } } /usr/informix/bin/dbaccessdemo7[149]: se: A test command parameter } is not valid. } } } 25596: The INFORMIXSERVER value is not listed in the sqlhosts file. } Error in line 1 } Near character position 1 } } } 25596: The INFORMIXSERVER value is not listed in the sqlhosts file. } } Loading data ... } } } 25596: The INFORMIXSERVER value is not listed in the sqlhosts file. } } 25596: The INFORMIXSERVER value is not listed in the sqlhosts file. } } The creation of the demonstration database is now complete. The remainder } of this script copies the examples into your current directory. } Press "Y" to continue, or "N" to abort. } } y } } Now copying SQL command files .... } } } End of DBACCESSDEMO script. } } ---------------------------- END SCRIPT OUTPUT ----------------------------- } } Here is a copy of my latest sqlhosts file: } } #************************************************************************** } # } # INFORMIX SOFTWARE, INC. } # } # PROPRIETARY DATA } # } # THIS DOCUMENT CONTAINS TRADE SECRET DATA WHICH IS THE PROPERTY OF } # INFORMIX SOFTWARE, INC. THIS DOCUMENT IS SUBMITTED TO RECIPIENT IN } # CONFIDENCE. INFORMATION CONTAINED HEREIN MAY NOT BE USED, COPIED OR } # DISCLOSED IN WHOLE OR IN PART EXCEPT AS PERMITTED BY WRITTEN AGREEMENT } # SIGNED BY AN OFFICER OF INFORMIX SOFTWARE, INC. } # } # THIS MATERIAL IS ALSO COPYRIGHTED AS AN UNPUBLISHED WORK UNDER } # SECTIONS 104 AND 408 OF TITLE 17 OF THE UNITED STATES CODE. } # UNAUTHORIZED USE, COPYING OR OTHER REPRODUCTION IS PROHIBITED BY LAW. } # } # } # Title: sqlhosts.demo } # Sccsid: @(#)sqlhosts.demo 9.2 7/15/93 15:20:45 } # Description: } # Default sqlhosts file for running demos. } # } #************************************************************************** } # } # Added to test demo software } # } store7 onipcshm cypres shm_file } eddie-db1 onipcshm cypres shm_file } } demo_on onipcshm on_hostname on_servername } demo_se seipcpip se_hostname sqlexec } } ------------------------------------------------------------------------------ } Here are some of the relevant environment parameters: } } PATH=/usr/vue/bin:/usr/bin/X11:/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettlad } m/bin:/usr/contrib/bin/X11:/usr/informix/bin:/usr/informix/bin } LOGNAME=informix } MAIL=/var/mail/informix } USER=informix } DISPLAY=cypres:0.0 } SHELL=/usr/bin/csh } VUETERM=/usr/vue/bin/hpterm } HOME=/usr/informix } TERM=hpterm } INFORMIXSERVER=cypres } INFORMIXDIR=/usr/informix } } -------------------------------------------------------------------------------- } } } } QUESTIONS: } 1.) I don't see a store data base anywhere. Why? } 2.) Why am I receiving the following error message: } INFORMIXSERVER value is not listed in the sqlhosts file } } } Thanks a LOT in advance, } Eddie } -- ========================================================================= = Tracy W. Nedd = = Banctec Inc. - DBA = = Silver Spring, Md = = tracyn@asd.banctec.com = ========================================================================= = ALL RIGHTS RESERVED. = = This posting is copyright and may be used only for the purposes = = of professional study, or the professional exchange of information. = = Use of this posting by any commercial organization for the purposes = = of vilifying another is explicitly prohibited. = =========================================================================