Pandora: Documentation en: Managing and Administration

From Pandora FMS Wiki
Jump to: navigation, search

Go back to Pandora FMS documentation index

1 The Management of Pandora FMS

1.1 Introduction

Several topics regarding the daily management of Pandora FMS such as group administration, user creation, etc. are discussed in this chapter.

1.2 Profiles, Users, Groups and ACLs

Pandora FMS is a network-management tool which allows multiple users to work with different permissions in multiple defined agent groups. Before adding new users, groups and profiles (as well as the data visibility we intend for each user) are required to be well defined.

1.2.1 Profiles in Pandora FMS

The permissions a user can have are defined within profiles. You're able to manage any profile by clicking on 'Profiles' -> 'Profiles Management'.

Gest1.png

The following list defines what ACL control allows in each feature on the console:

Feature ACL Control
View the agent's data (all tabs)AR
Tactical ViewAR
Group ViewAR
Visual console editingRW
Creating reportsRW
Creating user-defined graphsRW
Viewing reports, visual maps and custom graphsRR
Applying report templatesRR
Creating report templatesRM
Viewing eventsER
Validating and commenting eventsEW
Deleting eventsEM
Executing responsesEW
Creating incidents from events (response)EW&IW
Managing responsesPM
Managing filtersEW
Customizing event columnsPM
Changing owners / reopen eventEM
Viewing usersAR
SNMP Console viewingAR
Validating trapsIW
MessagesIW
Cron jobs PM
Tree view AR
Update Manager (operation and administration) PM
Extension Module GroupAR
Agent ManagementAW
Remote Agent Configuration Management AW
Assigning alerts to agentsLW
Defining, altering and deleting alert templates, actions and commandsLM
Group ManagementPM
Creating inventory modulesPM
Module Management (includes all suboptions)PM
Massive Management Operations AW
Creating agentsAW
Duplicating remote configurationsAW
Downtime ManagementAD
Alert ManagementLW
User ManagementUM
SNMP Console Management (alerts and MIB loading)PM
Profile ManagementPM
Server ManagementPM
System AuditPM
SetupPM
Database MaintenanceDM
Administrator Extension MenuPM
Search BarAR
Policy ManagementAW
Disabling agents / modules / alertsAD
Alerts validationLM&AR or AW&LW
Network-map viewMR
Network-map editionMW
Deletion of owned network-mapMW
Deletion of any network-mapMM
Visual console viewVR
Visual console editionVW
Deletion of owned visual consoleVW
Deletion of any visual consoleVM

1.2.1.1 Adding a Profile

In order to add a profile, please click on 'Profiles' -> 'Profile management' and click on the 'Create' button.

Gest2.png

In order to create a profile, please assign a name to it, pick the permissions it's supposed to have and click on the 'Create' button.

1.2.1.2 Editing a Profile

In order to edit a profile, please click on 'Profiles' -> 'Profiles Management' and click on the profile's name you intend to edit.

Gest3.png

1.2.1.3 Deleting a Profile

In order to delete a profile, please click on 'Profiles' -> 'Profile Management' and click on the trash icon on the right side of the profile's name you intend to delete.

Gest4.png

1.2.2 Pandora FMS Groups

The accesses are related to the groups which are used to group agents. An user could have different permissions in each of the groups to which it has access. The agents are only allowed to belong to one group.

Template warning.png

The group 'All' is a special group that cannot be deleted. All the groups are defined as subgroups of the group 'All'. Any element (e.g. reports, graphs or events) which is associated to the group 'All' can be viewed and managed by a user which has permissions for any group.

 


In order to define any group, please click on 'Administration' -> 'Monitoring' and 'Manage Groups'.

Gest5.png

1.2.2.1 Adding a Group

In order to add a group, please click on 'Profiles' -> 'Manage agent groups' and click on 'Create Group'.

Gest6.png

