15 |
|
|
16 |
# mysql settings |
# mysql settings |
17 |
source /etc/alxconfig-ng/config.rc |
source /etc/alxconfig-ng/config.rc |
18 |
|
# helper functions |
19 |
source /usr/lib/alxconfig-ng/functions/mysqlfunctions |
source /usr/lib/alxconfig-ng/functions/mysqlfunctions |
20 |
source /usr/lib/alxconfig-ng/functions/serial_functions |
source /usr/lib/alxconfig-ng/functions/serial_functions |
21 |
|
source /usr/lib/alxconfig-ng/functions/common |
22 |
|
|
23 |
# unset vars which may kill us |
# unset vars which may kill us |
24 |
unset ALX_SERIAL ALX_STATE ALX_IFACE |
unset ALX_SERIAL ALX_STATE ALX_IFACE |
44 |
{ |
{ |
45 |
local CUR_IP CUR_MAC ID |
local CUR_IP CUR_MAC ID |
46 |
|
|
47 |
echo -e ${COLMAGENTA}"Register system to database"${COLDEFAULT} |
rc_mecho "Register system to database" |
48 |
|
|
49 |
CUR_IP=$(/sbin/ifconfig ${ALX_IFACE} | sed -n '/addr:/s/ [^r]*..//gp') |
CUR_IP=$(/sbin/ifconfig ${ALX_IFACE} | sed -n '/addr:/s/ [^r]*..//gp') |
50 |
CUR_MAC=$(/sbin/ifconfig ${ALX_IFACE} | grep HWaddr | cut -d ' ' -f11) |
CUR_MAC=$(/sbin/ifconfig ${ALX_IFACE} | grep HWaddr | cut -d ' ' -f11) |
71 |
# nice status |
# nice status |
72 |
$CURS_UP |
$CURS_UP |
73 |
$SET_WCOL |
$SET_WCOL |
74 |
echo "[ SN: ${ALX_SERIAL}, U, ${ALX_STATE} ]" |
rc_echo "[ SN: ${ALX_SERIAL}, U, ${ALX_STATE} ]" |
75 |
|
|
76 |
mysqldo "update state_connected set |
mysqldo "update state_connected set |
77 |
hostname='${HOSTNAME}', |
hostname='${HOSTNAME}', |
86 |
# nice status |
# nice status |
87 |
$CURS_UP |
$CURS_UP |
88 |
$SET_WCOL |
$SET_WCOL |
89 |
echo "[ SN: ${ALX_SERIAL}, N, ${ALX_STATE} ]" |
rc_echo "[ SN: ${ALX_SERIAL}, N, ${ALX_STATE} ]" |
90 |
|
|
91 |
mysqldo "insert into state_connected( |
mysqldo "insert into state_connected( |
92 |
serial, |
serial, |
118 |
|
|
119 |
CUR_MAC=$(/sbin/ifconfig ${ALX_IFACE} | grep HWaddr | cut -d ' ' -f11) |
CUR_MAC=$(/sbin/ifconfig ${ALX_IFACE} | grep HWaddr | cut -d ' ' -f11) |
120 |
|
|
121 |
echo -e ${COLMAGENTA}"Unregister system from database"${COLDEFAULT} |
rc_mecho "Unregister system from database" |
122 |
|
|
123 |
# nice status |
# nice status |
124 |
$CURS_UP |
$CURS_UP |
125 |
$SET_WCOL |
$SET_WCOL |
126 |
echo "[ SN: ${ALX_SERIAL} ]" |
rc_echo "[ SN: ${ALX_SERIAL} ]" |
127 |
|
|
128 |
mysqldo "delete from state_connected where serial='${ALX_SERIAL}' and mac='${CUR_MAC}';" |
mysqldo "delete from state_connected where serial='${ALX_SERIAL}' and mac='${CUR_MAC}';" |
129 |
evaluate_retval |
evaluate_retval |
130 |
} |
} |