Kristine-
I tried by providing username/passwd in plugin configuration and its worked.
curl --request POST --header "Content-Type: application/json" -data
'{"name": "myplugin", "config": { "type": "jdbc", "driver":
"com.mysql.jdbc.Driver", "url":
"jdbc:mysql://10.10.71.14:3306/mydb","username":"root","password":"password","enabled":false
}}' http://localhost:8047/storage/myplugin.json
{
"result" : "success"
}
> On 19-Oct-2015, at 3:28 AM, Jacques Nadeau <[email protected]> wrote:
>
> It is important to note that Drill doesn't come prepackaged with any JDBC
> drivers. As such, you'll need to copy your desired JDBC driver to the
> jars/3rdparty path (or alternatively adding your path to the Drill startup
> classpath).
>
> --
> Jacques Nadeau
> CTO and Co-Founder, Dremio
>
> On Sun, Oct 18, 2015 at 9:37 AM, Kristine Hahn <[email protected]> wrote:
>
>> Nope, no luck. Must be my J connector setup. I'll try something like
>> exporting a CLASSPATH.
>>
>> My Drill 1.2 (tar downloaded from the Apache site yesterday) setup checks
>> out ok for creating a storage plugin config from REST API:
>>
>> Administratots-MacBook-Pro:apache-drill-1.2.0 khahn$ curl -X POST -H
>> "Content-Tpe: application/json" -d '{"name":"myplugin3", "config": {"type":
>> "file", "enabled": false, "connection": "file:///", "workspaces": { "root":
>> { "location": "/", "writable": false, "defaultInputFormat": null}},
>> "formats": null}}' http://localhost:8047/storage/myplugin3.json
>>
>> {
>>
>> "result" : "success"
>>
>> Administratots-MacBook-Pro:apache-drill-1.2.0 khahn$ curl --request POST
>> --hader "Content-Type: application/json" --data '{"name": "myplugin4",
>> "config": { "type": "jdbc", "enabled": false, "driver":
>> "com.mysql.jdbc.Driver", "url": "jdbc:mysql://localhost:3306;" }}'
>> http://localhost:8047/storage/myplugin4.json
>>
>> {
>>
>> "result" : "error (unable to create/ update storage)"
>>
>> }
>>
>> Kristine Hahn
>> Sr. Technical Writer
>> 415-497-8107 @krishahn skype:krishahn
>>
>>
>> On Sun, Oct 18, 2015 at 9:12 AM, Rajkumar Singh <[email protected]>
>> wrote:
>>
>>> Could you please try with this curl request
>>>
>>> curl --request POST --header "Content-Type: application/json"
>>> --data '{"name": "myplugin", "config": { "type": "jdbc",
>>> "enabled": false, "driver": "com.mysql.jdbc.Driver", "url":
>>> "jdbc:mysql://localhost:3306;" }}'
>>> http://localhost:8047/storage/myplugin.json
>>>
>>>> On 18-Oct-2015, at 9:16 PM, Kristine Hahn <[email protected]> wrote:
>>>>
>>>> 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 <
>>> http://localhost:8047/storage/myplugin.json>
>>>
>>
