VirtualBox – configuring a Host-Only Network

I’m currently indulging in the pastime that’s sweeping the country – trying not to think about Brexit.
It’s a craze that’s even spread as far our political elite. In their case, it manifests itself in slightly different ways.
On the one hand, there are those who are refusing to accept any solution offered to maintain a “soft” border on the island of Ireland. As far as I can tell, they haven’t managed to offer any practical solution that they would accept as that would involve thinking about Brexit.
On the other hand there are those who are pushing for a new referendum because, apparently, some politicians lied when campaigning. Maybe someone was “Putin” ’em up to it ?

For my part, as I don’t quite have the space for a bunker at the bottom of my garden, I’ve decided to hide out in to a world of make-believe…well Virtual Machines at any rate.

I want to setup a CentOS Virtual Machine (VM) that I can then use as to clone environments to host various software stacks that I may want to play with.
I’d like to be able to connect to these VMs directly from my host OS, just like a real-world server. However, I’d also like to be able to connect the VM to the outside world occasionally so I can run package updates via yum.
The specific steps I’m going to go through are :

• Install CentOS7 into a Virtualbox VM
• Setup Host Only Network in VirtualBox
• Create a Network Interface on the Guest to use the Host Only Network
• Assign a static IP address to the Guest

The software I’m using for this is :

• Ubuntu 16.04 LTS (the Host)
• VirtualBox 5.1.38 – available to download here
• CentOS7 (the Guest) – which you can download from here

Before we get cracking, it’s probably a good idea to have a quick look at…

Advertisements

New Dog, Old Tricks – how to save yourself some typing with sed

We have a new addition to our household –

Teddy

Cute and fluffy he may be, but he’s got to earn his keep. He can start making himself useful by helping me with this post.

It begins one Friday afternoon when an urgent request lands on my desk with a large splat.

The requirement is that some csv files be uploaded into the Oracle 11g Datbasae serving the UAT environment to facilitate some testing.
There are around 20 files, each with a slightly different set of attributes.
The files are currently sitting on the on the Red Hat Linux Server hosting the database.
I have sufficient OS permissions on the server to move them to a directory that has a corresponding database object in the UAT instance.
Nevertheless, the thought of having to knock out 20-odd external tables to read these files might leave me feeling a bit like this…

Fortunately, a certain Lee E. McMahon had the foresight to predict the potential risk to my weekend and wrote the Stream Editor (sed) program…

Cocktails and Traffic Cones – party time with DVDs and Blu-Rays in Ubuntu

This title may evoke images of a rumbustious night out filled with exotic drinks and highjinks followed by a morning waking up in possession of a traffic cone, the acquisition of which has somehow escaped the wreckage of your short-term memory.
If this is the case, you may be a tiny bit disappointed. This is all about how to play and rip DVDs and Blu-rays on Ubuntu.
Whilst that may not sound like quite as much fun, it’s less to leave you with a raging hangover. It should however, enable you to enjoy your video on your OS of choice.
What cocktails and traffic cones have to do with all of this will become apparent shortly.

What I’m going to cover here is :

• How to Decode and Play DVDs using VLC
• How to Convert DVD and Blu-ray files to mp4 video using Handbrake
• How to Transcode DVD and Blu-ray discs to Matroska (mkv) format using MakeMKV

This should give you all of the steps required to watch and – if required – copy movies, tv shows etc from an optical disc.

First of all though…

The Legal Disclaimer
The legality of ripping copyrighted material differs across jurisdictions. You may want to check the situation where you are before you follow any of the steps detailed in this article.

Whilst we’re on the subject of disclaimers…

The Taste Disclaimer
The subject matter at hand means that there is a strong temptation to include quotes and (possibly) oblique references to movies here and there. Of course I wouldn’t dream of stooping so low just to get cheap laughs…much.

Oh, one more thing…

Efficacy disclaimer – The steps described here will work most discs. In the rare instances where this is not the case do not seem to follow and discernible pattern.
For example, the same steps to persuade a dark comedy to present you with a Marmalade Sandwich (in mp4 format), may cause a loveable cartoon bear to fix you with a stare that’s harder than a coffin nail.

Moving swiftly on…

