Subversion Repositories SmartDukaan

Rev

Rev 6595 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
6595 kshitij.so 1 
#!/bin/bash
2 
rm -f Deniedlist
3 
rm -f GeoIPCountry*
4 
rm -f ARGlist
5 
rm -f temp
6 
 
6596 kshitij.so 7 
CURDIR=`pwd`
8 
 
6595 kshitij.so 9 
if [ -z "$1" ]; then
10 
 
6596 kshitij.so 11 
echo "Usage: GetDeniedIpRange.sh Country1,Country2,.....,CountryN DatabaseIPAddress"
6595 kshitij.so 12 
 
13 
exit 1
14 
 
15 
fi
16 
 
6596 kshitij.so 17 
 
18 
if [ -z "$2" ]; then
19 
 
20 
echo "No host given using localhost"
21 
 
22 
host="localhost"
23 
 
24 
else
25 
 
26 
host=$2
27 
 
28 
fi
29 
 
30 
 
6595 kshitij.so 31 
echo $1 | sed 's/,/\n/g' >ARGlist
32 
 
33 
wget http://geolite.maxmind.com/download/geoip/database/GeoIPCountryCSV.zip
34 
 
6596 kshitij.so 35 
if [ $? -eq 0 ]; then
6595 kshitij.so 36 
 
6596 kshitij.so 37 
/usr/bin/mysql -h $host -u root -pshop2020 -Bse "use transaction;delete from blockediprange"
6595 kshitij.so 38 
 
6596 kshitij.so 39 
else
6595 kshitij.so 40 
 
6596 kshitij.so 41 
echo "Request Denied IP List file not downloaded....Exiting"
6595 kshitij.so 42 
 
6596 kshitij.so 43 
exit 1
6595 kshitij.so 44 
 
6596 kshitij.so 45 
fi
6595 kshitij.so 46 
 
6596 kshitij.so 47 
unzip GeoIPCountryCSV.zip
6595 kshitij.so 48 
 
6596 kshitij.so 49 
while read arglist
6595 kshitij.so 50 
 
6596 kshitij.so 51 
do
6595 kshitij.so 52 
 
6596 kshitij.so 53 
PARAM=$arglist
6595 kshitij.so 54 
 
6596 kshitij.so 55 
grep -i "$PARAM" GeoIPCountryWhois.csv | awk -F ',' '{print $3" "$4}' | sed 's/"//g' > Deniedlist
6595 kshitij.so 56 
 
6596 kshitij.so 57 
/usr/bin/mysql -h $host -u root -pshop2020 -Bse "use transaction;LOAD DATA LOCAL INFILE '$CURDIR/Deniedlist' INTO TABLE blockediprange FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\n' (start,end)"
6595 kshitij.so 58 
 
59 
done < ARGlist