Docker – Handy Tip for Frequent Command

containers-smallOne command I use a lot when working with Docker, is docker ps -a to see what containers I have and which ones are active. To save a little time when entering that command, create an alias in your BASH profile for that command.

  1. From a command prompt, change to your home folder: cd ~
  2. Edit the .profile file with a text editor. In my case, I use NANO: nano ./.profile
  3. Add this line to the end of the file:  alias dpa=”docker ps -a”
  4. Save the file with CTRL-O and exit back to a command prompt with CTRL-X.
  5. Logout and log back in.
  6. At a command prompt enter: dpa. You’ll see the results of docker ps -a but without all the typing!

Configure your Ubuntu Docker installation for remote access

containerThe default installation for Docker on Ubuntu server (16.04) configures the daemon (service) to listen on a local socket. But what if you want to access your Docker daemon remotely, from another box, If you are using the default configuration, you would need to open a Secure Shell to the server, and access Docker that way. But there is a way to setup Docker to allow remote access.

First, lets verify that Docker is only working with a local socket.  On the server,  run from this command line:

ls -l /run

The results show have an entry with the docker.sock entry like this:

dockersocket

And you can check that the daemon is not listening on any ports on your system by running this command:

sudo netstat -tlp

No Docker application should be listed in the results.

NoDocker_port

Continue reading

Photo Break – Myrtle Beach at Night

MYRTLE-4984A brief photo break today to celebrate my website hitting 100,000 page views!

Got back late yesterday from a few days’ vacation down in Myrtle Beach, South Carolina. My last evening there, I took a walk along the sand south of Apache Pier after a kind of drizzy overcast day. I snapped this picture handheld (forgot my tripod on this trip) and I liked how it turned out.

Install the Saiku Analytics plugin in Pentaho BIServer CE

meterorite

I’ve been working with Mondrian and Pentaho’s Schema Workbench lately and attempted to add Meteorite Consulting’s Saiku Analytic plugin to my installation of Pentaho BI Server community edition, to process some MDX queries. MDX is a query language similar to SQL that is used for processing database cubes. Mondrian is a OLAP engine that implements the MDX language and is incorporated into the Saiku Analytic software. It differs from other OLAP engines in that the cubes are built on the fly as the query processes, rather than having the cube data stored on a server. For simpler cubes, the trade off between a slightly slower build time and disk space is negligible.

Here is the process I followed to get Saiku enabled in my BI Server:

Continue reading