Re: MySQL Storage Plugin Error

[Charles Givre <cg...@gmail.com>]

All, 
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.
—C



> On Aug 2, 2017, at 08:53, Muhammad Gelbana <m....@gmail.com> wrote:
> 
> 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 <kk...@mapr.com> wrote:
> 
>> What is the stack trace in the log?
>> 
>> -----Original Message-----
>> From: Bob Carter [mailto:bcarter@battelleecology.org]
>> Sent: Tuesday, August 01, 2017 7:13 AM
>> To: dev@drill.apache.org
>> 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
>>