1 |
# $Header: /home/cvsd/alx-cvs/alx-src/alxconfig-ng/functions/config_sessions.sh,v 1.16 2005-09-27 22:50:36 niro Exp $ |
# $Header: /home/cvsd/alx-cvs/alx-src/alxconfig-ng/functions/config_sessions.sh,v 1.17 2005-10-09 21:30:25 niro Exp $ |
2 |
# configures ica-sessions on the host via mysql db settings |
# configures ica-sessions on the host via mysql db settings |
3 |
|
|
4 |
get_sessions_settings() |
get_sessions_settings() |
9 |
# -> session1 session2 ... sessionN |
# -> session1 session2 ... sessionN |
10 |
|
|
11 |
# get settings from database |
# get settings from database |
12 |
all=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
all=$(mysqldo "select filename from cfg_sessions where serial='${ALX_SERIAL}'") |
|
"select filename from cfg_sessions where serial='${ALX_SERIAL}'") |
|
13 |
|
|
14 |
# split'em up and put in an array (only if $all not zero) |
# split'em up and put in an array (only if $all not zero) |
15 |
declare -i i=0 |
declare -i i=0 |
26 |
fi |
fi |
27 |
|
|
28 |
# get settings from database |
# get settings from database |
29 |
ALX_PROGRAMS=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
ALX_PROGRAMS=$(mysqldo "select name from cfg_other_menuitems where serial='${ALX_SERIAL}'") |
|
"select name from cfg_other_menuitems where serial='${ALX_SERIAL}'") |
|
30 |
|
|
31 |
export ALX_SESSIONS |
export ALX_SESSIONS |
32 |
export ALX_PROGRAMS |
export ALX_PROGRAMS |
35 |
get_autostart_settings() |
get_autostart_settings() |
36 |
{ |
{ |
37 |
# get settings from database |
# get settings from database |
38 |
ALX_AUTOSTART=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
ALX_AUTOSTART=$(mysqldo "select session from cfg_autostart where serial='${ALX_SERIAL}'") |
|
"select session from cfg_autostart where serial='${ALX_SERIAL}'") |
|
39 |
|
|
40 |
export ALX_AUTOSTART |
export ALX_AUTOSTART |
41 |
} |
} |
42 |
|
|
43 |
get_screensaver_settings() |
get_screensaver_settings() |
44 |
{ |
{ |
45 |
ALX_SCRN_SAVER=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
ALX_SCRN_SAVER=$(mysqldo "select screensaver from cfg_screensaver where serial='${ALX_SERIAL}'") |
46 |
"select screensaver from cfg_screensaver where serial='${ALX_SERIAL}'") |
ALX_SCRN_TIMEOUT=$(mysqldo "select timeout from cfg_screensaver where serial='${ALX_SERIAL}'") |
47 |
ALX_SCRN_TIMEOUT=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
ALX_SCRN_PASSWD=$(mysqldo "select password from cfg_screensaver where serial='${ALX_SERIAL}'") |
|
"select timeout from cfg_screensaver where serial='${ALX_SERIAL}'") |
|
|
ALX_SCRN_PASSWD=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
|
|
"select password from cfg_screensaver where serial='${ALX_SERIAL}'") |
|
48 |
|
|
49 |
export ALX_SCRN_SAVER |
export ALX_SCRN_SAVER |
50 |
export ALX_SCRN_TIMEOUT |
export ALX_SCRN_TIMEOUT |
66 |
local ses_colors |
local ses_colors |
67 |
|
|
68 |
# get settings from database |
# get settings from database |
69 |
all_ids=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
all_ids=$(mysqldo "select id from cfg_sessions where serial='${ALX_SERIAL}'") |
|
"select id from cfg_sessions where serial='${ALX_SERIAL}'") |
|
70 |
|
|
71 |
for i in ${all_ids} |
for i in ${all_ids} |
72 |
do |
do |
73 |
# get settings |
# get settings |
74 |
ses_session=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
ses_session=$(mysqldo "select session from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'") |
75 |
"select session from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'") |
ses_filename=$(mysqldo "select filename from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'") |
76 |
|
ses_username=$(mysqldo "select username from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'") |
77 |
ses_filename=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
ses_domain=$(mysqldo "select domain from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'") |
78 |
"select filename from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'") |
ses_password=$(mysqldo "select password from cfg_sessions where serial='${ALX_SERIAL}' and id='${i}'") |
79 |
|
ses_browseradrs=$(mysqldo "select browseradrs 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}'") |
|
80 |
|
|
81 |
# get the right colors |
# get the right colors |
82 |
ses_colors=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
ses_colors=$(mysqldo "select depth from cfg_graphic where serial='${ALX_SERIAL}'") |
83 |
"select depth from cfg_graphic where serial='${ALX_SERIAL}'") |
# convert to ica session file values |
84 |
case ${ses_colors} in |
case ${ses_colors} in |
85 |
24) ses_colors="8";; |
24) ses_colors="8";; |
86 |
16) ses_colors="4";; |
16) ses_colors="4";; |
179 |
unset workdir |
unset workdir |
180 |
unset icon |
unset icon |
181 |
|
|
182 |
name=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
name=$(mysqldo "select name from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'") |
183 |
"select name from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'") |
exec=$(mysqldo "select exec from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'") |
184 |
|
workdir=$(mysqldo "select workdir from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'") |
185 |
exec=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
icon=$(mysqldo "select icon from cfg_other_menuitems where serial='${ALX_SERIAL}' and name='${x}'") |
|
"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$ |
|
186 |
|
|
187 |
# now echo config line for fluxbox-menu |
# now echo config line for fluxbox-menu |
188 |
# make it "configureable" :P |
# make it "configureable" :P |
|
#[ -n "${workdir}" ] && workdir="cd ${workdir};" |
|
189 |
[ -n "${workdir}" ] && workdir="--workdir ${workdir}" |
[ -n "${workdir}" ] && workdir="--workdir ${workdir}" |
190 |
[ -n "${icon}" ] && icon="<${icon}>" |
[ -n "${icon}" ] && icon="<${icon}>" |
191 |
|
|
278 |
local progsh_path |
local progsh_path |
279 |
|
|
280 |
# get the resolution |
# get the resolution |
281 |
res=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
res=$(mysqldo "select resolution from cfg_graphic where serial='${ALX_SERIAL}'") |
|
"select resolution from cfg_graphic where serial='${ALX_SERIAL}'") |
|
282 |
|
|
283 |
# split res to x & y |
# split res to x & y |
284 |
xres="$(echo ${res} | cut -dx -f1)" |
xres="$(echo ${res} | cut -dx -f1)" |
389 |
local osversion |
local osversion |
390 |
|
|
391 |
osversion="$(< /etc/mageversion)" |
osversion="$(< /etc/mageversion)" |
392 |
hostname=$(mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ |
hostname=$(mysqldo "select hostname from cfg_network where serial='${ALX_SERIAL}'") |
|
"select hostname from cfg_network where serial='${ALX_SERIAL}'") |
|
393 |
sysinfo="Hostname: ${hostname} Serial: #${ALX_SERIAL} OS: alx-${osversion} Kernel: $(uname -r)" |
sysinfo="Hostname: ${hostname} Serial: #${ALX_SERIAL} OS: alx-${osversion} Kernel: $(uname -r)" |
394 |
|
|
395 |
# now get the right position: |
# now get the right position: |
426 |
local icon |
local icon |
427 |
local i |
local i |
428 |
|
|
|
# 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 |
|
|
|
|
429 |
# now setup fluxbox for user station |
# now setup fluxbox for user station |
430 |
|
|
431 |
# create a fresh fluxbox directory |
# create a fresh fluxbox directory |