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 <dev....@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" <boris.chm...@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 <dev....@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
> >
> >
> >
>
