Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Drill Embedded with TLS: Impossible? #2816

Open
thinkORo opened this issue Jul 17, 2023 · 0 comments
Open

Drill Embedded with TLS: Impossible? #2816

thinkORo opened this issue Jul 17, 2023 · 0 comments
Labels

Comments

@thinkORo
Copy link

Describe the bug
To secure the communication between client and server, drill-embedded is to be configured with TLS. Following the instructions on the website (https://drill.apache.org/docs/configuring-ssl-tls-for-encryption/) I always get the error message: Error: Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION : io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: localhost/127.0.0.1:31010 (state=,code=0)

To Reproduce
Steps to reproduce the behavior:

  1. Download Apache Drill from Drill website
  2. Create keystore.jks and truststore.jks via keytool
  3. Create drill-override.conf (see "Additional context" below)
  4. Start drill-embedded with required "-u" JDBC parameter to define TLS (see "Additional context" below)
  5. See error

Expected behavior
drill-embedded starts without any error message, sqlline interface is available, respective ports (8047, 31010) are bound

Error detail, log output or screenshots
Error: Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION : io.netty.channel.AbstractChannel$AnnotatedConnectException: Connection refused: localhost/127.0.0.1:31010 (state=,code=0)

Drill version
1.21.1

Additional context

  1. drill-override.conf:
drill.exec: {
  cluster-id: "drillbits1",
  zk.connect: "localhost:2181",
  security.user.encryption.ssl.enabled: true,
  ssl: {
    protocol: "TLSv1.2",
    keyStoreType: "JKS",
    keyStorePath: "/InstallFolder/apache-drill-1.21.1/conf/keystore.jks",
    keyStorePassword: "securePasswd",
    keyPassword: "securePasswd",
    trustStoreType: "JKS",
    trustStorePath: "/InstallFolder/apache-drill-1.21.1/conf/truststore.jks"
    trustStorePassword: "securePasswd",
    provider: "JDK",
    useHadoopConfig: false
  }
}
  1. drill-embedded:
cd /InstallFolder/apache-drill-1.21.1
bin/drill-embedded -u "jdbc:drill:schema=data.query;drillbit=localhost:31010;enableTLS=true;trustStorePath=/InstallFolder/apache-drill-1.21.1/conf/truststore.jks;trustStorePassword=securePasswd"
@thinkORo thinkORo added the bug label Jul 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant