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 <[email protected]> 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" <[email protected]> > 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 <[email protected]> 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 > > > > > > >
