squirrel-sql-users — A subscriber only discussion list for SQuirreL

Re: [Squirrel-sql-users] remote db2 connection over ssh tunnel

[John H. <jh...@im...>]

On Mon, 29 Aug 2016, Shilpa Kotiyan wrote:

> I am using the CLI commands through putty. Just to verify that my ssh
> commands are working. However, I want to use squirrel to connect to the DB
> and I am using the drivers provided by IBM (db2jcc) . using the format
> "jdbc:db2://localhost:port/dbname"  in the Squirrel alias as I have the
> port 50000 on my local host tunneled to db2 server host.

Does the AUTH database exist? Does it support transactions?

WAG by a non-DB2 user: I expect the JDBC driver may be doing OOB 
authentication via a different port. You might need to sniff network 
traffic (or read docs) to see if you need to redirect another port to the 
DB server as well.

>> ------------------------------
>> *From:* Shilpa Kotiyan <sko...@zt...>
>> *To:* squ...@li...
>> *Sent:* Friday, August 26, 2016 8:21 AM
>> *Subject:* [Squirrel-sql-users] remote db2 connection over ssh tunnel
>>
>> Hi,
>> I am using squirrel 3.7  to connect to a db2 database on linux. I am
>> tunneled to the DB server over ssh using putty. I confirmed that the tunnel
>> is working as I can execute sql over the command line. However, when I
>> attempt to connect via squirrel;, I get the error below:
>>
>> Connection via DB2 universal driver. using the format
>> "jdbc:db2://localhost:port/dbname"
>>
>> Java.util.concurrent.ExecutionException: java.lang.RuntimeException:
>> com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException:
>> [jcc][t4][2057][11264][4.17.29] The application server rejected
>> establishment of the connection.
>> An attempt was made to access a database, AUTH, which was either not found
>> or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   Windows Genuine Advantage (WGA) means that now you use your
   computer at the sufferance of Microsoft Corporation. They can
   kill it remotely without your consent at any time for any reason;
   it also shuts down in sympathy when the servers at Microsoft crash.
-----------------------------------------------------------------------
  251 days since the first successful real return to launch site (SpaceX)

Re: [Squirrel-sql-users] remote db2 connection over ssh tunnel

[Matt F. <de...@ya...>]

Could be a firewall issue where port for ssh is open (22) and DB is not (50000)

> On Aug 29, 2016, at 6:35 AM, Shilpa Kotiyan <sko...@zt...> wrote:
> 
> I am using the CLI commands through putty. Just to verify that my ssh commands are working. However, I want to use squirrel to connect to the DB and I am using the drivers provided by IBM (db2jcc) . using the format "jdbc:db2://localhost:port/dbname"  in the Squirrel alias as I have the port 50000 on my local host tunneled to db2 server host. 
> 
> Thanks.
> 
> 
>> On Mon, Aug 29, 2016 at 12:08 AM, Alexandre Peshansky <Ale...@ei...> wrote:
>> You question implies that you are connecting to a DB2 database on a server, but the connection URL you quoted seem to indicate that you directed SQuirreL to connect to localhost. 
>> 
>> Sent from my iPhone
>> 
>> On Aug 29, 2016, at 12:01 AM, Matt F <de...@ya...> wrote:
>> 
>>> What CLI commands are you issuing? 
>>> 
>>> I have always used the IBM drivers over the SQUIRREL included drivers FWIW
>>>  
>>> ==============================================
>>> Matt Ferreira
>>> de...@ya...
>>> 
>>> 
>>> From: Shilpa Kotiyan <sko...@zt...>
>>> To: squ...@li... 
>>> Sent: Friday, August 26, 2016 8:21 AM
>>> Subject: [Squirrel-sql-users] remote db2 connection over ssh tunnel
>>> 
>>> Hi, 
>>> I am using squirrel 3.7  to connect to a db2 database on linux. I am tunneled to the DB server over ssh using putty. I confirmed that the tunnel is working as I can execute sql over the command line. However, when I attempt to connect via squirrel;, I get the error below:
>>> 
>>> Connection via DB2 universal driver. using the format "jdbc:db2://localhost:port/dbname"
>>> 
>>> Java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][4.17.29] The application server rejected establishment of the connection.
>>> An attempt was made to access a database, AUTH, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004
> 
> 
> 
> -- 
> Shilpa Kotiyan / Chief Architect, eCommerce 
> 216.287.7768 / sko...@zt...
> 
> Zilker Technology 
> http://www.ztech.io
> 
> ------------------------------------------------------------------------------
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] remote db2 connection over ssh tunnel

