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 »

Resize a RHEL7 QEMU/KVM image

By | February 8, 2017

At some point my RHEL7 development virtual machine run out of space. Resizing the image is really made easy by RedHat: STEP 1: Resize the virtual machine disk [root@localhost VMs]# qemu-img resize RHEL7-clone.qcow2 50G Image resized. [root@localhost VMs]# STEP 2: Start the VM and check the disks from inside the VM Check the virtual disk:… Read More »

Deploy Windows cluster on two sites with only one domain controller.

By | April 14, 2016

The requirement that an enterprise system has high availability on site and across sites is very often encountered in the world of financial systems. To achieve this requirement the obvious solution is to have a cluster on the primary site (PR) and another cluster on the disaster recovery site (DR). On the PR we created… Read More »

EdgeRouter: Dual WAN + Hair Pin+ Multiple networks + OpenVPN site-to-site VPN

By | April 1, 2016

My setup becomes more and more complicated bellow there are the updated steps of my configurations with references to the original posts containing the partial configurations. STEP 1 EdgeRouter : Dual WAN with Hair Pin Initially I started with a dual-wan configuration with some extra setting to exclude from load balancing the hair pin connections:… Read More »

EdgeRouter: Dynamic DNS with afraid.org

By | July 11, 2016

I wanted to use for my site-to-site VPN connection some aliases in the configuration files. The simple solution was to configure some dynamic DNS aliases with afraid.org After creating an account and defining a site name like site1.mooo.com do the following from CLI configure set service dns dynamic interface eth0 service afraid host-name site1.mooo.com set… Read More »

EdgeRouter: OpenVPN site-to-site performance

By | March 30, 2016

As a result of setting up my site-to-site VPN see this it is much easier to transfer things from one site to the other. The questions that came to mind were: What is the bandwidth of my VPN ? What is the limiting factor ? My ISPs or the Edge Router ? To answer to… Read More »

EdgeRouter: OpenVPN site-to-site VPN

By | May 28, 2017

I have two sites hosting my home servers so I wanted a solution to have a permanent link between the sites. On site one I have an EdgeRouter POE and on the other site an EdgeRouter Lite and the obvious solution is to have a site to site VPN on a permanent basis. There is… Read More »

DB2: Find a foreign key

By | February 8, 2017

Sometimes working with Hibernate you get the following error in case a persist is executed on an object with dependencies. com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: Error for batch element #1: The insert or update value of the FOREIGN KEY “INST1.MESSAGE.FK_1FUTL48XT47HPPGH0YXQM1MIJ” is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=4.13.127 From IBM… Read More »