Telegram chatbot Contact
Mqtt Manual for IONA

MySQL IONA

Exploring the Essentials of MySQL Communication




















Accessing IONA's MySQL Database

IONA uses a MySQL database to store its real-time reading records. Direct connection to this database facilitates the integration of data into third-party systems and enables in-depth analysis without intermediaries.

Steps to Connect

  1. Get IONA's IP Address: Identify IONA’s IP address on your local network, accessible through the device’s settings or by performing a network scan.
  2. Connection Parameters: The default user and password details are as follows:
    • Host: IONA's IP address
    • Port: 3306 (standard MySQL port)
    • User: ditel
    • Password: default_0101

    Example command-line connection:

    mysql -h [IONA_IP_ADDRESS] -P 3306 -u ditel -p

  3. Data Table: LOGs: The database contains a table named LOGs, which stores the readings and device details. The available fields in this table are:
    • serialNumber: Device's serial number
    • temperature: Temperature recorded by the sensor
    • humidity: Humidity level detected
    • date: Timestamp of the reading
    • MAC: MAC address of the sensor
    • battery: Device's battery status
    • signal: Bluetooth signal strength in dBm
  4. SQL Query Examples: Below are some example queries for extracting specific data:
    • Get all current readings:
      SELECT * FROM LOGs;
    • Filter readings by specific serial number:
      SELECT * FROM LOGs WHERE serialNumber = '[SERIAL_NUMBER]';
    • Get readings within a date range:
      SELECT * FROM LOGs WHERE date BETWEEN '[START_DATE]' AND '[END_DATE]';

Security Considerations

The database access provided by IONA is configured with read-only permissions, ensuring that users can view data without the risk of modifying or altering it. It is still advisable to keep the user credentials secure and limit access to trusted devices when possible.

Integration Applications

This advanced option allows flexible integration into monitoring systems, trend analysis, and other platforms. From temperature and humidity control to monitoring the device’s signal and battery status, direct access to the database enables IONA’s functionality to be fully utilized in customized systems.

This approach is designed for users with technical knowledge of databases who seek to maximize the customization of IONA’s integration within their environments.

Enhanced Data Visualization Options

For users who prefer a more visual interface for viewing and managing IONA’s data, we recommend using database tools like DBeaver or SQLYog. These tools provide a user-friendly experience with features like graphical query building, data visualization, and easy filtering of records, making it simpler to interact with the stored readings without needing advanced SQL knowledge.

Both DBeaver and SQLYog allow you to securely connect to IONA’s MySQL database with read-only access, ensuring that you can explore and analyze the data in an intuitive way. These tools are especially useful for monitoring trends, filtering specific device readings, and enhancing overall data accessibility.