Login or Register to Ask a Question and Join Our Community


UNIX and Linux Applications

Using a queried value to query... I think.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Using a queried value to query... I think.
# 1  
Old 12-16-2009
MySQL Using a queried value to query... I think.
Hi,

One of our FTP servers is constantly under attack. I'm putting the output from the servers log file into a database. What I'm doing now is querying for anything hitting the server on port 21 in the last minute. Any single IP that has too high of a count within that minute is blocked. What I'd like to do is... In addition to gathered IP addresses hitting on port 21. Make sure that there are no hits from those IP addreses to the passive ports on our server. This would help eliminate false positives as much as I can.

The question is can I do this in a single statement?

The current statement is this:
Code:
"SELECT log_src_ip FROM traffic_log WHERE \
         (log_dst_ip = 'our.ftp.server.address' AND \
         log_dst_pt='21' AND \
         log_time > DATE_SUB(NOW(),INTERVAL $block_time second) \
         ORDER BY log_time ASC;"

Thanks,

MPH
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

2. UNIX for Dummies Questions & Answers

Query

Hi, I have a script to remove null values from a file. Could any one explain how this is working? :confused: while read f do echo process $f gawk... (0 Replies)
Discussion started by: abhi_n123
0 Replies

3. Shell Programming and Scripting

want to query : YES or NO

hi i want to make script. where i want to query from the user yes or no exp: do you want to proceed : y for yes n for NO. how this is possible in unix (3 Replies)
Discussion started by: dodasajan
3 Replies

4. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

5. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

I would like to use the result of a query in another query. How do I redirect/add the output to another variable? $result = odbc_exec($connect, $query); while ($row = odbc_fetch_array($result)) { echo $row,"\n"; } odbc_close($connect); ?> This will output hostnames: host1... (0 Replies)
Discussion started by: hazno
0 Replies

6. UNIX for Dummies Questions & Answers

Need Help on query

I just started to learn unix - need help to write a script to query a logfile and produce the results that contains a specific word "alarm" for a period from X day to Y day. I really have no idea how to begin - :( please help... ____________________________________________________ #... (1 Reply)
Discussion started by: snipfer
1 Replies

7. Shell Programming and Scripting

query.....

hi friends i want to know details of `exec` exact use of this command ..... actually i went through the man page but i didn`t get the satisfactory ...conclusion.... thaks in advance.... (1 Reply)
Discussion started by: newson
1 Replies

8. Shell Programming and Scripting

query

I have converted data written on excel sheet in unix through shell & perl prg now the problem is I want that if starting columns of the xls sheet is Blank than when data is converted into unix then it should appear with this '|' sign. but it appearing like this: hfgg|tytt| but I want like... (2 Replies)
Discussion started by: akash
2 Replies

9. UNIX for Dummies Questions & Answers

query

hi, how can i do the following..... i have file containing followig a k 10000 b c 200000 d e 50 a j 40 how can i list all rows containg last value more than 1000? and how can i find number of blank rows in the file? THANKS! regards vivek (2 Replies)
Discussion started by: vivekshankar
2 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

ka-forwarder

KA-FORWARDER(8) 					       AFS Command Reference						   KA-FORWARDER(8)

NAME

       ka-forwarder - Forward AFS Authentication Server requests to another server

SYNOPSIS

       ka-forwarder [-p <port>] <server>[/<port>] [...]

DESCRIPTION

       ka-forwarder listens for requests for an AFS Authentication Server and forwards them to a remove fakeka server.	fakeka is a server that
       answers AFS Authentication Server protocol requests using a regular Kerberos KDC and is provided with some Kerberos 5 implementations.
       fakeka has to run on the same host as the Kerberos KDC, however, and AFS clients send all native AFS authentication requests to the AFS
       database servers.  If you don't want to run your Kerberos KDCs and your AFS database servers on the same host, run ka-forwarder on the AFS
       database servers and point it to fakeka running on the Kerberos KDCs.

       ka-forwarder takes one or more servers to which to forward the requests.  The default port on the remote server to which to forward the
       command is 7004, but a different port can be specified by following the server name with a slash ("/") and the port number.  If multiple
       servers are given, ka-forwarder will send queries to each server in turn in a round-robin fashion.

CAUTIONS

       Due to the way that ka-forwarder distinguishes from client requests and server responses, any messages from one of the servers to which ka-
       forwarder is forwarding will be considered a reply rather than a command and will not be forwarded.  This means that the servers running
       fakeka will not be able to use native AFS authentication requests and rely on ka-forwarder to send the requests to the right server.

       ka-forwarder does not background itself.  It should either be run in the background via the shell, or run via the Basic OverSeer Server
       (see bosserver(8)).

OPTIONS

       -p <port>
	   By default, ka-forwarder listens to the standard AFS Authentication Server port (7004).  To listen to a different port, specify it with
	   the -p option.

EXAMPLES

       Forward AFS Authentication Server requests to the fakeka servers on kdc1.example.com and kdc2.example.com:

	   % ka-forwarder kdc1.example.com kdc2.example.com &

       Note the "&" to tell the shell to run this command in the background.

PRIVILEGE REQUIRED

       ka-forwarder only has to listen to port 7004 and therefore does not require any special privileges unless a privileged port is specified
       with the -p option.

SEE ALSO

       bosserver(8), fakeka(8), kaserver(8)

COPYRIGHT

       Copyright 2006 Russ Allbery <rra@stanford.edu>

       This documentation is covered by the IBM Public License Version 1.0.  This man page was written by Russ Allbery for OpenAFS.

OpenAFS 							    2012-03-26							   KA-FORWARDER(8)