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
|
vmod-dbrw -- history of user-visible changes. 2018-12-08
See the end of file for copying conditions.
Please send vmod-dbrw bug reports to <gray@gnu.org>
Version 2.2.91 (Git)
* SQL idle timeout
For MySQL backend, the default connection idle timeout is set equal to
the value of the MySQL variable 'wait_timeout'. For Postgres, default
idle timeout is not yet implemented.
Idle timeout can be configured using the timeout configuration option,
e.g.:
dbrw.config("mysql", "database=dbrw;user=proxy;timeout=600",
{"select dest,pattern,value,flags from rewrite where
locate(url,'$url') = 1 order by weight asc;"});
* The $() functions in SQL templates
The SQL templates support the use of $() constructs for invoking
built-in functions. So far one function is implemented:
$(urlprefixes PATH)
It expands to comma-separated list of properly quoted pathname
prefixes, constructed from its argument. Optional query part is
stripped off the argument prior to expansion. For example
$(urlprefixes "/local/user/local?a=1")
expands to:
'/local/user/local','/local/user','/local'
This construct is intended for use in SQL IN conditionals, for
example:
SELECT dest,pattern,value,flags
FROM rewrite
WHERE host='$host'
AND url IN ($(urlprefixes $url))
ORDER BY length(dest),value,weight DESC
Version 2.2, 2017-08-10
* Support for Varnish 5.1
Version 2.1, 2017-08-06
* Requires Varnish 4.1
* The --with-varnish-source option has been withdrawn
The configure script relies on pkg-config to determine the location of
Varnish header files and libraries.
Version 2.0, 2014-11-13
Support for Varnish 4.0.
Version 1.0, 2013-07-20
Initial release
=========================================================================
Copyright information:
Copyright (C) 2013-2018 Sergey Poznyakoff
Permission is granted to anyone to make or distribute verbatim copies
of this document as received, in any medium, provided that the
copyright notice and this permission notice are preserved,
thus giving the recipient permission to redistribute in turn.
Permission is granted to distribute modified versions
of this document, or of portions of it,
under the above conditions, provided also that they
carry prominent notices stating who last changed them.
Local variables:
mode: outline
paragraph-separate: "[ ]*$"
eval: (add-hook 'write-file-hooks 'time-stamp)
time-stamp-start: "changes. "
time-stamp-format: "%:y-%02m-%02d"
time-stamp-end: "\n"
end:
|