Database Query from WEB access

Introduction

You can make your database queries from the LoriotPro WEB interface. This interface uses PHP script embedded in html page for performing the queries.

The DataBase access allows you to perform queries on the SQL Tables of the Database.

There are 4 tables.

The Host table that contains the Hosts defined in the directory. This table is filled by the Import tool.
The Network table that contains the network defined in the directory. This table is filled by the Import tool.
The Event table that contains the events received since the LoriotPro and ODBC starting
The Netflow table that contains the data collected by the Netflow collector plug-in

The PHP scripts dedicated to the Loriotpro Table queries are available in the directory bin/www/www.

Warning : The PHP interpreter should be installed and configured else this option will not work. Install PHP before using

Accessing the Database

The home page of the LoritoPro WEB server has a menu with the option Database. Clicking on it will displays the Query tool.

Database access from a WEB navigator

A new window is open with 4 buttons that gives you access to the various tables.

LoriotPro WEB access window

Working on Host Table

The Host table that contains the Hosts defined in the directory. This table is filled by the Import tool.

If we choose the Host� button a frame is added to the window with a multi criterium selection.

If you perfom a query without changing any options, you will see the first 50 records of the Host table. By default the Table display the IP address, the host name and the MAC address.

The result is displayed in the third frame.

You can also apply a filter on the column contents. You can select a filter based on IP address, Host name and MAC address.

Example with a filter on the Host name

Working on Network Table

The Network table that contains the network defined in the directory. This table is filled by the Import tool.

If you perfom a query without changing any options, you will see the first 50 records of the Network table.

The Network table provides the following columns

l_network_id	IP address of the network
l_mask	IP Network Mask
l_name	Network Name define in the directory
l_ifdesc	Interface Description (router on which the network is attached)
l_iftype	Network type
l_speed	Speed of the link in bits/s

You can also apply a filter on the column contents.

Working on Event table

The Event table that contains the events received since the LoriotPro and ODBC starting.

If we choose the Events� button a frame is added to the window with a multi criterium selection.

If you perfom a query without changing any options, you will see the first 50 records of the Event table.

By default the table provides the time and date of the event, the level (severity), the description of the event (l_string), the LoriotPro IP address the has generated the events.

The level is also provided at the begining of the l_string field under its numeric format.

Working on Netflow Table

The Netflow table provide flow statistics collected by the Netflow Collector Plug-in.

Using this table is described in the following document.