Contents of /trunk/usbip/usbippolld-sql

#!/bin/bash

source /etc/conf.d/usbippolld
source /usr/lib/alxconfig-ng/functions/mysqlfunctions

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

	for client in ${ALLCLIENTS}
	do
		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	source /etc/conf.d/usbippolld
4	source /usr/lib/alxconfig-ng/functions/mysqlfunctions
5
6	while true
7	do
8	ALLCLIENTS=$(mysqldo "select ip from clients")
9
10	for client in ${ALLCLIENTS}
11	do
12	if [[ $(mysqldo "select connected from clients where ip='${client}'") = 1 ]]
13	then
14	BUSID=$(mysqldo "select busid from clients where ip='${client}'")
15
16	echo "-- polling client ${client} on dev ${BUSID}"
17	usbip -a ${client} ${BUSID}
18	else
19	echo "-- client ${client} not found, removing from list"
20
21	out=$(mktemp)
22	port=$(usbip -p &> ${out};grep -B3 -i "${client}" ${out} \| grep Port \| cut -d' ' -f2\| sed "s\|:\|\|")
23	[[ ! -z ${port} ]] && usbip -d ${port}
24	fi
25
26	sleep ${USBIP_WAIT_TIMEOUT}
27	done
28	done