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:

# 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/mysqlfunctions
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
}

# 1.serial 2.mtime 3.mac
validate_serial()
{
	local serial
	local db_serial
	local mtime
	local mac

	# abort if params are missing
	[ $# -ne 3 ] && return 1

	serial=$1
	mtime=$2
	mac=$3

	db_serial=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
		"select serial from client_serials where mtime='${mtime}' and mac='${mac}'" )

	if [[ ${db_serial} = ${serial} ]]
	then
		return 0
	else
		return 1
	fi
}

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