Linux Debian is a free and open-source operating system based on the Linux kernel. It is known for its stability, security, and flexibility, and is widely used as a server, desktop, and embedded platform.
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.
In this article I present you a config which allows to put the client MySQL / MariaDB in color to facilitate the reading of the results of your SQL queries.
Have you ever thought about using the .my.cnf configuration file to make it easier to connect to your MySQL or MariaDB databases? This configuration is very useful when you have to manage several databases and / or several servers. I propose you a presentation of what we can do with it in this article.
I almost use only the command line to make calls on APIs using cURL. It's convenient and fast, easily scriptable if needed and the history of bash saves me time. But the response provided by cURL is not always readable especially when it comes to JSON. In this article I will introduce JQ that I use to display a pretty readable JSON and more.