42 |
# nice name is alx_connected_state or sth like this |
# nice name is alx_connected_state or sth like this |
43 |
set_current_network_state() |
set_current_network_state() |
44 |
{ |
{ |
45 |
local CUR_IP CUR_MAC ID |
local cur_ip cur_mac cur_mtime id |
46 |
|
|
47 |
rc_mecho "Register system to database" |
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) |
51 |
CUR_MTIME=$(date +%s) |
cur_mtime=$(date +%s) |
52 |
|
|
53 |
# validate current serial |
# validate current serial |
54 |
if ! validate_serial "${ALX_SERIAL}" "${ALX_REG_DATE}" "${CUR_MAC}" |
if ! validate_serial "${ALX_SERIAL}" "${ALX_REG_DATE}" "${cur_mac}" |
55 |
then |
then |
56 |
# abort on non valid serial |
# abort on non valid serial |
57 |
ALX_STATE="invalid serial" |
ALX_STATE="invalid serial" |
62 |
|
|
63 |
# first check if an entry exist with my serial |
# first check if an entry exist with my serial |
64 |
# if it exist update this entry else insert a new one |
# if it exist update this entry else insert a new one |
65 |
ID=$(mysqldo "select serial from state_connected where serial=${ALX_SERIAL};") |
id=$(mysqldo "select serial from state_connected where serial=${ALX_SERIAL};") |
66 |
|
|
67 |
if [ -n "${ID}" ] |
if [ -n "${id}" ] |
68 |
then |
then |
69 |
# run an update |
# run an update |
70 |
|
|
75 |
|
|
76 |
mysqldo "update state_connected set |
mysqldo "update state_connected set |
77 |
hostname='${HOSTNAME}', |
hostname='${HOSTNAME}', |
78 |
ip='${CUR_IP}', |
ip='${cur_ip}', |
79 |
mac='${CUR_MAC}', |
mac='${cur_mac}', |
80 |
state='${ALX_STATE}', |
state='${ALX_STATE}', |
81 |
mtime='${CUR_MTIME}' |
mtime='${cur_mtime}' |
82 |
where serial=${ALX_SERIAL};" |
where serial=${ALX_SERIAL};" |
83 |
else |
else |
84 |
# run an insert |
# run an insert |
99 |
values( |
values( |
100 |
'${ALX_SERIAL}', |
'${ALX_SERIAL}', |
101 |
'${HOSTNAME}', |
'${HOSTNAME}', |
102 |
'${CUR_IP}', |
'${cur_ip}', |
103 |
'${CUR_MAC}', |
'${cur_mac}', |
104 |
'${ALX_STATE}', |
'${ALX_STATE}', |
105 |
'${CUR_MTIME}' |
'${cur_mtime}' |
106 |
);" |
);" |
107 |
fi |
fi |
108 |
} |
} |
113 |
# nice name is alx_connected_state or sth like this |
# nice name is alx_connected_state or sth like this |
114 |
unset_alx_connected() |
unset_alx_connected() |
115 |
{ |
{ |
116 |
local SQL_OPTS |
local sql_opts |
117 |
local CUR_MAC |
local cur_mac |
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 |
rc_mecho "Unregister system from database" |
rc_mecho "Unregister system from database" |
122 |
|
|
125 |
$SET_WCOL |
$SET_WCOL |
126 |
rc_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 |
} |
} |
131 |
|
|