File: sqlcipher-pragmas.test

package info (click to toggle)
sqlcipher 4.6.1-2
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 120,100 kB
  • sloc: ansic: 285,202; tcl: 19,833; javascript: 12,886; java: 8,151; sh: 4,409; yacc: 1,644; makefile: 1,578; cpp: 440; cs: 307; sql: 45
file content (499 lines) | stat: -rw-r--r-- 15,119 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
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
# SQLCipher
# codec.test developed by Stephen Lombardo (Zetetic LLC)
# sjlombardo at zetetic dot net
# http://zetetic.net
#
# Copyright (c) 2018, ZETETIC LLC
# Redistribution and use in source and binary forms, with or without
# modification, are permitted provided that the following conditions are met:
#     * Redistributions of source code must retain the above copyright
#       notice, this list of conditions and the following disclaimer.
#     * Redistributions in binary form must reproduce the above copyright
#       notice, this list of conditions and the following disclaimer in the
#       documentation and/or other materials provided with the distribution.
#     * Neither the name of the ZETETIC LLC nor the
#       names of its contributors may be used to endorse or promote products
#       derived from this software without specific prior written permission.
#
# THIS SOFTWARE IS PROVIDED BY ZETETIC LLC ''AS IS'' AND ANY
# EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
# WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
# DISCLAIMED. IN NO EVENT SHALL ZETETIC LLC BE LIABLE FOR ANY
# DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
# (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
# LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
# ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
# (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
# SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
#
# This file implements regression tests for SQLite library.  The
# focus of this script is testing code cipher features.
#
# NOTE: tester.tcl has overridden the definition of sqlite3 to
# automatically pass in a key value. Thus tests in this file
# should explicitly close and open db with sqlite_orig in order
# to bypass default key assignment.

set testdir [file dirname $argv0]
source $testdir/tester.tcl
source $testdir/sqlcipher.tcl

# verify the pragma cipher_version
# returns the currently configured
# sqlcipher version
do_test verify-pragma-cipher-version {
    sqlite_orig db test.db
    execsql {
        PRAGMA cipher_version;
    }
} {{4.6.1 community}}
db close
file delete -force test.db

# verify the pragma cipher_use_hmac
# is set to true be default
do_test verify-pragma-cipher-use-hmac-default {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_use_hmac;
    }
} {ok 1}
db close
file delete -force test.db

# verify the pragma cipher_use_hmac
# reports the flag turned off
do_test verify-pragma-cipher-use-hmac-off {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_use_hmac = off;
        PRAGMA cipher_use_hmac;
    }
} {ok 0}
db close
file delete -force test.db

# verify the pragma default_cipher_use_hmac
# is set to true by default
do_test verify-pragma-cipher-default-use-hmac-default {
    sqlite_orig db test.db
    execsql {
        PRAGMA cipher_default_use_hmac;
    }
} {1}
db close
file delete -force test.db

# verify the pragma default_cipher_use_hmac
# reports the flag turned off
do_test verify-pragma-cipher-default-use-hmac-off {
    sqlite_orig db test.db
    execsql {
        PRAGMA cipher_default_use_hmac = off;
        PRAGMA cipher_default_use_hmac;
        -- Be sure to turn cipher_default_use_hmac
        -- back on or it will break later tests 
        -- (it's a global flag)
        PRAGMA cipher_default_use_hmac = ON;
    }
} {0}
db close
file delete -force test.db

# verify the pragma default_cipher_kdf_iter
# is set to 256000 by default
do_test verify-pragma-cipher-default-kdf-iter-default {
    sqlite_orig db test.db
    execsql {
        PRAGMA cipher_default_kdf_iter;
    }
} {256000}
db close
file delete -force test.db


# verify the pragma default_cipher_kdf_ter
# reports changes
do_test verify-pragma-cipher-default-use-hmac-off {
    sqlite_orig db test.db
    execsql {
        PRAGMA cipher_default_kdf_iter = 1000;
        PRAGMA cipher_default_kdf_iter;
        PRAGMA cipher_default_kdf_iter = 256000;
    }
} {1000}
db close
file delete -force test.db

# verify the pragma kdf_iter
# reports the default value
do_test verify-pragma-kdf-iter-reports-default {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA kdf_iter;
    }
} {ok 256000}
db close
file delete -force test.db

