Contents of /alx-src/trunk/alx-config/import_to_mysql_db.sh
Parent Directory | Revision Log
Revision 217 -
(show 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 | #!/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};" |