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
|
# peer
md5 db user unix
peer dbp user unix
password db userp unix
trust dbz userz unix
scram-sha-256 dbs users unix
# hostssl
cert db user 10.1.1.1 tls
reject db user 10.1.1.1
reject db user 13.1.1.1
# hostnossl
reject db user 11.1.1.1 tls
md5 db user 11.1.1.1
reject db user 13.1.1.1
# host
password db user 127.0.0.2 tls
password db user 127.0.0.3
reject db user 127.0.1.4
# db1 filt
reject db1x user 127.0.1.4
md5 db1 user 127.0.1.4
# user1 filt
md5 db1z user1 15.0.0.1
reject db1z user2 15.0.0.1
# someusers
reject db2 user 16.0.0.1
md5 db2 user1 16.0.0.1
md5 db2 user2 16.0.0.1
md5 db2 user3 16.0.0.1
reject db2 user4 16.0.0.1
# manyusers
md5 db2 u1 17.0.0.1
md5 db2 u2 17.0.0.1
md5 db2 u3 17.0.0.1
md5 db2 u4 17.0.0.1
md5 db2 u5 17.0.0.1
md5 db2 u6 17.0.0.1
md5 db2 u7 17.0.0.1
md5 db2 u8 17.0.0.1
md5 db2 u9 17.0.0.1
md5 db2 u10 17.0.0.1
md5 db2 u11 17.0.0.1
# manydbs
reject d1 user 18.0.0.2
trust d1 t18user 18.0.0.2
trust d2 t18user 18.0.0.2
trust d3 t18user 18.0.0.2
trust d4 t18user 18.0.0.2
trust d5 t18user 18.0.0.2
trust d6 t18user 18.0.0.2
trust d7 t18user 18.0.0.2
trust d8 t18user 18.0.0.2
trust d9 t18user 18.0.0.2
trust d10 t18user 18.0.0.2
trust d11 t18user 18.0.0.2
# quoting
reject db t19user 19.0.0.2
cert all all 19.0.0.2
cert q1"q2 a , b 19.0.0.2
# bitmask
cert mdb muser 199.199.199.199
reject mdb muser 199.199.199.198
reject mdb muser 199.199.199.200
cert mdb2 muser 254.1.1.1
# ipv6
md5 mdb muser ff11:2::1
md5 mdb muser ff22:3::1
trust mdb muser ::1
reject mdb muser ::2
# "all" address
scram-sha-256 mdb3 muser 1.2.3.4
scram-sha-256 mdb3 muser face::1
reject mdb4 muser 1.2.3.4
reject mdb4 muser face::1
# replication
reject mdb muser ::1 replication
reject db userp unix replication
reject replication userp unix replication
trust db admin ::1 replication
trust replication admin ::1 replication
reject db admin ::1
reject replication admin ::1
trust db admin2 ::1 replication
trust replication admin2 ::1 replication
trust db2 admin2 ::1
reject replication admin2 ::1
|
