Diff of /trunk/usbip/usbippolld-sql

Parent Directory | Revision Log | Patch

	revision 174 by niro, Wed May 9 15:05:23 2007 UTC	revision 181 by niro, Thu May 10 15:02:35 2007 UTC
#	Line 1	Line 1
1	#!/bin/bash	#!/bin/bash
2
	SQL_USER=jomo
	SQL_PASS=j0m0
	SQL_HOST=128.20.41.110
	SQL_DB=jomo
3	source /etc/conf.d/usbippolld	source /etc/conf.d/usbippolld
4	source /home/rogalla/cvsroot/alx-src/alxconfig-ng/functions/mysqlfunctions	source /usr/lib/alxconfig-ng/functions/mysqlfunctions
5
6	while true	while true
7	do	do
8	ALLCLIENTS=$(mysqldo "select ip from clients")	ALLCLIENTS=$(mysqldo "select id from clients")
9
10	for client in ${ALLCLIENTS}	for client in ${ALLCLIENTS}
11	do	do
12	# BUSID=$(mysqldo "select busid from clients where ip='${client}'")	clientip=$(mysqldo "select ip from clients where id='${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
13
14	if [[ $(mysqldo "select connected from clients where ip='${client}'") = 1 ]]	if [[ $(mysqldo "select connected from clients where id='${client}'") = 1 ]]
15	then	then
16	BUSID=$(mysqldo "select busid from clients where ip='${client}'")	BUSID=$(mysqldo "select busid from clients where id='${client}'")
17
18	echo "-- polling client ${client} on dev ${BUSID}"	echo "-- polling client #${client} - ${clientip} on dev ${BUSID}"
19	usbip -a ${client} ${BUSID}	usbip -a ${clientip} ${BUSID}
20	else	else
21	echo "-- client ${client} not found, removing from list"	echo "-- client #${client} - ${clientip} not found, removing from list"
22
23	out=$(mktemp)	out=$(mktemp)
24	port=$(usbip -p &> ${out};grep -B3 -i "${client}" ${out}  | grep Port | cut -d' '  -f2| sed "s|:||")	port=$(usbip -p &> ${out};grep -B3 -i "${clientip}" ${out}  | grep Port | cut -d' '  -f2| sed "s|:||")
25	[[ ! -z ${port} ]] && usbip -d ${port}	[[ ! -z ${port} ]] && usbip -d ${port}
26		#mysqldo "delete from client where id='${client}'"
27	fi	fi
28
29	sleep ${USBIP_WAIT_TIMEOUT}	sleep ${USBIP_WAIT_TIMEOUT}

---

Colored Diff Long Colored Diff Full Colored Diff Unidiff Context Diff Side by Side

Legend: Removed from v.174   changed lines   Added in v.181