jdbc with sql

[Tommy Wu]

Hello,

I'm currently having an issue connecting killbill and kaui to a RDS databse, with use of SSL
I'm using the docker-compose file and filling in the 'KILLBILL_DAO_URL' and 'KAUI_CONFIG_DAO_URL' with:
jdbc:mysql://RDS-DNS:3306/killbill?sslMode=PREFERRED and jdbc:mysql://RDS-DNS:3306/killbill?sslMode=PREFERRED&trustCertificateKeyStoreUrl=global-bundle.pem
accordingly with https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-jdbc-url-format.html#connector-j-url-properties

When I use the '&' to add more 'variables' it gets stuck in the ansible part. I tried encoding it, when I do that I see in debug that it doesn't really recognize what is going on.

I hereby ask for help on how I should go about connecting to RDS database while using SSL.
I thank you in advance for your patience and understanding.

docker-compose:

version: '3.2'
services:
  killbill:
    image: killbill/killbill
    restart: always
    ports:
      - "8443:8443"
    volumes:
      - ./server.xml:/var/lib/tomcat/conf/server.xml
      - ./killbill_selfsigned.key:/var/lib/tomcat/conf/killbill_selfsigned.key
      - ./killbill_selfsigned.crt:/var/lib/tomcat/conf/killbill_selfsigned.crt
      - ./global-bundle.pem:/var/lib/tomcat/conf/global-bundle.pem
    environment:
      - KILLBILL_DAO_URL=jdbc:mysql://rds.amazonaws.com:3306/killbill?sslMode=PREFERRED&trustCertificateKeyStoreUrl=global-bundle.pem
      - KILLBILL_DAO_USER=killbill
      - KILLBILL_DAO_PASSWORD=SECRET
  kaui:
    image: killbill/kaui
    restart: always
    ports:
      - "9443:8443"
    volumes:
      - ./server.xml:/var/lib/tomcat/conf/server.xml
      - ./killbill_selfsigned.key:/var/lib/tomcat/conf/killbill_selfsigned.key
      - ./killbill_selfsigned.crt:/var/lib/tomcat/conf/killbill_selfsigned.crt
      - ./global-bundle.pem:/var/lib/tomcat/conf/global-bundle.pem
    environment:
      - KAUI_CONFIG_DAO_URL=jdbc:mysql://rds.amazonaws.com:3306/kaui?sslMode=PREFERRED&trustCertificateKeyStoreUrl=global-bundle.pem
      - KAUI_CONFIG_DAO_USER=kaui
      - KAUI_CONFIG_DAO_PASSWORD=SECRET
      - KAUI_KILLBILL_URL=https://killbill:8443

[Douglas Negrisolli]

Hi there! I´m facing the same problem, but I saw that Killbill can´t connect with SSL from MySQL 8.x, you shall downgrade to the way that is being used in 5.x

[Marius U]

Hi,

Facing the same problem. Did you folks find any workaround?

Is 5x mandatory for SSL to work?

Thanks,
Marius