Linux
Backing Up My Books
· โ˜• 3 min read
I have a lot of eBooks on my tablet and phone. I also have a backup on my Linux laptop. In the past I have often just plugged the tablet into the laptop, opened the appropriate MTP folder, selected everything and copied them all to the backup, overwriting the previous backup. There has to be a better way, surely? Step up rsync. The problem is the MTP mount, however, I found a way to make it work.

Useful AIX Unix Commands
· โ˜• 1 min read
proctree The proctree command acts like the Linux pstree and displays the hierarchy of processes from a given starting process id. View Large Files If, when you view a large file you get an errors about it being too big, try the following: echo "set ll=3501720 dir=/tmp" >> ~/.exrc That will allow you to read up toย 3501720 lines in a single text file.

FLAC to MP3 as Easy as Pie!
· โ˜• 2 min read
I have ripped all my music, well most of it, to FLAC for the quality aspect. Sometimes though, I need to convert to MP3 for some of the lesser audio players out there that I might have to use from time to time. I have recently come across a pretty nifty (Linux) way to do this, without having to cope with having duplicate files in FLAC and MP3 formats on my hard drives.

Using FUSE to Mount an SSH Folder Locally
· โ˜• 2 min read
I have recently come across a pretty nifty Linux utility that allows me to mount a remote filesystem on an SSH server, locally and without requiring root privileges to do so. The remote filesystem happens to be where my backups are located, so that’s going to be useful for making and restoring backups! The utility I’ve discovered is called sshfs and is a FUSE file system whereby a normal, non-root user, can mount the remote folder and see the contents as if they were actually in a local folder.

How to Start an Oracle Database When You Are Not in the DBA Group
· โ˜• 2 min read
This applies to Linux, Unix as well as Windows, but affected me on a Windows 2012 Server running Oracle 11.2.0.4 Enterprise Edition. My user on the server was an administration user, but not in the ora_dba group. This is required to connect / as sysdba within SQL*Plus. The SYS password had been changed recently but whoever did it, did not update the password vault. The users were urgently requiring their database be started, I was the only DBA in the office, the SYS password was unknown, and my user didn’t belong directly to the ora_dba group.

Printing, Completing & Scanning PDF Documents
· โ˜• 4 min read
As a contractor I often have to fill in and sign various contract agreements. These are usually tens of pages in length, and while I only have to sign one page, I still must scan in and send back each and every page, even the untouched ones. It would help if a PDF with form filling abilities was supplied, but hey, that’s only rarely the case. This is how I do it.

Turn Off Task Bar Thumbnail Previews on Linux Mint Cinnamon 17.3 through 20.1
· โ˜• 2 min read
I hate it when I click on a task bar icon to open up a snoozing application, and a couple of seconds later, there’s a preview of the application showing at the bottom of the screen. I don’t need it as the icon tells me what it is, thanks! Getting rid is easy:ย Updated 25th February 2021 after Mint 20 upgrade. Cinnamon 20.x Right-click the task bar on a blank space.

Raspberry Pi, PiZero, Raspbian Jessie, Networking and WiFi Setup
· โ˜• 8 min read
With a title like that, I should get some hits! ;-) Note: Updated 6th October 2018 to cover Raspbian Stretch which is slightly different to Jessie. But not much. Note: Updated 8th February 2016 to cover the new Raspberry Pi 3 with built in WiFi and Bluetooth. Note: Checked 20th October 2017 to make sure that the instructions below still apply, and work, on the new stretch release of Raspbian. They do!

Getting Arduino Working from a Windows 7 VirtualBox Guest
· โ˜• 6 min read
Do I like problems or what? :-) I’m running Linux Mint 17.2 as my host, and I have a VirtualBox 5.0 VM running Windows 7 Professional. I decided I’d like to be able to run the Arduino software from within the VM, but not talking to an Arduino, but to a bare bones setup and programming AtTiny85 devices. The following might be of use to other people’s needs as it explains how the FDTI device cane be automatically assigned to the VM rather than to the host, when plugged in and the VM is running.

HPLIP Stops Working After Linux Mint 17.2 Upgrade
· โ˜• 1 min read
I was able to use HPLIP with Mint 17.1 but when I upgraded to 17.2, I had the problem where attempting to run the utility caused nothing at all to happen. The solution: 1 sudo apt-get install hplip-gui Works perfectly for me now.

Shell Variable Indirection in a Database Build Script
· โ˜• 5 min read
Ever wanted to set a variable to the name of another variable, and from there, somehow get the value of the other variable? I did, recently, and this is what I had to do. I work with numerous databases but of all the ones I have, there are only 18 different types and these cover all possible (at present) systems in production or development. The first 3 characters of $ORACLE_SID define the system name and we use a script that duplicates any of 18 template databases to create the desired new one.

A Couple of Useful Linux & HP-UX Tricks
· โ˜• 2 min read
Recently at work, I was on an HP server and needed to grep -B3 a large log file to find the three lines prior to a number of Oracle error messages I was searching for, in order to fix things. It turned out that HP-UX doesn’t have the -B (or the -A) options. Bummer. A bit of awk fixed the former, but the latter I leave as an exercise for the reader as they say!