Read Only Access for providing backend support for an Oracle Application

The World Cup is finally over and “It’s Coming Home !”
For quite a long time, we English laboured under the illusion that “it” was football.
Fortunately for Scots everywhere, “It” turned out to be the World Cup which, like so many international sporting competitions, was conceived in France.

Another area that is often subject to flawed assumptions is what privileges are required to provide read-only access for someone to provide support to an Oracle Application.
So, for any passing auditors who may be wondering why “read only” access to an Oracle application sometimes means Write, or even Execute on certain objects…

You have chosen not to trust… – Citrix Receiver and SSL error 61 on Ubuntu

After months of trouble-free operation, Citrix Receiver decided to wreak some havoc one morning last week.
Connecting to work (using Firefox on Ubuntu and Citrix Receiver for Linux 13.8) was trouble free as usual.
However, when I then tried to select a PC to remote into, Citrix informed me that …

“You have chosen not to trust Entrust Root Certification Authority – G2. SSL error 61”

At that point, I reflected that what I knew about Citrix and SSL certificates would fit on the back of a fag packet.
After some intensive “research” it should now fit into a short blog post…

First Steps in SQLDeveloper Data Modeler

It’s true, Oracle are giving away free stuff. “Oracle ?”, I hear you say, “as in Larry’s Database Emporium and Cloud base ?” The very same.
It’s been going on for quite a while and includes relatively hidden gems such as SQLDeveloper Data Modeler.

There is some confusion around this particular tool for a couple of reasons.
When it was first released (sometime around 2009 as I recall), Data Modeler was an additional cost option. However, that didn’t last long.
At present (and for a number of years now), it is available either as a completely standalone tool, or as a fully integrated component of the SQLDeveloper IDE.
Either way, it costs exactly the same as the SQLDeveloper IDE – i.e. nothing.

I can tell you like the price, want to take it for a spin ?

I’m going to focus here on using the integrated version of Data Modeler. This is because

• I want to use it for small-scale modelling of the type you might expect to find when using an Agile Methodology
• I’m a developer and don’t want to leave the comfort of my IDE if I don’t need to

What I’m going to cover is :

• Viewing a Table Relationship Diagram (TRD) for an existing database table
• Creating a Logical Data Model and Entity Relationship Diagram (ERD)
• Generating a physical model from a logical model
• Generating DDL from a Physical Model (including some scripting tweaks to suit your needs)
• Using a Reporting Schema and pre-canned SQLDeveloper Reports to explore your models

Disclaimer
This post is about introducing the features of Data Modeler in the hope that you may find them useful.
It’s not intended as a paragon of data modelling virtue.
Come to that, it’s not intended as a definitive guide on how to use this tool. I’m no expert with Data Modeler (as you are about to find out). Fortunately, there are people out there who are.
If, after reading this, you want to explore further, then you could do worse than checking out words of Data Modeler wisdom from :

• Heli Helskyaho
• Jeff Smith

Let’s get started…

utPLSQL 3.0 – How to have your cake and eat it

“You can’t have your cake and eat it !” This seems to be a regular refrain from the EU in the ongoing Brexit negotiations.
They also seem to be a bit intolerant of “cherry picking”.
I’ve never really understood the saying, “You can’t have your cake and eat it”.
What’s the point in having the cake unless you are going to eat it ?
Fortunately, I’m not alone in my perplexity – just ask any Brexiteer member of the British Cabinet.
For those who want to make sense of it ( the saying, not Brexit), there is a handy Wikepedia page that explains all.

When it comes to Unit Testing frameworks for PL/SQL, compromise between cake ownership and consumption is usually required.
Both utPLSQL 2.0 and ruby-plsql-spec have their good points, as well as some shortcomings.
Of course, if you want a more declarative approach to writing Unit Tests, you can always use TOAD or SQLDeveloper’s built-in tools.

Recently, a new player has arrived on the PL/SQL testing scene.
Despite it’s name, utPLSQL 3.0 appears to be less an evolution of utPLSQL 2.0 as a new framework all of it’s own.
What I’m going to do here, is put utPLSQL 3.0 through it’s paces and see how it measures up to the other solutions I’ve looked at previously.
Be warned, there may be crumbs…