File: odbc_mail.default.ini

package info (click to toggle)
virtuoso-opensource 6.1.6+dfsg2-4
  • links: PTS, VCS
  • area: main
  • in suites: bullseye, buster, sid, stretch
  • size: 260,992 kB
  • ctags: 125,220
  • sloc: ansic: 652,748; sql: 458,419; xml: 282,834; java: 61,031; sh: 40,031; cpp: 36,890; cs: 25,240; php: 12,692; yacc: 9,523; lex: 7,018; makefile: 6,157; jsp: 4,484; awk: 1,643; perl: 1,013; ruby: 1,003; python: 326
file content (193 lines) | stat: -rw-r--r-- 6,825 bytes parent folder | download | duplicates (2)
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
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
;
;  odbc_mail.default.ini
;
;  Configuration file for the ODBC Mail Delivery Agent
;
;  This file is part of the OpenLink Software Virtuoso Open-Source (VOS)
;  project.
;
;  Copyright (C) 1998-2012 OpenLink Software
;
;  This project 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; only version 2 of the License, dated June 1991.
;
;  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.,
;  51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
;

[Options]

;;
;;  DSN = <connect string>
;;    Specfies the ODBC format database connect string
;;
;;  If the MDA is unable to connect to the database, it will
;;  exit with a temporarily-unavailable error code.
;;
;;  Example:
;;    DSN = Virtuoso;HOST=localhost:1111;UID=dba;PWD=dba
;;
DSN = DSN=Virtuoso;HOST=localhost;UID=dba;PWD=dba

;;  MaxMessageSize = <integer>
;;    Imposes a mail message size limit
;;
;; Limit messages to 2M. Comment out / set to 0 to disable
MaxMessageSize = 2097152

;;  RemovePrefix = <string>
;;    Removes a prefix from $local (eg for qmail)
;;
;RemovePrefix = lists-

;;  UnixFromLine = <0|1>
;;    insert 'From x@y <date>' line -- qmail & courier mode only
;;
;UnixFromLine = 1

;;  MailDebug = <filename>
;;    Make a copy of every message dropped into the database
;;
;MailDebug = /tmp/odbc_mail.debug

;;  Verify = <sql statement>
;;    Verifies that a mail recipient exists in the database.
;;
;;  The SQL statement is macro expanded and executed.
;;  Defined macros are:
;;  $local	Local recipient without domain
;;  $domain	Domain for the local recipient
;;  $sender	Mail sender
;;
;;  Both $macro and ${macro} are valid.
;;
;;  A missing Verify statement causes the message to be accepted.
;;  If the SQL statement fails, or doesn't return a result set,
;;  or if the VerifyCheckReturn fails, then fallback delivery is attempted
;;  (see below)
;;
;;  Use VerifyCheckReturn=<value> to test stored procedure execution completion.
;;
;;  Returned columns from the returned result set are available in the
;;  Deliver statement as $1, $2 ..
;;
;;  Examples:
;;
;;  1. Look up account name in Virtuoso's DAV table for internal POP3 use
;;     Verify = SELECT U_NAME FROM WS.WS.SYS_DAV_USER WHERE U_NAME='$local' AND U_ACCOUNT_DISABLED=0
;;
;;  2. Use use your own user table ...
;;     Verify = SELECT NAME FROM USERS WHERE NAME = '$local' AND '$sender' LIKE '%@openlinksw.com'
;;
;;  3. Call a stored procedure which should return 1 on success ...
;;     Verify = FIND_USER('$local')
;;     VerifyCheckReturn = 1
;;
;;  4. for the OpenLink Portal Server:
;;     Verify = select ac.account_id, ac.domain_id from usr..accounts ac, usr..domains dm where ac.domain_id = dm.domain_id and ac.account_name = '$local' and dm.domain_name = '$domain'
;;
Verify = SELECT U_NAME FROM WS.WS.SYS_DAV_USER WHERE U_NAME='$local' AND U_ACCOUNT_DISABLED=0