# verify the pragma kdf_iter
# reports value changed
do_test verify-pragma-kdf-iter-reports-value-changed {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA kdf_iter = 8000;
        PRAGMA kdf_iter;
    }
 } {ok 8000}
db close
file delete -force test.db

# verify the pragma fast_kdf_iter
# reports the default value
do_test verify-pragma-fast-kdf-iter-reports-default {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA fast_kdf_iter;
    }
} {ok 2}
db close
file delete -force test.db

# verify the pragma fast_kdf_iter
# reports value changed
do_test verify-pragma-kdf-iter-reports-value-changed {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA fast_kdf_iter = 4000;
        PRAGMA fast_kdf_iter;
    }
} {ok {PRAGMA fast_kdf_iter is deprecated, please remove from use} 4000}
db close
file delete -force test.db

# verify the pragma cipher_page_size
# reports default value
do_test verify-pragma-cipher-page-size-default {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_page_size;
    }
} {ok 4096}
db close
file delete -force test.db

# verify the pragma cipher_page_size
# reports change in value
do_test verify-pragma-cipher-page-size-changed {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_page_size = 8192;
        PRAGMA cipher_page_size;
    }
} {ok 8192}
db close
file delete -force test.db

# verify that a call to pragma page_size
# will report change via both page_size and cipher_page_size
# when there is an attached codec
do_test verify-pragma-page-size-encrypted {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA page_size = 8192;
        PRAGMA page_size;
        PRAGMA cipher_page_size;
    }
} {ok 8192 8192}
db close
file delete -force test.db

# verify that a call to pragma page_size
# will not report a change to cipher_page_size for an
# unencrypted database
do_test verify-pragma-page-size-plaintext {
    sqlite_orig db test.db
    execsql {
        PRAGMA page_size = 8192;
        PRAGMA page_size;
        PRAGMA cipher_page_size;
    }
} {8192}
db close
file delete -force test.db

# verify setting cipher_store_pass before key
# does not cause segfault
do_test verify-cipher-store-pass-before-key-does-not-segfault {
    sqlite_orig db test.db
    execsql {
        PRAGMA cipher_store_pass = 1;
        PRAGMA key = 'test';
    }
} {ok}
db close
file delete -force test.db

# verify setting cipher_store_pass results in deprecation warning
do_test verify-cipher-store-pass-deprecated {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_store_pass = 1;
    }
} {ok {PRAGMA cipher_store_pass is deprecated, please remove from use}}
db close
file delete -force test.db

# verify the pragma cipher
# reports the default value
if_built_with_openssl verify-pragma-cipher-default {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher;
    }
} {ok AES-256-CBC}
db close
file delete -force test.db

# verify the pragma cipher_hmac_salt_mask reports default
do_test verify-pragma-hmac-salt-mask-reports-default {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_hmac_salt_mask;
    }
} {ok 3a}
db close
file delete -force test.db

# verify the pragma cipher_hmac_salt_mask reports
# reports value changed
do_test verify-pragma-hmac-salt-mask-reports-value-changed {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_hmac_salt_mask = "x'11'";
        PRAGMA cipher_hmac_salt_mask;
        PRAGMA cipher_hmac_salt_mask = "x'3a'";
    }
} {ok {PRAGMA cipher_hmac_salt_mask is deprecated, please remove from use} 11 {PRAGMA cipher_hmac_salt_mask is deprecated, please remove from use}}
db close
file delete -force test.db

