Zoho UploadTool connect Heroku database issue
Hi.
I have an issue with connection to Heroku PostgreSQL database from UploadTool.
I'm getting an error: no pg_hba.conf entry for host ...
Looks like an additional parameter should be passed in with connection string sslmode=require as stated in Heroku docs. But I cannot find how can I set this configuration in ZohoUpload Tool.
Does any one know how to deal with it?
https://devcenter.heroku.com/articles/connecting-to-relational-databases-on-heroku-with-java#connecting-to-a-database-remotely
I have an issue with connection to Heroku PostgreSQL database from UploadTool.
I'm getting an error: no pg_hba.conf entry for host ...
Looks like an additional parameter should be passed in with connection string sslmode=require as stated in Heroku docs. But I cannot find how can I set this configuration in ZohoUpload Tool.
Does any one know how to deal with it?
https://devcenter.heroku.com/articles/connecting-to-relational-databases-on-heroku-with-java#connecting-to-a-database-remotely
https://devcenter.heroku.com/articles/heroku-postgresql#external-connections-ingress
- Error occurred in establishing the connection to your local database.
2017/10/12 10:13:51 CEST:
If you require assistance to resolve the problem, please send a mail to 'support@zohoreports.com' by attaching the files 'conf/database_connection_params.conf', and the logs folder as zip.
2017/10/12 10:13:51 CEST:
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "xx.xx.xx.xx", user "xxxxxxxxxxxxx", database "xxxxxxxxxxxxx", SSL off
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:275)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:94)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:382)
at org.postgresql.Driver.connect(Driver.java:260)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.adventnet.zoho.client.report.advancedtool.AdvancedUploader.startUpload(AdvancedUploader.java:441)
at com.adventnet.zoho.client.report.advancedtool.ZohoReportUploadDataFromDB.main(ZohoReportUploadDataFromDB.java:49)