mqtt_logger:repository

Repository

The default repository type is SQLite, it works very well with a small amount of data. For high-load systems, we recommend using different database type

  • SQLite
  • Postgres
  • MySQL
  • MariaDB
  • Microsoft SQL Server
  • Oracle
  1. Set ENABLE_SECURITY=0
  2. Set RUN_SQL_SCRIPTS=1
  3. Set Set CONNECTION_TYPE, DB_USER, DB_PASS, DB_NAME, DB_HOST, DB_PORT, DB_INSTANCE to appropriate values
  4. Restart MQTT Logger
  5. Recreate/Enable Groups
  6. Recreate/Enable Users
  7. Set ENABLE_SECURITY=1
  8. Restart MQTT Logger

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • mqtt_logger/repository.txt
  • Last modified: 16/04/2022 12:09
  • by admin