DEBIAN

Installation and Configuration of MariaDB in Debian 12

MariaDB installation and configuration in Debian 12 To install MariaDB in Debian 12, follow these steps: 1.Update the repositories and install the MariaDB package: First, update your system repositories and install MariaDB: javiercruces@jcruces:~$ sudo apt update javiercruces@jcruces:~$ sudo apt install mariadb-server 2.Enable and start the MariaDB service: Once installed, set MariaDB to automatically start the start and then start the service: javiercruces@jcruces:~$ sudo systemctl start mariadb javiercruces@jcruces:~$ sudo systemctl enable mariadb 3.Configure MariaDB:

Sunday, September 1, 2024 | 2 minutes Read

Interconnection of database servers

This post addresses how to configure and manage connections between different databases, both homogeneous and heterogeneous, to facilitate interoperability between various database systems. Throughout the article, different connection scenarios are explored, starting with configurations between databases of the same type, such as Oracle to Oracle or PostgreSQL to PostgreSQL, and then moving towards heterogeneous connections between different technologies, such as Oracle to MySQL, PostgreSQL to Oracle, and vice versa. It also covers the steps needed to configure links, create users, and modify key configuration files, allowing remote consultations.

Sunday, September 1, 2024 | 9 minutes Read

Oracle installation 19c under Debian 12

Installing Oracle 19c on Debian 12 may seem complicated, but don’t worry, I’m here to guide you in every step. In this post, I will explain to you in a simple way how to prepare your system and make the installation of Oracle 19c in Debian 12. Update the repositories The first thing is to update the repositories of our virtual machine and in case we don’t have any packages we update it:

Sunday, September 1, 2024 | 4 minutes Read

PostgreSQL installation in Debian 12

In this post, I will guide you through the process of installing PostgreSQL in Debian 12, creating a user with basic permissions, and how to create and consult a database. #1. PostgreSQL installation To install PostgreSQL in Debian 12, follow these steps: Update the repositories and install PostgreSQL * *: First, make sure your system is updated and install PostgreSQL: ```bash sudo apt update sudo apt install postgresql ``` Verifies that the service is in operation * *: After installation, make sure that the PostgreSQL service is in operation:

Sunday, September 1, 2024 | 3 minutes Read

Remote access configuration in MariaDB

To allow remote access to your MariaDB server, follow these steps: Configure the MariaDB configuration file First, edit the MariaDB configuration file to allow connections from specific IP addresses. Open the file /etc/mysql/mariadb.conf.d/50-server.cnf with a text editor, for example, nano: sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf Find the line that starts with bind-address and change it to accept connections from any IP address. You can have him accept connections from all the PIs with:

Sunday, September 1, 2024 | 2 minutes Read

Remote Access Configuration in Oracle

To configure remote access in Oracle, it is essential to correctly adjust the network files located in $ORACLE_HOME/network/admin. These files, such as listener.ora and tnsnames.ora, allow us to define how clients will connect to the database and which equipment will have access. Remote Access Configuration The Oracle configuration with respect to the network is saved in the directory that we have defined as the Oracle home: $ORACLE_HOME/network/admin.

Sunday, September 1, 2024 | 2 minutes Read

Comparative between OpenVPN and Wireguard

The goal of this post is to compare the different VPNs software most used by seeing which is faster, for which we will support in speed test using iperf3. [NOTE] The comparative part of the posts in this section in which we mount each type of VPN. Speed without VPN I’m gonna start by comparing the speeds of these 2 systems, using iperf3. For this I have removed the cisco router as I had it configured with FastEthernet interfaces and changed it to a Linux router with GigabitEthernet interfaces.

Thursday, March 28, 2024 | 9 minutes Read

Create certification authority (CA) and self-signed certificates in Linux

At first a student will establish a Certified Authority and sign a certificate for the other student’s page. We will then test it on the Apache and Nginx web servers. Create the certifying authority Step 1: Creating directories and files The first step will be to generate a directory in which you will locate your certification authority, in order to maintain an organization at all times. The directory name will be CA /. In turn, you have to generate several subdirectories within it:

Thursday, March 28, 2024 | 15 minutes Read

Forensic computer

Forensics is the set of techniques that allows us to obtain as much information as possible after a computer incident or crime. In this practice, you will perform the evidence-taking and analysis phase on one Linux machine and another Windows. We’ll assume we caught the criminal ‘in fraganti’ and the machines were on. Optionally, you can perform an Android device analysis. On each of the machines you must do a memory and a hard drive, taking the necessary measures to certify the chain of custody.

Thursday, March 28, 2024 | 23 minutes Read

Implementation of a perimeter firewall with Fortinet I

Before you start the practice, the scenario you see in the practice is as similar as I can ride to the original practice. I have used version 7.0.9-1 of FortiGate, as the higher versions bring some restrictions. You can download the image from this [link](https://drive.google.com/drive/folders/ 1VGmeLN5inkWNNNUsIvq9ewGUzJLTLkiM). Firewall start-up FortiGate devices are made with the IP 192.168.1.99 / 24, as I am from GNS3 do not need to connect to this interface with a device and change the configuration. Since I can do it from the console.

Thursday, March 28, 2024 | 10 minutes Read

Implementation of a perimeter firewall with Fortinet II

Now let’s emulate firewall practice II, but on GNS3. To this end, I have transformed client 1 into Odin, and added Thor and Loki as virtual machines instead of containers on the LAN network. I have also created a new network called DMZ, in which will be the Hela machine. Since I have transformed the previous scenario into this new one, we have some rules created earlier. Therefore, I will remove from the statement those that are already created, such as making SSH to Odin from port 2222, but with the service listening in the 22.

Thursday, March 28, 2024 | 16 minutes Read

Implementation of a perimeter firewall with Nftables I

In this post on a Debian machine scenario, we will apply rules with Nfables to match the traffic that goes into and out of our network, trying to imitate a scenario. [NOTE] To deploy the stage to perform these exercises you will need to deploy the .yaml file you will find in the link to the next paragraph. This will be in charge of deploying 2 machines one that will make firewall and one that will simulate a client that will be connected to the first machine to simulate a local network.

Thursday, March 28, 2024 | 27 minutes Read