← Back to branch summary

~ubuntu-branches/debian/lenny/freetds/lenny

« back to all changes in this revision

Viewing changes to doc/doc/freetds-0.63/userguide/stunnel.htm

  • Committer: Bazaar Package Importer
  • Author(s): Steve Langasek
  • Date: 2008-08-02 11:49:53 UTC
  • mfrom: (2.1.10 intrepid)
  • Revision ID: james.westby@ubuntu.com-20080802114953-0qdeowgl63k42n2c
Tags: 0.82-4
http://bugs.debian.org/493303
* Fix a typo in the freetds-common description, ugh
* Versioned replaces of libct4 by freetds-common, since the current one
  obviously doesn't have overlapping files.
* tdsodbc: check for /var/lib/odbc existence before removing it in the
  postinst, since there are cases where it won't exist on upgrade (i.e.,
  if the driver was never enabled in the first place).  Closes: #493303.

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/doc/freetds-0.63/userguide/stunnel.htm
1
 
<HTML
2
 
><HEAD
3
 
><TITLE
4
 
>stunnel HOWTO</TITLE
5
 
><META
6
 
NAME="GENERATOR"
7
 
CONTENT="Modular DocBook HTML Stylesheet Version 1.57"><LINK
8
 
REL="HOME"
9
 
TITLE="FreeTDS User Guide"
10
 
HREF="index.htm"><LINK
11
 
REL="UP"
12
 
TITLE="Advanced Configurations"
13
 
HREF="configs.htm"><LINK
14
 
REL="PREVIOUS"
15
 
TITLE="TDS Connection Pooling"
16
 
HREF="tdspool.htm"><LINK
17
 
REL="NEXT"
18
 
TITLE="How to get what works with it working"
19
 
HREF="software.htm"></HEAD
20
 
><BODY
21
 
CLASS="SECT1"
22
 
BGCOLOR="#FFFFFF"
23
 
TEXT="#000000"
24
 
LINK="#0000FF"
25
 
VLINK="#840084"
26
 
ALINK="#0000FF"
27
 
><DIV
28
 
CLASS="NAVHEADER"
29
 
><TABLE
30
 
WIDTH="100%"
31
 
BORDER="0"
32
 
CELLPADDING="0"
33
 
CELLSPACING="0"
34
 
><TR
35
 
><TH
36
 
COLSPAN="3"
37
 
ALIGN="center"
38
 
><SPAN
39
 
CLASS="PRODUCTNAME"
40
 
>FreeTDS</SPAN
41
 
> User Guide: A Guide to Installing, Configuring, and Running <SPAN
42
 
CLASS="PRODUCTNAME"
43
 
>FreeTDS</SPAN
44
 
></TH
45
 
></TR
46
 
><TR
47
 
><TD
48
 
WIDTH="10%"
49
 
ALIGN="left"
50
 
VALIGN="bottom"
51
 
><A
52
 
HREF="tdspool.htm"
53
 
>Prev</A
54
 
></TD
55
 
><TD
56
 
WIDTH="80%"
57
 
ALIGN="center"
58
 
VALIGN="bottom"
59
 
>Chapter 5. Advanced Configurations</TD
60
 
><TD
61
 
WIDTH="10%"
62
 
ALIGN="right"
63
 
VALIGN="bottom"
64
 
><A
65
 
HREF="software.htm"
66
 
>Next</A
67
 
></TD
68
 
></TR
69
 
></TABLE
70
 
><HR
71
 
ALIGN="LEFT"
72
 
WIDTH="100%"></DIV
73
 
><DIV
74
 
CLASS="SECT1"
75
 
><H1
76
 
CLASS="SECT1"
77
 
><A
78
 
NAME="STUNNEL"
79
 
>stunnel HOWTO</A
80
 
></H1
81
 
><P
82
 
>               Contributed by <A
83
 
HREF="mailto:bradleyb@u.washington.edu"
84
 
TARGET="_top"
85
 
>Bradley Bell</A
86
 
>.  
87
 
                </P
88
 
><P
89
 
>To set up freetds over stunnel between a Linux webserver and a W2k SQL server:
90
 
                </P
91
 
><P
92
 
></P
93
 
><OL
94
 
TYPE="1"
95
 
><LI
96
 
><P
97
 
>Get unencrypted freetds working</P
98
 
></LI
99
 
><LI
100
 
><P
101
 
>Install openssl and stunnel on the Linux box:
102
 
                                <A
103
 
HREF="http://www.stunnel.org/"
104
 
TARGET="_top"
105
 
>stunnel.org</A
106
 
>
107
 
                                </P
108
 
></LI
109
 
><LI
110
 
><P
111
 
>Download the <A
112
 
HREF="http://www.stunnel.org/download/binaries.html"
113
 
TARGET="_top"
114
 
>stunnel binary</A
115
 
> and openssl dll's for Windows.  
116
 
                                </P
117
 
></LI
118
 
><LI
119
 
><P
120
 
>Generate stunnel.pem (complete with Diffie-Hellman parameters) for
121
 
   placement on the W2k box. See <A
