Shaarli is a single user link sharing service. It stores its data on filesystem and does not need a database server. It is a very light solution of a single user working alone outside of a group. This howto is tested on: Debian 10.0 Buster This howto is tested with Read more…
biapy-downloader is a script created to automate the downloading of software’s latest versions. It find the URL of the latest version of the software, download its content and, if needed, extract it. This guide describe its installation on Debian. This howto is tested on: Debian 10.0 Buster This howto is Read more…
mysql-tools is a shell script automating database and user management from command-line for MySQL and MariaDB. This post describe how to install it and give some usage examples.
This howto is tested on: Debian 10.0 Buster Requirements This howto requires: a MySQL or MariaDB server, as described by Install MariaDB (MySQL) on Debian. This howto recommends: Adjusting the filesystem mount options, as described by Adjust filesystem options for MariaDB (MySQL). Environment setup Configuration Enable MySQL binary log to Read more…
The filesystem where MariaDB (MySQL) datadir is stored (“/var/lib/mysql” by default) should be mounted with theses options: noatime : disable the update of files access time. Limit I/O load generated by MySQL disk accesses. nodiratime : disable the update of folders access time. barrier=1 : Reduce risks of data loss Read more…
Tuning Primer is a tool helping to tune the performances of a MariaDB (MySQL) server. This howto is tested on: Debian 10.0 Buster Requirements This howto requires: a MySQL or MariaDB server, as described by Install MariaDB (MySQL) on Debian. Installation Install the software’s requirements: Install the software: Usage Wait Read more…
This howto is tested on: Debian 10.0 Buster Requirements This howto requires: a MySQL or MariaDB server, as described by Install MariaDB (MySQL) on Debian. the MariaDB sys schema, as described by Install the MariaDB sys schema on Debian. Environment setup Installation Install the software: Performance schema Enable the database Read more…
The MariaDB sys schema is a collection of views, functions and procedures to help MariaDB administrators get insight in to MariaDB Database usage. This howto is tested on: Debian 10.0 Buster This howto is tested with these versions of MariaDB: 10.3.28 Requirements This howto requires: a MySQL or MariaDB server, Read more…
This howto is tested on: Debian 10.0 Buster Requirements This howto requires: a MariaDB (MySQL) server, as described by Install MariaDB (MySQL) on Debian. Backup Manager, as described by Install Backup Manager on Debian. Settings Initialize the settings associative array: Set the name of the MySQL account to be created Read more…
MariaDB is a lightweight (compared to Oracle or PostgreSQL) database management system. It is designed to manage simple databases with a big number of records. MariaDB is mainly used to store websites Content Management Systems data. MariaDB is a free software fork of MySQL.
Backup Manager store its backups archives on the local disk. To prevent data loss in case of hardware failure, it is recommended to create a backup copy of the archives on a remote host. This post describe how to setup Backup Manager to copy its archives to a remote host Read more…
SFTP is a protocol allowing for secure file transfers over SSH. This guide describe how to setup SFTP only accounts on a SSH server.
bu-tools is a shell script easing the management of backup software such as Backup Manager. It offer a standardized method to manage the list of backed-up paths. This howto is tested on: Debian 10.0 Buster Requirements This howto recommends: biapy-updater, for automatic software updates. This howto recommends one of these Read more…
Backup Manager is a comprehensive backup tool providing a host of data backup methods. While too simple to manage a server farm, it is perfectly able to backup a lone server. This howto is tested on: Debian 10.0 Buster Settings Initialize the settings associative array: Set the group owning the Read more…
The performances of a database server are greatly dependent of its hosting hardware. Disk latency, available memory and processor computing power are the main parameters of the equation. This howto help you adjust a MariaDB (or MySQL) server settings to its hosting hardware. This howto is tested on: Debian 10.0 Read more…
MusicBrainz is an open music encyclopedia that collects music metadata and makes it available to the public. Picard is a music tagger developed by MusicBrainz that greatly ease managing a music library. This howto is tested on: Ubuntu 20.10 Groovy Gorilla This howto is tested with these versions of the Read more…
Rootkit Hunter is, as its name describe, a rootkits detection tool. It can detect if a system has been compromised. It is a required tool for checking a system health. This guide describe how to configure rkhunter on Debian.
DFind is the vulnerability scanner generating the “w00tw00t.at.ISC.SANS.DFind” HTTP requests found in Web servers logs. This guide setup some iptables rules blocking these requests. A better method is to use fail2ban to block the sources of these requests.
This post describe a simple way to block all access to a network port on Debian, except for specified IP addresses.
PeerGuardian is a firewall for Peer to Peer software (i.e. BitTorrent) blocking bad peers.
The /tmp folder can be used to compromise the system security. A simple way to prevent this issue is to prevent the execution of scripts stored in this path. This guide describe how to do this.
nginx-tools is a command-line tool easing and automating the daily administration of a NGINX server on Debian. This howto describe its installation and usage.
NGINX is a high performance HTTP server allowing for load balancing. It allow to serve a great number of visitors while using less CPU and RAM than Apache2.
sf-downloader is a script created to ease the download of software’s latest versions (from sourceforge.net initially). It find the correct download link for the software, and then download it and, if needed, extract it. This guide describe its installation on Debian.
biapy-updater is a Bash script designed to automate keep up-to-date tools provided by this site. It is a wrapper around wget to only replace the checked tool if a newest version is available. This guide describe how to install it on Debian.