Guest User

Untitled

a guest
Mar 16th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. DB_USER='****';
  2. DB_PASSWD='********';
  3. DB_NAME='*******';
  4. TABLE='*******';
  5. foo=("$(grep password logs.txt)")
  6.  
  7. while read -r line;
  8.  
  9. do
  10.  
  11. if [[ $line =~ root ]]
  12.  
  13. then
  14.  
  15. ip= echo $line | cut -d " " -f 11
  16. port= echo $line | cut -d " " -f 13
  17.  
  18. mysql --user=$DB_USER --password=$DB_PASSWD $DB_NAME -e "INSERT INTO $TABLE (ip, port) VALUES ('${ip}','${port}')"
  19.  
  20.  
  21. elif [[ $line =~ invalid ]]
  22.  
  23. then
  24.  
  25. ip= echo $line | cut -d " " -f 13
  26. port= echo $line | cut -d " " -f 15
  27.  
  28. mysql --user=$DB_USER --password=$DB_PASSWD $DB_NAME -e "INSERT INTO $TABLE (ip, port) VALUES ('${ip}','${port}')"
  29.  
  30. else
  31.  
  32. echo "No Data "
  33.  
  34. fi
  35.  
  36.  
  37. done <<<"${foo[@]}"
Add Comment
Please, Sign In to add comment