HELP: Problems creating demo database --- sqlhosts error
Posted in 1996
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 1Near 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_servernamedemo_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/nettladm/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