 | MySQL & mSQL |  |
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 configuration file.
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 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 sample msql.conf file:
[general] Inst_Dir = /usr/local/Hughes mSQL_User = msql Admin_User = root Pid_File = %I/msql2d.pid TCP_Port = 1114 UNIX_Port = %I/msql2.sock [system] Msync_Timer = 30 Host_Lookup = True Read_Only = False [w3-msql] Auth_Host = NULL Footer = True Force_Private = False
The general section affects the operation of all mSQL programs, the msqld 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 %I 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 /usr/local/Hughes.
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 %I/msql2d.pid.
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 1114.
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.
|  | |
| 16. MySQL and mSQL System Variables |  | 17. MySQL and mSQL Programs and Utilities |
Copyright © 2001 O'Reilly & Associates. All rights reserved.