I faced a similar case before and after debugging I found that the exception is squashed and never thrown nor printed. You'll have to debug to find out the problem. I checked the structure of your JSON and it looks ok, you may have a special character among those masked values or the connection information are simply invalid. Make sure you can connect to the DB using another client first.
Also did you restart Drill after placing the JAR ? - Gelbana On Tue, Aug 1, 2017 at 11:25 PM, Kunal Khatua <[email protected]> wrote: > What is the stack trace in the log? > > -----Original Message----- > From: Bob Carter [mailto:[email protected]] > Sent: Tuesday, August 01, 2017 7:13 AM > To: [email protected] > Subject: MySQL Storage Plugin Error > > I am getting the following when I try to create a MySQL Storage Plugin: > > > Please retry: error (unable to create/ update storage) > > > Below is the configuration. > > > { > "type": "jdbc", > "driver": "com.mysql.jdbc.Driver", > "url": "jdbc:mysql://xxx.xxx.xxx.xxx:3306", > "username": "xxxxx", > "password": "xxxx", > "enabled": true > } > > > I copied mysql-connector-java-5.1.43-bin.jar to jars/3rdparty > > Drill is running in embedded mode. > > > Thanks >
