I have also seen this fail if the supplied credentials are not valid. With MySQL it can be a bit tricky as credentials can depend on the location of the client, so make sure the MySQL user credentials are for % since Drill is a distributed system and any of the nodes may connect to MySQL.
--Andries > On Mar 24, 2016, at 8:39 AM, Christopher Matta <[email protected]> wrote: > > Scott, > Could you paste the JSON you're using to define the MySQL storage plugin > here? I've experienced that you get that error when either the JSON is > invalid, or Drill can't find the class you defined. > > I've created a JIRA to improve this functionality: > https://issues.apache.org/jira/browse/DRILL-4533 > > > > On Thursday, March 24, 2016, Wilburn, Scott > <[email protected]> wrote: > >> Hello, >> I am trying to connect to a mysql database using the jdbc storage plugin >> using Drill 1.5 described here: >> https://drill.apache.org/docs/rdbms-storage-plugin/ >> >> When I try to create the plugin through the web UI, I get the following >> vague error: >> "Please retry: error (unable to create/ update storage)" >> >> I tried to see if more information exists in the drillbit logs, but didn't >> see anything relevant. Does anyone know where I can find a better >> description of the problem, or is JDBC just broken in 1.5? I found the >> following Jira with the same description for 1.2 (DRILL-3977). Has it been >> broken since 1.2, or am I doing something stupid? >> >> Any help would be appreciated. >> >> Thanks, >> Scott Wilburn >> >> > > -- > Chris Matta > [email protected] > 215-701-3146