[Shilpa K. <sko...@zt...>]

I am using the CLI commands through putty. Just to verify that my ssh
commands are working. However, I want to use squirrel to connect to the DB
and I am using the drivers provided by IBM (db2jcc) . using the format
"jdbc:db2://localhost:port/dbname"  in the Squirrel alias as I have the
port 50000 on my local host tunneled to db2 server host.

Thanks.


On Mon, Aug 29, 2016 at 12:08 AM, Alexandre Peshansky <
Ale...@ei...> wrote:

> You question implies that you are connecting to a DB2 database on a
> server, but the connection URL you quoted seem to indicate that you
> directed SQuirreL to connect to localhost.
>
> Sent from my iPhone
>
> On Aug 29, 2016, at 12:01 AM, Matt F <de...@ya...> wrote:
>
> What CLI commands are you issuing?
>
> I have always used the IBM drivers over the SQUIRREL included drivers FWIW
>
> ==============================================
> Matt Ferreira
> de...@ya...
>
>
> ------------------------------
> *From:* Shilpa Kotiyan <sko...@zt...>
> *To:* squ...@li...
> *Sent:* Friday, August 26, 2016 8:21 AM
> *Subject:* [Squirrel-sql-users] remote db2 connection over ssh tunnel
>
> Hi,
> I am using squirrel 3.7  to connect to a db2 database on linux. I am
> tunneled to the DB server over ssh using putty. I confirmed that the tunnel
> is working as I can execute sql over the command line. However, when I
> attempt to connect via squirrel;, I get the error below:
>
> Connection via DB2 universal driver. using the format
> "jdbc:db2://localhost:port/dbname"
>
> Java.util.concurrent.ExecutionException: java.lang.RuntimeException:
> com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException:
> [jcc][t4][2057][11264][4.17.29] The application server rejected
> establishment of the connection.
> An attempt was made to access a database, AUTH, which was either not found
> or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004
>
>


-- 

Shilpa Kotiyan / Chief Architect, eCommerce
216.287.7768 / sko...@zt...

Zilker Technology
http://www.ztech.io

Re: [Squirrel-sql-users] remote db2 connection over ssh tunnel

[Alexandre P. <Ale...@ei...>]

You question implies that you are connecting to a DB2 database on a server, but the connection URL you quoted seem to indicate that you directed SQuirreL to connect to localhost.

Sent from my iPhone

On Aug 29, 2016, at 12:01 AM, Matt F <de...@ya...<mailto:de...@ya...>> wrote:

What CLI commands are you issuing?

I have always used the IBM drivers over the SQUIRREL included drivers FWIW

==============================================
Matt Ferreira
de...@ya...<mailto:de...@ya...>


________________________________
From: Shilpa Kotiyan <sko...@zt...<mailto:sko...@zt...>>
To: squ...@li...<mailto:squ...@li...>
Sent: Friday, August 26, 2016 8:21 AM
Subject: [Squirrel-sql-users] remote db2 connection over ssh tunnel

Hi,
I am using squirrel 3.7  to connect to a db2 database on linux. I am tunneled to the DB server over ssh using putty. I confirmed that the tunnel is working as I can execute sql over the command line. However, when I attempt to connect via squirrel;, I get the error below:

Connection via DB2 universal driver. using the format "jdbc:db2://localhost:port/dbname"

Java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][4.17.29] The application server rejected establishment of the connection.
An attempt was made to access a database, AUTH, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004

Re: [Squirrel-sql-users] remote db2 connection over ssh tunnel

[Matt F <de...@ya...>]

What CLI commands are you issuing? 
I have always used the IBM drivers over the SQUIRREL included drivers FWIW ==============================================Matt Ferreira
de...@ya...


      From: Shilpa Kotiyan <sko...@zt...>
 To: squ...@li... 
 Sent: Friday, August 26, 2016 8:21 AM
 Subject: [Squirrel-sql-users] remote db2 connection over ssh tunnel
   
Hi, I am using squirrel 3.7  to connect to a db2 database on linux. I am tunneled to the DB server over ssh using putty. I confirmed that the tunnel is working as I can execute sql over the command line. However, when I attempt to connect via squirrel;, I get the error below:
Connection via DB2 universal driver. using the format "jdbc:db2://localhost:port/dbname"
Java.util.concurrent.ExecutionException: java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2057][11264][4.17.29] The application server rejected establishment of the connection.An attempt was made to access a database, AUTH, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004 at java.util.concurrent.FutureTask.report(FutureTask.java:123) at java.util.concurrent.FutureTask.get(FutureTask.java:207) 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


