Author Archives: George Valentin Voina

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 »

Oracle: Finding and adding indices

By | February 8, 2017

Sometimes things go slow in the database even if the original setup was done with a lot of care. The data traffic the usage of the application can sometimes impose the need of extra indices in addition to the original indices added by the enterprise application client that uses the Oracle database. The following procedure… Read More »

Microsoft SQL Server: Database Replication (Mirroring)

By | October 25, 2017

Microsoft SQL Server Standard Edition has a great feature present in this basic license: Database Replication in Synchronous mode. To activate the database replication of a database from Primary Site (PR) to Disaster Recovery Site (DR) where the database to be replicated is called myDB the following simple steps must be performed: On PR site… Read More »

Microsoft SQL Server: Snapshot isolation

By | February 9, 2017

Snapshot isolation is a guarantee that all reads made in a transaction will see a consistent snapshot of the database. The transaction itself will successfully commit only if no updates it has made, conflicts with any concurrent updates made since that snapshot. By using it, deadlock situations when a read operation (intense resource consuming operation)… Read More »

EdgeRouter POE: Power 48V POE switches

By | May 25, 2016

I got my EdgeRouter POE from UbiQuiti EdgeRouter, 5-port Router POE and came with the 24VAC power supply. Because the Ubiquity devices are all using the strange low power POE for which 24VAC is enough they ship the EdgeRouter POE with the 24VAC power supply. As a result the device is useless in powering “normal”… Read More »

CVS: Add a missing tag by date for a CVS project release

By | February 8, 2017

Sometimes you discover that you forgot to tag on CVS a test release that made it on the production system. The issue starts when you discovered that in the mean time you or someone else already added new functionality on the development branch. In the following I will create a tag only based on the… Read More »