Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit43cadb9

Browse files
committed
Add missing pgcrypto files.
1 parent998cebc commit43cadb9

22 files changed

+837
-0
lines changed
Lines changed: 108 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,108 @@
1+
--
2+
-- Blowfish cipher
3+
--
4+
-- some standard Blowfish testvalues
5+
select encode(encrypt(
6+
decode('0000000000000000', 'hex'),
7+
decode('0000000000000000', 'hex'),
8+
'bf-ecb/pad:none'), 'hex');
9+
encode
10+
------------------
11+
4ef997456198dd78
12+
(1 row)
13+
14+
select encode(encrypt(
15+
decode('ffffffffffffffff', 'hex'),
16+
decode('ffffffffffffffff', 'hex'),
17+
'bf-ecb/pad:none'), 'hex');
18+
encode
19+
------------------
20+
51866fd5b85ecb8a
21+
(1 row)
22+
23+
select encode(encrypt(
24+
decode('1000000000000001', 'hex'),
25+
decode('3000000000000000', 'hex'),
26+
'bf-ecb/pad:none'), 'hex');
27+
encode
28+
------------------
29+
7d856f9a613063f2
30+
(1 row)
31+
32+
select encode(encrypt(
33+
decode('1111111111111111', 'hex'),
34+
decode('1111111111111111', 'hex'),
35+
'bf-ecb/pad:none'), 'hex');
36+
encode
37+
------------------
38+
2466dd878b963c9d
39+
(1 row)
40+
41+
select encode(encrypt(
42+
decode('0123456789abcdef', 'hex'),
43+
decode('fedcba9876543210', 'hex'),
44+
'bf-ecb/pad:none'), 'hex');
45+
encode
46+
------------------
47+
0aceab0fc6a0a28d
48+
(1 row)
49+
50+
select encode(encrypt(
51+
decode('01a1d6d039776742', 'hex'),
52+
decode('fedcba9876543210', 'hex'),
53+
'bf-ecb/pad:none'), 'hex');
54+
encode
55+
------------------
56+
3273b8badc9e9e15
57+
(1 row)
58+
59+
select encode(encrypt(
60+
decode('ffffffffffffffff', 'hex'),
61+
decode('0000000000000000', 'hex'),
62+
'bf-ecb/pad:none'), 'hex');
63+
encode
64+
------------------
65+
014933e0cdaff6e4
66+
(1 row)
67+
68+
-- setkey
69+
select encode(encrypt(
70+
decode('fedcba9876543210', 'hex'),
71+
decode('f0e1d2c3b4a5968778695a4b3c2d1e0f', 'hex'),
72+
'bf-ecb/pad:none'), 'hex');
73+
encode
74+
------------------
75+
93142887ee3be15c
76+
(1 row)
77+
78+
-- with padding
79+
select encode(encrypt(
80+
decode('01234567890123456789', 'hex'),
81+
decode('33443344334433443344334433443344', 'hex'),
82+
'bf-ecb'), 'hex');
83+
encode
84+
----------------------------------
85+
0d04a43a20456dee5ede6ed9e4dcaaa6
86+
(1 row)
87+
88+
-- cbc
89+
-- 28 bytes key
90+
select encode(encrypt(
91+
decode('6b77b4d63006dee605b156e27403979358deb9e7154616d959f1652bd5', 'hex'),
92+
decode('37363534333231204e6f77206973207468652074696d6520666f7220', 'hex'),
93+
'bf-cbc'), 'hex');
94+
encode
95+
------------------------------------------------------------------
96+
4f2beb748c4f689ec755edb9dc252a41b93a3786850b4c75d6a702b6a8e48825
97+
(1 row)
98+
99+
-- 29 bytes key
100+
select encode(encrypt(
101+
decode('6b77b4d63006dee605b156e27403979358deb9e7154616d959f1652bd5ff92cc', 'hex'),
102+
decode('37363534333231204e6f77206973207468652074696d6520666f722000', 'hex'),
103+
'bf-cbc'), 'hex');
104+
encode
105+
----------------------------------------------------------------------------------
106+
3ea6357a0ee7fad6d0c4b63464f2aafa40c2e91b4b7e1bba8114932fd92b5c8f111e7e50e7b2e541
107+
(1 row)
108+
Lines changed: 26 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,26 @@
1+
--
2+
-- crypt() and gen_salt(): bcrypt
3+
--
4+
select crypt('', '$2a$06$RQiOJ.3ELirrXwxIZY8q0O');
5+
crypt
6+
--------------------------------------------------------------
7+
$2a$06$RQiOJ.3ELirrXwxIZY8q0OlGbBEpDmx7IRZlNYvGJ1SHXwNi2cEKK
8+
(1 row)
9+
10+
select crypt('foox', '$2a$06$RQiOJ.3ELirrXwxIZY8q0O');
11+
crypt
12+
--------------------------------------------------------------
13+
$2a$06$RQiOJ.3ELirrXwxIZY8q0OR3CVJrAfda1z26CCHPnB6mmVZD8p0/C
14+
(1 row)
15+
16+
create table ctest (data text, res text, salt text);
17+
insert into ctest values ('password', '', '');
18+
update ctest set salt = gen_salt('bf', 8);
19+
update ctest set res = crypt(data, salt);
20+
select res = crypt(data, res) as "worked" from ctest;
21+
worked
22+
--------
23+
t
24+
(1 row)
25+
26+
drop table ctest;
Lines changed: 26 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,26 @@
1+
--
2+
-- crypt() and gen_salt(): crypt-des
3+
--
4+
select crypt('', 'NB');
5+
crypt
6+
---------------
7+
NBPx/38Y48kHg
8+
(1 row)
9+
10+
select crypt('foox', 'NB');
11+
crypt
12+
---------------
13+
NB53EGGqrrb5E
14+
(1 row)
15+
16+
create table ctest (data text, res text, salt text);
17+
insert into ctest values ('password', '', '');
18+
update ctest set salt = gen_salt('des');
19+
update ctest set res = crypt(data, salt);
20+
select res = crypt(data, res) as "worked" from ctest;
21+
worked
22+
--------
23+
t
24+
(1 row)
25+
26+
drop table ctest;
Lines changed: 26 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,26 @@
1+
--
2+
-- crypt() and gen_salt(): md5
3+
--
4+
select crypt('', '$1$Szzz0yzz');
5+
crypt
6+
------------------------------------
7+
$1$Szzz0yzz$To38XrR3BsbXQW2ZpfKjF1
8+
(1 row)
9+
10+
select crypt('foox', '$1$Szzz0yzz');
11+
crypt
12+
------------------------------------
13+
$1$Szzz0yzz$IYL49cd3t9bllsA7Jmz1M1
14+
(1 row)
15+
16+
create table ctest (data text, res text, salt text);
17+
insert into ctest values ('password', '', '');
18+
update ctest set salt = gen_salt('md5');
19+
update ctest set res = crypt(data, salt);
20+
select res = crypt(data, res) as "worked" from ctest;
21+
worked
22+
--------
23+
t
24+
(1 row)
25+
26+
drop table ctest;
Lines changed: 26 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,26 @@
1+
--
2+
-- crypt() and gen_salt(): extended des
3+
--
4+
select crypt('', '_J9..j2zz');
5+
crypt
6+
----------------------
7+
_J9..j2zzR/nIRDK3pPc
8+
(1 row)
9+
10+
select crypt('foox', '_J9..j2zz');
11+
crypt
12+
----------------------
13+
_J9..j2zzAYKMvO2BYRY
14+
(1 row)
15+
16+
create table ctest (data text, res text, salt text);
17+
insert into ctest values ('password', '', '');
18+
update ctest set salt = gen_salt('xdes', 1001);
19+
update ctest set res = crypt(data, salt);
20+
select res = crypt(data, res) as "worked" from ctest;
21+
worked
22+
--------
23+
t
24+
(1 row)
25+
26+
drop table ctest;
Lines changed: 72 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,72 @@
1+
--
2+
-- HMAC-MD5
3+
--
4+
select encode(hmac(
5+
'Hi There',
6+
decode('0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b', 'hex'),
7+
'md5'), 'hex');
8+
encode
9+
----------------------------------
10+
9294727a3638bb1c13f48ef8158bfc9d
11+
(1 row)
12+
13+
-- 2
14+
select encode(hmac(
15+
'Jefe',
16+
'what do ya want for nothing?',
17+
'md5'), 'hex');
18+
encode
19+
----------------------------------
20+
813aead7c4a34bff01a16d61368e7c13
21+
(1 row)
22+
23+
-- 3
24+
select encode(hmac(
25+
decode('dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', 'hex'),
26+
decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'hex'),
27+
'md5'), 'hex');
28+
encode
29+
----------------------------------
30+
56be34521d144c88dbb8c733f0e8b3f6
31+
(1 row)
32+
33+
-- 4
34+
select encode(hmac(
35+
decode('cdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcd', 'hex'),
36+
decode('0102030405060708090a0b0c0d0e0f10111213141516171819', 'hex'),
37+
'md5'), 'hex');
38+
encode
39+
----------------------------------
40+
697eaf0aca3a3aea3a75164746ffaa79
41+
(1 row)
42+
43+
-- 5
44+
select encode(hmac(
45+
'Test With Truncation',
46+
decode('0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c', 'hex'),
47+
'md5'), 'hex');
48+
encode
49+
----------------------------------
50+
56461ef2342edc00f9bab995690efd4c
51+
(1 row)
52+
53+
-- 6
54+
select encode(hmac(
55+
'Test Using Larger Than Block-Size Key - Hash Key First',
56+
decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'hex'),
57+
'md5'), 'hex');
58+
encode
59+
----------------------------------
60+
6b1ab7fe4bd7bf8f0b62e6ce61b9d0cd
61+
(1 row)
62+
63+
-- 7
64+
select encode(hmac(
65+
'Test Using Larger Than Block-Size Key and Larger Than One Block-Size Data',
66+
decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'hex'),
67+
'md5'), 'hex');
68+
encode
69+
----------------------------------
70+
6f630fad67cda0ee1fb1f562db3aa53e
71+
(1 row)
72+
Lines changed: 72 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,72 @@
1+
--
2+
-- HMAC-MD5
3+
--
4+
select encode(hmac(
5+
'Hi There',
6+
decode('0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b0b', 'hex'),
7+
'sha1'), 'hex');
8+
encode
9+
------------------------------------------
10+
675b0b3a1b4ddf4e124872da6c2f632bfed957e9
11+
(1 row)
12+
13+
-- 2
14+
select encode(hmac(
15+
'Jefe',
16+
'what do ya want for nothing?',
17+
'sha1'), 'hex');
18+
encode
19+
------------------------------------------
20+
156d4c35468a0339f3fa57a067bf47f814eb7a57
21+
(1 row)
22+
23+
-- 3
24+
select encode(hmac(
25+
decode('dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd', 'hex'),
26+
decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'hex'),
27+
'sha1'), 'hex');
28+
encode
29+
------------------------------------------
30+
d730594d167e35d5956fd8003d0db3d3f46dc7bb
31+
(1 row)
32+
33+
-- 4
34+
select encode(hmac(
35+
decode('cdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcdcd', 'hex'),
36+
decode('0102030405060708090a0b0c0d0e0f10111213141516171819', 'hex'),
37+
'sha1'), 'hex');
38+
encode
39+
------------------------------------------
40+
4c9007f4026250c6bc8414f9bf50c86c2d7235da
41+
(1 row)
42+
43+
-- 5
44+
select encode(hmac(
45+
'Test With Truncation',
46+
decode('0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c0c', 'hex'),
47+
'sha1'), 'hex');
48+
encode
49+
------------------------------------------
50+
37268b7e21e84da5720c53c4ba03ad1104039fa7
51+
(1 row)
52+
53+
-- 6
54+
select encode(hmac(
55+
'Test Using Larger Than Block-Size Key - Hash Key First',
56+
decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'hex'),
57+
'sha1'), 'hex');
58+
encode
59+
------------------------------------------
60+
aa4ae5e15272d00e95705637ce8a3b55ed402112
61+
(1 row)
62+
63+
-- 7
64+
select encode(hmac(
65+
'Test Using Larger Than Block-Size Key and Larger Than One Block-Size Data',
66+
decode('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'hex'),
67+
'sha1'), 'hex');
68+
encode
69+
------------------------------------------
70+
e8e99d0f45237d786d6bbaa7965c7808bbff1a91
71+
(1 row)
72+

‎contrib/pgcrypto/expected/init.out

Lines changed: 17 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,17 @@
1+
--
2+
-- init pgcrypto
3+
--
4+
\set ECHO none
5+
-- check for encoding fn's
6+
select encode('foo', 'hex');
7+
encode
8+
--------
9+
666f6f
10+
(1 row)
11+
12+
select decode('666f6f', 'hex');
13+
decode
14+
--------
15+
foo
16+
(1 row)
17+

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp