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
|
.\" msql.conf - mini SQL configuration file
.\" Copyright (c) 1996 Martin Schulze <joey@infodrom.north.de>
.\"
.\" This program is free software; you can redistribute it and/or modify
.\" it under the terms of the GNU General Public License as published by
.\" the Free Software Foundation; either version 2 of the License, or
.\" (at your option) any later version.
.\"
.\" This program is distributed in the hope that it will be useful,
.\" but WITHOUT ANY WARRANTY; without even the implied warranty of
.\" MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
.\" GNU General Public License for more details.
.\"
.\" You should have received a copy of the GNU General Public License
.\" along with this program; if not, write to the Free Software
.\" Foundation, Inc.,59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
.\"
.\" This manual page is written especially for Debian GNU/Linux. The
.\" information used are taken from the mSQL postscript documentation.
.\"
.TH MSQL.CONF 5 "11 Feb 1998" "Mini SQL" "Files"
.SH NAME
msql.conf \- Mini SQL configuration file
.SH DESCRIPTION
The file
.I /etc/msql.conf
controls the mSQL database server and clients.
This configuration file is divided in three sections, two of them are
dedicated to the mSQL server and one is used for w3-msql. As usual
with Unix it's a plain text file and lines starting with a hash
(``#'') are ignored.
Each section starts with a section header where the section name is
enclosed by square brackets. The key strings are not case sensitive.
When strings are used you may use the special string
.B %I
to refer to mSQL's Inst_Dir which is set to
.I /var/lib/msql
in Debian GNU/Linux and may also be set in the general section.
.SS "The general section"
.TP
.BI Inst_Dir " string"
Specify the full path of the main mSQL directory. Normally all mSQL
related files are put beneath it.
.TP
.BI mSQL_User " string"
Specify the user as which the mSQL server should run. If the user is
different to root the
.B msqld
performs uid/gid changes before going to work.
.TP
.BI Admin_User " string"
Specify the user that is allowed to perform basic database
management. This mainly includes the creation and deletion of
databases as well as shutting down the mSQL server.
.TP
.BI Pid_File " string"
The
.B msqld
will store it's process id here and uses this file as lockfile against
multiple executions.
.TP
.BI TCP_Port " number"
Specifies the TCP/IP port number on which the mSQL server will listen
to requests from the network.
.TP
.BI Unix_Port " string"
Specifies the location of the Unix domain socket to be used by the
.B msqld
to talk to the clients on the local machine.
.SS "The w3-msql section"
.TP
.BI Auth_Host " string"
Specifies the machine ono which the mSQL database containing w3-auth
data is located. If this is set to NULL it's assumed that the
database is on the local host
.TP
.BI Private_Only " boolean"
If set to true, the w3-msql interface will ony process private pages.
This way you can enforce strict security on your system.
.SS "The system section"
.TP
.BI Msync_Timer " number"
Specifies the interval in seconds at which the memory mapped data
regions maintained in the mSQL server process will be synced with the
on-disk images. Setting this value to 0 will disable forced
synchronisation of the data and rely on the kernel's sync'ing of the
mmap regions.
.TP
.BI Host_Lookup " boolean"
Determines wether ip address to hostname lookups are required. If
this is set to true, connections by hosts whose ip address do not
resolve to a hostname will be rejected.
.TP
.BI Read_Only " boolean"
Tells the mSQL server to operate in read-only mode. Any attempts to
modify the database will be rejected (i.e. the only commands accepted
are SELECT queries)).
This option may be used if multiple database server export the same
data and there is only one master server.
.SH AUTHOR
Mini SQL has been written by David Hughes of Bond University,
Australia as part of the Minerva Network Management
Environment. He may be reached via electronic mail using
bambi@Bond.edu.au.
.SH "SEE ALSO"
.BR msqld (8),
.BR msqladmin (8),
.BR msqlconfig (8).
|
