|
1
|
# Database
|
|
2
|
INMEMORY_DATABASE_FILE = ":memory:"
|
|
3
|
TEST_DATABASE_FILE = INMEMORY_DATABASE_FILE
|
|
4
|
DATETIME_FORMAT = "%a, %d %b %Y"
|
|
5
|
SCHEMA_SQL_FILE = "SQLite_database.sql"
|
|
6
|
VALUES_SQL_FILE = "SQLite_default_values.sql"
|
|
7
|
|
|
8
|
# Logging
|
|
9
|
LOG_DIR = "logs"
|
|
10
|
LOG_FILENAME = "application.log"
|
|
11
|
LOG_FORMAT = "%(levelname)-8s %(asctime)s - %(message)s"
|
|
12
|
LOG_NAME = "app_logger"
|
|
13
|
|
|
14
|
REV_REASON_UNSPECIFIED = "unspecified"
|
|
15
|
|
|
16
|
# Types of certificates
|
|
17
|
ROOT_CA_ID = 1
|
|
18
|
INTERMEDIATE_CA_ID = 2
|
|
19
|
CERTIFICATE_ID = 3
|
|
20
|
|
|
21
|
# Usage types of certificates
|
|
22
|
CA_ID = 1
|
|
23
|
SSL_ID = 2
|
|
24
|
SIGNATURE_ID = 3
|
|
25
|
AUTHENTICATION_ID = 4
|
|
26
|
DICT_USAGES = {CA_ID: False, SSL_ID: False, SIGNATURE_ID: False, AUTHENTICATION_ID: False}
|
|
27
|
|
|
28
|
# DB names of tables
|
|
29
|
TAB_CERTIFICATES = "Certificates"
|
|
30
|
TAB_PRIVATE_KEYS = "PrivateKeys"
|
|
31
|
TAB_CERTIFICATE_USAGES = "CertificateUsages"
|
|
32
|
TAB_CERTIFICATE_TYPES = "CertificateTypes"
|
|
33
|
TAB_USAGE_TYPES = "UsageTypes"
|
|
34
|
|
|
35
|
# DB column names
|
|
36
|
COL_ID = "id"
|
|
37
|
COL_PK = "private_key"
|
|
38
|
|
|
39
|
# DB column names of Certificates table
|
|
40
|
COL_VALID_FROM = "valid_from"
|
|
41
|
COL_VALID_TO = "valid_to"
|
|
42
|
COL_PEM_DATA = "pem_data"
|
|
43
|
COL_COMMON_NAME = "common_name"
|
|
44
|
COL_COUNTRY_CODE = "country_code"
|
|
45
|
COL_LOCALITY = "locality"
|
|
46
|
COL_PROVINCE = "province"
|
|
47
|
COL_ORGANIZATION = "organization"
|
|
48
|
COL_ORGANIZATIONAL_UNIT = "organizational_unit"
|
|
49
|
COL_EMAIL_ADDRESS = "email_address"
|
|
50
|
COL_REVOCATION_DATE = "revocation_date"
|
|
51
|
COL_REVOCATION_REASON = "revocation_reason"
|
|
52
|
COL_DELETION_DATE = "deletion_date"
|
|
53
|
COL_TYPE_ID = "certificate_type_id"
|
|
54
|
COL_PARENT_ID = "parent_certificate_id"
|
|
55
|
COL_PRIVATE_KEY_ID = "private_key_id"
|
|
56
|
|
|
57
|
# DB column names of PrivateKeys table
|
|
58
|
COL_PRIVATE_KEY = "private_key"
|
|
59
|
COL_PASSWORD = "password"
|
|
60
|
|
|
61
|
# DB column names of PrivateKey table
|
|
62
|
COL_CERTIFICATE_ID = "certificate_id"
|
|
63
|
COL_USAGE_TYPE_ID = "usage_type_id"
|
|
64
|
|
|
65
|
# configuration default
|
|
66
|
DEFAULT_CONNECTION_STRING = "db/database_sqlite.db"
|
|
67
|
DEFAULT_SERVER_BASE_URL = "http://localhost"
|
|
68
|
DEFAULT_LOG_LEVEL = "DEBUG"
|
|
69
|
DEFAULT_ROOT_DIR = "aswi2021jmsd"
|
|
70
|
|
|
71
|
# available certificate states and revocation reasons
|
|
72
|
CERTIFICATE_STATES = {"valid", "revoked"}
|
|
73
|
CERTIFICATE_REVOCATION_REASONS = {"unspecified", "keyCompromise",
|
|
74
|
"CACompromise", "affiliationChanged",
|
|
75
|
"superseded", "cessationOfOperation",
|
|
76
|
"certificateHold", "removeFromCRL"}
|
|
77
|
CERTIFICATE_REVOCATION_REASON_HOLD = "certificateHold"
|
|
78
|
|
|
79
|
CERTIFICATE_VALID = "valid"
|
|
80
|
CERTIFICATE_REVOKED = "revoked"
|
|
81
|
CERTIFICATE_EXPIRED = "expired"
|
|
82
|
|
|
83
|
|
|
84
|
# Insert values into the template using % (index_file, serial_file)
|
|
85
|
CRL_CONFIG = """[ ca ]
|
|
86
|
default_ca = crl_ca
|
|
87
|
|
|
88
|
[ crl_ext ]
|
|
89
|
authorityKeyIdentifier=keyid:always
|
|
90
|
|
|
91
|
[ crl_ca ]
|
|
92
|
database = %s
|
|
93
|
serial = %s
|
|
94
|
default_md = sha1
|
|
95
|
policy = crl_policy
|
|
96
|
default_crl_days = 30
|
|
97
|
|
|
98
|
[ crl_policy ]
|
|
99
|
commonName = supplied
|
|
100
|
stateOrProvinceName = optional
|
|
101
|
countryName = optional
|
|
102
|
emailAddress = optional
|
|
103
|
organizationName = optional
|
|
104
|
organizationalUnitName = optional
|
|
105
|
|
|
106
|
"""
|