Thanks for your reply.
I did as you said, but still the saving just happens once.
Nothing happens later on.
-
Database configuration howto
-
@Andre-Bensch Thanks for reporting. This should be fixed in pimatic v0.8.50.
-
From this thread I learned that for intervals the units are
- s for seconds
- m for minutes
- h for hours
- y for years
Hope this is right. Is there also an unit letter for month?
Would be nice if this thread can ne moved to the how-to section or even better to extend the pimatic doocumentation.
-
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.
pimatic-hap - pimatic HomeKit bridge
pimatic-echo - Amazon echo integration
pimatic-dash-button - Amazon dash button support
pimatic-alarm - pimatic alarm system
Like my work? Then consider a donation
Follow me: https://twitter.com/michaelkotten -
@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.
-
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?
pimatic + MySensors + Homeduino + z-way
https://github.com/n3roGit/MySensors_n3ro -
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" }
Pimatic = Smart Home
-
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" }
pimatic v0.9 has been released!
Support Pimatic and get some free stickers
Like us on Facebookmake it so !
-
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…
-
@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.
"Screw the captain. It's the engineer running the ship!"
pimatic-telegram, pimatic-tts, pimatic-woox, pimatic-lg-smart-tv, pimatic-spotify, pimatic-wakeuplight and some not-announced plugins