-1

Hi I am unable to connect mysql to apache drill on vm.

I have used jdbc connector 5.1.45 and mysql version is 5.7.20.

Also in VM its giving warning:

warning

tobi6
  • 8,033
  • 6
  • 26
  • 41
ruhi Srivastava
  • 1
  • 2
  • Please copy and paste the text from the terminal and add it as text to the question, so that it is searchable for others. – ilooner Feb 14 '18 at 01:56
  • I took the error message and let Google do it's magic. Have you done this too? https://stackoverflow.com/questions/34189756/warning-about-ssl-connection-when-connecting-to-mysql-database – tobi6 Feb 14 '18 at 08:40
  • yup I tried this too. – ruhi Srivastava Feb 14 '18 at 09:13

1 Answers1

1

Download mysql-connector-java-5.1.37-bin.jar connector and place it in jars/3rdparty/ folder

Modify conf/drill-override.conf to add the below line before }:

drill.exec.sys.store.provider.local.path = "mysql-connector-java-5.1.37-bin.jar"

Restart drill and try again.

Storage plugin should look something like this:

{
  "type": "jdbc",
  "driver": "com.mysql.jdbc.Driver",
  "url": "jdbc:mysql://localhost:3306",
  "username": "username",
  "password": "password",
  "enabled": true
}
Srihari Karanth
  • 2,067
  • 2
  • 24
  • 34