Hello. I'm trying to use AWS RDS on DataHub with t...
# all-things-deployment
r
Hello. I'm trying to use AWS RDS on DataHub with this page. https://datahubproject.io/docs/deploy/aws/ I already have an Aurora MySQL instance, database, user ID, and password created for Datahub. When I execute the command as shown in the guide, I keep encountering errors. Is there something wrong with my command? this is my command and yaml.
Copy code
kubectl create secret generic mysql-secrets --from-literal=mysql-root-password=<<password>>
this password is my db password in aws mysql.
Copy code
sql:
    datasource:
      host: "<<rds-endpoint>>:3306"
      hostForMysqlClient: "<<rds-endpoint>>"
      port: "3306"
      url: "jdbc:mysql://<<rds-endpoint>>:3306/datahub?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8"
      driver: "com.mysql.jdbc.Driver"
      username: "root"
      password:
        secretRef: mysql-secrets
        secretKey: mysql-root-password
rds-endpoint is the writer endpoint value of the my AWS MySQL instance that I created. And I changed the username to another userid that I created instead of using "root". Do I have to use only "root" as the username value? Could you please provide me with the correct way to connect AWS RDS to DataHub? Thank you in advance.
✅ 1
🔍 1
📖 1
l
Hey there 👋 I'm The DataHub Community Support bot. I'm here to help make sure the community can best support you with your request. Let's double check a few things first: ✅ There's a lot of good information on our docs site: www.datahubproject.io/docs, Have you searched there for a solution? ✅ It's not uncommon that someone has run into your exact problem before in the community. Have you searched Slack for similar issues? Did you find a solution to your issue? ❌ Sorry you weren't able to find a solution. I'm sending you some tips on info you can provide to help the community troubleshoot. Whenever you feel your issue is solved, please react ✅ to your original message to let us know!
a
Hi! @dazzling-yak-93039 may be able to help you here- what version are you using?
r
I solved this problem adding to 'enabledTLSProtocols=TLSv1.2' on end of url like this.
Copy code
url: "jdbc:mysql://<<rds-endpoint>>:3306/datahub?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8&enabledTLSProtocols=TLSv1.2"