alxconfig-ng/functions/config_sessions.sh

# $Header: /home/cvsd/alx-cvs/alx-src/alxconfig-ng/functions/config_sessions.sh,v 1.10 2005-08-18 02:51:16 niro Exp $
# configures ica-sessions on the host via mysql db settings

get_sessions_settings()
{
	local x i all count

	# all arrays:
	# ->  session1 session2 ... sessionN

	# get settings from database
	all=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
			"select filename 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
			ALX_SESSIONS[${i}]=${x}
			((i++))
		done
		count=${i}
	else
		count=0
	fi

	export ALX_SESSIONS
}

get_autostart_settings()
{
	# get settings from database
	ALX_AUTOSTART=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
			"select session from cfg_autostart where serial='${ALX_SERIAL}'")

	export ALX_AUTOSTART
}

generate_ica_session_files()
{
	local all_ids
	local i
	local x
	local server
	local ses_session
	local ses_filename
	local ses_username
	local ses_domain
	local ses_password
	local ses_browseradrs
	local ses_colors

	# get settings from database
	all_ids=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
			"select id from cfg_sessions where serial='${ALX_SERIAL}'")

	for i in ${all_ids}
	do
		# get settings
		ses_session=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
				"select session from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")

		ses_filename=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
				"select filename from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")

		ses_username=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
				"select username from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")

		ses_domain=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
				"select domain from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")

		ses_password=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
				"select password from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")

		ses_browseradrs=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
				"select browseradrs from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")

		# get the right colors
		ses_colors=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
			"select depth from cfg_graphic where serial='${ALX_SERIAL}'")
		case ${ses_colors} in
			24) ses_colors="8";;
			16) ses_colors="4";;
			8) ses_colors="2";;
			*) ses_colors="2";;
		esac

		# write session files
		echo '[WFClient]' > ${ALX_ICA_SESSIONS}/${ses_filename}
		echo 'Version=2' >> ${ALX_ICA_SESSIONS}/${ses_filename}
		OLD_IFS="$IFS"
		IFS=";"
		declare -i x=0
		for server in ${ses_browseradrs}
		do
			(( x++ ))
			echo "TcpBrowserAddress${x}=${server}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
		done
		IFS="${OLD_IFS}"
		unset x
		unset OLD_IFS
		
		echo 'ScreenPercent=0' >> ${ALX_ICA_SESSIONS}/${ses_filename}

		echo '[ApplicationServers]' >> ${ALX_ICA_SESSIONS}/${ses_filename}
		echo "${ses_session}=" >> ${ALX_ICA_SESSIONS}/${ses_filename}
		
		echo "[${ses_session}]" >> ${ALX_ICA_SESSIONS}/${ses_filename}
		echo "Address=${ses_session}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
		echo "InitialProgram=#${ses_session}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
		echo "DesiredColor=${ses_colors}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
		echo 'TransportDriver=TCP/IP' >> ${ALX_ICA_SESSIONS}/${ses_filename}
		echo 'WinStationDriver=ICA 3.0' >> ${ALX_ICA_SESSIONS}/${ses_filename}
		echo "ClearPassword=${ses_password}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
		echo "Username=${ses_username}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
		echo "Domain=${ses_domain}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
		echo 'UseFullScreen=Yes' >> ${ALX_ICA_SESSIONS}/${ses_filename}
		echo 'NoWindowManager=True' >> ${ALX_ICA_SESSIONS}/${ses_filename}
	done
}

