mqtt2sql.conf

# Optional configuration file for mqtt2sql
#
# Use it with parameter -c or --configfile, e.g.
# mqtt2sql.py -c my.conf
#
# Allowed parameters:
# All parameter starting with double dashes '--' from command line
# see mqtt2sql -h for details
#
# Parameter given here can be overwritten by command line parameters.
# Parameter grouping by [] are optional for better reading and ignored.
#
# For detailed configuration file syntax:
# see https://pypi.python.org/pypi/ConfigArgParse


[DEFAULT]
# optional logfile [string]
#logfile = /var/log/mqtt2sql.log

# debug output
#debug

# verbose output
#verbose


[MQTT]
# MQTT conection URL [string]
mqtt = mqtt://mqttusername:mqttpassword@localhost:1883/#

# MQTT topics subscribe to [string] or [array]
#mqtt-topic = [topic1/#, topic2/+/sub/#, topic3/#]

# MQTT cafile [string]
# if MQTT server uses an official cert you can use an official ca
#mqtt-cafile = /etc/ssl/certs/ISRG_Root_X1.pem

# MQTT certfile [string]
#mqtt-certfile =

# MQTT keyfile [string]
#mqtt-keyfile =

# MQTT suppress TLS verification (default False) [bool]
#mqtt-insecure

# MQTT keepalive timeout for the client (default 60) [integer]
#mqtt-keepalive = 60

# MQTT timeout for mqtt connection in ms (default 500) [integer]
#mqtt-connect-timeout = 500

[SQL]
# SQL server type ['mysql', 'sqlite'] (default 'mysql')  [string]
sql-type = mysql

# SQL host to connect (default localhost) [string]
sql-host = localhost

# SQL port to connect (default 3306) [integer]
#sql-port = 3306

# SQL username [string]
sql-username = sqlusername

# SQL password [string]
sql-password = sqlpassword

# SQL database to use [string]
sql-db = mqtt

# SQL table to use (default 'mqtt')  [string]
sql-table = mqtt

# SQL maximum number of simultaneous connections (default 50) [integer]
#sql-max-connection = 50

# maximum number of SQL connection retries on error [integer]
#sql-connection-retry = 10

# start delay between SQL reconnect retry (default 1) [float]
# is doubled after each occurrence
#sql-connection-retry-start-delay = 1

# maximum number of SQL transaction retry on error (default 10) [integer]
#sql-transaction-retry = 10