-193-
v7.3
Tools
Meshlium
X
treme
15.6.3. Local database
Meshlium has a MySQL database up and running which is used to store locally the information captured. In the
“
Local Data Base
” tab you can see the connection parameters.
A service in Meshlium will read periodically the GPS to gather location and will store it in the local database.
•
Database:
MeshliumDB
•
Table:
gpsData
•
IP:
localhost
•
Port:
3306
•
User:
root
•
Password:
libelium2007
Figure: Local database for GPS data
At any time you can see the last “x” records stored, filtered by access points or clients. Just set how many and what
kind of insertions you want to see and press the “Show data” button. The maximum number of data to display is
500.
The data from the database can be deleted pressing the button “Delete all data”. Be careful, as this option deletes
all the information of Bluetooth scans in the local database.
There is an option to program an automatic purge in the database every day, keeping the information in the
database the days you specify. Furthermore, if you intend to configure the external database, you can choose if
you want to delete only synchronized data or everything, taking care of the days established before.
