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 |
9 |
|
|
10 |
for client in ${ALLCLIENTS} |
for client in ${ALLCLIENTS} |
11 |
do |
do |
12 |
# BUSID=$(mysqldo "select busid from clients where ip='${client}'") |
# filter all not connected clients |
|
# |
|
|
# 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 |
if [[ $(mysqldo "select connected from clients where ip='${client}'") = 1 ]] |
if [[ $(mysqldo "select connected from clients where ip='${client}'") = 1 ]] |
14 |
then |
then |
15 |
BUSID=$(mysqldo "select busid from clients where ip='${client}'") |
BUSID=$(mysqldo "select busid from clients where ip='${client}'") |
16 |
|
|
17 |
echo "-- polling client ${client} on dev ${BUSID}" |
echo "-- polling client #${client} on dev ${BUSID}" |
18 |
usbip -a ${client} ${BUSID} |
usbip -a ${client} ${BUSID} |
19 |
else |
else |
20 |
echo "-- client ${client} not found, removing from list" |
echo "-- client #${client} not found, removing from list" |
21 |
|
|
22 |
out=$(mktemp) |
out=$(mktemp) |
23 |
port=$(usbip -p &> ${out};grep -B3 -i "${client}" ${out} | grep Port | cut -d' ' -f2| sed "s|:||") |
port=$(usbip -p &> ${out};grep -B3 -i "${client}" ${out} | grep Port | cut -d' ' -f2| sed "s|:||") |
24 |
[[ ! -z ${port} ]] && usbip -d ${port} |
[[ ! -z ${port} ]] && usbip -d ${port} |
25 |
|
|
26 |
|
mysqldo "update clients set connected='0', busid='' where ip='${client}'" |
27 |
fi |
fi |
28 |
|
|
|
sleep ${USBIP_WAIT_TIMEOUT} |
|
29 |
done |
done |
30 |
|
|
31 |
|
sleep ${USBIP_WAIT_TIMEOUT} |
32 |
done |
done |