The fields pertaining to this particular form are the following:

  • Name: The group's name
  • Icon: The combo box to pick the icon the group is going to have.
  • Parent: The combo box to assign another group as parent of the group under creation.
  • Alerts: If enabled, the agents belonging to the group will be able to send alerts. If not, they won't be able to do so.
  • Propagate ACL: If enabled, the child groups are going to have the same ACL as this group.
  • Custom ID: The groups have an ID in the database. In this field, you're able to input another customized ID to be used by an external program in an integration, e.g. CMDBs.
  • Description: A free-text field for a description.
  • Contact: A field intended for contact information which is accessible by the '_groupcontact_' macro.
  • Other: A field for other information, accessible by the '_group_other_' macro.
  • Skin: A field in which you're able to assign a skin for the group.

Once the fields have been filled out, please click on the 'Create' button.

1.2.2.2 Editing a Group

In order to edit a group, please click on 'Profiles' -> 'Manage Agents Groups' and click on the group's name you intend to edit or on the key-shaped icon.

Gest7.png

1.2.2.3 Deleting a Group

In order to delete a group, please click on 'Profiles' -> 'Manage Agents Groups' and click on the trash icon on the right side of the group's name you intend to delete.

Gest8.png

1.2.3 Tags under Pandora FMS (>=5.0)

From Pandora FMS versions 5 and above, the access to modules can be configured by a tags system. Tags are configured on the system and be assigned to the chosen modules. The user's access can be limited to modules with certain tags in this way.

Info.png

The access tags are not meant to replace the group access, they're just meant to complement it.

 


In order to manage the tags, please click on 'Profiles' -> 'Module Tags'.

Gesttags5.png

1.2.3.1 Adding a Tag

In order to add a tag, please click on 'Profiles' -> 'Module Tags' and click on the 'Create Tag' button.

Gesttags6.png

The fields pertaining to this particular form are the following:

  • Name: The tag's name.
  • Description: The tag's description.
  • URL: The field intended to insert an external link in order to add extra information to the tag.
  • Email: The field intended to insert an email address to be used in case of alerts associated to the tag.
  • Phone:The field intended for a phone number used in alerts associated to the tag.

Once the form is filled out properly, please click on the 'Create' button.

1.2.3.2 Editing Tag

In order to edit a tag, please click on 'Profiles' -> 'Module Tags' and click on the tag's name to edit or on the editing icon in the actions column.

Gesttag7.png

1.2.3.3 Deleting a Tag

In order to delete a tag, please click on 'Profiles' -> 'Module Tags' and click on the trash icon in the actions column.

Gestag8.png

1.2.4 Users in Pandora FMS

Once the profiles and groups in Pandora FMS have been defined, we suggest to define the users.

In order to manage the users, please click on 'Profiles' and 'Users Management', in which the list of the defined users is displayed.

Gest9.png

1.2.4.1 Adding a User

In order to add a user, please click on 'Administration' -> 'Manage Users' and click on the 'Create User' button.

Gest11.png

The fields pertaining to this particular tab are the following:

  • User ID: The ID Identifier the user is going to utilize for login.
  • Full Display Name: The field to store the full name.
  • First Name: The field to store the person's name.
  • Last Name: The field to store the family name.
  • Password: The field to insert the password.
  • Password Confirmation: The field to insert the password again for confirmation.
  • Global Profile: The field to choose between 'Administrator' or 'Standard User'. An administrator is going to have absolute permissions for the assigned groups within the application. A standard user is going to have the permissions defined in its assigned profile.
  • E-mail: The field to store the user's e-mail.
  • Phone Number: The field to store the user's phone number.
  • Comments: The field to store comments on the user.
  • Skin: The field to pick a skin.
  • Interactive Charts: The field intended to decide whether to use JavaScript or static PNG graphs.
  • Block size for pagination: The field to determine the block size for pagination.
  • Not login: The user for which the 'not login' flag is set is only allowed to access the API.

