I'm not an ops, but I'm using Linux server every day mostly with Debian distribution. I'm learning constantly on managing a server. What I really like is to automate and monitoring things. Posts in this category are mostly Tips and reminder to myself for all the trouble I had (still have) but some posts are also just for fun like puting PHP error in timeserie graph.
I recently updated my server to run last Debian version and faced an error I never encountered before with Nginx and PHP-FPM. Because of the mass update in software version, I suspected something really nasty and used everything I can to fix a simple typo, thanks to unexplicit error message.
Install software on Debian or Ubuntu is very easy with .deb package file. But sometimes dependencies can't be resolved and software install failed. Most of the time it's possible to fix this issue by editing the dependencies list. Because command are long and ambigous I propose here an Ansible role to achieve it.
One of my first articles on this blog dealt with backing up MySQL databases on a production server. Today, I offer you a variation of this article and the script to save your PC or development server (mysql, svn, git).
My first reminder of the blog: how to unban an IP that Fail2Ban wrongly banned. This happens to me a lot right now and I never remember the exact command line to reauthorize an IP.
[Paranoid Mode: ON] I think we all agree that the database is the most sensitive element of a site. Installing phpMyAdmin on a server is like exposing this data to everyone, well everyone who knows how to hack phpMyAdmin. Do you have to do without phpMyAdmin? No, it's far too practical, but a minimum of safety must be put in place to sleep soundly.
Once again, I struggled using Ansible module: blockinfile to change multiple sections of the same file. This article is a tips of how to achieve it with Grafana config file.
Vim is a great editor on Linux, but unfortunately the usual keyboard shortcuts such as Crtl + F to searh and replace text does not exist. In this tip I explain the command to make a text replacement in VIM.
Having a strategy of backup information is really important. We tend to neglect it and think about it after the first loss of information. Here is my backup script of my MySQL databases.
I use very little Vim editor to develop, but when I have my PHP code in black and white is not very practical. There are several solutions to color code (PHP, javascript .....) in Vim, here is an easy to install.