02-10-2007
Noob sorting question
Ok here is the deal, I have a command given to me by some systems guy who I cannot get ahold of on the weekend without paying him alot of money to help me. I need to get this done before Monday as I am just getting pummeled by DOS attacks. The comand given was....
netstat -ntu | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n
and when I run it it outputs.....
72 218.171.144.249
87 200.141.18.62
296 201.141.26.64
369 189.135.8.167
From what I was told by the said systems guy this will show me a list of IP's accessing my server and how many instances of each IP there are. What I want the command to do is to just output the IP's that have over 100+ connections (column 1) and display that IP (not column 1) so I can then fwrite that to my deny file. If someone can include how I would incorporate the fwrite command the would just make my day.
Thanks to all the Guru's out there.
10 More Discussions You Might Find Interesting
1. Programming
I'm just getting started to lean C and I'm using Ubuntu today I found a tutorial at this site: http://einstein.drexel.edu/courses/CompPhys/General/C_basics/c_tutorial.html and I got an error after compiling the fist code:
#include < stdio.h>
void main()
{
printf("\nHello World\n");
} ... (9 Replies)
Discussion started by: arya6000
9 Replies
2. UNIX for Dummies Questions & Answers
I have a file with 3 digit numbers in it formatted as such:
123
065
321
How would I go about seeing if each number is less than 100 and if so outputting it to another file
Yes, I am a bit of a noob. I have tried with grep but I don't think it'll work.
Any general direction would be... (6 Replies)
Discussion started by: kirkm76
6 Replies
3. Shell Programming and Scripting
I dont know what I am doing wrong but I would like to redirect the stderr output to a file?
the specific command is this
time wget http://www.something.com/somefile.bin
All I want to see is time's output which is stderr so I can see how long the file download took. I've tried redirecting... (2 Replies)
Discussion started by: trey85stang
2 Replies
4. Ubuntu
I am editing the squid.confi on my server.
I am done editing.
How do I exit the confi file?
Thank you. (2 Replies)
Discussion started by: sethartha
2 Replies
5. UNIX for Dummies Questions & Answers
I'm trying to parse the website, finance.yahoo.com/q?s=ge&ql=1, and retrieve the info between <span id="yfs_l84_ge">18.98</span>, so 18.98.
What would be the best way to go about this in a bash script?
Any help or suggestions will be much appreciated.
Thanks! (2 Replies)
Discussion started by: mayson
2 Replies
6. UNIX for Dummies Questions & Answers
First time poster here and I'm pretty much a total noob with UNIX and Perl. So please bear with me.
With Perl, I'm trying to fill an array with data that is in a CSV file. I would like to fill the array with only one of the columns in the CSV file.
I have a file called data.csv:
... (2 Replies)
Discussion started by: WongSifu
2 Replies
7. UNIX Desktop Questions & Answers
What is this script meant to do? How do I make it executable and how do i run it? I am trying to understand what the script is doing and how it is doing it... need a little advice. Here is is..
if
then
list=`w | grep $user | cut -c19-30`
if
then
echo "The user $user is... (2 Replies)
Discussion started by: DanableLector
2 Replies
8. Shell Programming and Scripting
Hello,
I am new to shell scripting and i am trying to figure why is this not working with else statement.
I am searching for every directory in that DIR i am in, however the "else" seems to be triggered whenever the run the script..
Much thanks in advance!
#!/bin/shell
for item in... (3 Replies)
Discussion started by: Reb0rn
3 Replies
9. Shell Programming and Scripting
I'm having some difficulty with convincing Expect to do what I need..
I have a loop that waits for input, a specific phrase of text followed by a single word. I need Expect to capture that word following the specific phrase. It should then store the word in a variable.
I'm fairly sure it's... (6 Replies)
Discussion started by: LongLeafTea
6 Replies
10. Shell Programming and Scripting
Hello All,
I have a file of ip addresses called activeips.txt
What I'm trying to do is run a simple bash script that has a loop in it. The loop is a cat of the IP addresses in the file.
The goal is to run 2 nmap commands to give me outputs where each address in the list has an OS... (11 Replies)
Discussion started by: Dirk_Pitt
11 Replies
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [ options ] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-jn m Join on the mth field of file n. If n is missing, use the mth field in each file.
-o list
Each output line comprises the fields specified in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO
sort(1), comm(1), awk(1)
BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
7th Edition April 29, 1985 JOIN(1)