Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DB_USER='****';
- DB_PASSWD='********';
- DB_NAME='*******';
- TABLE='*******';
- foo=("$(grep password logs.txt)")
- while read -r line;
- do
- if [[ $line =~ root ]]
- then
- ip= echo $line | cut -d " " -f 11
- port= echo $line | cut -d " " -f 13
- mysql --user=$DB_USER --password=$DB_PASSWD $DB_NAME -e "INSERT INTO $TABLE (ip, port) VALUES ('${ip}','${port}')"
- elif [[ $line =~ invalid ]]
- then
- ip= echo $line | cut -d " " -f 13
- port= echo $line | cut -d " " -f 15
- mysql --user=$DB_USER --password=$DB_PASSWD $DB_NAME -e "INSERT INTO $TABLE (ip, port) VALUES ('${ip}','${port}')"
- else
- echo "No Data "
- fi
- done <<<"${foo[@]}"
Add Comment
Please, Sign In to add comment