"Fossies" - the Fresh Open Source Software Archive 
Member "mysqlwdb-1.5.4/INSTALL" (21 Jan 2005, 9348 Bytes) of package /linux/www/old/mysqlwdb-1.5.4.tar.gz:
As a special service "Fossies" has tried to format the requested text file into HTML format (style:
standard) with prefixed line numbers.
Alternatively you can here
view or
download the uninterpreted source code file.
1
2 Installing mysqlwdb
3 ===================
4
5 Before trying to run mysqlwdb please read the REQUIREMENTS and the WARNINGS
6 documents, that you should find along with the program.
7
8
9 To configure and to install mysqlwdb on your system, please follow these
10 instructions:
11
12
13 1) Edit mysqlwdb.pl and
14 --------------------
15
16 a) change the first line to reflect the path to Perl on your system.
17
18 E.g. 1) '/usr/local/bin/perl' so the first line of mysqlwdb.pl
19 would be '#!/usr/local/bin/perl'
20
21 2) '/usr/bin/perl' so the first line of mysqlwdb.pl would
22 be '#!/usr/bin/perl'
23
24 3) 'c:\perl\bin\perl.exe' so the first line of mysqlwdb.pl
25 would be '#!c:\perl\bin\perl.exe'
26
27 If you are not able to know where perl is located on your
28 system, type 'which perl' in your shell (on a unix-like system).
29
30
31 b) The default behaviour of mysqlwdb is to be prompted for the login to a MySQL server.
32 If you want to manage MySQL databases in a custom manner, set $custom_configuration
33 variable to 1 and follow the rest of this b) section.
34
35 It possible to manage more than 1 database.
36
37 If you put data for only 1 database, you will not prompt for databases choice.
38 If you put data for more than 1 database, a menu of choice will appear.
39
40 To manage only one database
41 ===========================
42
43 1) go to the section:
44
45 Database(s) & user(s) variables section
46
47 Now you can see the variable
48
49 my %DATABASES= (
50
51 1 => {
52
53 host => " ! PUT HOST HERE ! ",
54 port => " ! PUT PORT HERE ! ", #3306 is the standard MySQL port
55 database => " ! PUT DATABASE NAME HERE ! ",
56 user => " ! PUT USER HERE ! ",
57 password => " ! PUT PASSWORD HERE ! ",
58 db_description => " ! PUT DB_DESCRIPTION HERE ! "
59
60 },
61
62 # some comments
63
64 );
65
66
67 2) change the entries: host , port , database , user , password , db_description
68 according to your needs.
69
70 E.g.
71
72 host => "localhost",
73 port => "3306", #3306 is the standard MySQL port
74 database => "test",
75 user => "root",
76 password => "****",
77 db_description => "Database for test"
78
79 To manage more than one database
80 ================================
81
82 1) go to the section:
83
84 Database(s) & user(s) variables section
85
86 2) change the entries for the first database as explained above in
87 "To manage only one database"
88
89 3) replace (copy & paste) the structure
90
91 1 => {
92
93 host => " ! PUT HOST HERE ! ",
94 port => " ! PUT PORT HERE ! ", #3306 is the standard MySQL port
95 database => " ! PUT DATABASE NAME HERE ! ",
96 user => " ! PUT USER HERE ! ",
97 password => " ! PUT PASSWORD HERE ! ",
98 db_description => " ! PUT DB_DESCRIPTION HERE ! "
99
100 },
101
102 within the
103 %DATABASES= (
104
105 );
106
107 limits.
108
109 4) change the entries for the second database as explained above in
110 "To manage only one database"
111
112 5) change the database order number (e.g. 1 will change in 2)
113
114 E.g. for 3 databases
115
116 %DATABASES= (
117
118 1 => {
119
120 host => "localhost",
121 port => "3306", #3306 is the standard MySQL port
122 database => "test",
123 user => "root",
124 password => "****",
125 db_description => "Database for test"
126
127 },
128
129 2 => {
130
131 host => "127.0.0.1",
132 port => "3306", #3306 is the standard MySQL port
133 database => "my_db",
134 user => "userA",
135 password => "*****",
136 db_description => "Personal database"
137
138 },
139
140 3 => {
141
142 host => "192.168.0.1",
143 port => "3306", #3306 is the standard MySQL port
144 database => "another_db",
145 user => "userB",
146 password => "******",
147 db_description => "Another personal database"
148
149 },
150 );
151
152
153 c) It is possible to prompt user for login.
154
155 i) If you do not want to manage user(s):
156
157 a) leave untouched
158
159 ii) If you want to manage user(s), please:
160
161 a) remove all # between the %LOGIN string and the ")"
162 (e.g. #"user1" => "pwd1",)
163 b) change the user(s) id and password according to your needs
164 c) set $login_prompt variable to 1
165
166 e.g. for 1 user:
167
168 %LOGIN=(
169
170 "onlyme" => "mypwd",
171 );
172
173 e.g. for 3 users:
174
175
176 %LOGIN=(
177
178 "user1" => "pwduser1",
179 "user2" => "pwduser2",
180 "user3" => "pwduser3",
181 );
182
183
184 d) set the $recent_DBD_is_pri_key variable value to 1 if you have a
185 recent version of Msql-Mysql-modules (the package that contains
186 DBD::mysql).
187 If you have an older version set the variable to 0.
188 Here, 'recent' means version 1.21_07 or greater (1998-11-08).
189
190 **The tipically value is 1**
191
192 (NOTE: This is needed due to the MySQL-specific method "is_pri_key"
193 that in recent versions of DBD::mysql is deprecated. Correct one
194 is now "mysql_is_pri_key".
195
196 It depends on the version of the Msql-Mysql-modules you have
197 installed (type 'perldoc DBD::mysql' for details).)
198
199
200 e) set the $recent_DBD_dsn_syntax variable value to 1 if you have a
201 recent version of Msql-Mysql-modules (i.e. DBD::mysql).
202 If you have an older version set the variable to 0.
203 Here, 'recent' means version 1.19_03 or greater (1998-02-06).
204
205 **The tipically value is 1**
206
207 (NOTE: This is needed due to the different versions for the
208 'dsn' syntax
209
210 e.g. i) $dsn="DBI:$DBI_driver:$database:$host";
211
212 for older DBD::mysql
213
214 or
215
216 ii) $dsn="DBI:$DBI_driver:database=$database;host=$host";
217
218 for recent ones (ODBC like).
219
220 It depends on the version of the Msql-Mysql-modules you have
221 installed (type 'perldoc DBD::mysql' for details).)
222
223
224 f) set the $obsolete_DBD_ListTables variable value to 0 if you have a
225 recent version of Msql-Mysql-modules (the package that contains
226 DBD::mysql).
227 If you have an older version set the variable to 1.
228 Here, 'recent' means version 1.21_07 or greater (1998-11-08).
229
230 **The tipically value is 1**
231
232 (NOTE: MySQL-specific function "_ListTables" is obsolete in recent
233 versions of DBD::mysql. Now is better to use the DBI method
234 $dbh->tables(). But due to a problem of $dbh->tables() with empty
235 databases in old drivers, the default value is 1 as a precaution.
236
237 It depends on the version of the Msql-Mysql-modules you have
238 installed (type 'perldoc DBD::mysql' for details).)
239
240 Set to 0 if you report problems (i.e. warnings) on your web server log.
241
242
243 g) try set the $ListDBs_data_sources variable value to 0 if you encounter
244 problems getting the database list via the initial login form
245
246 **The tipically value is 1**
247
248
249 2) Put mysqlwdb.pl in your cgi-bin and make sure it is executable.
250 ---------------------------------------------------------------
251
252 E.g. type 'chmod 755 mysqlwdb.pl'
253
254 on a unix-like system.
255
256
257
258 3) Be sure that your web server can execute .pl type files.
259 --------------------------------------------------------
260
261 Otherwise you can change the script name accordingly to the suffixes
262 accepted by your web server.
263
264
265
266 4) Call the script using a web browser.
267 ------------------------------------
268
269
270
271 Using a different name instead of 'mysqlwdb.pl'
272 ===============================================
273
274 You can freely change the name of the script
275 (E.g. 'mv mysqlwdb.pl something.else', on a unix-like system).
276 You have only to change the $thiscgi variable accordingly to the new name
277 you choose.
278
279
280
281 Configuring mysqlwdb look and actions
282 =====================================
283
284 mysqlwdb is easy to configure for what concerns several aspects of its HTML
285 look and DBMS actions:
286
287 1) HTML layout
288
289 You can change table colors, font size and font color, form elements
290 look, HTML header and footer.
291 To do this, please edit mysqlwdb.pl then go to section
292
293 HTML layout
294
295 and make the changes you need.
296
297
298 2) Configurable actions
299
300 You can choose what type of action you can do with mysqlwdb.
301 To do this, please edit mysqlwdb.pl then go to section
302
303 Configurable actions
304
305 and make the changes you need.
306
307 In particular the subsections:
308
309 a) DBMS actions
310
311 to enable or disable the operations on tables and records
312
313 b) javascript check
314
315 to enable or disable the javascript functions
316
317
318 3) Create table specific
319
320 You can choose specifiers and their order, the character not allowed in tables and field
321 names and you can configure types and specifiers.
322 To do this, please edit mysqlwdb.pl then go to section
323
324 Create table specific (and also to the end of line)
325
326 and make the changes you need.
327
328
329
330 4) Messages
331
332 You can change the text of the buttons, of the warnings and the error
333 messages, of the javascript alerts, and so on.
334 To do this, please edit mysqlwdb.pl then go to section
335
336 Messages
337
338 and make the changes you need.
339