tinyalxconfig-ng/init.d/alxsetstate

#!/bin/bash

#%rlevels: 3:s 0:k
#%start: 99
#%stop: 01

#deps
#%needs:
#%before:
#%after:

# $Id$

source /etc/conf.d/rc
source ${rc_functions}

# mysql settings
source /etc/alxconfig-ng/config.rc
source /usr/lib/alxconfig-ng/functions/mysqlfunctions
source /usr/lib/alxconfig-ng/functions/serial_functions

# unset vars which may kill us
unset ALX_SERIAL ALX_STATE ALX_IFACE

# get current system state
if [ -f /etc/alxconfig-ng/state/state ]
then
	source /etc/alxconfig-ng/state/state
else
	ALX_STATE=error
fi

if [ -f ${SETTINGSPATH}/confd-networking ]
then
	ALX_IFACE="$(< ${SETTINGSPATH}/confd-networking)"
fi
[[ -z ${ALX_IFACE} ]] && export ALX_IFACE=eth0

# need to put this to an extra init script which will be 
# executed when the real network is up and not the preliminary.
# nice name is alx_connected_state or sth like this
set_current_network_state()
{
	local CUR_IP CUR_MAC ID

	echo -e ${COLMAGENTA}"Register system to database"${COLDEFAULT}

	CUR_IP=$(/sbin/ifconfig ${ALX_IFACE} | sed -n '/addr:/s/ [^r]*..//gp')
	CUR_MAC=$(/sbin/ifconfig ${ALX_IFACE} | grep HWaddr | cut -d ' ' -f11)
	CUR_MTIME=$(date +%s)

	# validate current serial
	if ! validate_serial "${ALX_SERIAL}" "${ALX_REG_DATE}" "${CUR_MAC}"
	then
		# abort on non valid serial
		ALX_STATE="invalid serial"
		echo "ALX_STATE=${ALX_STATE}" > /etc/alxconfig-ng/state/state
		show_invalid_serial_msg
		exit 1
	fi

	# first check if an entry exist with my serial
	# if it exist update this entry else insert a new one
	ID=$(mysqldo "select serial from state_connected where serial=${ALX_SERIAL};")

	if [ -n "${ID}" ]
	then
		# run an update

		# nice status
		$CURS_UP
		$SET_WCOL
		echo "[ U, State: ${ALX_STATE} ]"

		mysqldo "update state_connected set
				hostname='${HOSTNAME}',
				ip='${CUR_IP}',
				mac='${CUR_MAC}',
				state='${ALX_STATE}',
				mtime='${CUR_MTIME}'
			where serial=${ALX_SERIAL};"
	else
		# run an insert

		# nice status
		$CURS_UP
		$SET_WCOL
		echo "[ N, State: ${ALX_STATE} ]"

		mysqldo "insert into state_connected(
				serial,
				hostname,
				ip,
				mac,
				state,
				mtime
			)
			values(
				'${ALX_SERIAL}',
				'${HOSTNAME}',
				'${CUR_IP}',
				'${CUR_MAC}',
				'${ALX_STATE}',
				'${CUR_MTIME}'
			);"
	fi
}


# need to put this to an extra init script which will 
# be executed first when the system is going down.
# nice name is alx_connected_state or sth like this
unset_alx_connected()
{
	local SQL_OPTS
	local CUR_MAC

	CUR_MAC=$(/sbin/ifconfig ${ALX_IFACE} | grep HWaddr | cut -d ' ' -f11)

	echo -e ${COLMAGENTA}"Unregister system from database"${COLDEFAULT}

	mysqldo "delete from state_connected where serial='${ALX_SERIAL}' and mac='${CUR_MAC}';"
	evaluate_retval
}


########### starts here ################

# first of all get current system serial
if [ -f /etc/alxconfig-ng/serial ]
then
	source /etc/alxconfig-ng/serial
else
	ALX_SERIAL=0
fi

case $1 in
	start)
		# check if mysql server is reachable
		# if not abort this script
		reach_mysql_server || exit 1

		set_current_network_state
		evaluate_retval
		;;

	stop)
		# check if mysql server is reachable
		# if not abort this script
		reach_mysql_server || exit 1

		unset_alx_connected
		evaluate_retval
		;;
	*)
		echo "Usage: $0 {start|stop} ..."
		;;
esac

