MySQL master-master replication on Windows

This post serves as a how to on how to set up MySQL master-master replication. Since I’m doing it on Windows, I wanted to make it as easy as possible, so I will be using a free SQL client, namely SQLyog community edition, that can be downloaded from here. For the MySQL itself the official community edition installer …

Protecting a web directory in Virtualmin

Virtualmin makes it easy to protect websites (or just parts of it) with an email / password combination. The nice thing about it is that you have granular control over which user has access to what. The user doesn’t have to remember a new password, it will simply be his/her old email password. Let’s see how it works! Go to …

Installing older printers on Windows 10

So I had a problem at work: a client had a pretty old printer and after a Windows 10 update they couldn’t install its driver. Let’s see how we can resolve the issue. The printer in question was a Sharp AR5316E and the error message was the following: “Windows can’t install the kernel-mode print driver. To obtain …

Site to site OpenVPN: pfSense <-> Mikrotik

In this tutorial we will look at how to set up a site to site VPN between a pfSense server and a Mikrotik client using OpenVPN the proper way. We’ll be taking advantage of pfSenses superb certificate management features to do SSL/TLS instead of just a pre-shared key. Our client will be a Routerboard RB2011 detailed in …

Mikrotik RB2011 introduction & initial configuration

Let’s talk about Mikrotik’s RB2011 routers for a second. They are pretty nifty, even though on the hardware side they are a bit lacking the software makes more than up for it. There are a lot of different sub-models, this one, RB2011UiAS-2HnD-IN is the beefiest, featuring an SFP cage, b/g/n Wireless, a micro-USB port and an LCD screen. …

Installing pfSense 2.1.x server

pfSense is in my opinion THE best firewall solution. Besides the usual stuff that all routers can do: Load Balancing (both Inbound an Outbound), can be set up to support hardware failover, has pretty decent OpenVPN integration (but also supports IPsec and PPTP) and best of all? It’s free! We will soon dive into the …

Add new HDD to existing CentOS 6.x LVM

Check if you can find the for newly added HDD: or use: If you cannot find your device force a rescan with: Now you should see a new device, with: or: Let’s presume its sdc, meaning it’s the 3th scsi/sata/sas drive added to this system. Create a new partition using fdisk: while in fdisk use …

Creating a HA cluster using two Centos 6.x servers

Important info in regards to CentOS 6.5 Due to consequence of multilib support and PATH handling heartbeat’s init scripts wont work on Centos 6.5. The easiest way to fix it is to install heartbeat 3.0.4-2 that is not currently in the epel repo, but can be downloaded from here: http://koji.fedoraproject.org/koji/taskinfo?taskID=6241294 Note: you will need both heartbeat-3.0.4-2.el6.x86_64.rpm and heartbeat-libs-3.0.4-2.el6.x86_64.rpm packages. …

dealing with VirtualHosts in XAMPP

If the URL schema of http://localhost/foldername isn’t working for you, or you just want to test the webpages behavior with the live address, you need to configure so called VirtualHosts in Apache. Usually that is done by editing httpd.conf but XAMPP has a different (and much easier) approach to this. Let’s take a look! First …