If you have to report any support ticket for Virtual Schema, Exasol would need some logs to check the problem. This section talks about how you can use netcat tool on Linux environment to get these logs.
- Start netcat in listen-mode on a free TCP port on a machine reachable for an Exasol cluster.
nc -lkp 3000
- Run the following command to find your IP address.
ip -br address
- Run the following SQL statement with your virtual schema and IP Address:Port information.
In the following command, CREATE VIRTUAL SCHEMA needs to be appended with the properties DEBUG_ADDRESS and LOG_LEVEL.
CREATE VIRTUAL SCHEMA VIRTUAL_EXASOL
USING SCHEMA_FOR_VS_SCRIPT.ADAPTER_SCRIPT_EXASOL WITH
CONNECTION_NAME = 'JDBC_CONNECTION'
SCHEMA_NAME = '<schema name>'
IMPORT_FROM_EXA = 'true'
EXA_CONNECTION = 'EXA_CONNECTION'
DEBUG_ADDRESS = '<IP Address>:<Port>'
LOG_LEVEL = 'ALL';
The parameter LOG_LEVEL specifies log level defined in Java Utility Logging Levels.
- The following message is shown in case of a successful connection.
Attached to output service