[Squirrel-sql-users] Error trying to connect to PostgreSQL server
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: <pm...@wi...> - 2016-07-29 19:50:31
|
I just downloaded the Squirrel client and setup a driver for PostgreSQL using the driver I downloaded from the PostgreSQL website. It was successfully registered for driver definition PostgreSQL. I downloaded pgAdminIII yesterday but it was not a very good client at all. I worked with Squirrel back in 2004 - 2011 with another JDBC driver and it worked great. I was hoping that now that I'm working with PostgreSQL that it would work as well however I'm getting an error when trying to connect. Any help/direction would be greatly appreciated. Thanks. Here is the error: java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "75.141.184.2", user "fwisd_ro", database "fwisd_appdev", SSL off at java.util.concurrent.FutureTask.report(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132) at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45) at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "75.141.184.2", user "fwisd_ro", database "fwisd_appdev", SSL off at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171) at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45) at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104) ... 5 more Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "75.141.184.2", user "fwisd_ro", database "fwisd_appdev", SSL off at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:451) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:223) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:67) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:212) at org.postgresql.Driver.makeConnection(Driver.java:407) at org.postgresql.Driver.connect(Driver.java:275) at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133) at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167) ... 7 more |