Interpretation of onstat -g ses, hostname column
Question: in 'onstat -g ses' output, the hostname column sometimes shows a hex string instead of a name when the client has no DNS entry — how to map it to an IP? Answered quickly: the value is just the IP in hex, split into four byte pairs and converted to decimal (e.g. a010a1e = 0a.01.0a.1e = 10.1.10.30). Two posters supplied small C programs to convert hex strings to dotted-quad form, and one noted an earlier reply's conversions were slightly wrong. Resolved.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Sometimes the hostname is the DNS entry (i.e. human readable). Other
times, when the connecting computer does not have a DNS entry, the
value is in hex (??). How can that be changed back to an IP address?
Example:
3 values for hostname from onstat -g ses:
a010a1e
a010d22
a0e0213
Mike Reetz wrote:
> Sometimes the hostname is the DNS entry (i.e. human readable). Other
> times, when the connecting computer does not have a DNS entry, the
> value is in hex (??). How can that be changed back to an IP address?
>
> Example:
>
> 3 values for hostname from onstat -g ses:
>
> a010a1e
> a010d22
> a0e0213
>
> From netstat -a connections via sqlexec with only IP addresses:
>
> 10.1.13.34
> 10.1.10.30
> 10.14.2.19
>
> How can I map from the onstat output to the one of the IPs in the
> netstat list?
>
> Thanks,
> Mike
Hexadecimal Decimal
0a 01 0a 1e => 10.1.13.30
0a 01 0d 22 => 10.1.13.34
0a 0e 02 13 => 10.14.2.19
a010a1e = (hex) a.01.0a.1e = (dec) 10.1.10.30
a010d22 = (hex) a.01.0d.22 = (dec) 10.1.13.34
a0e0213 = (hex) a.0e.02.13 = (dec) 10.14.2.19
Mike Reetz wrote:
> Sometimes the hostname is the DNS entry (i.e. human readable). Other
> times, when the connecting computer does not have a DNS entry, the
> value is in hex (??). How can that be changed back to an IP address?
>
> Example:
>
> 3 values for hostname from onstat -g ses:
>
> a010a1e
> a010d22
> a0e0213
>
> From netstat -a connections via sqlexec with only IP addresses:
>
> 10.1.13.34
> 10.1.10.30
> 10.14.2.19
>
> How can I map from the onstat output to the one of the IPs in the
> netstat list?
>
> Thanks,
> Mike
Here's some C code to build a command line tool "unhexip":
/*
Convert hexadecimal IP addresses to standard format
Doug Lawry, comp.databases.informix, 02/11/2004
*/
main(int argc, char **argv)
{
int ip, i, n[4];
char c;
if (argc == 1)
{
printf("Usage: %s hex-ip-address [...]\\n", *argv);
exit(1);
}
while (--argc)
if (sscanf(*++argv, "%x%c", &ip, &c) != 1)
printf("Invalid hex number %s\\n", *argv);
else
{
for (i = 0; i < 4; i++)
{
n[i] = ip % 256;
ip = ip / 256;
}
printf("%d.%d.%d.%d\\n", n[3], n[2], n[1], n[0]);
}
}
--
Regards,
Doug Lawry
www.douglawry.webhop.org
"Mike Reetz" <mreetz@gmail.com> wrote in message
news:6fb5b27c.0411020703.71aff71@posting.google.com...
> Sometimes the hostname is the DNS entry (i.e. human readable). Other
> times, when the connecting computer does not have a DNS entry, the
> value is in hex (??). How can that be changed back to an IP address?
>
> Example:
>
> 3 values for hostname from onstat -g ses:
>
> a010a1e
> a010d22
> a0e0213
>
> From netstat -a connections via sqlexec with only IP addresses:
>
> 10.1.13.34
> 10.1.10.30
> 10.14.2.19
>
> How can I map from the onstat output to the one of the IPs in the
> netstat list?
>
> Thanks,
> Mike
Thanks all for the replies!
Mike
Claus Samuelsen <csa@eye-bee-em.com> wrote in message news:<4187aade$0$33741$14726298@news.sunsite.dk>...
> a010a1e = (hex) a.01.0a.1e = (dec) 10.1.10.30
> a010d22 = (hex) a.01.0d.22 = (dec) 10.1.13.34
> a0e0213 = (hex) a.0e.02.13 = (dec) 10.14.2.19
>
>
> Mike Reetz wrote:
>
> > Sometimes the hostname is the DNS entry (i.e. human readable). Other
> > times, when the connecting computer does not have a DNS entry, the
> > value is in hex (??). How can that be changed back to an IP address?
> >
> > Example:
> >
> > 3 values for hostname from onstat -g ses:
> >
> > a010a1e
> > a010d22
> > a0e0213
> >
> > From netstat -a connections via sqlexec with only IP addresses:
> >
> > 10.1.13.34
> > 10.1.10.30
> > 10.14.2.19
> >
> > How can I map from the onstat output to the one of the IPs in the
> > netstat list?
> >
> > Thanks,
> > Mike
On Tue, 02 Nov 2004 10:03:06 -0500, Mike Reetz wrote:
> Sometimes the hostname is the DNS entry (i.e. human readable). Other
> times, when the connecting computer does not have a DNS entry, the value is
> in hex (??). How can that be changed back to an IP address?
<SNIP>
> How can I map from the onstat output to the one of the IPs in the netstat
> list?
Claus' translations look right to me, TBP's are off a bit.
Here's another C translator that's a bit simpler:
#include <stdlib.h>
#include <stdio.h>
#include <unistd.h>
#include <strings.h>
int main( int argc, char **argv )
{
union {
int whole;
char parts[4];
} hexnum;
char buff[1024];
while (fgets( buff, 1024, stdin ) != (char *)NULL ) {
hexnum.whole = strtol( buff, (char **)NULL, 16 );
printf( "%08x = %d.%d.%d.%d\\n", (int)hexnum.parts[0],
(int)hexnum.parts[1], (int)hexnum.parts[2],
(int)hexnum.parts[3] );
}
}
Art S. Kagel
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