Support Questions

Find answers, ask questions, and share your expertise

Nothing happens when I run squirrel-sql.sh from Sandbox

avatar
Super Collaborator

I have downloaded and installed Squirrel from here. I copied phoenix client jar to the lib directory of Squirrel and it is being installed successfully but I am not able to figure out how to start it. I ran squirrel-sql.sh from the HDP sandbox terminal but nothing happens after that. Please help.

1 ACCEPTED SOLUTION

avatar
Master Guru

It is easier to run Squirrel from your PC or Mac and point it at the Sandbox Phoenix server (make sure ports are open).

If you installed the Linux version on the sandbox, you will need to be in the VM graphical UI to see Squirrel Sql run as it is a GUI program and not a Web UI.

Can you tell me how you ran it?

I downloaded it via wget.

Then

[root@sandbox demo]# java -jar squirrel-sql-3.7.1-standard.jar
Welcome to the installation of SQuirreL SQL Client 3.7.1!
 - Gerd Wagner <gerdwagner@users.sourceforge.net>
 - Rob Manning <manningr@users.sourceforge.net>
 - Colin Bell <colbell@users.sourceforge.net>
The homepage is at: http://www.squirrelsql.org
press 1 to continue, 2 to quit, 3 to redisplay
... (pick a lot of options)

[ Unpacking finished ]
Install was successful
application installed on /opt/demo/squirrelsql
[ Console installation done ]

After that you run with /opt/demo/squirrelsql/

./squirrel-sql.sh

Unfortunately if you do not have a graphical UI in your Sandbox (HDP 2.5 is just command-line and web UI) you will not be able to run Squirrel SQL from there. Install it on your Host machine and run from there.

The VirtualBox image does not have a graphical UI (no XWindows by default).

View solution in original post

3 REPLIES 3

avatar
Master Guru

It is easier to run Squirrel from your PC or Mac and point it at the Sandbox Phoenix server (make sure ports are open).

If you installed the Linux version on the sandbox, you will need to be in the VM graphical UI to see Squirrel Sql run as it is a GUI program and not a Web UI.

Can you tell me how you ran it?

I downloaded it via wget.

Then

[root@sandbox demo]# java -jar squirrel-sql-3.7.1-standard.jar
Welcome to the installation of SQuirreL SQL Client 3.7.1!
 - Gerd Wagner <gerdwagner@users.sourceforge.net>
 - Rob Manning <manningr@users.sourceforge.net>
 - Colin Bell <colbell@users.sourceforge.net>
The homepage is at: http://www.squirrelsql.org
press 1 to continue, 2 to quit, 3 to redisplay
... (pick a lot of options)

[ Unpacking finished ]
Install was successful
application installed on /opt/demo/squirrelsql
[ Console installation done ]

After that you run with /opt/demo/squirrelsql/

./squirrel-sql.sh

Unfortunately if you do not have a graphical UI in your Sandbox (HDP 2.5 is just command-line and web UI) you will not be able to run Squirrel SQL from there. Install it on your Host machine and run from there.

The VirtualBox image does not have a graphical UI (no XWindows by default).

avatar
Super Collaborator

Thank a lot for the quick reply and a great explanation. Yes, you are right. I was running through HDP 2.5 command line. Now I installed Squirrel on my local MAC but it is little confusing now, how do I point it to Phoenix server at my Sandbox?

squirrelhomepage.png

avatar
Super Collaborator

I have successfully integrated Phoenix with Squirrel and also published an article on how to setup. Please have a look here