602SQL Documentation Index  

Configuration File for 602SQL Servers and Clients on Linux.

Basic 602SQL server configuration running on LINUX operating system is stored in the /etc/602sql file. Further configuration parameters are stored in the database system tables as properties.

The /etc/602sql file has the same structure as common initialization files. It's composed of sections that begin with the section name enclosed in square brackets ([ ]). Each line in these sections is always the parameter name followed by an equal sign and a value. Lines that begin with a semicolon are considered as comments. Parameter names are not case-sensitive.

The implicit configuration file is created during 602SQL installation, and almost every usable parameter is stated and commented there.

Server Sections

Each section describes one server, the section name is the same as the database name and thus the same as the server name. Two server types are being described: local servers, that can be run on this computer, and network servers, that can be accessed over a network.

These parameters are stated for local servers:

PATH=path           full path to the folder containing the database file
LOGPATH=path        full path to the folder containing basic server log file
TRANSACTPATH=path   full path to the folder containing the transaction server file
USER=name           name of the user account in the operating system, that runs the server with superuser privileges
AUTOSTART=0|1       assign or delete the server to/from the group of servers that can be run as daemons e.g. upon system startup 
         (systems with startup scripts of the System V type, such as RedHat or SUSE)
IPPORT=port          number of the port that 602SQL server listens to
SYSLOGS=log level   causes the server log contents to be written into the system log on the specified level
Only the PATH parameter is mandatory. The port number is used if the IPPort server property is not set (mainly on the first launch of the server). You can find more information about the database file parts locations here.

Information needed for the connecting client are stored in the configuration file of a remote network server:

IP ADDRESS=IP address IP address of the computer running the server
IPPORT=port            number of the port a remote SQL server listens to
IP address must be set for each network server. Port number has to be specified only for servers that are set to work on another port than the default 5001 port.

Other Sections

Apart from the server and licence numbers sections there are also another sections in the configuration file. Their names begin with a dot (so there won't be a mismatch with server name - server name cannot begin with the dot character). These sections are

Up-to-date description is in the distributed configuration file.