[Snort-users] ip address format of iphdr in mysql

Luo, Feng (Exchange) fengluo at ...5088...
Fri Mar 22 08:54:09 EST 2002


I am searching the ip address from mysql.
**********************************************************************
mysql> select * from iphdr;
+-----+-----+------------+------------+--------+---------+--------+--------+
----
---+----------+--------+--------+----------+---------+
| sid | cid | ip_src     | ip_dst     | ip_ver | ip_hlen | ip_tos | ip_len |
ip_
id | ip_flags | ip_off | ip_ttl | ip_proto | ip_csum |
+-----+-----+------------+------------+--------+---------+--------+--------+
----
---+----------+--------+--------+----------+---------+
|   1 | 417 | 2473322920 | 2473281217 |      4 |       5 |      0 |  33361 |
247
46 |        0 |      0 |     28 |        1 |   25793 |
|   1 | 416 | 2473322920 | 2473281217 |      4 |       5 |      0 |  33361 |
244
90 |        0 |      0 |     28 |        1 |   26049 |
|   1 | 419 | 2473322920 | 2473281217 |      4 |       5 |      0 |  33361 |
255
14 |        0 |      0 |     28 |        1 |   25025 |
|   1 | 418 | 2473322920 | 2473281217 |      4 |       5 |      0 |  33361 |
250
02 |        0 |      0 |     28 |        1 |   25537 |
+-----+-----+------------+------------+--------+---------+--------+--------+
----
---+----------+--------+--------+----------+---------+
4 rows in set (0.01 sec)
**********************************************************************

How can I translate 10 integer 2473322920 and 2473281217 to the regular ip
address?

Feng



****************************************************************
Bear Stearns is not responsible for any recommendation, solicitation, 
offer or agreement or any information about any transaction, customer 
account or account activity contained in this communication.
***********************************************************************





More information about the Snort-users mailing list