122
 
HREF="http://www.stunnel.org/faq/certs.html"
123
 
TARGET="_top"
124
 
>instructions</A
125
 
> in the stunnel FAQ.
126
 
                                </P
127
 
></LI
128
 
><LI
129
 
><P
130
 
>Start stunnel on the W2k box:</P
131
 
><PRE
132
 
CLASS="SCREEN"
133
 
>  <TT
134
 
CLASS="PROMPT"
135
 
>$ </TT
136
 
><TT
137
 
CLASS="USERINPUT"
138
 
><B
139
 
>stunnel.exe -d 61666 -r localhost:1433</B
140
 
></TT
141
 
>
142
 
  </PRE
143
 
><P
144
 
>61666 is just an arbitrary port number.  
145
 
                                </P
146
 
></LI
147
 
><LI
148
 
><P
149
 
>Start stunnel on the Linux box:
150
 
                                </P
151
 
><PRE
152
 
CLASS="SCREEN"
153
 
>  <TT
154
 
CLASS="PROMPT"
155
 
>$ </TT
156
 
><TT
157
 
CLASS="USERINPUT"
158
 
><B
159
 
>stunnel -c -d 1433 -r <TT
160
 
CLASS="REPLACEABLE"
161
 
><I
162
 
>win2kserver</I
163
 
></TT
164
 
>:61666</B
165
 
></TT
166
 
>
167
 
  </PRE
168
 
><P
169
 
>where <TT
170
 
CLASS="REPLACEABLE"
171
 
><I
172
 
>win2kserver</I
173
 
></TT
174
 
> is the hostname or IP address of the W2k box.
175
 
                                </P
176
 
></LI
177
 
><LI
178
 
><P
179
 
>Set up freetds to use the tunnel.  If this is your unencrypted entry in
180
 
   <TT
181
 
CLASS="FILENAME"
182
 
>freetds.conf</TT
183
 
>:
184
 
                                </P
185
 
><DIV
186
 
CLASS="EXAMPLE"
187
 
><A
188
 
NAME="E.G.UNENCRYPTED"
189
 
></A
190
 
><P
191
 
><B
192
 
>Example 5-7. Unencrypted entry in <TT
193
 
CLASS="FILENAME"
194
 
>freetds.conf</TT
195
 
></B
196
 
></P
197
 
><PRE
198
 
CLASS="PROGRAMLISTING"
199
 
>   [win2kserver]
200
 
        host = win2kserver
201
 
        port = 1433</PRE
202
 
></DIV
203
 
><P
204
 
>   the encrypted equivalent uses:
205
 
                                </P
206
 
><DIV
207
 
CLASS="EXAMPLE"
208
 
><A
209
 
NAME="E.G.ENCRYPTED"
210
 
></A
211
 
><P
212
 
><B
213
 
>Example 5-8. Encrypted entry in <TT
214
 
CLASS="FILENAME"
215
 
>freetds.conf</TT
216
 
></B
217
 
></P
218
 
><PRE
219
 
CLASS="PROGRAMLISTING"
220
 
>   [win2kserver]
221
 
        host = localhost
222
 
        port = 1433</PRE
223
 
></DIV
224
 
></LI
225
 
></OL
226
 
></DIV
227
 
><DIV
228
 
CLASS="NAVFOOTER"
229
 
><HR
230
 
ALIGN="LEFT"
231
 
WIDTH="100%"><TABLE
232
 
WIDTH="100%"
233
 
BORDER="0"
234
 
CELLPADDING="0"
235
 
CELLSPACING="0"
236
 
><TR
237
 
><TD
238
 
WIDTH="33%"
239
 
ALIGN="left"
240
 
VALIGN="top"
241
 
><A
242
 
HREF="tdspool.htm"
243
 
>Prev</A
244
 
></TD
245
 
><TD
246
 
WIDTH="34%"
247
 
ALIGN="center"
248
 
VALIGN="top"
249
 
><A
250
 
HREF="index.htm"
251
 
>Home</A
252
 
></TD
253
 
><TD
254
 
WIDTH="33%"
255
 
ALIGN="right"
256
 
VALIGN="top"
257
 
><A
258
 
HREF="software.htm"
259
 
>Next</A
260
 
></TD
261
 
></TR
262
 
><TR
263
 
><TD
264
 
WIDTH="33%"
265
 
ALIGN="left"
266
 
VALIGN="top"
267
 
>TDS Connection Pooling</TD
268
 
><TD
269
 
WIDTH="34%"
270
 
ALIGN="center"
271
 
VALIGN="top"
272
 
><A
273
 
HREF="configs.htm"
274
 
>Up</A
275
 
></TD
276
 
><TD
277
 
WIDTH="33%"
278
 
ALIGN="right"
279
 
VALIGN="top"
280
 
>How to get what works with it working</TD
281
 
></TR
282
 
></TABLE
283
 
></DIV
284
 
></BODY
285
 
></HTML
286
 
>
 
 
b'\\ No newline at end of file'