Proteggiamo il tuo ambiente digitale da qualsiasi attacco informatico. Sfrutta tutte le potenzialità della piattaforma SGBox!

Gallery

Contatti

Via Melchiorre Gioia, 168 - 20125 Milano

info@sgbox.it

+39 02 60830172

Search another article?

Configure MySQL App

You are here:
< Back

Download and Configure MySQL App

This articles explain how to configure MySQL App in order to retrieve logs from a specifc database table.
Before start here you can see how our database is configured:
Configure MySQL App

Requirements:

  • SGBox version 4.2.5

Go to the application lists from SGBox go to SCM > Applications
Configure MySQL App

Select Vendors Integrations and download the application Log from MySQL
Configure MySQL App

You need to configure the application as follow:
Configure MySQL App

Host: Database IP
Username: SQL user used to login
Password: SQL user's password
Star Date: Initial date to retrieve logs
Timestamp field: The Column name that contain the timestamp
Timestamp table: The table that contain the timestamp
Separate field: Charater used to separate information once retrieved
Query: query used to extract information
DB name: The database name

After configured you need to schedule the application to be executed. See this section to know how to schelude an application.

Once executed you’ll see your logs LM > Analysis > Historical Search
Configure MySQL App

Configure MySQL App

If yuo have more databases or more SQL Server you can clone it and configure a new one.
Configure MySQL App