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
|
# name: test/sql/extensions/allowed_directories_install.test
# description: Test extension installation with allowed_directories setting
# group: [extensions]
statement ok
set extension_directory='__TEST_DIR__/extension_dir'
statement ok
SET allowed_directories=['__TEST_DIR__', 'http://', 'https://'];
statement ok
SET enable_external_access=false;
# error messsage `Failed to download extension` means duckdb
statement error
INSTALL bogus FROM 'http://not.existent';
----
Failed to download extension
# now switch the extension directory to one that is not in the allowed_directories list
statement ok
set extension_directory='/tmp'
# duckdb will throw permission error because /tmp is not allowed
statement error
INSTALL bogus FROM 'http://not.existent';
----
Permission Error: Cannot access directory
|
