SQL Injection Detection Post: 302906221

Sponsored Content

Top Forums Shell Programming and Scripting SQL Injection Detection Post 302906221 by Akshay Hegde on Wednesday 18th of June 2014 06:48:58 AM

06-18-2014

Moderator

Working for me

Code:

[akshay@nio tmp]$ cat log 
sssss SElect xxxxx InTO
dsjdhshdj CREATE xxxx ss s ggggs TabLE
DElete sdsdssd from wjhdssd WHErE dffsdfsd

Code:

[akshay@nio tmp]$ cat pattern 
benchmark
union
information_schema
drop
truncate
group_concat
into
case
hex
lpad
group
order
having
insert
union
select
from
where
delete
create
table

Code:

[akshay@nio tmp]$ awk 'BEGIN{IGNORECASE=1}NR==FNR {SRCSTR=SRCSTR DELIM $0; DELIM="|"; next} gsub (SRCSTR,"&")==2' pattern log
sssss SElect xxxxx InTO
dsjdhshdj CREATE xxxx ss s ggggs TabLE

Code:

[akshay@nio tmp]$ awk 'NR==FNR {SRCSTR=SRCSTR DELIM tolower($0); DELIM="|"; next}{p=tolower($0)} gsub(SRCSTR,"&",p)==2' pattern log
sssss SElect xxxxx InTO
dsjdhshdj CREATE xxxx ss s ggggs TabLE

if you want 2 or more words then use this

Code:

awk 'BEGIN{IGNORECASE=1}NR==FNR {SRCSTR=SRCSTR DELIM $0; DELIM="|"; next} gsub (SRCSTR,"&")>=2' pattern log

Code:

awk 'NR==FNR {SRCSTR=SRCSTR DELIM tolower($0); DELIM="|"; next}{p=tolower($0)} gsub(SRCSTR,"&",p)>=2' pattern log

Akshay Hegde

View Public Profile for Akshay Hegde

Find all posts by Akshay Hegde

LEARN ABOUT SUSE

irsend

IRSEND(1)								FSF								 IRSEND(1)

NAME

       irsend - basic LIRC program to send infra-red commands

SYNOPSIS

       irsend [options] DIRECTIVE REMOTE CODE [CODE...]

DESCRIPTION

       Asks the lircd daemon to send one or more CIR (Consumer Infra-Red) commands. This is intended for remote control of electronic devices such
       as TV boxes, HiFi sets, etc.

       DIRECTIVE can be:
	  SEND_ONCE	    - send CODE [CODE ...] once
	  SEND_START	    - start repeating CODE
	  SEND_STOP	    - stop repeating CODE
	  LIST		    - list configured remote items
	  SET_TRANSMITTERS  - set transmitters NUM [NUM ...]
	  SIMULATE	    - simulate IR event

       REMOTE is the name of a remote, as described in the lircd configuration file.

       CODE is the name of a remote control key of REMOTE, as it appears in the lircd configuration file.

       NUM is the transmitter number of the hardware device.

       For the LIST DIRECTIVE, REMOTE and/or CODE can be empty:

	  LIST	 ""    ""   - list all configured remote names
	  LIST REMOTE  ""   - list all codes of REMOTE
	  LIST REMOTE CODE  - list only CODE of REMOTE

       The SIMULATE command only works if it has been explicitly enabled in lircd.

       -h --help
	      display usage summary

       -v --version
	      display version

       -d --device
	      use given lircd socket [/var/run/lirc/lircd]

       -a --address=host[:port]
	      connect to lircd at this address

       -# --count=n
	      send command n times

EXAMPLES

	  irsend LIST DenonTuner ""
	  irsend SEND_ONCE  DenonTuner PROG-SCAN
	  irsend SEND_ONCE  OnkyoAmpli VOL-UP VOL-UP VOL-UP VOL-UP
	  irsend SEND_START OnkyoAmpli VOL-DOWN ; sleep 3
	  irsend SEND_STOP  OnkyoAmpli VOL-DOWN
	  irsend SET_TRANSMITTERS 1
	  irsend SET_TRANSMITTERS 1 3 4
	  irsend SIMULATE "0000000000000476 00 OK TECHNISAT_ST3004S"

FILES

       /etc/lirc/lircd.conf
	      Default lircd configuration file.  It should contain all the remotes, their infra-red codes and the corresponding timing	and  wave-
	      form details.

DIAGNOSTICS

       If lircd is not running (or /var/run/lirc/lircd lacks write permissions) irsend aborts with the following diagnostics:
       "irsend: could not connect to socket"
       "irsend: Connection refused" (or "Permission denied").

SEE ALSO

       The documentation for lirc is maintained as html pages. They are located under html/ in the documentation directory.

       lircd(8), mode2(1), smode2(1), xmode2(1), irrecord(1), irw(1), http://www.lirc.org.

irsend 0.8.7pre1						     May 2010								 IRSEND(1)