MySQL Storage Plugin Error
Add Reply
Charles Givre
2017-08-02 13:06:49 UTC
Raw Message
I think we should open a JIRA about this. Basically, the error messages when you add or modify a storage plugin make it difficult to locate the problem. I encountered the same issue recently when trying to connect to MySQL and it turned out the error was that the user account that I was using was not configured correctly—on the MySQL side. However, the error I was getting suggested that the JSON was malformed. Bottom line, this is another area where we really should work on using more helpful error messages.

Perhaps we could use something like https://sourceforge.net/projects/codepress/ <https://sourceforge.net/projects/codepress/> or https://sourceforge.net/projects/editarea/ <https://sourceforge.net/projects/editarea/> instead of the blank textarea, as this would help with syntax errors.
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
What is the stack trace in the log?
-----Original Message-----
Sent: Tuesday, August 01, 2017 7:13 AM
Subject: MySQL Storage Plugin Error
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.