Annotation of /alx-src/trunk/alx-config/import_to_mysql_db.sh
Parent Directory | Revision Log
Revision 217 -
(hide annotations)
(download)
(as text)
Sat Mar 5 17:08:18 2005 UTC (19 years, 6 months ago) by niro
File MIME type: application/x-sh
File size: 3598 byte(s)
Sat Mar 5 17:08:18 2005 UTC (19 years, 6 months ago) by niro
File MIME type: application/x-sh
File size: 3598 byte(s)
test; not ready for public
1 | niro | 217 | #!/bin/bash |
2 | |||
3 | # functions_mysql_update | ||
4 | |||
5 | source /etc/alx-config/config.rc | ||
6 | source /opt/alx-config/functions/mysqlfunctions | ||
7 | source /etc/alx-config/serial | ||
8 | |||
9 | |||
10 | #get all settings | ||
11 | |||
12 | #network | ||
13 | if [ -f $SETTINGS_TEMPLATE/system/network/networking ] | ||
14 | then | ||
15 | networking="$( < $SETTINGS_TEMPLATE/system/network/networking)" | ||
16 | else | ||
17 | networking="" | ||
18 | fi | ||
19 | |||
20 | if [ -f $SETTINGS_TEMPLATE/system/network/hostname ] | ||
21 | then | ||
22 | hostname="$( < $SETTINGS_TEMPLATE/system/network/hostname)" | ||
23 | else | ||
24 | hostname="" | ||
25 | fi | ||
26 | |||
27 | if [ -f $SETTINGS_TEMPLATE/system/network/domain ] | ||
28 | then | ||
29 | domain="$( < $SETTINGS_TEMPLATE/system/network/domain)" | ||
30 | else | ||
31 | domain="" | ||
32 | fi | ||
33 | |||
34 | if [ -f $SETTINGS_TEMPLATE/system/network/ip ] | ||
35 | then | ||
36 | ip="$( < $SETTINGS_TEMPLATE/system/network/ip)" | ||
37 | else | ||
38 | ip="" | ||
39 | fi | ||
40 | |||
41 | if [ -f $SETTINGS_TEMPLATE/system/network/netmask ] | ||
42 | then | ||
43 | netmask="$( < $SETTINGS_TEMPLATE/system/network/netmask)" | ||
44 | else | ||
45 | netmask="" | ||
46 | fi | ||
47 | |||
48 | if [ -f $SETTINGS_TEMPLATE/system/network/broadcast ] | ||
49 | then | ||
50 | broadcast="$( < $SETTINGS_TEMPLATE/system/network/broadcast)" | ||
51 | else | ||
52 | broadcast="" | ||
53 | fi | ||
54 | |||
55 | if [ -f $SETTINGS_TEMPLATE/system/network/gateway ] | ||
56 | then | ||
57 | gateway="$( < $SETTINGS_TEMPLATE/system/network/gateway)" | ||
58 | else | ||
59 | gateway="" | ||
60 | fi | ||
61 | |||
62 | if [ -f $SETTINGS_TEMPLATE/system/network/dns ] | ||
63 | then | ||
64 | dns="$( < $SETTINGS_TEMPLATE/system/network/dns)" | ||
65 | else | ||
66 | dns="" | ||
67 | fi | ||
68 | |||
69 | if [ -f $SETTINGS_TEMPLATE/system/modules/modules ] | ||
70 | then | ||
71 | modules="$( < $SETTINGS_TEMPLATE/system/modules/modules)" | ||
72 | else | ||
73 | modules="" | ||
74 | fi | ||
75 | |||
76 | |||
77 | #write the stuff to mysql db | ||
78 | mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ | ||
79 | "update cfg_network set | ||
80 | module='${modules}', | ||
81 | domain='${domain}', | ||
82 | networking='${networking}', | ||
83 | netmask='${netmask}', | ||
84 | dns='${dns}', | ||
85 | gateway='${gateway}', | ||
86 | broadcast='${broadcast}', | ||
87 | ip='${ip}' | ||
88 | where serial=${ALX_SERIAL};" | ||
89 | |||
90 | #update hostname | ||
91 | mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ | ||
92 | "update cfg_serial set | ||
93 | hostname='${hostname}' | ||
94 | where id=${ALX_SERIAL};" | ||
95 | |||
96 | #vga | ||
97 | if [ -f $SETTINGS_TEMPLATE/system/mouse/mouse ] | ||
98 | then | ||
99 | mouseprot="$( < $SETTINGS_TEMPLATE/system/mouse/mouse)" | ||
100 | else | ||
101 | mouseprot="" | ||
102 | fi | ||
103 | |||
104 | if [ -f $SETTINGS_TEMPLATE/system/vga/vga ] | ||
105 | then | ||
106 | vgadrv="$( < $SETTINGS_TEMPLATE/system/vga/vga)" | ||
107 | else | ||
108 | vgadrv="" | ||
109 | fi | ||
110 | |||
111 | if [ -f $SETTINGS_TEMPLATE/system/vga/vgadepth ] | ||
112 | then | ||
113 | vgadepth="$( < $SETTINGS_TEMPLATE/system/vga/vgadepth)" | ||
114 | else | ||
115 | vgadepth="" | ||
116 | fi | ||
117 | |||
118 | if [ -f $SETTINGS_TEMPLATE/system/vga/vgares ] | ||
119 | then | ||
120 | resolution="$( < $SETTINGS_TEMPLATE/system/vga/vgares)" | ||
121 | else | ||
122 | resolution="" | ||
123 | fi | ||
124 | |||
125 | mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ | ||
126 | "update cfg_grafik set | ||
127 | module='${vgadrv}', | ||
128 | resolution='${resolution}', | ||
129 | depth='${vgadepth}', | ||
130 | mouse='${mouseprot}' | ||
131 | where serial=${ALX_SERIAL};" | ||
132 | |||
133 | #sessions | ||
134 | if [ -f $SETTINGS_TEMPLATE/system/sessions/sessions ] | ||
135 | then | ||
136 | sessions="$( < $SETTINGS_TEMPLATE/system/sessions/sessions)" | ||
137 | else | ||
138 | sessions="" | ||
139 | fi | ||
140 | |||
141 | if [ -n "${sessions}" ] | ||
142 | then | ||
143 | |||
144 | #first delete all sessions with serial=${ALX_SERIAL} | ||
145 | mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ | ||
146 | "delete from cfg_session where serial='${ALX_SERIAL}';" | ||
147 | |||
148 | #than add them | ||
149 | for i in ${sessions} | ||
150 | do | ||
151 | mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ | ||
152 | "insert into cfg_session( | ||
153 | serial, | ||
154 | session | ||
155 | ) | ||
156 | values( | ||
157 | '${ALX_SERIAL}', | ||
158 | '${i}' | ||
159 | );" | ||
160 | done | ||
161 | fi | ||
162 | |||
163 | #printers | ||
164 | |||
165 | #monitors | ||
166 | if [ -f $SETTINGS_TEMPLATE/system/monitor/monitor ] | ||
167 | then | ||
168 | source $SETTINGS_TEMPLATE/system/monitor/monitor | ||
169 | else | ||
170 | myvendor="" | ||
171 | mymodel="" | ||
172 | hsync="" | ||
173 | vref="" | ||
174 | fi | ||
175 | |||
176 | mysql_command ${SQL_USER} ${SQL_PASS} ${SQL_HOST} ${SQL_DB} \ | ||
177 | "update cfg_monitor set | ||
178 | vendor='${myvendor}', | ||
179 | model='${mymodel}', | ||
180 | hsync='${hsync}', | ||
181 | vrefresh='${vref}' | ||
182 | where serial=${ALX_SERIAL};" |