STAR 5.02 at ISC causes 952 error.
Posted in 1994
Dear Informix gurus! Could somebody please help me?
We had ordered Informix software for Interactive Unix
SVR3.2 v.4.0, but we got Informix products for Interactive Unix SVR3.2 v.3.0.
Any attempt to connect IBM PC to Unix server causes a trouble. That is
a description of our trouble.
The environment:
Server AT-486 16 MB:
Informix OnLine 5.02.UC2 for INTER./IX 386 R3.2 3.0
Informix Star TCP/IP 5.02.UC2 for INTER./IX 386 R3.2 3.0
Interactive Unix SVR3.2 4.0
Client AT-486 16 MB:
HyperScript Tools 1.0
Informix-SQL 4.10.DC1
Informix-NetPC 4.10.DC1
FTP PC/TCP 2.2
MS Windows 3.1
MS-DOS 5.0
The trouble:
1. Informix OnLine server works properly. Thare is only one user at the time.
2. All local 4GL programs, dbaccess, 4GL Programmers's Environment
work properly.
3. But any attempt to connect a client to the server via Informix NetPC
and Star causes 952 error "User's password is not correct for the remote host".
4. The system files /etc/hosts, /etc/hosts.equiv, /etc/services at the server
and FTP_ETC\\hosts and FTP_ETC\\services at the client are set correctly.
5. When I take offline OnLine 5.02 and Star 5.02 and startup OnLine 4.10.UD3
and Star 4.10.UD3 the client computer works properly without any changes.
6. Two instances of OnLine 5.02 engine and Star 5.02 work properly.
The .profile: ***************************************************
MAIL=/usr/mail/${LOGNAME:?}
if [ "`tty`" != "/dev/console" ] && [ "`tty|cut -c1-7`" != "/dev/vt" ] && [ ! -z$TERM ]
then
echo "TERM=\\c"
read TERM
fi
PATH=$PATH:/usr/local/bin::/usr/lbin
HZ=100
PAGER=pg
PS1="informix$ "
INFORMIXDIR=/usr3/informix.502TBCONFIG=tbconfig
SQLEXEC=$INFORMIXDIR/lib/sqlturbo[
PATH=$INFORMIXDIR/bin:$PATH
export MAIL PATH TERM HZ PAGER PS1 INFORMIXDIR TBCONFIG SQLEXEC
VPIXCNF=$HOME/vpix/vpix.cnf
DOSPATH=/usr/vpix/dosbin:.
PATH=$PATH:$DOSPATHexport DOSPATH VPIXCNF
The etc/tbconfig file: ***************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /usr3/informix.502/chunks/cook1 # Path for device containing root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes)
ROOTSIZE 10000 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration
MIRROR 0 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing root dbspace mirror
MIRROROFFSET 0 # Offset into mirror device (Kbytes)
# Physical Log Configuration
PHYSDBS rootdbs # Name of dbspace that contains physical log
PHYSFILE 1000 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 6 # Number of logical log files
LOGSIZE 500 # Size of each logical log file (Kbytes)
# Message Files
MSGPATH /usr3/informix.502/online.log1 # OnLine message log pathname
CONSOLE /dev/console # System console message pathname
# Archive Tape Device
TAPEDEV /dev/null # Archive tape device pathname
TAPEBLK 16 # Archive tape block size (Kbytes)
TAPESIZE 10240 # Max amount of data to put on tape (Kbytes)
# Logical Log Backup Tape Device
LTAPEDEV /dev/null # Logical log tape device pathname
LTAPEBLK 16 # Logical log tape block size (Kbytes)
LTAPESIZE 10240 # Max amount of data to put on log tape (Kbytes)
# Identification Parameters
SERVERNUM 1 # Unique id associated with this OnLine instance
DBSERVERNAME tern11 # Unique name of this OnLine instance
# Shared Memory Parameters
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)USERS 20 # Maximum number of concurrent user processes
TRANSACTIONS 20 # Maximum number of concurrent transactions
LOCKS 2000 # Maximum number of locks
BUFFERS 200 # Maximum number of shared memory buffersTBLSPACES 200 # Maximum number of active tblspaces
CHUNKS 8 # Maximum number of chunks
DBSPACES 8 # Maximum number of dbspaces and blobspaces
PHYSBUFF 32 # Size of physical log buffers (Kbytes)
LOGBUFF 32 # Size of logical log buffers (Kbytes)LOGSMAX 6 # Maximum number of logical log files
CLEANERS 1 # Number of page-cleaner processes
SHMBASE 0x0 # Shared memory base address
CKPTINTVL 300 # Checkpoint interval (in seconds)
LRUS 8 # Number of LRU queues
LRU_MAX_DIRTY 60 # LRU modified begin-cleaning limit (percent)
LRU_MIN_DIRTY 50 # LRU modified end-cleaning limit (percent)
LTXHWM 80 # Long TX high-water mark (percent)
LTXEHWM 90 # Long TX exclusive high-water mark (percent)
# Machine- and Product-Specific Parameters
DYNSHMSZ 0 # Dynamic shared memory size (Kbytes)
GTRID_CMP_SZ 32 # Number of bytes to use in GTRID comparision
DEADLOCK_TIMEOUT 60 # Max time to wait for lock in distributed env.
TXTIMEOUT 300 # Transaction timeout for I-STAR (in seconds)SPINCNT 0 # No. of times process tries for latch
STAGEBLOB # Reserved for INFORMIX-OnLine/Optical
# System Page Size
BUFFSIZE 2048 # Page size (do not change!)
The log file for I-Star: ***************************************************
sqlexec andy andy -p
sqlexec andy andy -p
sqlexec andy andy -p
sqlexec andy andy -p
*************************************************************************
Thanks in advance.
---------------------------------------------------------------
Andrew Yu. Grachyov | Phone +7 (095) 928-6078
TERN, Moscow, Russia | +7 (095) 925-1785
andy@tern.msk.su | Fax +7 (095) 280-3870