|
North American Network Operators Group Date Prev | Date Next | Date Index | Thread Index | Author Index | Historical Re: IP database ideas
Also, what feeds this: -- Name: attack_db Type: TABLE Owner: neteng -- CREATE TABLE "attack_db" ( "attack_type" integer, "start_time" timestamp with time zone, "end_time" timestamp with time zone, "src_router" inet, "input_int" integer, "output_int" integer, "src_as" integer, "src_ip" inet, "src_port" integer, "dst_as" integer, "dst_ip" inet, "dst_port" integer, "protocol" integer, "tos" integer, "pr_flags" integer, "pkts" bigint, "bytes" bigint, "next_hop" inet ); This one really piqued my interest... C | Charles Sprickman | Internet Channel | INCH System Administration Team | (212)243-5200 | [email protected] | [email protected] On Wed, 7 Nov 2001, Larry Rosenman wrote: > > * Charles Sprickman <[email protected]> [011107 16:05]: > > > > Hello all, > > > > I just discovered Postgres (after having used MySQL for some time), and it > > has some IP datatypes. I'm looking to stuff all of our IP allocations > > into a db for easier allocation/tracking, and I'm just thrilled to see > > that I can store IPs/networks natively. > > > > Before I get too far into this, are there any pre-existing packages out > > there to help manage IP allocation? Does anyone have anything homegrown, > > and would you be willing to share some pieces, even just a schema, or > > advice? I don't want to dive in and find that I've laid everything out > > poorly and painted myself into a corner... > Go look in the archives around May-july for posts from me. > > I've done exactly this, and shared SOME of my stuff. > > I can't release any more, but it's in the archives. > > > > > > Thanks, > > > > Charles > > > > | Charles Sprickman | Internet Channel > > | INCH System Administration Team | (212)243-5200 > > | [email protected] | [email protected] > > > > -- > Larry Rosenman http://www.lerctr.org/~ler > Phone: +1 972-414-9812 E-Mail: [email protected] > US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 >
|