File: server.txt

package info (click to toggle)
solid-desktop 2.2-3
  • links: PTS
  • area: non-free
  • in suites: potato, slink
  • size: 3,620 kB
  • ctags: 2,830
  • sloc: sh: 290; sql: 80; makefile: 64
file content (245 lines) | stat: -rw-r--r-- 7,974 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245

SOLID Server 2.2		 		        server.txt
------------------------------------------------------------------

This document is divided into the following parts:
- System requirements
- Supported communication protocols
- Product files inventory
- Installation instructions
- Note for evaluators
- How to order SOLID Server
- More information on SOLID Server

SOLID Server System Requirements
--------------------------------
SOLID Server 2.2 requires:
- about 3.5 MB of disk space
- about 6.5 MB of virtual memory in the default configuration
- adequate disk space for the database and log files. 
  An empty database requires about 500 KB of disk space.
- adequate disk space for backup files. Backups require at most
  twice the space occupied by database and log files.

For information about the supported operating system versions, 
please check the file relnotes.txt in this same directory.

Supported Communication Protocols
---------------------------------
Supported communication protocols are UNIX Pipes and TCP/IP.

Please refer to the chapter COMMUNICATION PROTOCOLS in SOLID 
Server Administrators Guide for details.

Product Contents
----------------

The product package : 

   ss<VVooo>.tar.Z

is a compressed tar archive that contains the following files:

   orderme.txt		runtime license ordering instructions
   relnotes.txt		SOLID version specific information
   server.txt		installation instructions (this file)

   bin/			executables
	solid		SOLID Server - database server program
	solcon		Remote Control - teletype administration
	solsql   	SQL Interpreter - SQL script execution
	solinst		Install - license & config creation

   database/		SOLID Server databases subdirectory
	default/	a sample database directory
           solidlic.txt	evaluation license terms
           default.ini	configuration file 
           default.lic	evaluation license, 
			database age limit: 30 days
	   log/		default db logfiles(move to another drive!)
	   backup/	default db backups (move to another drive!)
	
   public_html/		SOLID documentation
       	admingui/	SOLID Server Administrator's Guide	
	   admingui.htm	AG Table of Contents
	   00000XXX.htm AG chapters
	   XXXXXXXX.gif	AG images
       	techdesc/	SOLID Server Technical Description	
	   techdesc.htm	TD Table of Contents
	   00000XXX.htm TD chapters
	   XXXXXXXX.gif	TD images

   samples/
	sampledb.sql	SQL data definition language (DDL) sample
	solidsrv.ini	SOLID Server configuration file sample
	


 Installation Instructions:
------------------------------------------------------------------

0) Create a UNIX user account to act as the owner of Solid files
   and processes. You may want to name this user as 'solid'. Log 
   on to the target node as the solid user:
	su - solid

1) Create an appropriate directory in your environment, and copy 
   the product package there. You may want to use the 
   home directory of the user solid for this purpose. E.g.,
	cd ~solid
	cp /mnt/floppy/* .

2)  Uncompress the product package with the commands:
	uncompress ss<VVooo>.tar.Z
	tar xvf ss<VVooo>.tar

3) Edit your path setting to include ~solid/bin

4) Create license and configuration files by starting the SOLID 
   Installation program and following the instructions:
	solinst

NOTE. The default configuration suggested is intended to be an 
      'Express Installation to Get Started Quickly'.
 
      It is strongly recommended for production databases
      to change the configuration as follows:
      - log files and database files to separate physical devices
      - backup directory and database to separate physical devices 

      You may change the configuration later by editing the 
      file 'solid.ini' or by using SOLID Remote Control. 
      Please see SOLID Server Administrator's Guide for 
      details.

5) Create the sample database and start the server with the command:
	solid -c ~solid/database/default -f
   or
	cd ~solid/database/default
	solid -f

   The option -f makes the database server process stay in the 
   foreground during the database creation interaction. After the 
   database has been created, it starts listening to the network 
   for data requests and stops accepting any input from the 
   shell session it was started from. You can continue working 
   within the same shell session by: 
   	- sending the server process to the background:	<Ctrl-Z>
	- allowing the background process to continue:	bg

   To start a server process later and to open the sample 
   database, please enter the command:

	solid -c ~solid/database/default
   or 
	cd ~solid/database/default
	solid

   or add either of these commands in the server startup scripts.

7) Create a table and some test data into the sample database by 
   running an SQL script with SQL Editor:

	cd ~solid/samples
        solsql -a -c ~solid/database/default -f sample.sql

8) Server administration commands can be submitted with:

	solcon

   enter 'help' to see command alternatives. You may stop the 
   server with the command:

	shutdown

   For more instructions on how to manage SOLID Server, please see 
   the Administrator's Guide using any HTML browser.


How to Create a New Database
----------------------------
1) Create a new subdirectory under solid/database for the new database. 
   For example, if you would like to establish a database for your
   intranet access log records, you might need the 'customer' DB.
	cd ~solid/database
	mkdir customer
	
2) Copy the following files from an existing database directory:
	- license file		(solid.lic)
	- configuration file	(solid.ini)
   and make any necessary modifications to the configuration file.
   At least the listening name must be different 
   from any previous SOLID Server listening on the same node.
   I.e., change the values of the following parameter:
	[Com] Listen=tcp 1234

3) Start the server to create an empty database
	cd ~solid/database/customer
	solid -f

4) Design the database structures and write CREATE TABLE and 
   other SQL DDL statements into an SQL file (see sample.sql)
   and execute it with the teletype SQL Editor:
	solsql -a -c ~solid/database/customer -f customer.sql

5) Insert any base data that your applications need with the teletype 
   SQL Editor or with the SOLID SpeedLoader tool.


Note for Evaluators
--------------------
The evaluation license does not allow you to use databases that 
are older than 30 days. The expiration of the evaluation license 
causes the following message to appear when trying to start 
SOLID Server:
	SOLID Utility Fatal Error 11015:
	Evaluation license expired.
	See ORDERME.TXT for instructions on 
	how to order a license for SOLID Server,
	exiting from SOLID Server...


How to Order SOLID Server
-------------------------
To place an order for SOLID licenses, please see the file orderme.txt 
in the same directory. 


How to Install the SOLID Server License
---------------------------------------
Once you have purchased a license you may update your license.

Enter the Software Enable Key received in an activation letter with 
the command:

	solinst -l -c ~solid/database/customer

and your evaluation copy of SOLID Server is ready for production 
use. You can continue using the databases you have created during
the evaluation without disruptions.


More Information on SOLID Server
--------------------------------
Latest product information and technical documentation are 
available from Solid Online Services. You can access our Web 
server at:

	http://www.solidtech.com/

Alternatively, you may address questions to:

	info@solidtech.com


Operating System Specific Information, Linux 2.0.X
==================================================

Linux version
-------------

SOLID Server for Linux is built using the 2.0.0 version of Linux.
This is the Linux version what has also been used also in testing.

The SOLID Server for Linux has been used succesfully in development
and production in 1.2.X and 2.0.X Linux versions.