Author Archives: George Valentin Voina

DB2 : Claim back space from dropped tables

By | February 8, 2017

Especially when creating a demo image of an enterprise system we want to have a smaller footprint than the full system that was cloned. The same is true when the image is used for volume benchmarks. Between different benchmark sessions we want to clean the old test data and maybe in the end we want… Read More »

Server Rack: Create your own low-cost rack console

By | March 1, 2017

Because the number of my systems increased moving all my stuff to a rack was the right decision to avoid cable spaghetti and administration hell. But when you have a rack you need to have an administration console for it. Looking on the market (the deals market) the cheapest console I could find was some… Read More »

Change HP ILO settings without server restart

By | May 26, 2017

I was relocating my servers in a new rack and configuration and decided to put all my ILO ports to a different router with no DHCP. Obviously I ended up with some fake IP6 address defaulted to the ILO device. To make the changes to ILO without a server reboot we have the nice hponcfg… Read More »

EdgeRouter: Routing through OpenVPN and IPSEC with OSPF

By | May 9, 2016

Open Shortest Path First (OSPF) is a routing protocol for Internet Protocol (IP) networks. Because I have site-to-site OpenVPN and IPSEC tunnels between my primary and remote sites I ended up defining lots of static routes. The environment started to be complex enough to justify the use of OSPF that is supported by EdgeRouter. The… Read More »

EdgeRouter: IPSEC site-to-site with Virtual Tunnel Interface

By | February 27, 2019

The following are the steps I used to perform to set up an IPSEC VPN with a vti (virtual tunnel interface). The advantage is that using a vti gives us a route-able interface so making it easy to work with the IPSEC tunnel. The current setup looks like: Primary Site: ER-8 (with load-balancing WAN1 and… Read More »

EdgeRouter: Policy Based Routing for OpenVPN when Load Balancing dual WANs

By | May 26, 2017

Trying to fix my OpenVPN site-to-site link and due to the environment update I had to do some changes. The initial setup of the OpenVPN is here https://blog.voina.uk/edgerouter-dual-wan-hair-pin-multiple-networks-openvpn-site-to-site-vpn/ First of all there is a new EdgeRouter ER-8 that is directly linked to the main ISP I got this from Amazon.de see Ubiquiti ER-8 Netzwerk/Router .… Read More »

SafeNet(Gemalto) Licence and software client

By | May 4, 2016

Very important information about the SafeNet software and licences. I get all the time very puzzled clients that find it difficult to understand how to see the license validity and how to install the e-token support. In order to obtain the software and to be able to monitor your licences you need an account with… Read More »

Secure authentication using SafeNet(Gemalto) security tokens and Windows CA

By | May 4, 2016

In the following I will try to show how to generate user certificates on e-tokens by using the Windows CA. This tokens can be used after that for secure user authentication or signing. Prerequisites: – Install the Windows CA service. This comes a standard feature in Windows Server 2012. – Internet Explorer 9 and up… Read More »

DB2 (Reason code = “18”.. SQLCODE=-30090, SQLSTATE=25000)

By | February 8, 2017

In a setup having an enterprise application depending on a database instance where some tables are defined as nicknames to tables from a federated database, it can happen to get this very cryptic DB2 error. I already had a post related to this case when the setup uses access to a federated database https://blog.voina.uk/db2-sql-error-30090-caused-by-read-only-table-nickname-to-a-federated-database/. You… Read More »

Clone DB2 10g FC23 install to a virtual machine (FC23 or RHEL7)

By | February 8, 2017

I wanted to move my test db2 installation based on a Fedora Core 23 to a RHEL7 virtual machine without having to reinstall everything and not lose any data. This is in fact cloning my test environment database. This is not an easy task as is not officially supported by IBM but the beauty of… Read More »