importMetaClients.sh

#!/bin/bash

USER=""
PASS=""
DB="warden"

if [ -z $PASS ]; then
	MYSQL_CMD="mysql -u$USER $DB";
else
	MYSQL_CMD="mysql -u$USER -p$PASS $DB";
fi

for host in `cat meta-nodes`; do
	IP=`host $host | grep -v 'handle' | awk '{print $4}'`
	echo "INSERT INTO clients VALUES (NULL, '$host', now(),'automatic', 'test', 's', NULL, 'n', 'bruteforce', '$IP/32');" | $MYSQL_CMD
done