16.2. mSQL System Variables
Before mSQL 2, the only post-install configuration that could be
performed was through a few global environment variables. However,
mSQL 2.0 introduced a configuration file that allows for a much
greater flexibility in setting mSQL's parameters. This section
covers both the environment variables and the mSQL 2 specific
16.2.1. Environment Variables
The following variables are specific to mSQL programs. They may be
defined in the current shell or as part of a shell script.
The debugging level for the program. This is a number from
(no output) to 3 (maximum output).
The path to the mSQL configuration file as shown later.
In addition, the mSQL programs use the following environment
variables that are routinely set as part of the Unix environment.
The username of the current user.
The path of the default editor. The msql program
uses this program to edit SQL statements if a \e
command is encountered.
16.2.2. The mSQL Configuration File
The mSQL configuration file contains the values of several variables
that effect the operation of the mSQL programs. By default, the
location of the configuration file is
/usr/local/Hughes/msql.conf. This value can be
changed by setting the MSQL_CONF_FILE environment
variable. The configuration file begins with a section name in
brackets followed by the variables for that section. Following is a
Inst_Dir = /usr/local/Hughes
mSQL_User = msql
Admin_User = root
Pid_File = %I/msql2d.pid
TCP_Port = 1114
UNIX_Port = %I/msql2.sock
Msync_Timer = 30
Host_Lookup = True
Read_Only = False
Auth_Host = NULL
Footer = True
Force_Private = False
The general section affects the operation of all
mSQL programs, the
database server uses the system
section and the w3-msql section is for
the W3-mSQL web/database interaction system. When mSQL reads the
configuration files, it replaces the characters
with the location of the mSQL
installation on the server machine. The available variables for each
section are listed below.
The username of the account allowed to make changes to the mSQL
database as a whole. The default value is root.
The location of the mSQL installation. All occurrences of
%I in the configuration file are replaced with
this value. The default value is
The username of the account that runs the mSQL server daemon. The
default value is msql.
The location of the file containing the process ID
of the running mSQL daemon. The default is
The TCP port number used to connect to a mSQL server (in the case of
the client programs) or to listen for incoming connections (in the
case of msql2d). The default value is
The filename of the Unix socket used to connect to the local mSQL
server (in the case of the client programs) or to allow local
connections (in the case of msql2d). The default
value is %I/msql2.sock.
If set to `True', all client connections must be from
machines that have valid, verifiable hostnames.
The interval (in seconds) at which the data used by the server in RAM
is synchronized with the data on disk.
If set to `True', no modifications are allowed on the
database. Only SELECT queries are permitted.
The hostname of the machine containing the database server with the
W3-Auth tables. If set to NULL or omitted, the
local server is used.
If set to `True', the standard Hughes Technologies footer
will be appended to every page.
If set to `True', only pages that are protected by
W3-Auth can be accessed through W3-mSQL. This prevents regular HTML
files from being processed through W3-mSQL.
Copyright © 2001 O'Reilly & Associates. All rights reserved.