Closed devendermishra closed 7 months ago
Log:
WARNING: Published ports are discarded when using host network mode
time="2023-11-30T10:41:34Z" level=info msg="Starting service acra-server [pid=1]" version=0.95.0
time="2023-11-30T10:41:34Z" level=info msg="Validating service configuration..."
time="2023-11-30T10:41:34Z" level=info msg="Load encryptor configuration from /encryptor_config.yml ..."
time="2023-11-30T10:41:34Z" level=info msg="Encryptor configuration loaded"
time="2023-11-30T10:41:34Z" level=info msg="Initialising keystore..."
time="2023-11-30T10:41:34Z" level=info msg="Initializing default env ACRA_MASTER_KEY loader"
time="2023-11-30T10:41:34Z" level=info msg="Cached keystore on start successfully"
time="2023-11-30T10:41:34Z" level=info msg="Keystore init OK" path=/keystore/newkey1
time="2023-11-30T10:41:34Z" level=info msg="Configuring transport..."
time="2023-11-30T10:41:34Z" level=info msg="Use sni" sni=""
time="2023-11-30T10:41:34Z" level=info msg="Use sni" sni=127.0.0.1
time="2023-11-30T10:41:34Z" level=info msg="Loaded TLS configuration" tls_client_id_from_cert=false
time="2023-11-30T10:41:34Z" level=info msg="Initialize in-memory db storage for tokens"
time="2023-11-30T10:41:34Z" level=info msg="Initialized in-memory db storage for tokens"
time="2023-11-30T10:41:34Z" level=info msg="Initialized SQL query parser in default mode"
time="2023-11-30T10:41:34Z" level=info msg="Start listening to connections. Current PID: 1"
time="2023-11-30T10:41:34Z" level=info msg="Enabling VERBOSE log level"
time="2023-11-30T10:41:34Z" level=info msg="Create listener" connection_string="tcp://0.0.0.0:9393/" from_descriptor=false
time="2023-11-30T10:41:34Z" level=info msg="Start listening connections" connection_string="tcp://0.0.0.0:9393/" from_descriptor=false
time="2023-11-30T10:41:45Z" level=info msg="Got new connection to AcraServer: 127.0.0.1:46308" connection_string="tcp://0.0.0.0:9393/" from_descriptor=false
time="2023-11-30T10:41:45Z" level=info msg="Handle client's connection" client_id=MyClientID session_id=1
time="2023-11-30T10:41:45Z" level=warning msg="ignoring error of non parsed sql statement"
time="2023-11-30T10:41:45Z" level=warning msg="ignoring error of non parsed sql statement"
time="2023-11-30T10:41:45Z" level=warning msg="ignoring error of non parsed sql statement"
Hello.
- id
varbinary(20)
that couldn't be used for AcraBlock that has overhead 138 bytes over plaintext. Use BLOB
instead of varbinary(20)
according to our docs@Lagovas Thanks for quick response.
Updated config is
database_settings:
mysql:
case_sensitive_table_identifiers: true
defaults:
crypto_envelope: acrablock
schemas:
- table: cphone
columns:
- id
- phone
- e_phone
encrypted:
- column: "e_phone"
data_type: "str"
I have changed type to BLOB
. Still facing the same problem.
@Lagovas It seems that it is not working with MySQL 8.
Describe the Issue I am using mysql. I have
acra_test_db
with following sample tableMy encryptor config is as follows:
I am running docker command as follows:
On connecting to the server, when I insert any record, it is not getting encrypted.
Acra configuration files For AcraServer:
-client_id ${ACRA_CLIENT_ID} -db_host 127.0.0.1 -db_port 3306 -mysql_enable --v -keys_dir /keystore/newkey1 -encryptor_config_file /encryptor_config.yml --tls_client_id_from_cert=false --tls_auth=0 --tls_client_auth=0 --tls_database_auth=0 --tls_cert=/ssl/acra-server.crt --tls_key=/ssl/acra-server.key
Environment (please complete the following information):
Acra version: [e.g. 0.95.0]
Database server and its version: MySQL 8
Installed components:
Data-in-transit encryption between Acra and the client-side application:
Installation way:
Additional context Add any other context about the problem here.