Shell Script to control services on Linux Mint (especially SQL Server)

I’ve posted before about how I don’t run certain services on my Linux system all the time, but rather only when I am working with them. For example, Docker, Pentaho applications, and several database servers like MySQL, MariaDB and now Microsoft SQL Server.  The reasons are simple: because I experiment with a variety of technologies, I don’t want to dedicate resources unnecessarily and there may often be conflicts such as web server interfaces using the same ports. So to alleviate some of those problems I generally disable services and start them when necessary.

To do that I usually create Bash scripts to start and stop the services, and save those in a named location in /opt that is associated with the server application. I would have two scripts, one to start and one to stop, but since I’ve had some time lately I’ve worked up a method to do this in one script. Below is a script I drafted to start and stop Microsoft SQL Server on Linux. I saved this to the /opt folder where the SQL Server components are installed and then created a Launcher shortcut to add it to my menu. Now I just select that option in the menu, and I see the current status of the server, and I can start it or shut it down as need be.

Its heavily commented to provide information, so use it as a source for yourself if you are running on Debian based systems.

Continue reading “Shell Script to control services on Linux Mint (especially SQL Server)”

Access a Raspberry Pi with Remote Desktop Protocol (RDP) and REMMINA

    I am a huge proponent of Open Source software, and when I have the choice between a proprietary application or an open source one with similar features, I’ll generally opt for the open source program unless there is a compelling reason not to. In the case of remotely accessing PCs, I prefer to use RDP software over VNC. While RDP is a proprietary protocol developed by Microsoft, and VNC is open source, I find RDP easier to use for remotely accessing GUI based systems. If I need to access a non-GUI system, I do fall back to SSH though.
   Recently I have been experimenting with Raspberry Pi computers. (I am working to setup a Hadoop cluster, and will hopefully write more about that in the future.) The initial setup of the PI’s includes updating the package lists and installing any newer versions of the included software, setting a static IP and then installing xRDP. After that I use my Linux Mint laptop to make any further changes after I have them headless in the rack using REMMINA , which supports SSH, VNC and RDP.
    Installing xRDP on the PIs is pretty straightforward. Here is how to do that:

Continue reading “Access a Raspberry Pi with Remote Desktop Protocol (RDP) and REMMINA”