Infrastructure at your Service

 
Joël Cattin

Automating Linux patching with Ansible – How to keep all your environments consistent ?

By | Ansible, DevOps, Operation systems, Security | No Comments

Your may want to patch your Linux servers on a regular basis (e.g using “yum/dnf update”). As always, it’s obviously recommended to : 1) Patch the TEST systems 2) Check if there is no side effects 3) Wait few days or weeks 4) Patch the PROD systems The problem here is that between step 1 and 4 above, a new version of the packages can be available on the public repository you use. Consequently after…

Read More
Elisa Usai

What I really like about Percona PMM

By | Cloud, Database Administration & Monitoring, MariaDB, MySQL, Oracle, Postgres, SQL Server | No Comments

Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we can do much more with it! I discovered this tool 2 years ago when I started a monitoring study for a customer, and ever since, I’ve been in love with it. I will explain you why.

Read More
Cesare Cervini

Installing the cdata ODBC drivers for Excel

By | Database Administration & Monitoring | No Comments

This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and MariaDB. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). Like MongoDB, Excel is not a relational data source, but the ODBC API will allow…

Read More
Cesare Cervini

Installing the ODBC drivers for MongoDB

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, Excel, and MariaDB. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). MongoDB is a noSQL database but the ODBC API will hide this fact and allow…

Read More
Cesare Cervini

Installing the ODBC drivers for Microsoft SQLServer for Linux

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). As root, follow the documentation here to get and install sqlserver express for Linux. Here are the…

Read More
Cesare Cervini

Installing the ODBC drivers for HSQLDB

By | Database Administration & Monitoring | No Comments

This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). As user debian, follow the documentation here and here to get and install hsqldb for…

Read More
Cesare Cervini

Installing the ODBC drivers for Oracle RDBMS

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

This article is part of a series that includes SQLite, Postgresql, Firebird, MongoDB, Microsoft SQL Server, HSQLDB, Excel, and MariaDB. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). As we already have a running Oracle remote instance, we don’t need to set one up…

Read More
Cesare Cervini

Installing the ODBC drivers for MariaDB

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes SQLite, Postgresql, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). The MariaDB ODBC drivers can be installed from the platform’s default package repositories. As it…

Read More
Cesare Cervini

Installing the ODBC drivers for Firebird

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes SQLite, Postgresql, Microsoft SQLServer, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). As root, install the Firebird RDBMS and its ODBC drivers from the official repositories: # apt…

Read More
Cesare Cervini

Installing the ODBC drivers for PostgreSQL

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes SQLite, MariaDB, Firebird, Oracle RDBMS, Microsoft SQL Server, HSQLDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Refer to SQLite for installing the required ODBC Driver Manager. The test system is a debian v11 (bullseye). The postgresql drivers can be installed from the platform’s default package repositories using the following…

Read More
Cesare Cervini

Installing the ODBC Driver Manager with SQLite on Linux

By | Database Administration & Monitoring, Development & Performance | No Comments

This article is part of a series that includes Firebird, Postgresql, Microsoft SQLServer, Oracle RDBMS, HSQLDB, MariaDB, MongoDB, and Excel. The goal is to set up a self-standing environment for testing an ODBC extension for gawk presented here to be completed. Excepting the present part which deals with the ODBC Driver manager’s installation which is a prerequisite, each part can be used independently from the others. The test system is a debian v11 (bullseye). Installation…

Read More
Mouhamadou Diaw

Oracle 21C Security : diagnostics_control and enable diagnostics

By | Database Administration & Monitoring, Database management, Oracle | No Comments

Some debug-events and debug-actions are not safe and should be exposed to users with caution. In previous releases, privilege control for the usage of these diagnostics was not sufficient. With Oracle 21c, regular users can be blocked from using these diagnostics to better support separation of duty. Indeed with Oracle 21c, we have a new mechanism to control the debug-events and debug-actions through ALTER SESSION and/or ALTER SYSTEM. This mechanism is implemented by two new…

Read More