# verify the pragma cipher_hmac_pgno reports default
do_test verify-pragma-hmac-pgno-reports-default {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_hmac_pgno;
    }
} {ok le}
db close
file delete -force test.db

# verify the pragma cipher_hmac_pgno 
# reports value changed
do_test verify-pragma-hmac-pgno-reports-value-changed {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_hmac_pgno = be;
        PRAGMA cipher_hmac_pgno;
        PRAGMA cipher_hmac_pgno = native;
        PRAGMA cipher_hmac_pgno;
        PRAGMA cipher_hmac_pgno = le;
        PRAGMA cipher_hmac_pgno;
    }
} {ok {PRAGMA cipher_hmac_pgno is deprecated, please remove from use} be {PRAGMA cipher_hmac_pgno is deprecated, please remove from use} native {PRAGMA cipher_hmac_pgno is deprecated, please remove from use} le}
db close
file delete -force test.db

# verify the pragma cipher_hmac_algorithm works properly
do_test verify-pragma-cipher-hmac-algorithm-reports-default {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_hmac_algorithm;
    }
} {ok HMAC_SHA512}
db close
file delete -force test.db

do_test verify-pragma-cipher-hmac-algorithm-reports-value-changed {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_hmac_algorithm = HMAC_SHA1;
        PRAGMA cipher_hmac_algorithm;
    }
} {ok HMAC_SHA1}
db close
file delete -force test.db

do_test verify-pragma-cipher-default-hmac-algorithm {
    sqlite_orig db test.db
    execsql {
        PRAGMA cipher_default_hmac_algorithm;
        PRAGMA cipher_default_hmac_algorithm = HMAC_SHA1;
        PRAGMA cipher_default_hmac_algorithm;
        PRAGMA cipher_default_hmac_algorithm = HMAC_SHA512;
    }
} {HMAC_SHA512 HMAC_SHA1}
db close
file delete -force test.db

# verify the pragma cipher_kdf_algorithm works properly
do_test verify-pragma-cipher-kdf-algorithm-reports-default {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_kdf_algorithm;
    }
} {ok PBKDF2_HMAC_SHA512}
db close
file delete -force test.db

do_test verify-pragma-cipher-kdf-algorithm-reports-value-changed {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_kdf_algorithm = PBKDF2_HMAC_SHA1;
        PRAGMA cipher_kdf_algorithm;
    }
} {ok PBKDF2_HMAC_SHA1}
db close
file delete -force test.db

do_test verify-pragma-cipher-default-kdf-algorithm {
    sqlite_orig db test.db
    execsql {
        PRAGMA cipher_default_kdf_algorithm;
        PRAGMA cipher_default_kdf_algorithm = PBKDF2_HMAC_SHA1;
        PRAGMA cipher_default_kdf_algorithm;
        PRAGMA cipher_default_kdf_algorithm = PBKDF2_HMAC_SHA512;
    }
} {PBKDF2_HMAC_SHA512 PBKDF2_HMAC_SHA1}
db close
file delete -force test.db

if_built_with_openssl verify-default-cipher {
    sqlite_orig db test.db
    execsql {
        PRAGMA key='test';
        PRAGMA cipher;
    }
} {ok AES-256-CBC}
db close
file delete -force test.db

if_built_with_libtomcrypt verify-default-cipher {
    sqlite_orig db test.db
    execsql {
        PRAGMA key='test';
        PRAGMA cipher;
    }
} {ok aes-256-cbc}
db close
file delete -force test.db

if_built_with_commoncrypto verify-default-cipher {
    sqlite_orig db test.db
    execsql {
        PRAGMA key='test';
        PRAGMA cipher;
    }
} {ok aes-256-cbc}
db close
file delete -force test.db

if_built_with_nss verify-default-cipher {
    sqlite_orig db test.db
    execsql {
        PRAGMA key='test';
        PRAGMA cipher;
    }
} {ok aes-256-cbc}
db close
file delete -force test.db

