how to get host's ip address of session !
Posted in 2010
A user on IDS 11.50 (RHEL 5) wanted to identify the IP address of an unknown client machine connected to the server, but 'onstat -g ses' truncated the hostname (js090731) and, with no DNS available, ping returned "unknown host." Suggestions included pinging the name from a Windows box, and correlating 'netstat -a | grep LISTEN' output for the sqlhosts service/port with the session list. The most direct answer came from IBM: query syssessions in the sysmaster database, which shows the full, untruncated hostname.
Topics: General Discussion
Dear All... I've found a strange host in my IDS 11.50.uc6 running in RedHat Enterprise 5, The following showes the host's seesion informiation : id user tty pid hostname 1600 informix JS090731 3612 js090731 I know it is js090731 host connect IDS , my question is how to get the ip address of js090731 in IDS command or shell command without asking for help of network team ?! Any suggestions are welcomed ~~
At the OS prompt enter: ping js090731 The display should show js090731's ip address. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 3, 2010 at 8:59 PM, MARS CHEN <mars@jsun.com> wrote: > Dear All... > > I've found a strange host in my IDS 11.50.uc6 running in RedHat Enterprise > 5, > The following showes the host's seesion informiation : > > id user tty pid hostname > 1600 informix JS090731 3612 js090731 > > I know it is js090731 host connect IDS , my question is > how to get the ip address of js090731 in IDS command or shell command > without asking for help of network team ?! > > Any suggestions are welcomed ~~ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0ce0b10a07abc80480f0f5bd
I've tried it , but it showes :
Unknown host JS090731
ping JS090731
Unknown host JS090731.
ping js090731
Unknown host js090731.
I don't have Domain name server in Linux , so I do ping in Windows ,
actually I just found this windows , it is :js090731-ix2k0v ,
because in "onstat -g ses" I can only see js090731 ,
that is why I can not find it ...
May I get longer string of host name in "onstat -g ses" ?
Unfortunately no.
Art=20
-----Original Message-----
From: MARS CHEN <mars@jsun.com>
Sent: Wednesday, March 03, 2010 10:24 PM
To: ids@iiug.org
Subject: Re: how to get host's ip address of session ! [19211]
I've tried it , but it showes :=20
Unknown host JS090731=20
ping JS090731=20
Unknown host JS090731.=20
ping js090731=20
Unknown host js090731.=20
I don't have Domain name server in Linux , so I do ping in Windows ,=20
actually I just found this windows , it is :js090731-ix2k0v ,=20
because in "onstat -g ses" I can only see js090731 ,=20
that is why I can not find it ...=20
May I get longer string of host name in "onstat -g ses" ?=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
Try with the command:
netstat -a|grep LISTEN |grep <service>
where <service> is the name or port number defined in the sqlhosts tcp
conection.
Whit this information, try to cross with the information of the 'onstat -g ses'
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art S.
Kagel
Sent: miércoles, 03 de marzo de 2010 09:32 p.m.
To: ids@iiug.org
Subject: RE: how to get host's ip address of session ! [19212]
Unfortunately no.
Art=20
-----Original Message-----
From: MARS CHEN <mars@jsun.com>
Sent: Wednesday, March 03, 2010 10:24 PM
To: ids@iiug.org
Subject: Re: how to get host's ip address of session ! [19211]
I've tried it , but it showes :=20
Unknown host JS090731=20
ping JS090731=20
Unknown host JS090731.=20
ping js090731=20
Unknown host js090731.=20
I don't have Domain name server in Linux , so I do ping in Windows ,=20
actually I just found this windows , it is :js090731-ix2k0v ,=20
because in "onstat -g ses" I can only see js090731 ,=20
that is why I can not find it ...=20
May I get longer string of host name in "onstat -g ses" ?=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
In sysmaster if you select from syssessions then you will get the full
hostname.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 03/03/2010 07:32:14 PM:
> Unfortunately no.
>
> Art=20
>
> -----Original Message-----
> From: MARS CHEN <mars@jsun.com>
> Sent: Wednesday, March 03, 2010 10:24 PM
> To: ids@iiug.org
> Subject: Re: how to get host's ip address of session ! [19211]
>
> I've tried it , but it showes :=20
> Unknown host JS090731=20
>
> ping JS090731=20
> Unknown host JS090731.=20
>
> ping js090731=20
> Unknown host js090731.=20
>
> I don't have Domain name server in Linux , so I do ping in Windows ,=20
> actually I just found this windows , it is :js090731-ix2k0v ,=20
> because in "onstat -g ses" I can only see js090731 ,=20
> that is why I can not find it ...=20
>
> May I get longer string of host name in "onstat -g ses" ?=20
>
>
***************************************************************************=
> ****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g