Contents 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	#!/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