# Pandora AzurePostgresql

# Introduction

**Ver.** 23-08-2022

Plugin with which to monitor an azure postgresql data server.

**Type:** Server plug-in

# Compatibility matrix

<table border="1" id="bkmrk-sistemas-donde-se-ha"><tbody><tr><td>**Systems where tested**</td><td>CentOS 7, Fedora, rocky linux

</td></tr><tr><td>**Systems where it should work**</td><td>Any linux system

</td></tr></tbody></table>

# Pre requisites

- Pandora FMS Data Server enabled
- Have the Pandora FMS Plugin Server enabled.
- Know some of your account credentials, such as your tenant id, secret, client id and server resource id.

# Previous configuration

The plugin makes use of a file in which two types of data can be entered.

```
#credentials
tenant_id:<tenant-id>
client_id:<client-id>
secret:<secret>
#id resources
serverpostgres_id:<server_resource_id>
```

Obtaining credentials necessary for the use of the plugin.

1\. Credentials to authenticate:

-Tenant id

-Client id

-Secret

**2. Recurse ID**

You need the resource id of the resource that the plugin monitors, these are :

\- Postgresql server resource id

Obtaining tenant id and client id.

1\. To obtain the tenant id and the client id, we will go to the application registry menu inside the active directory:

[![menu.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-05/scaled-1680-/menu.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-05/menu.png)

2\. We will enter inside the application.

[![menu2.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-05/scaled-1680-/menu2.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-05/menu2.png)

3\. The tenant id and client id will appear in the application menu.

[![menu3.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-05/scaled-1680-/menu3.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-05/menu3.png)

4\. To find the secret we will go to certificates and secrets inside the active directory menu.

[![menu4.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-05/scaled-1680-/menu4.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-05/menu4.png)

5\. Within this menu we will be able to see the secret keys or generate them (it has to be the key value, not the id).

[![menu5.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-05/scaled-1680-/menu5.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-05/menu5.png)

Obtaining the resource id of the database.

In the server menu, in general information, we can see the resource id of the server by clicking on json view.

[![image-1652285449723.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-05/scaled-1680-/image-1652285449723.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-05/image-1652285449723.png)

# Parameters

<table border="1" id="bkmrk-par%C3%A1metro-descripci%C3%B3"><tbody><tr><td>**Parámetro**</td><td>**Descripción**</td></tr><tr><td>--timespan</td><td>In hours (optional), last time period, can be used in a custom run to display data from a time period (optional). </td></tr><tr><td>--metric</td><td>Metric name for custom execution (optional).</td></tr><tr><td>--granularity</td><td>In minutes combined with timespan it will show you the data in intervals (optional). </td></tr><tr><td>--name\_module</td><td>To choose the name of the module in a custom run (optional).</td></tr><tr><td>--tentacle\_port</td><td>Tentacle port Default 41121(optional)</td></tr><tr><td>--tentacle\_address</td><td>Ip of the tentacle server to send the data (optional)</td></tr><tr><td>--agent\_name</td><td>To name the agent that will contain the modules, by default: "Azure SQL" (optional).</td></tr><tr><td>--prefix\_module</td><td>To prefix the modules in case you want to differentiate them from other executions (optional).</td></tr><tr><td>--conf</td><td>Path of the conf file with the queries (required)</td></tr><tr><td>-g,--group</td><td>Pandora FMS target group (optional)</td></tr><tr><td>--data\_dir</td><td>Pandora FMS data directory. By default it is /var/spool/pandora/data\_in/ (optional)</td></tr><tr><td>--as\_agent\_plugin</td><td>It is optional, if you want the plugin to be an agent plugin and put the modules in the pandora agent, execute this with a 1 (optional)</td></tr></tbody></table>

# Manual execution

**Basic manual execution**

```
./pandora_azurepostgresql --conf <path-conf> --as_agent_plugin 1
```

[![image-1661254388021.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/scaled-1680-/image-1661254388021.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/image-1661254388021.png)

**Manual execution for module creation with customized intervals**

```
./pandora_azurepostgresql --conf <path-conf> --as_agent_plugin 1 --timespan <period in hours> --granularity <interval in minutes> --metric <name-metric> --name_module <name_module>
```

[![image-1661254665603.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/scaled-1680-/image-1661254665603.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/image-1661254665603.png)

[![image-1661254891721.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/scaled-1680-/image-1661254891721.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/image-1661254891721.png)

```
./pandora_azurepostgresql --conf <path-conf> --as_agent_plugin 1
```

[![image-1661254388021.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/scaled-1680-/image-1661254388021.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/image-1661254388021.png)

**Manual execution for module creation with customized intervals**

```
./pandora_azurepostgresql --conf <path-conf> --as_agent_plugin 1 --timespan <period in hours> --granularity <interval in minutes> --metric <name-metric> --name_module <name_module>
```

[![image-1661254665603.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/scaled-1680-/image-1661254665603.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/image-1661254665603.png)

[![image-1661254891721.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/scaled-1680-/image-1661254891721.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/image-1661254891721.png)

# Configuration in PandoraFMS

As server plugin

Manual installation

Go to servers &gt; plugins:

[![image-1629974405286.png](https://pandorafms.com/guides/public/uploads/images/gallery/2021-08/scaled-1680-/image-1629974405286.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2021-08/image-1629974405286.png)

Click on add:

[![image-1629974430627.png](https://pandorafms.com/guides/public/uploads/images/gallery/2021-08/scaled-1680-/image-1629974430627.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2021-08/image-1629974430627.png)

We put in name and the description that is preferred.

We put as command the execution with the path of the plugin:

```
/path_pandora_azurepostgresql
```

<p class="callout info align-center">Remember that the recommended path for the use of the server plugins is: /usr/share/pandora\_server/util/plugin/</p>

And in parameters of the plugin we will introduce these followed by the macro "\_field&lt;N&gt;\_", the obligatory one for it to work is --conf.

<p class="callout warning">Although it is not mandatory, it is highly recommended the use of the --agent\_name parameter, since it allows us to customize the name of the agent that will contain the modules created for each customized query. It is also advisable to use the --prefix\_module parameter, because this will allow us to assign a prefix to the modules, which can be useful to recognize them faster and differentiate them if we create several executions for different databases.</p>

**--CONF**

[![image-1656438528074.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-06/scaled-1680-/image-1656438528074.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-06/image-1656438528074.png)

Once this is done, we will click on "create".

Once this is done, the only thing left to do is to call it, so we will go to some agent's view and create an add-in module:

[![image-1646741530197.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-03/scaled-1680-/image-1646741530197.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-03/image-1646741530197.png)

We will give it a name and in the section "plugin" we will put the one we have just configured.

Once this is done, click on create.

If the module is shown with 1, it means that it is running correctly.

# Modules generated by the plugin

The plugin will create an agent with the name we have set with the --agent\_name parameter.

[![image-1661255594501.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/scaled-1680-/image-1661255594501.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/image-1661255594501.png)

And it will create the following modules:

<table border="1" id="bkmrk-cpu_percent-memory_p"><tbody><tr><td><div><div>cpu_percent</div></div></td></tr><tr><td><div><div>memory_percent</div></div></td></tr><tr><td><div><div>io_consumption_percent</div></div></td></tr><tr><td><div><div>storage_percent</div></div></td></tr><tr><td><div><div>storage_used</div></div></td></tr><tr><td><div><div>storage_limit</div></div></td></tr><tr><td><div><div>serverlog_storage_percent</div></div></td></tr><tr><td><div><div>serverlog_storage_usage</div></div></td></tr><tr><td><div><div>serverlog_storage_limit</div></div></td></tr><tr><td><div><div>active_connections</div></div></td></tr><tr><td><div><div>connections_failed</div></div></td></tr><tr><td><div><div>backup_storage_used</div></div></td></tr><tr><td><div><div>network_bytes_egress</div></div></td></tr><tr><td><div><div>network_bytes_ingress</div></div></td></tr><tr><td><div><div>pg_replica_log_delay_in_seconds</div></div></td></tr><tr><td><div><div>pg_replica_log_delay_in_bytes</div></div></td></tr></tbody></table>

[![image-1661255733199.png](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/scaled-1680-/image-1661255733199.png)](https://pandorafms.com/guides/public/uploads/images/gallery/2022-08/image-1661255733199.png)