Using External Database

Introduction

LoriotPro can store some of its information in any ODBC compliant SQL Database.

The LoriotPro WEB remote access can access this database (this functionnality requires a MySQL database and the PHP interpreter).

The data that can be save in the database are:

• The hosts of the Directory
• The networks of the Directory
• The events
• Cisco Netflow data collected by the Cisco Netflow Collector plug-in

Remark:LoriotPro do not provide a Database service but will support ODBC drivers provided with your preferred Database Engine.

Open Database Connectivity (ODBC) is a widely accepted application programming interface (API) for database access. It is based on the Call-Level Interface (CLI) specifications from X/Open and ISO/IEC for database APIs and uses Structured Query Language (SQL) as its database access language.

Warning : This support has been tested with a MySQL Database. Normally other database engine should work but we will not provide support on them.

Installation steps

The installation steps that should be followed are:

• DataBase server Installation and configuration
• Creation of the loriotpro database
• ODBC driver installation and configuration (the configuration can be done from LoriotPro)
• LoriotPro ODBC server parameters setting and table initialisation
• php interpreter and ISAPI dll installation (for Web remote access and SQL queries)

Software requirements

As we mentionned previously a Database server is required and the PHP language.

We do not have tested LoriotPro with all existing Database and ODBC associated drivers.

We have mainly focused on the MySQL Database in version 3 and 4.

We use the PHP 4 version. PHP 5 is also available but not yet tested with our PHP scripts.

For those that are not acustomed with Open Source Program, we recommend to use the EASYPHP package that will install the necessary software. This package contains the Apache WEB server, PHP script interpreter, the MySQL server Database engine and PhpMyAdmin a tool written in PHP that will help you to manage MySQL Database.

Remark: Apache and phpMyAdmin are not required by LoriotPro. LoriotPro provides its own WEB server and do not rely on an external WEB server.

You can download EasyPHP from:

http://www.easyphp.org/telechargements.php3

This table list the current available version of EasyPHP and its underlying softwares.