Category: Linux
ksqlDB to load and transform in SQL your data and flows
DuckDB to query Excel file in SQL
Table of contents
Debezium to stream data from Oracle to MariaDB
Kafka TLS/SSL encryption and Access Control Lists (ACLs) setup
Table of contents
- Preamble
- Kafka TLS/SSL encryption
- Access Control Lists (ACLs)
-
Issues encountered
- org.apache.kafka.common.errors.SslAuthenticationException: SSL handshake failed
- Error creating Kafka producer: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: Hostname mismatch, certificate is not valid for 'server01.domain.com'. (_ssl.c:1028)
- Error creating Kafka producer: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self-signed certificate in certificate chain (_ssl.c:1028)
- listenerName=ListenerName(CONTROLLER), securityProtocol=SASL_SSL, buffer=null, envelope=None) is not authorized
- References
Configure Kafka authentication to build Kafka client application
Table of contents
- Preamble
- Confluent Community Platform SASL/PLAIN setup for Kafka client application authentication
- Python consumer and producer Kafka client application
- Java consumer and producer Kafka client application
- Connecting to Oracle
-
Issues encountered
- java.util.concurrent.ExecutionException: org.apache.kafka.common.errors.TimeoutException: Timed out waiting for a node assignment.
- KafkaTimeoutError: Failed to update metadata after 4999000.0 secs
- No serviceName defined in either JAAS or Kafka config
- org.apache.kafka.common.errors.SaslAuthenticationException: Failed to configure SaslClientAuthenticator
- Unexpected Kafka request of type METADATA during SASL handshake
- bootstrap.servers ignored and keeps trying to connect to localhost:9092
- Even with 'auto.offset.reset' set to 'earliest' you get no message
- References