Kaui - JDBC error - FATAL -- : ActiveRecord::JDBCError (SSL connection is required. Please specify SSL options and retry.)

[Vrushali Hargude]

I am deploying killbill using docker desktop - here is my docker compose file -

services:

 

  killbill:  

    image: killbill/killbill:0.23.0-c89061b-SNAPSHOT

    container_name: killbill-0.23.0

    ports:

      - 8082:8080

    working_dir: /home

    volumes:

      - ./:/home

    environment:

      KILLBILL_DAO_URL: jdbc:mysql://localhost:3306/killbill?useSSL=true

      KILLBILL_DAO_USER: killbill

      KILLBILL_OSGI_DAO_URL: jdbc:mysql://localhost:3306/killbill?useSSL=true

      KILLBILL_OSGI_DAO_USER: killbill

      KILLBILL_SERVER_TEST_MODE: "true"

      KILLBILL_DAO_PASSWORD: killbill

      KILLBILL_OSGI_DAO_PASSWORD: killbill

  kaui:

    image: killbill/kaui:2.0.9                      

    container_name: kaui

    ports:

      - 8081:8080

    working_dir: /home

    volumes:

      - ./:/home

    environment:

     

      KAUI_KILLBILL_URL: http://localhost:8082

      KAUI_CONFIG_DAO_URL: jdbc:mysql://localhost:3306/kaui?useSSL=true

      KAUI_CONFIG_DAO_USER: killbill

      KAUI_CONFIG_DAO_PASSWORD: killbill

I am using azure mysql server - SSL enabled  (tried with both 5.7 and 8.0)

I tried all possible ways to enable SSL in jdbc connection string like - 

jdbc:mysql://localhost:3306/kaui?useSSL=true

jdbc:mysql://localhost:3306/kaui?sslMode=REQUIRED

jdbc:mysql://localhost:3306/kaui?sslMode= PREFERRED    

jdbc:mysql://localhost:3306/kaui?sslMode=VERIFY_CA&trustCertificateKeyStoreUrl=file:/home/truststore&trustCertificateKeyStorePassword=password

jdbc:mysql://localhost:3306/kaui?sslMode= VERIFY_IDENTITY&trustCertificateKeyStoreUrl=file:/home/truststore&trustCertificateKeyStorePassword=password

I even tried using different kaui image but no luck

Any help is appreciated. 

Thanks. 

[Reshma Bidikar]

Hi Vrushali,

The Kill Bill/Kaui Docker image versions are wrong in your docker-compose file. The Kill Bill version should be 0.24.x, Kaui should be 2.0.11. You can take a look at the sample docker-compose file here:  https://docs.killbill.io/latest/getting_started.html#_docker_installation

Could you please make the necessary changes and see if this resolves your errors?

Regards,

Reshma

[Marius U]

Hi, Having same issue with KAUI. 

I'm able to connect from KILLBILL to Azure MySQL using SSL, but not from KAUI.

Vrushali were you able to find a workaround?

Thanks,
Marius