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 PHP

ftp_alloc

FTP_ALLOC(3)								 1							      FTP_ALLOC(3)

ftp_alloc - Allocates space for a file to be uploaded

SYNOPSIS

       bool ftp_alloc (resource  $ftp_stream, int  $filesize, [string  &$result])

DESCRIPTION

	Sends an ALLO command to the remote FTP server to allocate space for a file to be uploaded.

       Note

	       Many  FTP  servers do not support this command. These servers may return a failure code ( FALSE) indicating the command is not sup-
	      ported or a success code ( TRUE) to indicate that pre-allocation is not necessary and the client should continue as though the oper-
	      ation were successful. Because of this, it may be best to reserve this function for servers which explicitly require preallocation.

PARAMETERS

	      o $ftp_stream
		- The link identifier of the FTP connection.

	      o $filesize
		- The number of bytes to allocate.

	      o $result
		- A textual representation of the servers response will be returned by reference in $result if a variable is provided.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      ftp_alloc(3) example

	      <?php

	      $file = "/home/user/myfile";

	      // connect to the server
	      $conn_id = ftp_connect('ftp.example.com');
	      $login_result = ftp_login($conn_id, 'anonymous', 'user@example.com');

	      if (ftp_alloc($conn_id, filesize($file), $result)) {
		echo "Space successfully allocated on server.  Sending $file.
";
		ftp_put($conn_id, '/incomming/myfile', $file, FTP_BINARY);
	      } else {
		echo "Unable to allocate space on server.  Server said: $result
";
	      }

	      ftp_close($conn_id);

	      ?>

SEE ALSO

       ftp_put(3), ftp_fput(3).

PHP Documentation Group 													      FTP_ALLOC(3)