Thanks John, A note about checking that the rdbms server is running is in the docs: http://drill.apache.org/docs/jdbc-storage-plugin/
I suspect that you have to set up a password and not use the default (no password) in the case of MySQL. I'll clarify that in the docs. Turns out my problem was lack of support for the TEXT type in the products table of classic models. A Jira has been opened. On Monday, October 26, 2015, John Omernik <[email protected]> wrote: > Kristine - > > After beating my head against the wall on this issue, the result you are > getting appears to be related when your mysql server isn't actually > accessible. (Mine wasn't) Once I fixed that issue, then it worked. *Note we > could REALLY use some better error messages on the storage plugin > configurations. I am not sure if this error is the same one that would be > returned if your user/pass is incorrect though. In my case, I hadn't > started my MySQL server (bollocks) > > > > On Sun, Oct 18, 2015 at 10:46 AM, Kristine Hahn <[email protected] > <javascript:;>> wrote: > > > What's wrong with this command? > > > > curl -X POST -H "Content-Tpe: application/json" -d '{"name":"myplugin", > > "config": {"type": "jdbc", "enabled": false, > > "driver":"com.mysql.jdbc.Driver", "url":"jdbc:mysql://localhost:3306;"}}' > > http://localhost:8047/storage/myplugin.json > > > > { > > > > "result" : "error (unable to create/ update storage)" > > > > } > > > > > > Kristine Hahn > > Sr. Technical Writer > > 415-497-8107 @krishahn skype:krishahn > > > -- Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn skype:krishahn
