data base

How to protect our server from attacks on our databases with "Access denied for user root@ip address (using password: YES / NO)" using Fail2Ban

botond published 2022/06/05, v - 01:45 time
When we run websites, our server and the websites and services that run on it are often vulnerable to external attacks, and our MySQL / MariaDB database server is no exception. If the Fail2Ban protection software is also available on your server, this short description will show you how to make your server more secure against attacks on your "Access denied for user root @ ip address (using password: YES / NO)" database server.

Upgrading your Drupal 9 base system in two ways

botond published March 2021, 02, Thu - 25:23 time
There have been several base system updates for Drupal 9 CMS in recent weeks, so it's worth reviewing its update mechanism as before for the Drupal 8 update. In this description, I'm going to update the Drupal 10 website installed on the Debian 9 (Buster) perfect server from 9.1.2 to 9.1.4, so here we now jump to several versions at once. There are two ways to do this: first with a composer, and then look at the manual update.

How to upgrade our Matomo (formerly Piwik) web analytics system to version 4.x (page 2)

botond published 2020/12/15, k - 09:34 time
The Matomo (formerly Piwik) web analytics system is a high-quality statistical tool that provides us with a detailed and comprehensive view of our website traffic. I have previously described how to install and deploy Matomo software on your own server, and in this tutorial we will review how to upgrade your web analytics system to the recently released 4.x major version. The web statistics program also contains many new features, but in this description we do not focus on these, but we satisfy the software requirements for the new main version so that the system can continue to operate stably. On this page, we will provide the post-upgrade system requirements.

Installing Debian 10 (Buster) LAMP Server v1.0 (page 2)

botond published 2019/11/19, k - 14:28 time
With the help of LAMP systems, we can run dynamic websites on our server or even on our home computer. In this description, we create a LAMP server for Debian 10 (Buster) with the following components: MariaDB 10.3.18, Apache 2.4.38, PHP 7.3 and phpMyAdmin 4.9.1. On this page, we install and configure the phpMyAdmin web database management interface, which is done in a unique way because the Debian 10 repository does not include this software by default.

Installing Debian 10 (Buster) LAMP Server v1.0

botond published 2019/11/19, k - 14:25 time
With the help of LAMP systems, we can run dynamic web pages on our server or even on our home computer. In this description, we create a LAMP server for Debian 10 (Buster) with the following components: MariaDB 10.3.18, Apache 2.4.38, PHP 7.3 and phpMyAdmin 4.9.1. On this page we install the Apache, MariaDB and PHP components.

How to install Matomo (formerly Piwik) web analytics software on our Apache server

botond published 2019/09/01, v - 16:01 time
In this tutorial, we will install Matomo (formerly Piwik) web analytics system on an existing server, which will then provide us with detailed statistics on visitor traffic to websites running on the server. First, we create the database, storage, and configure the Apache for the system ...

Installing WordPress 5.2 CMS on ISPConfig Server Environment (page 2)

botond published 2019/07/12, p - 17:12 time
WordPress is a free, open source, easy-to-use, customizable, and search-friendly CMS system that makes it easy to create blogs, websites, or even web stores. On this page, we will continue to create the web account by creating a Shell user and then finish by installing the WordPress 5.2 CMS system.

Installing WordPress 5.2 CMS on an ISPConfig server environment

botond published 2019/07/12, p - 17:10 time
WordPress is a free, open source, easy-to-use, customizable, and search-friendly CMS system that makes it easy to create blogs, websites, or even web stores. We have previously installed a Drupal 8 system for a perfect Debian 8 (Jessie) server configuration, and now we will be talking about WordPress version 5.2 on a server environment that is also ISPConfig. More descriptions will be built on the installed website later.