get_other_menuitems()
{
	local x i count name exec icon workdir

	# all arrays:
	# ->  session1 session2 ... sessionN

	# get settings from database
	count=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
		"select name from cfg_other_menuitems where serial='${ALX_SERIAL}'")

	# get all instances and put them into an array
	if [ -n "${count}" ]
	then
		for x in ${count}
		do
			# to be sure
			unset name
			unset exec
			unset workdir
			unset icon

			name=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
				"select name from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'")

			exec=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
				"select exec from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'")

			workdir=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
				"select workdir from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'")

			icon=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
				"select icon from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'")

			# debug only
			#echo "DEBUG: ${x}: name:'${name}' exec:'${exec}' workdir:'${workdir}' ic$

			# now echo config line for fluxbox-menu
			# make it "configureable" :P
			[ -n "${workdir}" ] && workdir="cd ${workdir};"
			[ -n "${icon}" ] && icon="[${icon}]"
			echo "[exec] (${name}) {${workdir}${exec}} ${icon}"
		done
	fi
}

config_sessions()
{
	# generate ica session files
	generate_ica_session_files

	# first of all get the vars
	get_sessions_settings
	get_autostart_settings

	local count=${#ALX_SESSIONS[*]}
	local icon
	local i

	# DEBUG
# 	declare -i i=0
# 	echo count=${count}
# 	echo "Number of new sessions: ${count}"
# 	for ((i=0; i < count; i++))
# 	do
# 		echo "${i} - ${ALX_SESSIONS[${i}]}"
# 	done

	# now setup fluxbox for user station

	# create a fresh fluxbox directory
	[ -d ${ALX_UNPRIV_HOME}/.fluxbox ] && rm -rf ${ALX_UNPRIV_HOME}/.fluxbox
	install -d ${ALX_UNPRIV_HOME}/.fluxbox

	# now generate fluxbox config files

	# fluxbox main config
	cat ${ALX_SKELETONS}/fluxbox/init \
		> ${ALX_UNPRIV_HOME}/.fluxbox/init

	# fluxbox autostart
	cat ${ALX_SKELETONS}/fluxbox/apps \
		> ${ALX_UNPRIV_HOME}/.fluxbox/apps

	# add autostart session
	if [[ ${ALX_AUTOSTART} != "" ]]
	then
		echo "[startup] {wfica ${ALX_ICA_SESSIONS}/${ALX_AUTOSTART}}" \
			>> ${ALX_UNPRIV_HOME}/.fluxbox/apps
	fi

	# fluxbox hotkeys
	cat ${ALX_SKELETONS}/fluxbox/apps \
		> ${ALX_UNPRIV_HOME}/.fluxbox/keys

	# fluxbox menu header
	cat ${ALX_SKELETONS}/fluxbox/menu.header \
		> ${ALX_UNPRIV_HOME}/.fluxbox/menu

	# now fix it with proper messages :P
	local ver="$(< /etc/mageversion)"
	sed -i "s:@CHANGEME@:alx-${ver}  #${ALX_SERIAL}:g" \
		${ALX_UNPRIV_HOME}/.fluxbox/menu

	# add a newline (maybe there is no crlf in the header)
	echo >> ${ALX_UNPRIV_HOME}/.fluxbox/menu

	# fluxbox menu sessions
	for (( i=0; i < count; i++ ))
	do
		[ -n "${ALX_SESSIONS[${i}]}" ] && \
			echo "[exec] ($(basename ${ALX_SESSIONS[${i}]} .ica)) {wfica ${ALX_ICA_SESSIONS}/${ALX_SESSIONS[${i}]}}" \
				>> ${ALX_UNPRIV_HOME}/.fluxbox/menu
	done

	# add other menuitems
	get_other_menuitems >> ${ALX_UNPRIV_HOME}/.fluxbox/menu

	# fluxbox menu footer
	cat ${ALX_SKELETONS}/fluxbox/menu.footer \
		>> ${ALX_UNPRIV_HOME}/.fluxbox/menu

	# add a newline (maybe there is no crlf in the footer)
	echo >> ${ALX_UNPRIV_HOME}/.fluxbox/menu

	# now we generate the desktop icons
	cat ${ALX_SKELETONS}/idesk/ideskrc \
		> ${ALX_UNPRIV_HOME}/.ideskrc

	# whipe out old stuff and install a fresh directory
	[ -d ${ALX_UNPRIV_HOME}/.idesktop ] && rm -rf ${ALX_UNPRIV_HOME}/.idesktop
	install -d ${ALX_UNPRIV_HOME}/.idesktop

	local name
	for (( i=0; i < count; i++ ))
	do
		name="$(basename ${ALX_SESSIONS[${i}]} .ica)"

		if [ -f ${ALX_SESSIONS_ICONS}/${name}.png ]
		then
			icon="${ALX_SESSIONS_ICONS}/${name}.png"
		else
			icon="${ALX_SESSIONS_ICONS}/default.png"
		fi

		echo "table Icon
Caption: ${name}
Command: wfica ${ALX_ICA_SESSIONS}/${name}.ica
Icon: ${icon}
end" > ${ALX_UNPRIV_HOME}/.idesktop/${name}.lnk
	done

	# set correct permissions
	chown ${ALX_UNPRIV_USER}:${ALX_UNPRIV_GROUP} ${ALX_UNPRIV_HOME}
	chown ${ALX_UNPRIV_USER}:${ALX_UNPRIV_GROUP} ${ALX_UNPRIV_HOME}/.fluxbox
	chmod 0755 ${ALX_UNPRIV_HOME}/.fluxbox
	chmod 0755 ${ALX_UNPRIV_HOME}/.idesktop
	chmod 0644 ${ALX_UNPRIV_HOME}/.ideskrc


	# unset vars
	unset ALX_SESSIONS
}
1	# $Header: /home/cvsd/alx-cvs/alx-src/alxconfig-ng/functions/config_sessions.sh,v 1.10 2005-08-18 02:51:16 niro Exp $
2	# configures ica-sessions on the host via mysql db settings
3
4	get_sessions_settings()
5	{
6	local x i all count
7
8	# all arrays:
9	# -> session1 session2 ... sessionN
10
11	# get settings from database
12	all=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
13	"select filename from cfg_sessions where serial='${ALX_SERIAL}'")
14
15	# split'em up and put in an array (only if $all not zero)
16	declare -i i=0
17	if [ -n "${all}" ]
18	then
19	for x in ${all}
20	do
21	ALX_SESSIONS[${i}]=${x}
22	((i++))
23	done
24	count=${i}
25	else
26	count=0
27	fi
28
29	export ALX_SESSIONS
30	}
31
32	get_autostart_settings()
33	{
34	# get settings from database
35	ALX_AUTOSTART=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
36	"select session from cfg_autostart where serial='${ALX_SERIAL}'")
37
38	export ALX_AUTOSTART
39	}
40
41	generate_ica_session_files()
42	{
43	local all_ids
44	local i
45	local x
46	local server
47	local ses_session
48	local ses_filename
49	local ses_username
50	local ses_domain
51	local ses_password
52	local ses_browseradrs
53	local ses_colors
54
55	# get settings from database
56	all_ids=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
57	"select id from cfg_sessions where serial='${ALX_SERIAL}'")
58
59	for i in ${all_ids}
60	do
61	# get settings
62	ses_session=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
63	"select session from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")
64
65	ses_filename=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
66	"select filename from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")
67
68	ses_username=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
69	"select username from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")
70
71	ses_domain=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
72	"select domain from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")
73
74	ses_password=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
75	"select password from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")
76
77	ses_browseradrs=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
78	"select browseradrs from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'")
79
80	# get the right colors
81	ses_colors=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
82	"select depth from cfg_graphic where serial='${ALX_SERIAL}'")
83	case ${ses_colors} in
84	24) ses_colors="8";;
85	16) ses_colors="4";;
86	8) ses_colors="2";;
87	*) ses_colors="2";;
88	esac
89
90	# write session files
91	echo '[WFClient]' > ${ALX_ICA_SESSIONS}/${ses_filename}
92	echo 'Version=2' >> ${ALX_ICA_SESSIONS}/${ses_filename}
93	OLD_IFS="$IFS"
94	IFS=";"
95	declare -i x=0
96	for server in ${ses_browseradrs}
97	do
98	(( x++ ))
99	echo "TcpBrowserAddress${x}=${server}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
100	done
101	IFS="${OLD_IFS}"
102	unset x
103	unset OLD_IFS
104
105	echo 'ScreenPercent=0' >> ${ALX_ICA_SESSIONS}/${ses_filename}
106
107	echo '[ApplicationServers]' >> ${ALX_ICA_SESSIONS}/${ses_filename}
108	echo "${ses_session}=" >> ${ALX_ICA_SESSIONS}/${ses_filename}
109
110	echo "[${ses_session}]" >> ${ALX_ICA_SESSIONS}/${ses_filename}
111	echo "Address=${ses_session}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
112	echo "InitialProgram=#${ses_session}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
113	echo "DesiredColor=${ses_colors}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
114	echo 'TransportDriver=TCP/IP' >> ${ALX_ICA_SESSIONS}/${ses_filename}
115	echo 'WinStationDriver=ICA 3.0' >> ${ALX_ICA_SESSIONS}/${ses_filename}
116	echo "ClearPassword=${ses_password}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
117	echo "Username=${ses_username}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
118	echo "Domain=${ses_domain}" >> ${ALX_ICA_SESSIONS}/${ses_filename}
119	echo 'UseFullScreen=Yes' >> ${ALX_ICA_SESSIONS}/${ses_filename}
120	echo 'NoWindowManager=True' >> ${ALX_ICA_SESSIONS}/${ses_filename}
121	done
122	}
123
124	get_other_menuitems()
125	{
126	local x i count name exec icon workdir
127
128	# all arrays:
129	# -> session1 session2 ... sessionN
130
131	# get settings from database
132	count=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
133	"select name from cfg_other_menuitems where serial='${ALX_SERIAL}'")
134
135	# get all instances and put them into an array
136	if [ -n "${count}" ]
137	then
138	for x in ${count}
139	do
140	# to be sure
141	unset name
142	unset exec
143	unset workdir
144	unset icon
145
146	name=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
147	"select name from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'")
148
149	exec=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
150	"select exec from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'")
151
152	workdir=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
153	"select workdir from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'")
154
155	icon=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \
156	"select icon from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'")
157
158	# debug only
159	#echo "DEBUG: ${x}: name:'${name}' exec:'${exec}' workdir:'${workdir}' ic$
160
161	# now echo config line for fluxbox-menu
162	# make it "configureable" :P
163	[ -n "${workdir}" ] && workdir="cd ${workdir};"
164	[ -n "${icon}" ] && icon="[${icon}]"
165	echo "[exec] (${name}) {${workdir}${exec}} ${icon}"
166	done
167	fi
168	}
169
170	config_sessions()
171	{
172	# generate ica session files
173	generate_ica_session_files
174
175	# first of all get the vars
176	get_sessions_settings
177	get_autostart_settings
178
179	local count=${#ALX_SESSIONS[*]}
180	local icon
181	local i
182
183	# DEBUG
184	# declare -i i=0
185	# echo count=${count}
186	# echo "Number of new sessions: ${count}"
187	# for ((i=0; i < count; i++))
188	# do
189	# echo "${i} - ${ALX_SESSIONS[${i}]}"
190	# done
191
192	# now setup fluxbox for user station
193
194	# create a fresh fluxbox directory
195	[ -d ${ALX_UNPRIV_HOME}/.fluxbox ] && rm -rf ${ALX_UNPRIV_HOME}/.fluxbox
196	install -d ${ALX_UNPRIV_HOME}/.fluxbox
197
198	# now generate fluxbox config files
199
200	# fluxbox main config
201	cat ${ALX_SKELETONS}/fluxbox/init \
202	> ${ALX_UNPRIV_HOME}/.fluxbox/init
203
204	# fluxbox autostart
205	cat ${ALX_SKELETONS}/fluxbox/apps \
206	> ${ALX_UNPRIV_HOME}/.fluxbox/apps
207
208	# add autostart session
209	if [[ ${ALX_AUTOSTART} != "" ]]
210	then
211	echo "[startup] {wfica ${ALX_ICA_SESSIONS}/${ALX_AUTOSTART}}" \
212	>> ${ALX_UNPRIV_HOME}/.fluxbox/apps
213	fi
214
215	# fluxbox hotkeys
216	cat ${ALX_SKELETONS}/fluxbox/apps \
217	> ${ALX_UNPRIV_HOME}/.fluxbox/keys
218
219	# fluxbox menu header
220	cat ${ALX_SKELETONS}/fluxbox/menu.header \
221	> ${ALX_UNPRIV_HOME}/.fluxbox/menu
222
223	# now fix it with proper messages :P
224	local ver="$(< /etc/mageversion)"
225	sed -i "s:@CHANGEME@:alx-${ver} #${ALX_SERIAL}:g" \
226	${ALX_UNPRIV_HOME}/.fluxbox/menu
227
228	# add a newline (maybe there is no crlf in the header)
229	echo >> ${ALX_UNPRIV_HOME}/.fluxbox/menu
230
231	# fluxbox menu sessions
232	for (( i=0; i < count; i++ ))
233	do
234	[ -n "${ALX_SESSIONS[${i}]}" ] && \
235	echo "[exec] ($(basename ${ALX_SESSIONS[${i}]} .ica)) {wfica ${ALX_ICA_SESSIONS}/${ALX_SESSIONS[${i}]}}" \
236	>> ${ALX_UNPRIV_HOME}/.fluxbox/menu
237	done
238
239	# add other menuitems
240	get_other_menuitems >> ${ALX_UNPRIV_HOME}/.fluxbox/menu
241
242	# fluxbox menu footer
243	cat ${ALX_SKELETONS}/fluxbox/menu.footer \
244	>> ${ALX_UNPRIV_HOME}/.fluxbox/menu
245
246	# add a newline (maybe there is no crlf in the footer)
247	echo >> ${ALX_UNPRIV_HOME}/.fluxbox/menu
248
249	# now we generate the desktop icons
250	cat ${ALX_SKELETONS}/idesk/ideskrc \
251	> ${ALX_UNPRIV_HOME}/.ideskrc
252
253	# whipe out old stuff and install a fresh directory
254	[ -d ${ALX_UNPRIV_HOME}/.idesktop ] && rm -rf ${ALX_UNPRIV_HOME}/.idesktop
255	install -d ${ALX_UNPRIV_HOME}/.idesktop
256
257	local name
258	for (( i=0; i < count; i++ ))
259	do
260	name="$(basename ${ALX_SESSIONS[${i}]} .ica)"
261
262	if [ -f ${ALX_SESSIONS_ICONS}/${name}.png ]
263	then
264	icon="${ALX_SESSIONS_ICONS}/${name}.png"
265	else
266	icon="${ALX_SESSIONS_ICONS}/default.png"
267	fi
268
269	echo "table Icon
270	Caption: ${name}
271	Command: wfica ${ALX_ICA_SESSIONS}/${name}.ica
272	Icon: ${icon}
273	end" > ${ALX_UNPRIV_HOME}/.idesktop/${name}.lnk
274	done
275
276	# set correct permissions
277	chown ${ALX_UNPRIV_USER}:${ALX_UNPRIV_GROUP} ${ALX_UNPRIV_HOME}
278	chown ${ALX_UNPRIV_USER}:${ALX_UNPRIV_GROUP} ${ALX_UNPRIV_HOME}/.fluxbox
279	chmod 0755 ${ALX_UNPRIV_HOME}/.fluxbox
280	chmod 0755 ${ALX_UNPRIV_HOME}/.idesktop
281	chmod 0644 ${ALX_UNPRIV_HOME}/.ideskrc
282
283
284	# unset vars
285	unset ALX_SESSIONS
286	}