|
SQL Server Operation on Linux | Console Client Configuration |
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.
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 levelOnly 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 toIP 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.
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
SQL Server Operation on Linux | Console Client Configuration |