You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Devender Yadav <de...@gmail.com> on 2016/01/28 12:20:54 UTC
Drill Microsoft SQL plugin
Hi,
I am using drill 1.4 in embedded mode. I am trying to add MS SQL server
plugin in drill. I am referring:
https://drill.apache.org/docs/rdbms-storage-plugin/#example-sql-server-configuration
I got error:
*error(unable to create/update plugin)*
I am not able to see the logs in sqlline.log or in the shell.
How will I know the reason for the failure of plugin addition?
Note: I added sqljdbc41.jar in 3rd party
Regards,
Devender
Re: Drill Microsoft SQL plugin
Posted by Brent Payne <br...@cursivelabs.com>.
We had a similar issue with a heroku postgresql db. It turned out that it
was because ssl mode is enforced (which is a good thing). There didn't
seem to be an option for setting this via the storage params, but we found
a workaround by modifying our url parameter as follows:
"url": "jdbc:postgresql://
ec2-something.amazonaws.com:1234/dbname?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
",
ᐧ
On Thu, Jan 28, 2016 at 6:02 AM, Devender Yadav <de...@gmail.com> wrote:
> I verified connection with squirrel client. I want to check logs for the
> error. This error cause must have logged somewhere but i am not able to
> find the logs.
> On 28-Jan-2016 7:20 PM, "Boris Chmiel" <bo...@yahoo.com.invalid>
> wrote:
>
> > Hello
> > If you cannot create the plugin that means that the connexion is not
> > working. The jdbc / mssql link is working for me :- I create a SQL user
> > named drill2 within the Database- I check the jdbc connection with
> > SQuirrel - here is my plugin parameters :
> > { "type": "jdbc", "driver":
> > "com.microsoft.sqlserver.jdbc.SQLServerDriver", "url":
> > "jdbc:sqlserver://localhost:1433;databaseName=TEST", "username":
> > "drill2", "password": "*****", "enabled": false}
> >
> > regsBoris
> >
> > Le Jeudi 28 janvier 2016 12h20, Devender Yadav <de...@gmail.com> a
> > écrit :
> >
> >
> > Hi,
> >
> >
> > I am using drill 1.4 in embedded mode. I am trying to add MS SQL server
> > plugin in drill. I am referring:
> >
> >
> https://drill.apache.org/docs/rdbms-storage-plugin/#example-sql-server-configuration
> >
> >
> > I got error:
> >
> > *error(unable to create/update plugin)*
> >
> > I am not able to see the logs in sqlline.log or in the shell.
> > How will I know the reason for the failure of plugin addition?
> >
> > Note: I added sqljdbc41.jar in 3rd party
> >
> >
> > Regards,
> > Devender
> >
> >
> >
>
Re: Drill Microsoft SQL plugin
Posted by Devender Yadav <de...@gmail.com>.
I verified connection with squirrel client. I want to check logs for the
error. This error cause must have logged somewhere but i am not able to
find the logs.
On 28-Jan-2016 7:20 PM, "Boris Chmiel" <bo...@yahoo.com.invalid>
wrote:
> Hello
> If you cannot create the plugin that means that the connexion is not
> working. The jdbc / mssql link is working for me :- I create a SQL user
> named drill2 within the Database- I check the jdbc connection with
> SQuirrel - here is my plugin parameters :
> { "type": "jdbc", "driver":
> "com.microsoft.sqlserver.jdbc.SQLServerDriver", "url":
> "jdbc:sqlserver://localhost:1433;databaseName=TEST", "username":
> "drill2", "password": "*****", "enabled": false}
>
> regsBoris
>
> Le Jeudi 28 janvier 2016 12h20, Devender Yadav <de...@gmail.com> a
> écrit :
>
>
> Hi,
>
>
> I am using drill 1.4 in embedded mode. I am trying to add MS SQL server
> plugin in drill. I am referring:
>
> https://drill.apache.org/docs/rdbms-storage-plugin/#example-sql-server-configuration
>
>
> I got error:
>
> *error(unable to create/update plugin)*
>
> I am not able to see the logs in sqlline.log or in the shell.
> How will I know the reason for the failure of plugin addition?
>
> Note: I added sqljdbc41.jar in 3rd party
>
>
> Regards,
> Devender
>
>
>
Re: Drill Microsoft SQL plugin
Posted by Boris Chmiel <bo...@yahoo.com.INVALID>.
Hello
If you cannot create the plugin that means that the connexion is not working. The jdbc / mssql link is working for me :- I create a SQL user named drill2 within the Database- I check the jdbc connection with SQuirrel - here is my plugin parameters :
{ "type": "jdbc", "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver", "url": "jdbc:sqlserver://localhost:1433;databaseName=TEST", "username": "drill2", "password": "*****", "enabled": false}
regsBoris
Le Jeudi 28 janvier 2016 12h20, Devender Yadav <de...@gmail.com> a écrit :
Hi,
I am using drill 1.4 in embedded mode. I am trying to add MS SQL server
plugin in drill. I am referring:
https://drill.apache.org/docs/rdbms-storage-plugin/#example-sql-server-configuration
I got error:
*error(unable to create/update plugin)*
I am not able to see the logs in sqlline.log or in the shell.
How will I know the reason for the failure of plugin addition?
Note: I added sqljdbc41.jar in 3rd party
Regards,
Devender