Thanks,
------------------------------------------------------------------------------

_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


   

[Squirrel-sql-users] remote db2 connection over ssh tunnel

[Shilpa K. <sko...@zt...>]

Hi,
I am using squirrel 3.7  to connect to a db2 database on linux. I am
tunneled to the DB server over ssh using putty. I confirmed that the tunnel
is working as I can execute sql over the command line. However, when I
attempt to connect via squirrel;, I get the error below:

Connection via DB2 universal driver. using the format
"jdbc:db2://localhost:port/dbname"

Java.util.concurrent.ExecutionException: java.lang.RuntimeException:
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException:
[jcc][t4][2057][11264][4.17.29] The application server rejected
establishment of the connection.
An attempt was made to access a database, AUTH, which was either not found
or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004
at java.util.concurrent.FutureTask.report(FutureTask.java:123)
at java.util.concurrent.FutureTask.get(FutureTask.java:207)
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



Thanks,

[Squirrel-sql-users] displaying utf8 chars in the results tab

[Stephen W. <wi...@ha...>]

Been struggling to display utf8 chars in the results tab. I can copy
the seemingly empty cells & paste elsewhere to see the actual chars.
Chars appear fine in the "results as text" tab. Is this by design or
is there a trick to unmask the chars in this view?
--thx, Steve

Re: [Squirrel-sql-users] How to actually remove the 100 rows limit?

[Alexandre P. <Ale...@ei...>]

It is also alias property, so it can be default when you open the alias.

-- 
Alexandre Peshansky, MS
Senior Bioinformatics Analyst, Research Informatics Core (RIC)
Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore
Albert Einstein College of Medicine
1300 Morris Park Ave, Block Bldg., Rm 534 Bronx, NY 10461
(718) 430-2440, (914) 457-6792 (office) (201) 970-3530 (cell) - NEW!!!


-----Original Message-----
From: Roger Hill [mailto:rh...@hi...] 
Sent: Thursday, August 11, 2016 4:24 PM
To: KARR, DAVID
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] How to actually remove the 100 rows limit?

In the SQL window, top right hand corner, there is a box that has the number of rows to retrieve. It should say 100. Change it to whatever you want.

Roger
On Thu, August 11, 2016 21:17, KARR, DAVID wrote:
> I have a query where I need to see more than the first 100 rows 
> returned from the query.  I've googled for this, and I've cleared the 
> checkbox in "New Session Properties", and it's cleared in my current 
> session properties, but when I run a query, it still says "Limited to 100 rows".  What am I missing?
****************************************
Roger Hill
****************************************

Re: [Squirrel-sql-users] How to actually remove the 100 rows limit?

[Roger H. <rh...@hi...>]

In the SQL window, top right hand corner, there is a box that has the number
of rows to retrieve. It should say 100. Change it to whatever you want.

Roger
On Thu, August 11, 2016 21:17, KARR, DAVID wrote:
> I have a query where I need to see more than the first 100 rows returned from
> the query.  I've googled for this, and I've cleared the checkbox in "New
> Session Properties", and it's cleared in my current session properties, but
> when I run a query, it still says "Limited to 100 rows".  What am I missing?
>
> -----------------------------------------------------------------------------
> -
> What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
> patterns at an interface-level. Reveals which users, apps, and protocols are
> consuming the most bandwidth. Provides multi-vendor support for NetFlow,
> J-Flow, sFlow and other flows. Make informed decisions using capacity
> planning reports. http://sdm.link/zohodev2dev
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>


****************************************
Roger Hill
****************************************

[Squirrel-sql-users] How to actually remove the 100 rows limit?

[KARR, D. <dk...@at...>]

I have a query where I need to see more than the first 100 rows returned from the query.  I've googled for this, and I've cleared the checkbox in "New Session Properties", and it's cleared in my current session properties, but when I run a query, it still says "Limited to 100 rows".  What am I missing?

[Squirrel-sql-users] utf8 in results tab

[Stephen W. <wi...@ha...>]

Been struggling to display utf8 chars in the results tab. I can copy
the seemingly empty cells & paste elsewhere to see the actual chars.
Chars appear fine in the "results as text" tab. Is this by design or
is there a trick to unmask the chars in this view?
--thx, Steve

[Squirrel-sql-users] SQuirreL SQL for Greenplum database taking very long time to load objects

[Sathesh S <sat...@ho...>]

Dear All,

I’m trying to use Squirrel SQL for Greenplum database, I have the Greenplum plugin installed and I’m using PostgreSQL JDBC version 9.4.1206. 