If the form has been filled out appropriately, please click on the 'Create' button. The newly created user, an applicable profile and a new section appears in order to define the groups the user is supposed to have access to.

Gest12.png

A user can be granted access to as much groups as you want. Please select a profile and a group and click on the green '+' symbol.

From Pandora FMS versions 5 and above, it's possible add tags to each user-profile-group association in order to limit access to the modules containing these tags. If no tags are assigned at all, the user is going to have access to all modules of these group's agents.

Gest13.png

In case you intend to remove access to a group, please click on the trash icon on the right side of the access window to remove it.

Gest14.png

1.2.4.2 Editing your own User Settings

If the user has administrator permissions, it's able to modify certain parameters of its configuration by clicking on 'Operation' -> 'Workspace' and 'Edit my User'.

If the user creation form is displayed, everything is editable, except group permissions.

Gest16.png

1.2.4.3 User Editing by the Administrator

In order to completely edit a user (including the permissions and groups part), please click on 'Administration' -> 'Manage Users' and click on the user's name or on the key-shaped icon.

Gest18.png

1.2.4.4 Removing a User

In order to completely remove a user, please click on 'Administration' and 'Manage Users' and click on the trash icon on the right side of the user's name.

Gest19.png

1.3 The 'All' Group

Pandora FMS has a system of groups that are entities in which the agents will be categorized and used to disperse privileges. It provides some permissions for the users, framed into one or several groups in that way. They possess the capability of seeing and interacting with agents and other objects from their environment.

To render the assignation and filtering of the groups a little easier, we've designed a tool named the 'All' group. The 'All' group means: All groups or any of them, depending on the context. It's just about the same in version 3.1, but its implementation has changed.

Within version 3, the 'All' group is a special group which is contained in the database with identifier '1'. This one was attached to this group in this way, so the group with ID '1' was managed as an exception throughout the console's code, along with the necessity of the subsequent control if the groups were listed, and where it was necessary to sometimes omit this group.

In version 3.1, the 'All' group has disappeared entirely from the database. The identifier '1' has been released for use to any normal group. Now, the identifier reserved for the "All" group is '0', bearing the difference that it's completely controlled by code. Now it's controlled in such a way that the objects associated with the '0' group are going to be associated to all groups, without the need to define whether a group, taken out from the database is special or not.

If we take out agents from a group or vice versa, there isn't any problem, because an agent belongs to only one group. If we're e.g. extracting the groups to which a user belongs to (or the users which belong to one particular group) it's important to keep in mind that we should display the ones which are members of all groups (group '0') if we're going to list the users which belong to one group. If we're displaying the groups of a user, it's recommended to display all of them in case this user belongs to the 'All' group ('0').

1.4 The Enterprise ACL System

The Open Source ACL model is based on a 'unix style' type of role/action/group/user procedure.

