[KLUG Members] Informix ODBC Gehenna
Thomas
members@kalamazoolinux.org
Fri, 2 May 2003 14:59:46 -0700
>Hopefully sanity prevails. I love those "we gotta pitch everything"
>guys.
Well yes. But if you have seen the 'type a command first and ask what
we should do latter' approach of our other guy...
I really don't blame him for his attitude. I am just coming up to speed
and any change I make is like playing in traffic. I think our system
would be more stable if I just publish our root password. OK. Enough
ranting.
>Ok, no connection refused messages.
>BTW, your checkpoints are basically instantaneous (I'm assuming your
>business is open when this was taken), you might be able to move
>CKPTINTVL up a little and increase write throughput. It looks like the
>default value of 300 seconds. Just make sure CLEANERS is set to the
>number of physical drives (assuming that number is less than 10).
You da man. Thanks. I will do what I can to implement these things.
>Does your onconfig file have a NETTYPE soctcp entry? Or just an ipcshm
>entry?
/i/informix/etc/onconfig.gtyserver1 has no NETTYPE line.
Does "netstat -ap" on the server show a line like -
tcp 0 0 *:online *:*
LISTEN
Netstat -ap does not work but -a does.
The whole text is: (I figure too much information is better than not
enough)
Active Internet connections (including servers)
Proto Recv-Q Send-Q Local Address Foreign Address
(state)
tcp 0 0 192.168.1.5.1509 192.168.1.208.ftp-data
TIME_WAIT
tcp 0 2 192.168.1.5.telnet gtymis.2070
ESTABLISHED
tcp 0 0 192.168.1.5.telnet 192.168.1.54.1077
ESTABLISHED
tcp 0 0 192.168.1.5.telnet 192.168.1.64.1040
ESTABLISHED
tcp 0 0 192.168.1.5.telnet receptionist.1385
ESTABLISHED
tcp 0 0 192.168.1.5.telnet jcrawford-242.3623
ESTABLISHED
tcp 0 0 192.168.1.5.telnet jcrawford-242.3575
ESTABLISHED
tcp 0 0 192.168.1.5.telnet radiosec.4089
ESTABLISHED
tcp 0 0 192.168.1.5.telnet jprince-250.3208
ESTABLISHED
tcp 0 0 192.168.1.5.telnet 192.168.1.30.1325
ESTABLISHED
tcp 0 0 192.168.1.5.telnet dcarr-122.1970
ESTABLISHED
tcp 0 0 192.168.1.5.telnet cs-242.1188
ESTABLISHED
tcp 0 0 192.168.1.5.telnet 192.168.1.83.1493
ESTABLISHED
tcp 0 0 192.168.1.5.telnet vwhitley-242.2682
ESTABLISHED
tcp 0 0 192.168.1.5.telnet jcrawford-242.2548
ESTABLISHED
tcp 0 0 192.168.1.5.telnet iolanplus4.2122
ESTABLISHED
tcp 0 0 192.168.1.5.telnet cfleig-201.1319
ESTABLISHED
tcp 0 0 192.168.1.5.telnet vherana-242.3845
ESTABLISHED
tcp 0 0 192.168.1.5.telnet 192.168.1.30.1036
ESTABLISHED
tcp 0 0 192.168.1.5.telnet johnd-129.3826
ESTABLISHED
tcp 0 0 localhost.7940 localhost.8599
ESTABLISHED
tcp 0 0 localhost.8599 localhost.7940
ESTABLISHED
tcp 0 0 localhost.7940 localhost.8597
ESTABLISHED
tcp 0 0 localhost.8597 localhost.7940
ESTABLISHED
tcp 0 0 localhost.7942 localhost.8591
ESTABLISHED
tcp 0 0 localhost.8591 localhost.7942
ESTABLISHED
tcp 0 0 localhost.7941 localhost.8589
ESTABLISHED
tcp 0 0 localhost.8589 localhost.7941
ESTABLISHED
tcp 0 0 *.7944 *.*
LISTEN
tcp 0 0 localhost.7939 localhost.8577
ESTABLISHED
tcp 0 0 localhost.8577 localhost.7939
ESTABLISHED
tcp 0 0 localhost.7940 localhost.8573
ESTABLISHED
tcp 0 0 localhost.8573 localhost.7940
ESTABLISHED
tcp 0 0 localhost.7939 localhost.8569
ESTABLISHED
tcp 0 0 localhost.8569 localhost.7939
ESTABLISHED
tcp 0 0 localhost.7939 localhost.8567
ESTABLISHED
tcp 0 0 localhost.8567 localhost.7939
ESTABLISHED
tcp 0 0 *.7943 *.*
LISTEN
tcp 0 0 localhost.7939 localhost.8561
ESTABLISHED
tcp 0 0 localhost.8561 localhost.7939
ESTABLISHED
tcp 0 0 localhost.7939 localhost.8559
ESTABLISHED
tcp 0 0 localhost.8559 localhost.7939
ESTABLISHED
tcp 0 0 *.7942 *.*
LISTEN
tcp 0 0 localhost.7939 localhost.8553
ESTABLISHED
tcp 0 0 localhost.8553 localhost.7939
ESTABLISHED
tcp 0 0 localhost.7939 localhost.8551
ESTABLISHED
tcp 0 0 localhost.8551 localhost.7939
ESTABLISHED
tcp 0 0 *.7941 *.*
LISTEN
tcp 0 0 localhost.7939 localhost.8545
ESTABLISHED
tcp 0 0 localhost.8545 localhost.7939
ESTABLISHED
tcp 0 0 *.7940 *.*
LISTEN
tcp 0 0 *.7939 *.*
LISTEN
tcp 0 0 *.7937 *.*
LISTEN
tcp 0 0 *.7938 *.*
LISTEN
tcp 0 0 192.168.1.5.gtyserve *.*
LISTEN
tcp 0 0 *.sco-inet *.*
LISTEN
tcp 0 0 *.scohelp *.*
LISTEN
tcp 0 0 *.http *.*
LISTEN
tcp 0 0 *.sco-webs *.*
LISTEN
tcp 0 0 *.1007 *.*
LISTEN
tcp 0 0 *.1032 *.*
LISTEN
tcp 0 0 *.* *.*
CLOSED
tcp 0 0 *.1031 *.*
LISTEN
tcp 0 0 *.2049 *.*
LISTEN
tcp 0 0 *.1030 *.*
LISTEN
tcp 0 0 *.1029 *.*
LISTEN
tcp 0 0 *.6000 *.*
LISTEN
tcp 0 0 *.smtp *.*
LISTEN
tcp 0 0 *.smux *.*
LISTEN
tcp 0 0 *.printer *.*
LISTEN
tcp 0 0 *.imap *.*
LISTEN
tcp 0 0 *.pop3 *.*
LISTEN
tcp 0 0 *.time *.*
LISTEN
tcp 0 0 *.daytime *.*
LISTEN
tcp 0 0 *.chargen *.*
LISTEN
tcp 0 0 *.discard *.*
LISTEN
tcp 0 0 *.echo *.*
LISTEN
tcp 0 0 *.tcpmux *.*
LISTEN
tcp 0 0 *.finger *.*
LISTEN
tcp 0 0 *.exec *.*
LISTEN
tcp 0 0 *.login *.*
LISTEN
tcp 0 0 *.shell *.*
LISTEN
tcp 0 0 *.telnet *.*
LISTEN
tcp 0 0 *.ftp *.*
LISTEN
tcp 0 0 *.sunrpc *.*
LISTEN
udp 0 0 *.7940 *.*
udp 0 0 *.7938 *.*
udp 0 0 *.1007 *.*
udp 0 0 *.1058 *.*
udp 0 0 *.989 *.*
udp 0 0 *.988 *.*
udp 0 0 *.1056 *.*
udp 0 0 *.1055 *.*
udp 0 0 *.2049 *.*
udp 0 0 *.177 *.*
udp 0 0 *.1041 *.*
udp 0 0 *.snmp *.*
udp 0 0 *.time *.*
udp 0 0 *.daytime *.*
udp 0 0 *.chargen *.*
udp 0 0 *.discard *.*
udp 0 0 *.echo *.*
udp 0 0 *.ntalk *.*
udp 0 0 *.biff *.*
udp 0 0 *.1026 *.*
udp 0 0 *.* *.*
udp 0 0 *.1025 *.*
udp 0 0 *.sunrpc *.*
udp 0 0 *.1024 *.*
udp 0 0 *.* *.*
udp 0 0 *.488 *.*
udp 0 0 *.* *.*
Active UNIX domain sockets
Address Type Recv-Q Send-Q Conn Addr
fce96288 stream 0 0 0
/usr/tmp/scohelp.sock
et
fce99180 stream 0 0 fce98b08
fce98b08 stream 0 0 fce99180
fce99210 stream 0 0 fce992a0
fce992a0 stream 0 0 fce99210
fce99330 stream 0 0 fce993c0
fce993c0 stream 0 0 fce99330
fce99450 stream 0 0 fce994e0
fce994e0 stream 0 0 fce99450
fce99ba0 stream 0 0 fce99c30
fce99c30 stream 0 0 fce99ba0
fce982e0 stream 0 0 fce98370
fce98370 stream 0 0 fce982e0
fce98640 dgram 0 0 fce968b8
fce986d0 dgram 0 0 fce968b8
fce98d48 stream 0 0 0 /dev/printer
fce97b48 dgram 0 0 fce968b8
fce963a8 stream 0 0 fce96438
fce96438 stream 0 0 fce963a8
fce964c8 stream 0 0 fce96678
fce96558 stream 0 0 0
/pmd/PMDCT_pipe
fce96678 stream 0 0 fce964c8
fce96708 stream 0 0 0 /pmd/LST_pipe
fce96798 stream 0 0 0
/pmd/IPCCT_pipe
fce96828 dgram 0 0 fce968b8
fce968b8 dgram 0 0 0 /dev/syslog
I think the line your looking for is only one that lists CLOSED. This
business has many atHackers so security is a big issue.
Thank for looking.
-Thomas