Annotation of /trunk/usbip/usbippolld-sql

#!/bin/bash

SQL_USER=jomo
SQL_PASS=j0m0
SQL_HOST=128.20.41.110
SQL_DB=jomo

source /etc/conf.d/usbippolld
source /home/rogalla/cvsroot/alx-src/alxconfig-ng/functions/mysqlfunctions

while true
do
	ALLCLIENTS=$(mysqldo "select ip from clients")

	for client in ${ALLCLIENTS}
	do
#		BUSID=$(mysqldo "select busid from clients where ip='${client}'")
#
#		if fping -q ${FPING_OPTS} ${client}
#		then
#			echo "-- polling client ${client} on dev ${BUSID}"
#			usbip -a ${client} ${BUSID}
#		else
#			echo "-- client ${client} not found, removing from list"
#
#			out=$(mktemp)
#			port=$(usbip -p &> ${out};grep -B3 -i "128.20.3.3" ${out}  | grep Port | cut -d' '  -f2| sed "s|:||")
#			usbip -d ${port}
#			mysqldo "delete from clients where ip='${client}'"
#		fi


		if [[ $(mysqldo "select connected from clients where ip='${client}'") = 1 ]]
		then
			BUSID=$(mysqldo "select busid from clients where ip='${client}'")

			echo "-- polling client ${client} on dev ${BUSID}"
			usbip -a ${client} ${BUSID}
		else
			echo "-- client ${client} not found, removing from list"

			out=$(mktemp)
			port=$(usbip -p &> ${out};grep -B3 -i "${client}" ${out}  | grep Port | cut -d' '  -f2| sed "s|:||")
			[[ ! -z ${port} ]] && usbip -d ${port}
		fi

		sleep ${USBIP_WAIT_TIMEOUT}
	done
done
1	niro	174	#!/bin/bash
2
3			SQL_USER=jomo
4			SQL_PASS=j0m0
5			SQL_HOST=128.20.41.110
6			SQL_DB=jomo
7
8			source /etc/conf.d/usbippolld
9			source /home/rogalla/cvsroot/alx-src/alxconfig-ng/functions/mysqlfunctions
10
11			while true
12			do
13			ALLCLIENTS=$(mysqldo "select ip from clients")
14
15			for client in ${ALLCLIENTS}
16			do
17			# BUSID=$(mysqldo "select busid from clients where ip='${client}'")
18			#
19			# if fping -q ${FPING_OPTS} ${client}
20			# then
21			# echo "-- polling client ${client} on dev ${BUSID}"
22			# usbip -a ${client} ${BUSID}
23			# else
24			# echo "-- client ${client} not found, removing from list"
25			#
26			# out=$(mktemp)
27			# port=$(usbip -p &> ${out};grep -B3 -i "128.20.3.3" ${out} \| grep Port \| cut -d' ' -f2\| sed "s\|:\|\|")
28			# usbip -d ${port}
29			# mysqldo "delete from clients where ip='${client}'"
30			# fi
31
32
33			if [[ $(mysqldo "select connected from clients where ip='${client}'") = 1 ]]
34			then
35			BUSID=$(mysqldo "select busid from clients where ip='${client}'")
36
37			echo "-- polling client ${client} on dev ${BUSID}"
38			usbip -a ${client} ${BUSID}
39			else
40			echo "-- client ${client} not found, removing from list"
41
42			out=$(mktemp)
43			port=$(usbip -p &> ${out};grep -B3 -i "${client}" ${out} \| grep Port \| cut -d' ' -f2\| sed "s\|:\|\|")
44			[[ ! -z ${port} ]] && usbip -d ${port}
45			fi
46
47			sleep ${USBIP_WAIT_TIMEOUT}
48			done
49			done