alxconfig-ng/init.d/alxsettings

#!/bin/bash

# <niro@magellan-linux.de>

#%rlevels: 7:s 0:k 6:k
#%start: 41
#%stop: 01

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

# $Header: /home/cvsd/alx-cvs/alx-src/alxconfig-ng/init.d/alxsettings,v 1.3 2005-03-09 00:04:23 niro Exp $

# checks first if the client was already configured and if it has an valid serial
# if not it runs the autoconfiguration script
# these settings will be used for client setup
#
# if client was valid it first will check if his settings against the server
# if no changes are at server side they will be kept, if yes the get updated. 
# the server settings has higher priority.

source /etc/sysconfig/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
source /usr/lib/alxconfig-ng/functions/config_network
source /usr/lib/alxconfig-ng/functions/config_printers
source /usr/lib/alxconfig-ng/functions/config_x11

#check if mysql is available
[ -x /usr/bin/mysql ] && MYSQL_ALX=true

#other needed vars
ALX_HW_DETECT=false

#unset vars which may kill us
unset ALX_SERIAL ALX_STATE


#setup needed directories
[ ! -d /etc/alxconfig-ng/state ] && install -d /etc/alxconfig-ng/state


validate_sessions(){

	local x i all LOCAL_SESSIONS DB_SESSIONS SETTINGSPATH count
	
	#all arrays:
	# ->  session1 session2 ... sessionN
	
	
	#no LOCAL_SESSIONS here, needs bubblesort
	
	#get settings from database
	all=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
			"select session from cfg_sessions where serial='${ALX_SERIAL}'")
	
	#split'em up and put in an array (only if $all not zero)
	declare -i i=0
	if [ -n "${all}" ]
	then
		for x in ${all}
		do
			DB_SESSIONS[${i}]=${x}
			((i++))
		done
		count=${i}
	else
		count=0
	fi
	
	## no compare here, can only done with bubblesort or s.th like that
	# shows only the new sessions
	declare -i i=0
	#count=${#DB_SESSIONS[*]} #---> not working gets always 1, why ?
	
	echo "Number of new sessions: ${count}"
	for ((i=0; i < count; i++))
	do
		echo "${i} - ${DB_SESSIONS[${i}]}"
	done
	
	#update local configs
	SETTINGSPATH=${SETTINGS_TEMPLATE}/menu
	declare -i i=0
	
	#count=${#DB_SESSIONS[*]}
	
	if [ ${count} -gt 0 ]
	then
		#create directory if not exist
		[ ! -d ${SETTINGSPATH}/sessions ] && install -d ${SETTINGSPATH}/sessions
		
		#delete old sessions
		echo -n > ${SETTINGSPATH}/sessions/sessions
		
		for ((i=0; i < count; i++))
		do
			echo "${DB_SESSIONS[${i}]}" >> ${SETTINGSPATH}/sessions/sessions
		done
		
		#set update flag
		ALX_SESSION_SETUP=true
	fi
}


update_system_settings(){
	echo -e ${COLMAGENTA}"Checking system setup ..."${COLDEFAULT}

	# imports network settings from db
	config_networking

	# imports x11 settings from db
	config_x11

	#echo
	#echo "sessions"
	#validate_sessions
	#echo

	# imports printer settings from db
	config_printing
}