;;  Deliver = <sql statement>
;;    Delivers the mail into the database.
;;
;;  The SQL string is macro expanded and executed.
;;  Defined macros are:
;;  $local	Local recipient without domain
;;  $domain	Domain for the local recipient
;;  $sender	Mail sender
;;  $message	Message. Note that this is bound as a parameter
;;  $1, $2 ..	Returned columns from the Verify query
;;
;;  The Deliver query is only executed after a successful verification.
;;  If the SQL statement fails, the mail is bounced.
;;
;;  Use DeliverCheckReturn=<value> to test stored procedure execution
;;  completion. The message will be bounced if the completion value is
;;  different from the specified value
;;
;;  Examples:
;;  1. Use Virtuoso's mail drop stored procedure so user can use POP3 on it
;;     Deliver = DB.DBA.NEW_MAIL($1, $message)
;;
;;  2. Use use your own user table ...
;;     Deliver = INSERT INTO MYMAIL(AT,USR,MSG) VALUES(datestring(now()),'$local',$message)
;;
;;  3. Call a stored procedure which should return 1 on success ...
;;     Deliver = DELIVER_MAIL('${local}@$domain','$sender',$message)
;;     DeliverCheckReturn = 1
;;
;;  4. for the OpenLink Portal Server:
;;     Deliver = eml..recive_message($2,$1,NULL,$message,NULL,-1,100)
;;
Deliver = DB.DBA.NEW_MAIL($1, $message)

;;  Fallback = <command>
;;    Specify auxiliary mail delivery agent
;;
;;  Fallback delivery is invoked when the recipient user is NOT in
;;  the database (when the Verify query fails)
;;  If there is no Fallback setting defined, the mail will be bounced.
;;
;;  Environment variables SENDER, LOCAL and HOST are set up before
;;  invocation. Macros $local, $domain and $sender are also usable here.
;;
;;  Examples:
;;  1. VMailMgr under qmail
;;     Fallback = vdeliver
;;
;;  2. procmail under qmail
;;     Fallback = preline procmail -m .procmailrc
;;
;;  3. procmail fallback for sendmail
;;     Fallback = /bin/sh -c "procmail -f $sender -d $local"
;;
;;  Fallback under win32:
;;  - PATH is NOT searched.
;;  - added environment variables: SENDER, RECIPIENT, LOCAL, HOST
;;
;Fallback = /bin/sh -c "procmail -f $sender -d $local"

;;  Environment
;;
;;  These variables are merged with the environment before the database
;;  is connected. UDBCINI may be required to locate the DSN.
;;  Define additional environment variables here necessary for
;;  fallback delivery.
;;
[Environment]
PATH		= /bin:/usr/bin:/sbin:/usr/sbin
SHELL		= /bin/sh
;UDBCINI	= /home/openlink/lib/udbc.ini

;;  Bounce messages
;;
;;  Indent continuation lines with at least a space or tab.
;;
[Bounce]
UserUnknown= The OpenLink Application Mailer:
 Sorry, the user you are trying to reach doesn't exist in our system.
 The user could be removed, or you may have encountered a software
 misconfiguration. Please contact the postmaster for the domain if you
 believe there's something wrong.

DatabaseError= The OpenLink Application Mailer:
 Sorry, our mail delivery program encountered a fatal error while trying
 to deliver your message to the database. I got the following error(s):

InternalError= The OpenLink Application Mailer:
 Sorry, our mail delivery program encountered an internal error or
 software misconfiguration while trying to deliver your message.
 This shouldn't happen under normal circumstances.
 Please contact the postmaster for the domain if these problems persist.

TooLong= The OpenLink Application Mailer:
 Sorry, our mail delivery program cannot deliver your message because it's
 size exceeds the maximum allowed message size limit of 2 megabytes.