When I try to connect to the database the connection is established successfully, but the SQL prompt doesn’t show up for very long time. I assume this is because SQuirreL SQL loads all the objects in all schemas. 

I tried to avoid this in the schema properties and choose not to load any objects from all schemas, but again when I need to check the objects and click on the objects tab it starts to load the objects and takes very long time.

My questions, can you please help here:

1. Will this be a one time work which Squirrel SQL does? Or will it be repeated every time I connect to the database?
2. Is there a way to make this faster, because it is taking very long time.

Thanks,
Sathesh

Re: [Squirrel-sql-users] UNSUBSCRIBE

[John H. <jh...@im...>]

Sorry, we can't help you with that. Take a look at the mailing list URL 
that's added at the bottom of every list posting. You can unsubscribe 
there.

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   Drugs will always be around. Politicians are therefore making an
   active decision to distribute them through violent gangs. --twitter
-----------------------------------------------------------------------
  7 days until the 281st anniversary of John Peter Zenger's acquittal

[Squirrel-sql-users] UNSUBSCRIBE

[Nadendla, P. (HP Connected) <ven...@hp...>]

Re: [Squirrel-sql-users] Error trying to connect to PostgreSQL server

[John H. <jh...@im...>]

On Fri, 29 Jul 2016, pm...@wi... wrote:

> Thanks for the replies.  I did try changing the HOSTNAME to the IP 
> address but that did not help.

Rats.

> Actually I just got it to work.  I kept googling and found this solution:
>
> In the ALIAS I modified the URL value where after the DB name I added:
>
> ?sslmode=require
>
> That allowed me to access the DB on the remote vendor server without 
> issue since I cannot make any modifications to that server.  This did 
> the trick.

Yay!

> Hopefully if someone else runs into this same issue this may help.
>
> Thanks and have a great weekend.

You too.

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   Drugs will always be around. Politicians are therefore making an
   active decision to distribute them through violent gangs. --twitter
-----------------------------------------------------------------------
  7 days until the 281st anniversary of John Peter Zenger's acquittal

Re: [Squirrel-sql-users] Error trying to connect to PostgreSQL server

[<pm...@wi...>]

Hi John, 

Thanks for the replies.  I did try changing the HOSTNAME to the IP address but that did not help.  

Actually I just got it to work.  I kept googling and found this solution:

In the ALIAS I modified the URL value where after the DB name I added:

?sslmode=require

That allowed me to access the DB on the remote vendor server without issue since I cannot make any modifications to that server.  This did the trick.

Hopefully if someone else runs into this same issue this may help.

Thanks and have a great weekend.

  
On Friday, July 29, 2016 3:04 PM, John Hardin <jh...@im...> wrote: 

=============
On Fri, 29 Jul 2016, pm...@wi... wrote: 
 
> I forgot to mention that I'm on Windows 10. 
> 
> The Postgresql box is a VENDOR box and I cannot make any changes there. 
> 
> I got this same error in pgAdmin III but there was another setting under 
> the ADVANCED tab called Host Address where I entered the IP address and 
> then I was able to access the server without issue. 
 
...does it work if you use the IP address (vs. the hostname) in the JDBC 
connect string? 
 
-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/ 
  jh...@im...    FALaholic #11174     pgpk -a jh...@im... 
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79 
----------------------------------------------------------------------- 
   You are in a maze of twisty little protocols, 
   all written by Microsoft. 
---------------------------------------------------------------------- 
  7 days until the 281st anniversary of John Peter Zenger's acquittal 

Re: [Squirrel-sql-users] Error trying to connect to PostgreSQL server

[John H. <jh...@im...>]

On Fri, 29 Jul 2016, pm...@wi... wrote:

> I forgot to mention that I'm on Windows 10.
>
> The Postgresql box is a VENDOR box and I cannot make any changes there.
>
> I got this same error in pgAdmin III but there was another setting under 
> the ADVANCED tab called Host Address where I entered the IP address and 
> then I was able to access the server without issue.

...does it work if you use the IP address (vs. the hostname) in the JDBC 
connect string?

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   You are in a maze of twisty little protocols,
   all written by Microsoft.
----------------------------------------------------------------------
  7 days until the 281st anniversary of John Peter Zenger's acquittal

Re: [Squirrel-sql-users] Error trying to connect to PostgreSQL server

[John H. <jh...@im...>]

On Fri, 29 Jul 2016, pm...@wi... wrote:

> 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.
>
> 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

