Created 07-08-2016 04:06 AM
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.
Created 07-08-2016 04:42 AM
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).
Created 07-08-2016 04:42 AM
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).
Created 07-08-2016 05:38 AM
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?
Created 07-09-2016 10:38 AM
I have successfully integrated Phoenix with Squirrel and also published an article on how to setup. Please have a look here