question Re: Nothing happens when I run squirrel-sql.sh from Sandbox in Archives of Support Questions (Read Only)

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

mrizvi — Fri, 08 Jul 2016 11:06:25 GMT

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.

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

TimothySpann — Fri, 08 Jul 2016 11:42:14 GMT

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

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

mrizvi — Fri, 08 Jul 2016 12:38:25 GMT

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

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

mrizvi — Sat, 09 Jul 2016 17:38:57 GMT

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