The Enterprise ACL system (which was implemented in version 3.1) allows to define to which pages the user has access to for any profile (defined individually or by groups). This feature e.g. only allows to let a user see the 'Group' and 'Detailed Agent' views, but skipping over pages like the 'Alert' or 'Monitor' views. Those are already grouped within the classic ACL system of Pandora FMS as 'ARs' (the agent's read privileges).

This feature even allows you to restrict the administration for each page. This is also very useful to allow specific low-level operations.

Both models are implemented side by side and compatible, but the enhanced ACL system is an Enterprise feature only. The regular ACL system will continue to exist, because it provides a very easy to handle ACL system for Pandora FMS.

An activation is required within the setup in order to use the new enhanced ACL system. The option to activate it is only visible if you're running the Enterprise Version of Pandora FMS.

Acl setup2.png

In order to utilize the Enterprise ACL system, please click on the specific option for Enterprise ACL on 'Administration' and 'Setup'. Within this window, you're also able to add new items to the ACL System and see the items defined by its profile. You're also able to delete items from the Enterprise ACL system there.

Acl setup1.png

If activated, the Enterprise ACL system restricts all pages to all groups (even administrators) to defined (allowed) pages in the Enterprise ACL system. If a user with an 'Administrator' profile has no defined pages within the Enterprise ACL system, it can't see anything.


Template warning.png

Please exercise extreme caution in handling this feature, because you're running the risk of entirely losing your console's access if you're accidentally setting up incorrect Enterprise ACL configuration values for your user account.

 


In order to disable the Enterprise version's ACL System from the command line, please execute the following command:

/usr/share/pandora_server/util/pandora_manage.pl /etc/pandora_server.conf --disable_eacl

You're also able to define the rules page by page', by whole sections, to setup a 'any' rule or to add 'custom pages' which aren't going to be accessible from the menu.

There are two methods to add pages to a profile: By the wizard (default setting) or by custom edition. There is a button on top of the 'Add Rules' button to change this mode.

1.4.1 The Wizard

The default method is to pick the sections and pages for a combo control by the wizard.


Template warning.png

The pages of these combos are exactly the ones accessible from the menu. In order to grant access to pages which are accessible in other ways (e.g. the main view of the agents), you're required to use the Custom Editor to do so.

 


In order to include a particular Pandora FMS page into the 'allowed pages list', you're required to select the profile to which the ACL is going to apply to and to pick the allowed section by the 'Section' control. In this moment, you're also able to select any desired section of the page by the 'Page' control.

Acl setup4.png

Another available option is to select a section and to assign the 'All' value for 'Page'. This is going to allow the selected profile to see 'everything', just as it would be without the Enterprise version's ACL system related to that profile. If you e.g. select 'All' within both controls, this profile could see all sections in their entirety, as if it would be without the Enterprise version's ACL system within these sections.


Template warning.png

In order to render a section visible within the menu, the user is required to have been granted access to this particular section's first page. In order to e.g. display the 'Monitoring' section, the user is required to have been granted access to the 'Tactical View' page prior to that.

 


1.4.2 Custom Editing

In order to add single pages which aren't accessible from the menu, you're also able to introduce their 'sec2' parameter manually. To do so, you're just accessing the page you intend to add and copy the 'sec2' parameter.

If we e.g. intend to add the agent's main view, we're just going to any agent's main view in which the URL looks like the one shown below:

http://localhost/pandora/index.php?sec=estado&sec2=operation/agentes/ver_agente&id_agente=7702

Now we're going to insert the 'sec2' parameter ('operation/agentes/ver_agente') into the text box as shown below.

Acl setup5.png

1.4.3 Security

Any page which is defined as 'not allowed' is not going to be displayed within the menu. Those pages are also not allowed to be used, even if the user e.g. inserts their URLs manually in order to gain access to them. Any page defined as 'not allowed' by the regular Pandora FMS ACL System is not going to be allowed by the Enterprise ACL, because these pages are still handled by the regular ACL.

This is an example which contains several filters:

Acl example.png

There is also a control which was designed to check whether a page belongs to a section or not, thereby improving the security against manually conducted URL modifications. This check can be avoided by pages added by the custom editor, providing this particular user has been granted access to all pages of a section e.g. in order to optimize their performances prior to that.

1.5 The Workspace

1.5.1 Chat

This tool was designed to interact with other Pandora FMS users connected to the console in real time. This tool might come in handy if you e.g. intend to share comments or issues about the service with other operators or administrators.

1.5.2 Connected Users

This extension displays other users which are connected to the Pandora FMS console, different from our own. This functionality is quite important, because the Pandora FMS Console allows connections from different users.

In order to display the connected users, please click on 'Operation' -> 'Workspace' and 'Users Connected'.

Ex4b.png

1.5.3 Messages

Pandora FMS has a tool which allows the users to send messages to each other. Pending messages have a blinking icon within the header.

1.5.3.1 Viewing Messages

If a user receives a message, an envelope-shaped icon is going to appear on the console's top right.

Gest20.png

In order to view the user's messages, please click on 'Operation' -> 'Workspace' and 'Messages'.

Gest21.png

Gest22.png

You may read the message on top of the messages list by clicking on the envelope-shaped icon and answer it by clicking on the black 'Reply' button you see below.

Gest23.png

Once your answer is complete, please click on 'Send Message'.

1.5.3.1.1 Sending Messages

In order to send a message, please click on 'Operation' -> 'Workspace' -> 'Messages' and 'New Message'.

Gest25.png

Once your message is complete, please send it by clicking on the 'Send Message' button.

1.5.3.1.2 Deleting Messages

In order to delete user related messages, please click on 'Operation' -> 'Workspace' -> 'Messages' and click on the trash icon on the message's right side.

Gest24.png

1.6 The Servers

The server's detailed view is considered common knowledge, besides the Pandora FMS server's general state, its load level and its delay. Below, we're going to show one picture which contains the server's state. Please click on 'Operation' and 'Pandora Servers' in order to obtain it.

Server info 1.png

We're looking at several important pieces of data within this window:

  • The server's name.

Usually it's the system's hostname.

  • The server's status

('green' = running, 'grey' = stopped or down).

  • The server's type

data servers, network servers, etc.

  • The number of modules

Displays the number of modules of this type executed by the server in relation to the total number of modules of this type.

  • Server Lag:

The highest amount of time the oldest module has been waiting for data and the number of modules which have exceeded their life time. In this example, there is 1 module considered out of their life time, bearing a lag time of 10 minutes and 13 seconds. This indicator is quite useful in case we have a lot of modules to execute and like to know whether the server is on the limit of its load capacity or not, as it is in this case. It's not an excessive delay (10 minutes and 21 seconds).

  • The total number of modules in queue waiting to be attended to.

These parameters display a state of excessive load. Modules aren't supposed to be held in queue at all. Such a state always indicates the server's disability to process data fast enough.

  • Number of seconds since the server has updated its data.

Each server contains a 'Keep alive' that updates its state in order to make sure that it's active. It's also updating its statistics.

  • In the T/Q column we can see a number of threads we have configured for each server, and a number of modules in a queue.

to change the configured threads of a server you should do it from the /etc/pandora/pandora_server.conf

Threads01.png

1.7 Backup extension

It's an extension designed to conduct database backups and restore them. Please click on 'Administration' -> 'Extensions' and 'Backup'. to call it up. In order to complete the procedure, we suggest to create a distinct backup description and click on the 'Create' button as shown below.

Ex12.png

After the backup is completed, it's going to appear in the backup list, bearing the running icon under 'Status'.

Ex13.png

Once the Backup has been created, it's possible to:

  • Download it clicking on the image icon shown below.

Ex14.png

  • Conduct a rollback by clicking on the image icon shown below.

Ex15.png

The rollback feature applies to any backups which have been created before. This will destroy all existing data in the console and will apply data that already exist in the backup where the rollback is done.

  • Delete it by clicking on the image icon shown below.

Ex16.png

1.8 Cron Jobs

This is a feature of the Enterprise Versions of Pandora FMS.

It's an extension which allows to schedule the completion of tasks assigned to Pandora FMS Servers.

Please click on 'Operation' -> 'Extensions' and 'Cron Jobs' to execute this feature.

Cron jobs.jpg

In order to add a task, you're required to fill out the following fields:

  • Task: The combo to pick the task that is going to be performed, e.g.:
    • Sending a custom report by e-mail.
    • Executing a custom script.
    • Conducting a Pandora database backup.
    • Saving a custom report to the disk.
  • Scheduled: The field to determine how often the task is going to be executed.
    • Not Scheduled: These tasks are only going to be executed once and at a specified time, e.g.:
    • Hourly
    • Daily
    • Weekly
    • Monthly
    • Yearly
  • First Execution: The field to choose the date and hour for the task's first execution. It's going to be executed periodically by utilizing taking the predefined date and hour as reference.
  • Parameter: The field which allows to introduce parameters into the task to perform. It's options diversify and depend on the task which are going to be conducted.
    • Backup Pandora database: Database description and path to store the backup.
    • Send custom report by e-mail: The report to send and the destination e-mail address.
    • Execute custom script: The custom script to execute.
    • Save custom report to disk: The report to save and the destination folder.

Once you have inserted all data, please click on the 'Create' button and the task is going to be displayed within the scheduled tasks list.

Cron jobs list.jpg

Once you have created the scheduled task, it's possible to force its execution by clicking on the green circle located on the task's right or deleting it by clicking on the red 'X' on the left (It's only visible if the task is active. It replaces the green circle-shaped icon).

1.9 Planned Downtime

Pandora FMS contains a scheduled downtime management system. This system was designed to deactivate the alerts in the intervals whenever there is down time by deactivating the agent. If an agent is deactivated, it doesn't collect information. In a down time, the down-time intervals aren't taken into account for most of the metrics or types of reports, because the agents don't contain any data within those intervals.

In order to create a downtime, please click on 'Operation' -> 'Monitoring' -> 'Scheduled Downtime' and click on the 'Add' button as shown below.

Downtime1.png

The configurable parameters pertaining to this particular form are the following:

  • Name: The name of the scheduled downtime.
  • Group: The group we intend it to belong to.
  • Description: A field for a description.
  • Type: The downtime type. We're able to configure the following types of downtimes:
    • Quiet: It marks as "quiet" the selected modules, so they won't generate events, alerts, and won't store historic data.
    • Disable Agents: It disables the selected agents. It is important to know that if an agent was manually disabled before the task started, it will get enabled once the task ends.
    • Disable Alerts: It disables the alerts for the selected agents.
  • Execution: It allows us to determine whether we intend it to run it once or periodically.
  • Configure the time: A field to define date and time within which it's going to start and stop, the planned end, either once or periodically, depending on what has been defined under the 'Running' option before.

Info.png

If the Pandora FMS administrator enables the option in the visual setup section, it will be possible to create planned downtimes on a past date. This planned downtimes will never be executed, but its existence will be reflected on many reports.

 


Downtime2.png

Now we're going to specify the agents we intend to include into this downtime.

Downtime5.png

If a scheduled service stop is defined as 'active', it usually cannot be modified or deleted. From Pandora FMS versions 5 and above, there is a new option with which we're able to stop the execution of the scheduled shutdown. It's called 'Stop Downtime' and re-enables all agents, modules and alarms the planned stop is temporarily disabling. This option is not compatible to the regular scheduled downtimes. From PandoraFMS version 6 and above, you're able to postpone non-periodic downtimes even when they are 'active'.

Downtime10.png

In the moment the scheduled downtime ends, you're able to edit or delete it.

1.9.1 Alternatives to the Service Downtime Management in the Console

There are often some re-emerging situations we're required to keep in mind in which the service downtime management method is too specific. We e.g. quickly and precisely intend to deactivate all agents or to schedule a general downtime each week within a specific hour range. For these types of operations, there are the following command-line ways to accomplish that:

There are two faster ways of putting all agents into service mode:

1. By using the Pandora management tool named 'pandora_manage.pl' on the command line by executing the following command:

./pandora_manage.pl /etc/pandora/pandora_server.conf --enable_group 1

Pandora FMS Manage tool 3.1 PS100519 Copyright (c) 2010 Artica ST
This program is Free Software, licensed under the terms of GPL License v2
You can download latest versions and documentation at http://www.pandorafms.org

[*] Pandora FMS Enterprise module loaded.

[INFO] Enabling group 1

This command activates all agents. In order to deactivate 'Group 1', please execute the following command:

./pandora_manage.pl /etc/pandora/pandora_server.conf --disable_group 1

2. You're also able to achieve this by using the MYSQL interface by modifying the data directly:

echo "UPDATE tagente SET disabled = 1" | mysql -u pandora -ppassword pandora

Within the 'password' passage of the above mentioned command, you're obviously required to enter the access password for the database. You also have the option of conducting a more granular operation by using the SQL method, e.g. to specify it by the agent's name:

echo "UPDATE tagente SET disabled = 1 WHERE nombre LIKE '%_XXXX%'" | mysql -u pandora -ppassword pandora

1.10 The Audit Log

Pandora FMS generates a log, containing all important changes and actions which have taken place within the Pandora FMS console. This log can be invoked by clicking on 'Administration' and 'System Audit Log'.

Gest67.png

1.10.1 Reviewing the System Logs

In this screen, you can see a series of entries related to the console activity, information about the user, type of action, date and a small description of the events logged.

In the upper right side, you can see a circular graph with the percentage of actions per user. it shows the top most active users..

Audit 01.png

In the upper left side, you can filter which entry is going to show by different criteria including actions, user, and IP even you can perform a text search and determine the max hours old.

The filtering fields available are:

  • Action: The different possible actions among which to filter -> ACL Violation, Agent management, Agent remote configuration, Alert management, Command management, Dashboard management, Event alert management, Event deleted, Extension DB inface, File collection, Logoff, Logon, Logon Failed, Massive management, Module management, No session, Policy management, Report management, Setup, System, Template alert management, User management, Visual console builder.
  • User. the user who perform any action.
  • Free text for search: search the string in the fields User, Action y Comments.
  • Max. Hours old: number of hours back to show the events.
  • IP: dirección source IP .

It is also possible to export the listing on the screen and a CSV file using the action button located at the bottom right of the audit log.

Audit 02.png
Available actions to filter


With this tool, you can search for example the task a user perform about Agent management in the last hour.

Audit 03.png

Or the time when a certain user has logged in in the console. you can retrieve all the information about the actions performing by all the user. Also, you can view the date of the Pandora server daemon was started or when the setup was changed.

Audit 04.png

1.11 Managing the Database from the Console

The core of Pandora FMS is its Database. All data collected from the monitored systems, the agents configuration, the alarms, the events, the audit data, the different users and their data are stored within it. It's all considered system data.

The efficiency and reliability of this module is vital to the correct functionality of Pandora FMS. An appropriate maintenance of the Pandora FMS Database is of course crucial for its proper operation.

In order to perform a regular maintenance of the database, the administrators are able to either use MySQL standard commands from the command line or to manage the database from the console without having to be an expert on MySQL.

The database diagnosis report is obtained from Admin Tools -> Diagnosis info.

The management by means of sql statements of the Database is carried out from "Admin tools -> Admin Tools -> DB Interface".

Database Schema check management is done from "Admin tools -> Admin Tools -> DB Schema Check".

Captura de pantalla de 2017-10-09 13-37-10.png


1.11.1 The Database Interface

It's an extension which was designed to execute commands in the database and to observe the results. It's a very advanced tool that is recommended only to be used by people who have a serious knowledge of the SQL language and the Pandora FMS Database Structure in detail.


Template warning.png

If this tool gets used in any inappropriate way, it's very likely to result in a permanent destruction of Pandora FMS, its database or its data !

 



Please click on 'Administration' -> 'Admin Tools' and 'DB Interface' in order to invoke the database's interface.

Ex10.png

Please click on 'Administration' -> 'Admin Tools' and 'DB interface', insert your SQL command into the text field and click on the 'Execute SQL' button.

1.11.2 DB Schema Check

This is an extension that allows you to check the structural differences between the database established in your Pandora and a pattern scheme to compare possible errors.

Please click on 'Administration' -> 'Admin Tools' and 'Schema Check' in order to invoke the database's schema check.



Captura de pantalla de 2017-10-09 13-47-04.png



Please click on 'Administration' -> 'Admin Tools' and 'DB schema check', insert your db access data into the text field and click on the 'Run test' button.

1.12 The Plug-In Registration

The plug-in registration was designed to render the logging of server plug ins an easy task. Please click on 'Administration' -> 'Manage Servers' -> 'Register Plug In' in order to invoke this plug in.

Ex9.png

In order to log a plug in, please pick the file by clicking on 'Examine' and click on the 'Upload' button.

You may obtain more information about the '.pspz' server plug ins in the Server Plug-In Development Section.

1.13 Inserting Data

This extension was designed to import data by means of a comma-separated file (CSV) to an agent's module. Please click on 'Administration' -> 'Manage Monitoring' and 'Insert Data' in order to invoke this extension.

Insert data1.png

The syntax in the CSV file format is required to be 'date;value' in each and every line. The date's syntax format is required to be 'Y/m/d H:i:s', e.g.:

2011/08/06 12:20:00;77.0
2011/08/06 12:20:50;66.8

1.14 CSV Import

This is a feature of the Pandora FMS Enterprise Version.

This extension was designed to import a file, separated by any divider on the Pandora FMS server.

Please click on 'Administration' -> 'Extensions' and 'CSV Import' in order to invoke this extension.

Ex17.png

Please pick the field to import by clicking on the 'Examine' button, choose the server on which the export is supposed to be conducted on and select the divider from a combo. Once the before mentioned combos are served appropriately, please click on the 'Go' button.

The CSV file is required to contain the following fields in the below mentioned sequence:

  • The agent's name
  • IP address
  • The operating system's ID
  • The interval and group ID the agent belongs to.

1.15 Resources Registration

This extension was designed to import '.prt' files which contain the definition of local, network, SNMP and WMI components. Except for the local components, you're allowed to add these components to a template.

Resource registration screenshot.png

1.15.1 File Definition for the PRT Format

This is an appropriate definition for '.prt' files.

<?xml version="1.0"?>
<pandora_export version="1.0" date="yyyy-mm-dd" time="hh:mm">
	<component>
		<name></name>
		<description></description>
		<module_source></module_source>
		<id_os></id_os>
		<os_version></os_version>
		<data></data>
		<type></type>
		<max></max>
		<min></min>
		<max_cri></max_cri>
		<min_cri></min_cri>
		<max_war></max_war>
		<min_war></min_war>
		<historical_data></historical_data>
		<ff_treshold></ff_treshold>
		<module_interval></module_interval>
		<id_module_group></id_module_group>
		<group></group>
		<tcp_port></tcp_port>
		<tcp_send></tcp_send>
		<tcp_rcv_text></tcp_rcv_text>
		<snmp_community></snmp_community>
		<snmp_oid></snmp_oid>
		<snmp_version></snmp_version>
		<auth_user></auth_user>
		<auth_password></auth_password>
		<privacy_method></privacy_method>
		<privacy_pass></privacy_pass>
		<auth_method></auth_method>
		<security_level></security_level>
		<plugin></plugin>
		<plugin_username></plugin_username>
		<plugin_password></plugin_password>
		<plugin_parameters></plugin_parameters>
		<wmi_query></wmi_query>
		<key_string></key_string>
		<field_number></field_number>
		<namespace></namespace>
		<wmi_user></wmi_user>
		<wmi_password></wmi_password>
		<max_timeout></max_timeout>
		<post_process></post_process>
	</component>
	<component>...</component>
	<component>...</component>
	<template>
		<name></name>
		<description></description>
	</template>
</pandora_export>

1.16 Translation of Strings

This extension can be found in the god-mode menu under 'Administration' -> 'Setup' and 'Translate String' and was designed to translate strings on the Pandora FMS interface for the purpose of personalizing it.

Translate string.png

The fields pertaining to this particular extension are the following:

  • Language: It allows to filter the strings by language.
  • Free text for search: The field to insert the string content you intend to personalize.

Three columns are going to be displayed in this window: The first one is going to display the original string, the second one displays the current translated string and the third one contains the custom translation you intend to add.


Go back to Pandora FMS Documentation Index