do_test verify-cipher_settings_default {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_settings;
    }
} {ok {PRAGMA kdf_iter = 256000;} {PRAGMA cipher_page_size = 4096;} {PRAGMA cipher_use_hmac = 1;} {PRAGMA cipher_plaintext_header_size = 0;} {PRAGMA cipher_hmac_algorithm = HMAC_SHA512;} {PRAGMA cipher_kdf_algorithm = PBKDF2_HMAC_SHA512;}}
db close
file delete -force test.db

do_test verify-cipher_settings_v1 {
    sqlite_orig db test.db
    execsql {
        PRAGMA key = 'test';
        PRAGMA cipher_compatibility = 1;
        PRAGMA cipher_settings;
    }
} {ok {PRAGMA kdf_iter = 4000;} {PRAGMA cipher_page_size = 1024;} {PRAGMA cipher_use_hmac = 0;} {PRAGMA cipher_plaintext_header_size = 0;} {PRAGMA cipher_hmac_algorithm = HMAC_SHA1;} {PRAGMA cipher_kdf_algorithm = PBKDF2_HMAC_SHA1;}} 
db close
file delete -force test.db

do_test verify-cipher_default_settings_v1 {
    sqlite_orig db test.db
    execsql {
        PRAGMA cipher_default_compatibility = 1;
        PRAGMA cipher_default_settings;
        PRAGMA cipher_default_compatibility = 4;
    }
} {{PRAGMA cipher_default_kdf_iter = 4000;} {PRAGMA cipher_default_page_size = 1024;} {PRAGMA cipher_default_use_hmac = 0;} {PRAGMA cipher_default_plaintext_header_size = 0;} {PRAGMA cipher_default_hmac_algorithm = HMAC_SHA1;} {PRAGMA cipher_default_kdf_algorithm = PBKDF2_HMAC_SHA1;}} 
db close
file delete -force test.db

do_test verify-cipher_default_settings_default {
    sqlite_orig db test.db
    execsql {
        PRAGMA cipher_default_settings;
    }
} {{PRAGMA cipher_default_kdf_iter = 256000;} {PRAGMA cipher_default_page_size = 4096;} {PRAGMA cipher_default_use_hmac = 1;} {PRAGMA cipher_default_plaintext_header_size = 0;} {PRAGMA cipher_default_hmac_algorithm = HMAC_SHA512;} {PRAGMA cipher_default_kdf_algorithm = PBKDF2_HMAC_SHA512;}}
db close
file delete -force test.db

do_test verify-cipher_log_source {
    sqlite_orig db :memory:
    execsql {
        PRAGMA cipher_log_source; -- default should be ANY
        PRAGMA cipher_log_source = NONE; --reset to NONE
        PRAGMA cipher_log_source = PROVIDER; -- add PROVIDER to log source
        PRAGMA cipher_log_source = CORE; -- add CORE to log source
        PRAGMA cipher_log_source = MEMORY; -- add MEMORY to log source
        PRAGMA cipher_log_source = NOTASOURCE; -- stay the same
        PRAGMA cipher_log_source = ANY; -- reset to ANY
    }
} {ANY NONE PROVIDER {CORE PROVIDER} {CORE MEMORY PROVIDER} {CORE MEMORY PROVIDER} ANY}
db close

do_test verify-cipher_log_level {
    sqlite_orig db :memory:
    execsql {
        PRAGMA cipher_log_level; -- default should be WARN
        PRAGMA cipher_log_level = TRACE;
        PRAGMA cipher_log_level = DEBUG;
        PRAGMA cipher_log_level = INFO;
        PRAGMA cipher_log_level = WARN;
        PRAGMA cipher_log_level = ERROR;
        PRAGMA cipher_log_level = NOTALEVEL; -- an unknown level should set back to none
    }
} {WARN TRACE DEBUG INFO WARN ERROR NONE}
db close

finish_test