Database

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