get_system_serial(){

	local CUR_IP CUR_MAC CUR_MTIME

	#check if serial file exists
	if [ -f /etc/alxconfig-ng/serial ]
	then
		source /etc/alxconfig-ng/serial

		# if system is already configured, it *has* a hostname.
		# so we take the hostname of this system here
		source /etc/hostname

		#start preliminary networking (dhcp)
		preliminary_network start

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

		echo -e ${COLOREDSTAR} "Trying to validate my serial ..."

		#nice serial output
		$CURS_UP
		$SET_WCOL
		echo "[ SN: ${ALX_SERIAL} ]"

		if validate_serial "${ALX_SERIAL}" "${ALX_REG_DATE}" "${CUR_MAC}"
		then
			ALX_STATE="ok"
		else
			ALX_STATE="invalid serial"
		fi

	else
		#run hardware detection
		echo
		echo -e ${COLMAGENTA}"Preparing system for first boot"${COLDEFAULT}
		ALX_HW_DETECT=true
		/etc/init.d/hwdetect start

		#set hostname to alx_default_hostname
		[ -z "${ALX_DEFAULT_HOSTNAME}" ] && ALX_DEFAULT_HOSTNAME=magellan-alx
		HOSTNAME="${ALX_DEFAULT_HOSTNAME}"

		#update the hostname on the system for sure
		echo "HOSTNAME=${HOSTNAME}" > /etc/hostname

		#start preliminary networking (dhcp)
		preliminary_network start

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

		echo -e ${COLOREDSTAR} "Trying to get new serial ..."

		#request new serial
		#ALX_REG_DATE="$(date +%F)"

		#we're using the mtime now (better for vaildating the serial)
		mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
			"insert into client_serials(
				mtime,
				mac
			) 
			values(
				'${CUR_MTIME}',
				'${CUR_MAC}'
			);"

		#then validate and retrieve serial

		### warning must be changed that only the LAST ID will be fetched,  ###
		### or you get error if the computer name and date are the same     ###
		### you have more than one serial number then                       ###

		#select highest id only (added max)
		ALX_SERIAL=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
			"select max(serial) from client_serials where mtime='${CUR_MTIME}' and mac='${CUR_MAC}'")

		if [ "${ALX_SERIAL}" != NULL ]
		then
			#nice serial output
			$CURS_UP
			$SET_WCOL
			echo "[ SN: ${ALX_SERIAL} ]"

			#set ALX_STATE to ok so everybody that everything was ok
			ALX_STATE=ok

			echo "ALX_SERIAL=${ALX_SERIAL}" > /etc/alxconfig-ng/serial
			echo "ALX_REG_DATE=${CUR_MTIME}" >> /etc/alxconfig-ng/serial

			evaluate_retval
		else
			#print false (works only if this is the first statement here)
			evaluate_retval

			#set ALX_STATE to error so everybody sees there was an error
			ALX_STATE=error

			#show an error that no new serial was found
			#nice serial output
			$CURS_UP
			$SET_WCOL
			echo -e "[ SN: ${COLRED}None, 0${COLDEFAULT} ]"
		fi
	fi

	#write current state to temp file
	echo "ALX_STATE=${ALX_STATE}" > /etc/alxconfig-ng/state/state
}


check_is_configured() {
	if [ -f /etc/alxconfig-ng/state/configured ]
	then
		export ALX_CONFIGURED=true
	else
		export ALX_CONFIGURED=false
	fi
}


# imports current settings to the database resolved by the hardware detection
import_settings_to_db() {
	#note: networking is always 'dhcp' if hw was autodetected
	#note: default_domain/hostname is set in config.rc
	
	#to be safe, we do some sanity checks
	[ -z "${ALX_DEFAULT_DOMAIN}" ] && ALX_DEFAULT_DOMAIN=localdomain
	[ -z "${ALX_DEFAULT_HOSTNAME}" ] && ALX_DEFAULT_HOSTNAME=magellan-alx
	
	#vars used by hwdetect
	local NETCARD_FULLNAME NETCARD_DRIVER MOUSE_FULLNAME MOUSE_DEVICE SOUND_FULLNAME
	local SOUND_DRIVER XSERVER XMODULE XDESC FLOPPY_FULLNAME FLOPPY_DEVICE FLOPPY_DRIVER
	local MOUSETYPE XMOUSETYPE FULLNAME DEVICE
	
	#get setting from hwdetect
	source /etc/sysconfig/hwsetup/knoppix
	source /etc/sysconfig/hwsetup/mouse
	
	echo
	echo -e ${COLMAGENTA}"Importing detected settings to database"${COLDEFAULT}
	
	#network
	echo -e "      Network settings ..."
	mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
		"insert into cfg_network(
			hostname,
			serial,
			module,
			domain,
			networking
		)
		values(
			'${ALX_DEFAULT_HOSTNAME}',
			'${ALX_SERIAL}',
			'${NETCARD_DRIVER}',
			'${ALX_DEFAULT_DOMAIN}',
			'dhcp'
		);"
	evaluate_retval
	
	#xserver
	echo -e "      Graphic settings ..."
	#xserver general
	( mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
		"insert into cfg_graphic(
			serial,
			module,
			resolution,
			depth
		)
		values(
			'${ALX_SERIAL}',
			'${XMODULE}',
			'1024x768',
			'16'
		);";
	#xserver monitor
	  mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
		"insert into cfg_monitor(
			serial,
			vendor,
			model,
			hsync,
			vrefresh
		)
		values(
			'${ALX_SERIAL}',
			'Aamazing',
			'CM-1528-FS',
			'28-64',
			'47-104'
		);";
		
	# input
	  mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
			"insert into cfg_input(serial,mouse) values('${ALX_SERIAL}','${XMOUSETYPE}');";)
	evaluate_retval
}