1	niro	386	#!/bin/bash
2
3	niro	482	#%rlevels: 3:s 0:k
4	niro	386	#%start: 99
5			#%stop: 01
6
7			#deps
8			#%needs:
9			#%before:
10			#%after:
11
12	niro	537	# $Id$
13	niro	386
14	niro	502	source /etc/conf.d/rc
15			source ${rc_functions}
16	niro	386
17			# mysql settings
18			source /etc/alxconfig-ng/config.rc
19			source /usr/lib/alxconfig-ng/functions/mysqlfunctions
20			source /usr/lib/alxconfig-ng/functions/serial_functions
21
22			# unset vars which may kill us
23			unset ALX_SERIAL ALX_STATE ALX_IFACE
24
25			# get current system state
26			if [ -f /etc/alxconfig-ng/state/state ]
27			then
28			source /etc/alxconfig-ng/state/state
29			else
30			ALX_STATE=error
31			fi
32
33			if [ -f ${SETTINGSPATH}/confd-networking ]
34			then
35			ALX_IFACE="$(< ${SETTINGSPATH}/confd-networking)"
36			fi
37			[[ -z ${ALX_IFACE} ]] && export ALX_IFACE=eth0
38
39			# need to put this to an extra init script which will be
40			# executed when the real network is up and not the preliminary.
41			# nice name is alx_connected_state or sth like this
42			set_current_network_state()
43			{
44			local CUR_IP CUR_MAC ID
45
46			echo -e ${COLMAGENTA}"Register system to database"${COLDEFAULT}
47
48			CUR_IP=$(/sbin/ifconfig ${ALX_IFACE} \| sed -n '/addr:/s/ [^r]*..//gp')
49			CUR_MAC=$(/sbin/ifconfig ${ALX_IFACE} \| grep HWaddr \| cut -d ' ' -f11)
50			CUR_MTIME=$(date +%s)
51
52			# validate current serial
53			if ! validate_serial "${ALX_SERIAL}" "${ALX_REG_DATE}" "${CUR_MAC}"
54			then
55			# abort on non valid serial
56			ALX_STATE="invalid serial"
57			echo "ALX_STATE=${ALX_STATE}" > /etc/alxconfig-ng/state/state
58			show_invalid_serial_msg
59			exit 1
60			fi
61
62			# first check if an entry exist with my serial
63			# if it exist update this entry else insert a new one
64			ID=$(mysqldo "select serial from state_connected where serial=${ALX_SERIAL};")
65
66			if [ -n "${ID}" ]
67			then
68			# run an update
69
70			# nice status
71			$CURS_UP
72			$SET_WCOL
73			echo "[ U, State: ${ALX_STATE} ]"
74
75			mysqldo "update state_connected set
76			hostname='${HOSTNAME}',
77			ip='${CUR_IP}',
78			mac='${CUR_MAC}',
79			state='${ALX_STATE}',
80			mtime='${CUR_MTIME}'
81			where serial=${ALX_SERIAL};"
82			else
83			# run an insert
84
85			# nice status
86			$CURS_UP
87			$SET_WCOL
88			echo "[ N, State: ${ALX_STATE} ]"
89
90			mysqldo "insert into state_connected(
91			serial,
92			hostname,
93			ip,
94			mac,
95			state,
96			mtime
97			)
98			values(
99			'${ALX_SERIAL}',
100			'${HOSTNAME}',
101			'${CUR_IP}',
102			'${CUR_MAC}',
103			'${ALX_STATE}',
104			'${CUR_MTIME}'
105			);"
106			fi
107			}
108
109
110			# need to put this to an extra init script which will
111			# be executed first when the system is going down.
112			# nice name is alx_connected_state or sth like this
113			unset_alx_connected()
114			{
115			local SQL_OPTS
116			local CUR_MAC
117
118			CUR_MAC=$(/sbin/ifconfig ${ALX_IFACE} \| grep HWaddr \| cut -d ' ' -f11)
119
120			echo -e ${COLMAGENTA}"Unregister system from database"${COLDEFAULT}
121
122			mysqldo "delete from state_connected where serial='${ALX_SERIAL}' and mac='${CUR_MAC}';"
123			evaluate_retval
124			}
125
126
127			########### starts here ################
128
129			# first of all get current system serial
130			if [ -f /etc/alxconfig-ng/serial ]
131			then
132			source /etc/alxconfig-ng/serial
133			else
134			ALX_SERIAL=0
135			fi
136
137			case $1 in
138			start)
139			# check if mysql server is reachable
140			# if not abort this script
141			reach_mysql_server \|\| exit 1
142
143			set_current_network_state
144			evaluate_retval
145			;;
146
147			stop)
148			# check if mysql server is reachable
149			# if not abort this script
150			reach_mysql_server \|\| exit 1
151
152			unset_alx_connected
153			evaluate_retval
154			;;
155			*)
156			echo "Usage: $0 {start\|stop} ..."
157			;;
158			esac
159