Re: Solaris 8, IDSWE 7.31, WARNING: Network Down
Yes it's a problem with Solaris 8. It uses the new IPv6 in inetd, so informix
has problem conecting with socks (AFAIK).
On Solaris 7 it works OK!!!
On Mon, 24 Jul 2000, KCStout wrote:
> OS: Solaris 8
> Database Engine: Informix Dynamic Server Workgroup Edition 7.31.UC4-1
> Problems:
> 1. database initializes using oninit but the following error displays
> running onmonitor as root:
> ** WARNING: Network Down **
>
> 2. running dbaccess as informix:
> 25572: Network driver cannot bind a name to the port.
> Exec format error>
> Process of installing and initializing Informix Dynamic Server Workgroup
> Edition 7.31.UC4-1:
> 1. created informix group
> 2. created informix user
> 3. placed informix user in group
> 4. entries in /etc/hosts (see below)
> 5. added entry to /etc/services (see below)
> 6. added environment variables to /etc/profile (see below)
> 7. reboot server
> 8. installed Informix database server as root
> 9. ran onmonitor, parameters, initialize, set parameters (see end of
> message)
> 10. installed I-Connect as informix
> 11. modified /etc/system to increase shared memory segment
> 12. reboot server
> 13. oninit -iv (see excerpt from buildsmi.866)
>
> System status & settings:
> I can access the web and ping outside sources from the server.
>
> *** file: /etc/hosts
> # Internet host table
> 127.0.0.1 localhost
> 198.78.8.37 eprospector01 loghost
>
> *** file: /etc/services
> idswe2 1525/tcp # Informix Dynamic Server
>
> *** file: /usr/informix/etc/sqlhosts
> ep01_net ontlitcp eprospector01 idswe2>
> *** file: /etc/profile
> INFORMIXDIR=/usr/informix> export INFORMIXDIR
> PATH=$INFORMIXDIR/bin:$PATH> export PATH
> INFORMIXSERVER=ep01_net> export INFORMIXSERVER
> ONCONFIG=onconfig.ep01_net> export ONCONFIG
> SQLEXEC=$INFORMIXDIR/lib/sqlrm
> export SQLEXEC
> xhost +localhost
>
> # netstat -an | grep 1525
> 198.78.8.37.1525 *.* 0 0 24576 0 LISTEN
>
> *** file: /tmp/buildsmi.866
> # tail buildsmi.866
> 25572: Network driver cannot bind a name to the port.>
> Exec format error
> Error in line 3118> Near character position 1
> Cleaning up whatever was successfully created
>
> 25572: Network driver cannot bind a name to the port.>
> Exec format error
>
> #**************************************************************************
> # INFORMIX SOFTWARE, INC.
> # Title: onconfig.ep01_net
> #**************************************************************************
> # Root Dbspace Configuration
> ROOTNAME rootdbs # Root dbspace name
> ROOTPATH /dev/chunk1 # Path for raw device containing root> dbspace
> ROOTOFFSET 0 # Offset of root dbspace into device
> (Kbytes)
> ROOTSIZE 540000 # Size of root dbspace (Kbytes)>
> # Disk Mirroring Configuration Parameters
> MIRROR 1 # Mirroring flag (Yes = 1, No = 0)
> MIRRORPATH /dev/mirror1 # Path for device containing mirrored root
> MIRROROFFSET 0 # Offset into mirrored device (Kbytes)>
> # Physical Log Configuration
> PHYSDBS rootdbs # Location (dbspace) of physical log
> PHYSFILE 4000 # Physical log file size (Kbytes)>
> # Logical Log Configuration
> LOGFILES 6 # Number of logical log files
> LOGSIZE 60000 # Logical log size (Kbytes)>
> # Diagnostics
> MSGPATH /usr/informix/online.log # System message log file path
> CONSOLE /dev/console # System console message path
> ALARMPROGRAM /usr/informix/etc/log_full.sh # Alarm program path> SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path
> TBLSPACE_STATS 1>
> # System Archive Tape Device
> TAPEDEV /dev/rmt/0 # Tape device path
> TAPEBLK 16 # Tape block size (Kbytes)
> TAPESIZE 4756764 # Maximum amount of data to put on tape
> (Kbytes)>
> # Log Archive Tape Device
> LTAPEDEV /dev/rmt/0 # Log tape device path
> LTAPEBLK 16 # Log tape block size (Kbytes)
> LTAPESIZE 4756764 # Max amount of data to put on log tape
> (Kbytes)>
> # Optical
> STAGEBLOB # Informix Dynamic Server/Optical staging
> area
>
> # System Configuration
> SERVERNUM 0 # Unique id corresponding to a Dynamic> Server instance
> DBSERVERNAME ep01_net # Name of default database server
> DBSERVERALIASES # List of alternate dbservernames
> NETTYPE tlitcp,,, # Configure poll thread(s) for nettype
> DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed
> env.
> RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
>
> MULTIPROCESSOR 0 # 0 for single-processor, 1 for> multi-processor
> NUMCPUVPS 1 # Number of user (cpu) vps
> SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps to> one
>
> NOAGE 0 # Process aging
> AFF_SPROC 0 # Affinity start processor
> AFF_NPROCS 0 # Affinity number of processors>
> # Shared Memory Parameters
> LOCKS 20000 # Maximum number of locks
> BUFFERS 4750 # Maximum number of shared buffers
> NUMAIOVPS # Number of IO vps
> PHYSBUFF 128 # Physical log buffer size (Kbytes)
> LOGBUFF 128 # Logical log buffer size (Kbytes)> LOGSMAX 35 # Maximum number of logical log files
> CLEANERS 2 # Number of buffer cleaner processes
> SHMBASE 0xa000000 # Shared memory base address
> SHMVIRTSIZE 8000 # initial virtual shared memory segment size
> SHMADD 8192 # Size of new shared memory segments
> (Kbytes)
> SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
> CKPTINTVL 300 # Check point interval (in sec)
> LRUS 8 # Number of LRU queues
> LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
> LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
> LTXHWM 50 # Long transaction high water mark> percentage
> LTXEHWM 60 # Long transaction high water mark
> (exclusive)
> TXTIMEOUT 0x12c # Transaction timeout (in sec)
> STACKSIZE 32 # Stack size (Kbytes)>
> # System Page Size
> # BUFFSIZE - Dynamic Server no longer supports this configuration parameter.
> # To determine the page size used by Dynamic Server on your
> platform
> # see the last line of output from the command, 'onstat -b'.
>
> # Recovery Variables
> # OFF_RECVRY_THREADS:
> # Number of parallel worker threads during fast recovery or an offline
> restore.
> # ON_RECVRY_THREADS:@@