# imports current settings to the local system resolved by the hardware detection
# we only need the network settings 
import_settings_local(){
	#note: networking is always 'dhcp' if hw was autodetected
	#note: default_domain/hostname is set in config.rc

	#to be safe, we do some sanity checks
	[ -z "${ALX_DEFAULT_DOMAIN}" ] && ALX_DEFAULT_DOMAIN=localdomain
	[ -z "${ALX_DEFAULT_HOSTNAME}" ] && ALX_DEFAULT_HOSTNAME=magellan-alx

	#vars used by hwdetect
	local NETCARD_FULLNAME NETCARD_DRIVER MOUSE_FULLNAME MOUSE_DEVICE SOUND_FULLNAME
	local SOUND_DRIVER XSERVER XMODULE XDESC FLOPPY_FULLNAME FLOPPY_DEVICE FLOPPY_DRIVER
	local MOUSETYPE XMOUSETYPE FULLNAME DEVICE

	#get setting from hwdetect
	source /etc/sysconfig/hwsetup/knoppix

	echo
	echo -e ${COLMAGENTA}"Importing detected settings to local system"${COLDEFAULT}

	[ ! -d ${SETTINGSPATH} ] && install -d ${SETTINGSPATH}
	echo "${NETCARD_DRIVER}" > ${SETTINGSPATH}/modules
	evaluate_retval

	#set system state to 'already configured'
	touch /etc/alxconfig-ng/state/configured
}

#start|stop
preliminary_network(){
	local module

	if [ -f /etc/alxconfig-ng/state/configured ]
	then
		#get module name
		module=$(cat ${SETTINGSPATH}/modules)
		modprobe ${module}
	else
		#vars used by hwdetect
		local NETCARD_FULLNAME NETCARD_DRIVER MOUSE_FULLNAME MOUSE_DEVICE SOUND_FULLNAME
		local SOUND_DRIVER XSERVER XMODULE XDESC FLOPPY_FULLNAME FLOPPY_DEVICE FLOPPY_DRIVER

		#get setting from hwdetect
		source /etc/sysconfig/hwsetup/knoppix
		modprobe ${NETCARD_DRIVER}
	fi

	case $1 in
		start)
			# keeping like always safe:
			# no network should be startet here,
			# so we can delete all pid files if one exists
			if ps -A|grep dhcpcd > /dev/null
			then
				echo -e ${COLMAGENTA}"Forcing network down"${COLDEFAULT}
				dhcpcd -k
				sleep 1
			else
				rm -f /var/run/dhcpcd-eth?.pid
			fi

			echo -e ${COLMAGENTA}"Starting preliminary network ... "${COLDEFAULT}
			dhcpcd &> /dev/null

			# aka_fix ########################################
			#ifconfig eth0 128.20.222.222 netmask 255.255.0.0 up
			#route del default gw 128.20.50.13 &> /dev/null
			#route add default gw 128.20.50.21 &> /dev/null
			#echo "nameserver 128.20.50.21" > /etc/resolv.conf
			##################################################

			evaluate_retval
			;;

		stop)
			echo -e ${COLMAGENTA}"Stopping preliminary network ... "${COLDEFAULT}
			ifconfig eth0 down
			if ps -A|grep dhcpcd > /dev/null
			then
				dhcpcd -z  &> /dev/null
			fi
			evaluate_retval
			;;

		*)
			echo "Usage: preliminary_network {start|stop}"
			;;
	esac
}