This doesn't look like an error specific to Squirrel. I'd suggest looking 
for that file (pg_hba.conf) on your system, and doing some googling to see 
how it is supposed to be used.

-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   If guns kill people, then...
     -- pencils miss spel words.
     -- cars make people drive drunk.
     -- spoons make people fat.
-----------------------------------------------------------------------
  7 days until the 281st anniversary of John Peter Zenger's acquittal

Re: [Squirrel-sql-users] Error trying to connect to PostgreSQL server

[<pm...@wi...>]

I forgot to mention that I'm on Windows 10.

The Postgresql box is a VENDOR box and I cannot make any changes there.

I got this same error in pgAdmin III but there was another setting under the ADVANCED tab called Host Address where I entered the IP address and then I was able to access the server without issue.

Thanks.

On Friday, July 29, 2016 2:50 PM, pm...@wi... wrote: 

=============
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.OpenConnectionComman
d.awaitConnection(OpenConnectionCommand.java:132) 
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComman
d.access$100(OpenConnectionCommand.java:45) 
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComman
d$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.OpenConnectionComman
d.executeConnect(OpenConnectionCommand.java:171) 
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComman
d.access$000(OpenConnectionCommand.java:45) 
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComman
d$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(ConnectionF
actoryImpl.java:451) 
    at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Connectio
nFactoryImpl.java:223) 
    at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.ja
va: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(SQLDri
verManager.java:133) 
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComman
d.executeConnect(OpenConnectionCommand.java:167) 
    ... 7 more 
 
 
 
------------------------------------------------------------------------------ 
_______________________________________________ 
Squirrel-sql-users mailing list 
Squ...@li... 
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users 

[Squirrel-sql-users] Error trying to connect to PostgreSQL server

[<pm...@wi...>]

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

 

[Squirrel-sql-users] VARBINARY fields visualization

[Alex M. <ale...@bl...>]

Would the development team consider adding visualization for the fields that may contain images, like SSMS Boost does?

Thank you!
Alex

[Squirrel-sql-users] Squirrel disappears when docking / undocking and unexpectedly quits, windows 10

[Lenny V. <len...@do...>]

Hi Guys

I have an issue with Squirrel while running a query if I undock my Lenovo
t450 laptop with windows 10, squirrel disappears as if it were never
opened. No quit message, no errors, just completely gone. I have tried
uninstalling and reinstalling squirrel but the problem persists. Any idea?

[Squirrel-sql-users] (no subject)

[Lenny V. <len...@do...>]

-- 
*Lenny Vaknine*
Corporate IT / HelpDeskDoubleVerify
575 8th Avenue, New York, NY 10018
718-840-9102 (C)
lenny.vaknine@*doubleverify.com* <len...@do...>

<http://www.doubleverify.com/>
<https://twitter.com/doubleverify>
<https://www.facebook.com/DoubleVerify-129650610434547/>
<https://www.linkedin.com/company/doubleverify-inc>
Join us! *DV is hiring <http://www.doubleverify.com/careers/>*

[Squirrel-sql-users] How can I do a left join with SQurreL in a different schema than public?

[Kristian M. <kri...@gm...>]

Hi!

If I first run the command
SET search_path TO my_schema;
Then i can use the query builder to create my left join query (its pretty
big so the query builder makes it much easier). That work.
But if I copy the query from the query builder to the SQL command window it
fail despite the use of search path??

I need to copy the query from the query builder to the SQL command so I can
modify it, I need to use GROUP BY that the query builder don't seem to
support.

Is there a way I can make the output SQL in the query builder to include
schema names, or is there a way I can use set search path to work when I
run join tables? (I can select rows from individual tables after using
search_path but when i use them in a join query, it fails. Im logged on as
admin user).

Best regards

Re: [Squirrel-sql-users] [Squirrel-sql-develop] Reg Calling Procedures Squirrel

[John H. <jh...@im...>]

On Fri, 8 Jul 2016, Narendra Reddy wrote:

> I have been using DB Squirrel for connecting to Oracle and now that I want
> to create a procedure with a parameter and call that , i have no problem
> with the compilation but getting error while calling the same procedure
> with the parameter. Please help me in using that, or is that not possible
> to call a procedure suing db squirrel.
>
> Thanks & Regards
> Narendra Reddy

Replying on the Users list as that's where this should have been posted. 
Your question is not related to developing Squirrel itself...

What error are you getting?


-- 
  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
   People who are unable to figure out how to make change without the
   help of a cash register are demanding a $15/hr minimum wage?
-----------------------------------------------------------------------
  12 days until the 47th anniversary of Apollo 11 landing on the Moon