SSL certificate installation on the Ubiquiti Unifi controller

As a lot of users, I got tired of the SSL certificate error page every time I visit the controller’s page. Unfortunately, Ubiquiti doesn’t provide an “easy” upload functionality through the web interface. But they do provide some documentation, which seems easy and quick enough. Or so I thought. Ubiquiti documentation You can find the … Continue reading SSL certificate installation on the Ubiquiti Unifi controller

Setup Let’s Encrypt to Secure Your Website

If you don’t know what Let’s Encrypt is, let me briefly explain. Let’s Encrypt is a free, automated and open Certificate Authority (CA) that provides an easy way to obtain and install free TLS/SSL certificates. As mentioned on their website, the key principles behind Let’s Encrypt are: Free: Anyone who owns a domain name can … Continue reading Setup Let’s Encrypt to Secure Your Website

Testing Ansible Roles on Multiple Operating Systems with Docker and Semaphore

NOTE: This article was initialy written for the SemaphoreCi community page. Introduction In a previous article, we wrote about testing Ansible roles directly against Semaphore. This is great when you are targeting the same operating system as your continuous integration server, but what to do if you you need to target other operating systems as … Continue reading Testing Ansible Roles on Multiple Operating Systems with Docker and Semaphore

Testing Ansible Roles with Travis CI

Ansible is a great config management tool. Unfortunately I lacked the time of writing a bit more about minding, except of my 2 previous posts (Getting started with configuration management: Ansible and Configuration management with Ansible: Playbooks & Execution ) Not that I haven’t done anything new on that front. I’m currently using / maintaining some … Continue reading Testing Ansible Roles with Travis CI

Taking MySQL dumps with a twist

Taking mysql dumps is pretty straightforward, but what if you needed to take a dump excluding certain tables? For this, you have two options: 1. use the –ignore-table option: mysqldump -u username -p database –ignore-table=database.table1 –ignore-table=database.table2 > database.sql This works fine as long as you don’t have too much tables to exclude. 2. The second … Continue reading Taking MySQL dumps with a twist

Mysql temporary tables and replication

MySQL and replication, it has always been a touchy subject. Overall, things work properly. Non the less, on a certain project, we experienced regular replication failures: Error ‘Can’t create table ‘db.temp_table’ (errno: -1)’ on query. Default database: ‘db’. Query: ‘CREATE TEMPORARY TABLE temp_table … Basically the errors clearly points out that the temporary MySQL table … Continue reading Mysql temporary tables and replication