Database configuration howto

sweetpi

@michbeck100 said in Database configuration howto:

Is it possible to disable some attributes completely from being logged in the database? I would like to exclude the battery attribute of my temperature sensor.

@sweetpi said

All values with expire set to “0” are not written to the database at all. This also applies to the deviceAttributeLogging config.

n3ro

i want to delete some old entries like “No device with the ID “XX” found.” and “Device “Battery” has no attribute with the name “battery_10” found.”. When i use the database-page i get an timeout … is there a trick do do it?

wutu

Can I use the wildcards in attributeName? temperature.* does not work. I have several devices that have several temperatures.
For example:

    {
      "attributes": [
        {
          "name": "temperature.fishtank",
          "topic": "mh/gf/lab/wemosd1r2/fishtank/temperature",
          "type": "number",
          "unit": "°C",
          "acronym": "fishtank",
          "messageMap": {}
        },
        {
          "name": "temperature.freshtank",
          "topic": "mh/gf/lab/wemosd1r2/freshwater/temperature",
          "type": "number",
          "unit": "°C",
          "acronym": "freshwater",
          "messageMap": {}
        },
        {
          "name": "temperature.room",
          "topic": "mh/gf/lab/wd1mini-9/si7021/temperature",
          "type": "number",
          "unit": " °C",
          "acronym": "room",
          "messageMap": {}
        }
      ],
      "xAttributeOptions": [
        {
          "name": "temperature.room",
          "displaySparkline": false
        }
      ],
      "id": "fishtank-temp",
      "name": "Temperature",
      "class": "MqttSensor"
    }

leader21

you could try it with this one for the fishtank-temp device to log all data with this id.
with the below example, you need to create a database entry for each device.
if a wildcard is possible i cannot tell, but maybe @sweetpi can ?

    {
       "deviceId": "fishtank-temp", 
       "attributeName": "*", 
       "type": "number",
       "interval": "5min", 
       "expire": "1y"
     }

Orki

Is it possible to read out the pimatic database via Grafana as it offers MySQL and now Microsoft SQL Server datasource features? Sorry for the noob question as i am still new to databases but i guess the answer to my question would be “no” as pimatic isnt offering a database server ? I am just trying to find a way to get the pimatic database file into grafana as i don´t want to feed all the pimatic data in my influx db and having twice the data…

Dan

@orki You could opt for using MySQL as DB platform (Installed either on the Pimatic server or remote), which is more flexible for remote access. Also see here. Hope this gets you underway!

Example section for config.json:

"database": {
      "client": "mysql",
      "connection": {
        "host": "<ip or dns name of DB server>",
        "user": "<user_with_db_admin",
        "password": "<db_admin_password>",
        "database": "<db-name>"
      },
      ...............

All you would need to do is install MySQL Db server, and configure an empty database, and a user with suffient privileges, and allowed to access from the localhost or local subnet.