31
31
/* main.cf configuration parameters for this search.
33
33
/* In the first case, the configuration parameters below are
34
/* specified in the file as \fIname\fR=\fBvalue\fR pairs.
34
/* specified in the file as \fIname\fR=\fIvalue\fR pairs.
36
36
/* In the second case, the configuration parameters are
37
37
/* prefixed with the value of \fIname\fR and an underscore,
47
47
/* See dict_open(3).
49
49
/* Configuration parameters:
51
/* The parameters encodes a number of pieces of information:
52
/* username, password, databasename, table, select_field,
53
/* where_field, and hosts:
55
51
/* Username for connecting to the database.
57
53
/* Password for the above.
59
55
/* Name of the database.
61
57
/* List of domains the queries should be restricted to. If
62
58
/* specified, only FQDN addresses whose domain parts matching this
63
59
/* list will be queried against the SQL database. Lookups for
64
60
/* partial addresses are also supressed. This can significantly
65
61
/* reduce the query load on the server.
67
63
/* Query template, before the query is actually issued, variable
68
64
/* substitutions are performed. See mysql_table(5) for details. If
69
65
/* No query is specified, the legacy variables \fItable\fR,
70
66
/* \fIselect_field\fR, \fIwhere_field\fR and \fIadditional_conditions\fR
71
67
/* are used to construct the query template.
72
/* .IP \fIresult_format\fR
73
69
/* The format used to expand results from queries. Substitutions
74
70
/* are performed as described in mysql_table(5). Defaults to returning
75
71
/* the lookup result unchanged.
78
74
/* exceed the limit fail with dict_errno=DICT_ERR_RETRY. Note that each
79
75
/* non-empty (and non-NULL) column of a multi-column result row counts as
82
78
/* When \fIquery\fR is not set, name of the table used to construct the
83
79
/* query string. This provides compatibility with older releases.
84
/* .IP \fIselect_field\fR
85
81
/* When \fIquery\fR is not set, name of the result field used to
86
82
/* construct the query string. This provides compatibility with older
88
/* .IP \fIwhere_field\fR
89
85
/* When \fIquery\fR is not set, name of the where clause field used to
90
86
/* construct the query string. This provides compatibility with older
92
/* .IP \fIadditional_conditions\fR
88
/* .IP additional_conditions
93
89
/* When \fIquery\fR is not set, additional where clause conditions used
94
90
/* to construct the query string. This provides compatibility with older
97
93
/* List of hosts to connect to.
99
95
/* For example, if you want the map to reference databases of
104
100
/* "vmailer" and password "passwd" then the configuration file
107
/* \fIuser\fR = \fBvmailer\fR
109
/* \fIpassword\fR = \fBpasswd\fR
111
/* \fIdbname\fR = \fBvmailer_info\fR
113
/* \fItable\fR = \fBaliases\fR
115
/* \fIselect_field\fR = \fBforw_addr\fR
117
/* \fIwhere_field\fR = \fBalias\fR
119
/* \fIhosts\fR = \fBhost1.some.domain\fR \fBhost2.some.domain\fR
120
/* .IP \fIadditional_conditions\fR
107
/* dbname = vmailer_info
111
/* select_field = forw_addr
113
/* where_field = alias
115
/* hosts = host1.some.domain\fR \fBhost2.some.domain
116
/* .IP additional_conditions
121
117
/* Backward compatibility when \fIquery\fR is not set, additional
122
118
/* conditions to the WHERE clause.
124
120
/* List of hosts to connect to.
126
122
/* For example, if you want the map to reference databases of
131
127
/* "vmailer" and password "passwd" then the configuration file
134
/* \fIuser\fR = \fBvmailer\fR
136
/* \fIpassword\fR = \fBpasswd\fR
138
/* \fIdbname\fR = \fBvmailer_info\fR
140
/* \fItable\fR = \fBaliases\fR
142
/* \fIselect_field\fR = \fBforw_addr\fR
144
/* \fIwhere_field\fR = \fBalias\fR
146
/* \fIhosts\fR = \fBhost1.some.domain\fR \fBhost2.some.domain\fR
134
/* dbname = vmailer_info
138
/* select_field = forw_addr
140
/* where_field = alias
142
/* hosts = host1.some.domain\fR \fBhost2.some.domain
149
145
/* dict(3) generic dictionary manager
added
removed
src/global/dict_mysql.c