case $1 in
	start)
		#retrieve or validate current serial
		get_system_serial
		if [ "${ALX_HW_DETECT}" == "true" ]
		then
			import_settings_to_db
			import_settings_local
		fi
		
		#now setup system configuration
		#alx_setup_or_whatever_it_will_be_called()
		[ "${ALX_HW_DETECT}" == "false" ] && update_system_settings

		#stop at last the preliminary networking (dhcp)
		preliminary_network stop
		;;
	
	stop)
		#unset_alx_connected #--> now in alxsetstate-rc6
		# ! important !: del systemstate
		[ -f /etc/alxconfig-ng/state/state ] && rm /etc/alxconfig-ng/state/state
		sleep 0.1
		;;
	*)
		echo "Usage: $0 {start|stop} ..."
		;;
esac
1	niro	221	#!/bin/bash
2
3			# <niro@magellan-linux.de>
4
5			#%rlevels: 7:s 0:k 6:k
6			#%start: 41
7			#%stop: 01
8
9			#deps
10			#%needs:
11			#%before:
12			#%after:
13
14	niro	227	# $Header: /home/cvsd/alx-cvs/alx-src/alxconfig-ng/init.d/alxsettings,v 1.3 2005-03-09 00:04:23 niro Exp $
15
16	niro	221	# checks first if the client was already configured and if it has an valid serial
17			# if not it runs the autoconfiguration script
18			# these settings will be used for client setup
19			#
20			# if client was valid it first will check if his settings against the server
21			# if no changes are at server side they will be kept, if yes the get updated.
22			# the server settings has higher priority.
23
24			source /etc/sysconfig/rc
25			source $rc_functions
26
27			#mysql settings
28	niro	226	source /etc/alxconfig-ng/config.rc
29			source /usr/lib/alxconfig-ng/functions/mysqlfunctions
30	niro	227	source /usr/lib/alxconfig-ng/functions/serial_functions
31	niro	226	source /usr/lib/alxconfig-ng/functions/config_network
32			source /usr/lib/alxconfig-ng/functions/config_printers
33			source /usr/lib/alxconfig-ng/functions/config_x11
34	niro	221
35			#check if mysql is available
36			[ -x /usr/bin/mysql ] && MYSQL_ALX=true
37
38			#other needed vars
39			ALX_HW_DETECT=false
40
41			#unset vars which may kill us
42			unset ALX_SERIAL ALX_STATE
43
44
45			#setup needed directories
46	niro	226	[ ! -d /etc/alxconfig-ng/state ] && install -d /etc/alxconfig-ng/state
47	niro	221
48
49			validate_sessions(){
50
51			local x i all LOCAL_SESSIONS DB_SESSIONS SETTINGSPATH count
52
53			#all arrays:
54			# -> session1 session2 ... sessionN
55
56
57			#no LOCAL_SESSIONS here, needs bubblesort
58
59			#get settings from database
60			all=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
61			"select session from cfg_sessions where serial='${ALX_SERIAL}'")
62
63			#split'em up and put in an array (only if $all not zero)
64			declare -i i=0
65			if [ -n "${all}" ]
66			then
67			for x in ${all}
68			do
69			DB_SESSIONS[${i}]=${x}
70			((i++))
71			done
72			count=${i}
73			else
74			count=0
75			fi
76
77			## no compare here, can only done with bubblesort or s.th like that
78			# shows only the new sessions
79			declare -i i=0
80			#count=${#DB_SESSIONS[*]} #---> not working gets always 1, why ?
81
82			echo "Number of new sessions: ${count}"
83			for ((i=0; i < count; i++))
84			do
85			echo "${i} - ${DB_SESSIONS[${i}]}"
86			done
87
88			#update local configs
89			SETTINGSPATH=${SETTINGS_TEMPLATE}/menu
90			declare -i i=0
91
92			#count=${#DB_SESSIONS[*]}
93
94			if [ ${count} -gt 0 ]
95			then
96			#create directory if not exist
97			[ ! -d ${SETTINGSPATH}/sessions ] && install -d ${SETTINGSPATH}/sessions
98
99			#delete old sessions
100			echo -n > ${SETTINGSPATH}/sessions/sessions
101
102			for ((i=0; i < count; i++))
103			do
104			echo "${DB_SESSIONS[${i}]}" >> ${SETTINGSPATH}/sessions/sessions
105			done
106
107			#set update flag
108			ALX_SESSION_SETUP=true
109			fi
110			}
111
112
113	niro	226	update_system_settings(){
114			echo -e ${COLMAGENTA}"Checking system setup ..."${COLDEFAULT}
115	niro	221
116	niro	226	# imports network settings from db
117			config_networking
118
119			# imports x11 settings from db
120			config_x11
121
122			#echo
123			#echo "sessions"
124			#validate_sessions
125			#echo
126
127			# imports printer settings from db
128			config_printing
129	niro	221	}
130
131			get_system_serial(){
132
133			local CUR_IP CUR_MAC CUR_MTIME
134
135			#check if serial file exists
136	niro	226	if [ -f /etc/alxconfig-ng/serial ]
137	niro	221	then
138	niro	226	source /etc/alxconfig-ng/serial
139
140	niro	221	# if system is already configured, it has a hostname.
141			# so we take the hostname of this system here
142			source /etc/hostname
143	niro	226
144			#start preliminary networking (dhcp)
145	niro	221	preliminary_network start
146	niro	226
147	niro	221	CUR_IP=$(/sbin/ifconfig eth0 \| sed -n '/addr:/s/ [^r]*..//gp')
148			CUR_MAC=$(/sbin/ifconfig eth0 \| grep HWaddr \| cut -d ' ' -f11)
149			CUR_MTIME=$(date +%s)
150	niro	226
151	niro	221	echo -e ${COLOREDSTAR} "Trying to validate my serial ..."
152	niro	226
153	niro	221	#nice serial output
154			$CURS_UP
155			$SET_WCOL
156			echo "[ SN: ${ALX_SERIAL} ]"
157
158			if validate_serial "${ALX_SERIAL}" "${ALX_REG_DATE}" "${CUR_MAC}"
159			then
160			ALX_STATE="ok"
161			else
162			ALX_STATE="invalid serial"
163			fi
164
165			else
166			#run hardware detection
167			echo
168			echo -e ${COLMAGENTA}"Preparing system for first boot"${COLDEFAULT}
169			ALX_HW_DETECT=true
170			/etc/init.d/hwdetect start
171	niro	226
172	niro	221	#set hostname to alx_default_hostname
173			[ -z "${ALX_DEFAULT_HOSTNAME}" ] && ALX_DEFAULT_HOSTNAME=magellan-alx
174			HOSTNAME="${ALX_DEFAULT_HOSTNAME}"
175	niro	226
176	niro	221	#update the hostname on the system for sure
177			echo "HOSTNAME=${HOSTNAME}" > /etc/hostname
178	niro	226
179	niro	221	#start preliminary networking (dhcp)
180			preliminary_network start
181	niro	226
182	niro	221	CUR_IP=$(/sbin/ifconfig eth0 \| sed -n '/addr:/s/ [^r]*..//gp')
183			CUR_MAC=$(/sbin/ifconfig eth0 \| grep HWaddr \| cut -d ' ' -f11)
184			CUR_MTIME=$(date +%s)
185	niro	226
186	niro	221	echo -e ${COLOREDSTAR} "Trying to get new serial ..."
187	niro	226
188	niro	221	#request new serial
189			#ALX_REG_DATE="$(date +%F)"
190	niro	226
191	niro	221	#we're using the mtime now (better for vaildating the serial)
192			mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
193			"insert into client_serials(
194			mtime,
195			mac
196			)
197			values(
198			'${CUR_MTIME}',
199			'${CUR_MAC}'
200			);"
201	niro	226
202	niro	221	#then validate and retrieve serial
203	niro	226
204	niro	221	### warning must be changed that only the LAST ID will be fetched, ###
205			### or you get error if the computer name and date are the same ###
206	niro	226	### you have more than one serial number then ###
207
208	niro	221	#select highest id only (added max)
209			ALX_SERIAL=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
210			"select max(serial) from client_serials where mtime='${CUR_MTIME}' and mac='${CUR_MAC}'")
211
212			if [ "${ALX_SERIAL}" != NULL ]
213			then
214			#nice serial output
215			$CURS_UP
216			$SET_WCOL
217			echo "[ SN: ${ALX_SERIAL} ]"
218	niro	226
219	niro	221	#set ALX_STATE to ok so everybody that everything was ok
220			ALX_STATE=ok
221	niro	226
222			echo "ALX_SERIAL=${ALX_SERIAL}" > /etc/alxconfig-ng/serial
223			echo "ALX_REG_DATE=${CUR_MTIME}" >> /etc/alxconfig-ng/serial
224
225	niro	221	evaluate_retval
226			else
227			#print false (works only if this is the first statement here)
228			evaluate_retval
229	niro	226
230	niro	221	#set ALX_STATE to error so everybody sees there was an error
231			ALX_STATE=error
232	niro	226
233	niro	221	#show an error that no new serial was found
234			#nice serial output
235			$CURS_UP
236			$SET_WCOL
237			echo -e "[ SN: ${COLRED}None, 0${COLDEFAULT} ]"
238			fi
239			fi
240	niro	226
241	niro	221	#write current state to temp file
242	niro	226	echo "ALX_STATE=${ALX_STATE}" > /etc/alxconfig-ng/state/state
243	niro	221	}
244
245
246			check_is_configured() {
247	niro	226	if [ -f /etc/alxconfig-ng/state/configured ]
248	niro	221	then
249			export ALX_CONFIGURED=true
250			else
251			export ALX_CONFIGURED=false
252			fi
253			}
254
255
256			# imports current settings to the database resolved by the hardware detection
257			import_settings_to_db() {
258			#note: networking is always 'dhcp' if hw was autodetected
259			#note: default_domain/hostname is set in config.rc
260
261			#to be safe, we do some sanity checks
262			[ -z "${ALX_DEFAULT_DOMAIN}" ] && ALX_DEFAULT_DOMAIN=localdomain
263			[ -z "${ALX_DEFAULT_HOSTNAME}" ] && ALX_DEFAULT_HOSTNAME=magellan-alx
264
265			#vars used by hwdetect
266			local NETCARD_FULLNAME NETCARD_DRIVER MOUSE_FULLNAME MOUSE_DEVICE SOUND_FULLNAME
267			local SOUND_DRIVER XSERVER XMODULE XDESC FLOPPY_FULLNAME FLOPPY_DEVICE FLOPPY_DRIVER
268			local MOUSETYPE XMOUSETYPE FULLNAME DEVICE
269
270			#get setting from hwdetect
271			source /etc/sysconfig/hwsetup/knoppix
272			source /etc/sysconfig/hwsetup/mouse
273
274			echo
275			echo -e ${COLMAGENTA}"Importing detected settings to database"${COLDEFAULT}
276
277			#network
278			echo -e " Network settings ..."
279			mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
280			"insert into cfg_network(
281			hostname,
282			serial,
283			module,
284			domain,
285			networking
286			)
287			values(
288			'${ALX_DEFAULT_HOSTNAME}',
289			'${ALX_SERIAL}',
290			'${NETCARD_DRIVER}',
291			'${ALX_DEFAULT_DOMAIN}',
292			'dhcp'
293			);"
294			evaluate_retval
295
296			#xserver
297			echo -e " Graphic settings ..."
298			#xserver general
299			( mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
300			"insert into cfg_graphic(
301			serial,
302			module,
303			resolution,
304			depth
305			)
306			values(
307			'${ALX_SERIAL}',
308			'${XMODULE}',
309			'1024x768',
310			'16'
311			);";
312			#xserver monitor
313			mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
314			"insert into cfg_monitor(
315			serial,
316			vendor,
317			model,
318			hsync,
319			vrefresh
320			)
321			values(
322			'${ALX_SERIAL}',
323			'Aamazing',
324			'CM-1528-FS',
325			'28-64',
326			'47-104'
327			);";
328
329			# input
330			mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
331			"insert into cfg_input(serial,mouse) values('${ALX_SERIAL}','${XMOUSETYPE}');";)
332			evaluate_retval
333			}
334
335			# imports current settings to the local system resolved by the hardware detection
336	niro	226	# we only need the network settings
337	niro	221	import_settings_local(){
338			#note: networking is always 'dhcp' if hw was autodetected
339			#note: default_domain/hostname is set in config.rc
340	niro	226
341	niro	221	#to be safe, we do some sanity checks
342			[ -z "${ALX_DEFAULT_DOMAIN}" ] && ALX_DEFAULT_DOMAIN=localdomain
343			[ -z "${ALX_DEFAULT_HOSTNAME}" ] && ALX_DEFAULT_HOSTNAME=magellan-alx
344	niro	226
345	niro	221	#vars used by hwdetect
346			local NETCARD_FULLNAME NETCARD_DRIVER MOUSE_FULLNAME MOUSE_DEVICE SOUND_FULLNAME
347			local SOUND_DRIVER XSERVER XMODULE XDESC FLOPPY_FULLNAME FLOPPY_DEVICE FLOPPY_DRIVER
348			local MOUSETYPE XMOUSETYPE FULLNAME DEVICE
349
350			#get setting from hwdetect
351			source /etc/sysconfig/hwsetup/knoppix
352	niro	226
353	niro	221	echo
354			echo -e ${COLMAGENTA}"Importing detected settings to local system"${COLDEFAULT}
355
356	niro	226	[ ! -d ${SETTINGSPATH} ] && install -d ${SETTINGSPATH}
357			echo "${NETCARD_DRIVER}" > ${SETTINGSPATH}/modules
358			evaluate_retval
359	niro	221
360			#set system state to 'already configured'
361	niro	226	touch /etc/alxconfig-ng/state/configured
362	niro	221	}
363
364			#start\|stop
365			preliminary_network(){
366			local module
367	niro	226
368			if [ -f /etc/alxconfig-ng/state/configured ]
369	niro	221	then
370			#get module name
371	niro	226	module=$(cat ${SETTINGSPATH}/modules)
372	niro	221	modprobe ${module}
373			else
374			#vars used by hwdetect
375			local NETCARD_FULLNAME NETCARD_DRIVER MOUSE_FULLNAME MOUSE_DEVICE SOUND_FULLNAME
376			local SOUND_DRIVER XSERVER XMODULE XDESC FLOPPY_FULLNAME FLOPPY_DEVICE FLOPPY_DRIVER
377	niro	226
378	niro	221	#get setting from hwdetect
379			source /etc/sysconfig/hwsetup/knoppix
380			modprobe ${NETCARD_DRIVER}
381			fi
382	niro	226
383	niro	221	case $1 in
384			start)
385			# keeping like always safe:
386			# no network should be startet here,
387			# so we can delete all pid files if one exists
388			if ps -A\|grep dhcpcd > /dev/null
389			then
390			echo -e ${COLMAGENTA}"Forcing network down"${COLDEFAULT}
391			dhcpcd -k
392			sleep 1
393			else
394			rm -f /var/run/dhcpcd-eth?.pid
395			fi
396	niro	226
397	niro	221	echo -e ${COLMAGENTA}"Starting preliminary network ... "${COLDEFAULT}
398	niro	226	dhcpcd &> /dev/null
399
400	niro	221	# aka_fix ########################################
401	niro	226	#ifconfig eth0 128.20.222.222 netmask 255.255.0.0 up
402			#route del default gw 128.20.50.13 &> /dev/null
403			#route add default gw 128.20.50.21 &> /dev/null
404			#echo "nameserver 128.20.50.21" > /etc/resolv.conf
405	niro	221	##################################################
406	niro	226
407	niro	221	evaluate_retval
408			;;
409	niro	226
410	niro	221	stop)
411			echo -e ${COLMAGENTA}"Stopping preliminary network ... "${COLDEFAULT}
412			ifconfig eth0 down
413			if ps -A\|grep dhcpcd > /dev/null
414			then
415			dhcpcd -z &> /dev/null
416			fi
417			evaluate_retval
418			;;
419	niro	226
420	niro	221	*)
421			echo "Usage: preliminary_network {start\|stop}"
422			;;
423			esac
424			}
425
426			case $1 in
427			start)
428			#retrieve or validate current serial
429			get_system_serial
430			if [ "${ALX_HW_DETECT}" == "true" ]
431			then
432			import_settings_to_db
433			import_settings_local
434			fi
435
436			#now setup system configuration
437			#alx_setup_or_whatever_it_will_be_called()
438			[ "${ALX_HW_DETECT}" == "false" ] && update_system_settings
439
440			#stop at last the preliminary networking (dhcp)
441			preliminary_network stop
442			;;
443
444			stop)
445			#unset_alx_connected #--> now in alxsetstate-rc6
446			# ! important !: del systemstate
447	niro	226	[ -f /etc/alxconfig-ng/state/state ] && rm /etc/alxconfig-ng/state/state
448	niro	221	sleep 0.1
449			;;
450			*)
451			echo "Usage: $0 {start\|stop} ..."
452			;;
453			esac