Contents of /trunk/usbip/usbippolld-sql
Parent Directory | Revision Log
Revision 174 -
(show annotations)
(download)
Wed May 9 15:05:23 2007 UTC (17 years, 4 months ago) by niro
File size: 1282 byte(s)
Wed May 9 15:05:23 2007 UTC (17 years, 4 months ago) by niro
File size: 1282 byte(s)
-sql version
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 |
Properties
Name | Value |
---|---|
svn:executable | * |