Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error saving in-memory database, unable to open data/mosquitto.db.new for writing. #6

Open
PapaErde opened this issue Aug 1, 2022 · 0 comments

Comments

@PapaErde
Copy link

PapaErde commented Aug 1, 2022

First of all: Tnx for this addon, it will hopefully solve many probs with the AWS, sureflap is using.
I did the step-by-step installation @https://pethublocal.github.io/ on a raspi running the latest hass.io with mosquitto broker and pethublocal addon. this ist the pethublocal-output:

s6-rc: info: service s6rc-oneshot-runner: starting
s6-rc: info: service s6rc-oneshot-runner successfully started
s6-rc: info: service fix-attrs: starting
s6-rc: info: service fix-attrs successfully started
s6-rc: info: service legacy-cont-init: starting
cont-init: info: running /etc/cont-init.d/mosquitto.sh
cont-init: info: /etc/cont-init.d/mosquitto.sh exited 0
s6-rc: info: service legacy-cont-init successfully started
s6-rc: info: service legacy-services: starting
services-up: info: copying legacy longrun mosquitto (no readiness notification)
services-up: info: copying legacy longrun pethublocal (no readiness notification)
s6-rc: info: service legacy-services successfully started
[05:29:26] INFO: Username xxx
[05:29:26] INFO: Password xxx
INFO:pethublocal:Config file pethubconfig.json found, ready to start
INFO:pethublocal:Start Pet Hub Local - Always blow on the pie, safer communities together
INFO:pethublocal:Serve: Starting Server
INFO:pethublocal:Loading Config file pethubconfig.json
INFO:pethublocal:Starting HTTP Server
DEBUG:asyncio:Using selector: EpollSelector
INFO:pethublocal:MQTT: Init MQTT Host 127.0.0.1
INFO:pethublocal:Starting HTTPS Server
INFO:pethublocal:Error "[Errno 111] Connection refused". Reconnecting in 3 seconds.
[05:29:32] INFO: Starting Pet Hub Local mosquitto MQTT broker...
1659238172: Warning: Mosquitto should not be run as root/administrator.
1659238172: mosquitto version 2.0.14 starting
INFO:pethublocal:MQTT: Init MQTT Host 127.0.0.1
DEBUG:pethublocal:HAInit - Last Init Time: 1659070683
INFO:pethublocal:MQTT: Initialise Home Assistant entities
DEBUG:pethublocal:HA_INIT: Topic:homeassistant/sensor/pethub/H008-0293485_Hub/config Message:{"name": "Leohub", "ic": "mdi:radio-tower", "uniq_id": "H008-0293485_Hub", "stat_t": "pethub/ha/H008-0293485_Hub/state", "val_tpl": "{{value_json.State}}", "json_attr_t": "pethub/ha/H008-0293485_Hub/state", "avty_t": "pethub/ha/H008-0293485_Hub/state", "avty_tpl": "{{value_json.Availability}}", "device": {"ids": "0000801F1299BAC4", "name": "Leohub", "sw": 2, "mdl": "Hub", "mf": "Pet Hub Local"}}
DEBUG:pethublocal:HA_INIT: Topic:homeassistant/sensor/pethub/H008-0293485_8CC8E8FEFF121F80_battery/config Message:{"name": "Front-Haustür Battery", "ic": "mdi:battery", "uniq_id": "H008-0293485_8CC8E8FEFF121F80_battery", "stat_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "val_tpl": "{{value_json.Battery}}", "json_attr_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "avty_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "avty_tpl": "{{value_json.Availability}}", "device": {"ids": "8CC8E8FEFF121F80", "name": "Front-Haustür", "sw": 2, "mdl": "PetDoor", "mf": "Pet Hub Local"}}
DEBUG:pethublocal:HA_INIT: Topic:homeassistant/switch/pethub/H008-0293485_8CC8E8FEFF121F80_keepin/config Message:{"name": "Front-Haustür KeepIn", "ic": "mdi:door", "uniq_id": "H008-0293485_8CC8E8FEFF121F80_keepin", "stat_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "val_tpl": "{{value_json.KeepIn}}", "json_attr_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "cmd_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/KeepIn", "avty_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "avty_tpl": "{{value_json.Availability}}", "device": {"ids": "8CC8E8FEFF121F80", "name": "Front-Haustür", "sw": 2, "mdl": "PetDoor", "mf": "Pet Hub Local"}}
DEBUG:pethublocal:HA_INIT: Topic:homeassistant/switch/pethub/H008-0293485_8CC8E8FEFF121F80_keepout/config Message:{"name": "Front-Haustür KeepOut", "ic": "mdi:door", "uniq_id": "H008-0293485_8CC8E8FEFF121F80_keepout", "stat_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "val_tpl": "{{value_json.KeepOut}}", "json_attr_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "cmd_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/KeepOut", "avty_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "avty_tpl": "{{value_json.Availability}}", "device": {"ids": "8CC8E8FEFF121F80", "name": "Front-Haustür", "sw": 2, "mdl": "PetDoor", "mf": "Pet Hub Local"}}
DEBUG:pethublocal:HA_INIT: Topic:homeassistant/switch/pethub/H008-0293485_8CC8E8FEFF121F80_curfew/config Message:{"name": "Front-Haustür Curfew", "ic": "mdi:door", "uniq_id": "H008-0293485_8CC8E8FEFF121F80_curfew", "stat_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "val_tpl": "{{value_json.Curfew}}", "json_attr_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "cmd_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/Curfew", "avty_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "avty_tpl": "{{value_json.Availability}}", "device": {"ids": "8CC8E8FEFF121F80", "name": "Front-Haustür", "sw": 2, "mdl": "PetDoor", "mf": "Pet Hub Local"}}
DEBUG:pethublocal:HA_INIT: Topic:homeassistant/sensor/pethub/H008-0293485_8CC8E8FEFF121F80/config Message:{"name": "Front-Haustür", "ic": "mdi:door", "uniq_id": "H008-0293485_8CC8E8FEFF121F80", "stat_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "val_tpl": "{{value_json.State}}", "json_attr_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "avty_t": "pethub/ha/H008-0293485_8CC8E8FEFF121F80/state", "avty_tpl": "{{value_json.Availability}}", "device": {"ids": "8CC8E8FEFF121F80", "name": "Front-Haustür", "sw": 2, "mdl": "PetDoor", "mf": "Pet Hub Local"}}
DEBUG:pethublocal:HA_INIT: Topic:homeassistant/sensor/pethub/040-098100478884/config Message:{"name": "Festos", "icon": "mdi:cat", "uniq_id": "040-098100478884", "stat_t": "pethub/ha/040-098100478884/state", "json_attr_t": "pethub/ha/040-098100478884/state", "val_tpl": "{{value_json.State}}", "device": {"ids": "040-098100478884", "name": "Festos", "sw": "v2.0", "mdl": "Cat", "mf": "Pet Hub Local Pet"}}
DEBUG:pethublocal:HA_INIT: Topic:homeassistant/sensor/pethub/040-098100479035/config Message:{"name": "Lentas", "icon": "mdi:cat", "uniq_id": "040-098100479035", "stat_t": "pethub/ha/040-098100479035/state", "json_attr_t": "pethub/ha/040-098100479035/state", "val_tpl": "{{value_json.State}}", "device": {"ids": "040-098100479035", "name": "Lentas", "sw": "v2.0", "mdl": "Cat", "mf": "Pet Hub Local Pet"}}
DEBUG:pethublocal:HA_INIT: Topic:homeassistant/sensor/pethub/040-098100472463/config Message:{"name": "Wallace", "icon": "mdi:cat", "uniq_id": "040-098100472463", "stat_t": "pethub/ha/040-098100472463/state", "json_attr_t": "pethub/ha/040-098100472463/state", "val_tpl": "{{value_json.State}}", "device": {"ids": "040-098100472463", "name": "Wallace", "sw": "v2.0", "mdl": "Cat", "mf": "Pet Hub Local Pet"}}
DEBUG:pethublocal:HA_INIT: Topic:homeassistant/sensor/pethub/040-098100479228/config Message:{"name": "Nelson", "icon": "mdi:cat", "uniq_id": "040-098100479228", "stat_t": "pethub/ha/040-098100479228/state", "json_attr_t": "pethub/ha/040-098100479228/state", "val_tpl": "{{value_json.State}}", "device": {"ids": "040-098100479228", "name": "Nelson", "sw": "v2.0", "mdl": "Cat", "mf": "Pet Hub Local Pet"}}
DEBUG:pethublocal:HA_INIT: Topic:homeassistant/sensor/pethub/040-098100503497/config Message:{"name": "Zotti", "icon": "mdi:cat", "uniq_id": "040-098100503497", "stat_t": "pethub/ha/040-098100503497/state", "json_attr_t": "pethub/ha/040-098100503497/state", "val_tpl": "{{value_json.State}}", "device": {"ids": "040-098100503497", "name": "Zotti", "sw": "v2.0", "mdl": "Cat", "mf": "Pet Hub Local Pet"}}
DEBUG:pethublocal:HA_INIT: Topic:homeassistant/sensor/pethub/1658bbf01756/config Message:{"name": "1658BBF01756", "icon": "mdi:alien", "uniq_id": "1658bbf01756", "stat_t": "pethub/ha/1658bbf01756/state", "json_attr_t": "pethub/ha/1658bbf01756/state", "val_tpl": "{{value_json.State}}", "device": {"ids": "1658bbf01756", "name": "1658BBF01756", "sw": "v2.0", "mdl": "Alien", "mf": "Pet Hub Local Pet"}}
DEBUG:pethublocal:HA_INIT: Pet Topic:pethub/ha/H008-0293485_Hub/state Message:{"Availability": "online", "State": "Online", "Uptime": "0 Mins", "Name": "Leohub", "Reconnects": "0", "Serial": "H008-0293485", "MAC Address": "0000801F1299BAC4", "LED Mode": "BRIGHT", "Pairing Mode": "DISALBED"}
DEBUG:pethublocal:HA_INIT: Pet Topic:pethub/ha/H008-0293485_8CC8E8FEFF121F80/state Message:{"Availability": "online", "State": "Unlocked", "Battery": "6.3825", "KeepIn": "OFF", "KeepOut": "OFF", "Curfew": "OFF", "Curfews": "12:01-12:02"}
DEBUG:pethublocal:HA_INIT: Pet Topic:pethub/ha/040-098100478884/state Message:{"State": "Outside"}
DEBUG:pethublocal:HA_INIT: Pet Topic:pethub/ha/040-098100479035/state Message:{"State": "Inside"}
DEBUG:pethublocal:HA_INIT: Pet Topic:pethub/ha/040-098100472463/state Message:{"State": "Inside"}
DEBUG:pethublocal:HA_INIT: Pet Topic:pethub/ha/040-098100479228/state Message:{"State": "Outside"}
DEBUG:pethublocal:HA_INIT: Pet Topic:pethub/ha/040-098100503497/state Message:{"State": "Outside"}
DEBUG:pethublocal:HA_INIT: Pet Topic:pethub/ha/1658bbf01756/state Message:{"State": "NoDoor"}
DEBUG:pethublocal:Generate Message Hub:H008-0293485 Product:3, Operation:SETTIME
DEBUG:pethublocal:Generate Message Hub:H008-0293485 Product:3, Operation:GETBATTERY
INFO:pethublocal:MQTT: Topic filter: pethub/hub/+/messages/+
INFO:pethublocal:MQTT: Topic filter: pethub/hub/+/messages
INFO:pethublocal:MQTT: Topic filter: pethub/ha/+/KeepIn
INFO:pethublocal:MQTT: Topic filter: pethub/ha/+/KeepOut
INFO:pethublocal:MQTT: Topic filter: pethub/ha/+/Curfew
INFO:pethublocal:MQTT: Topic filter: v2/production/+/messages/+
INFO:pethublocal:MQTT: Topic filter: v2/production/+/messages
INFO:pethublocal:Client: Start
INFO:aiohttp.access:127.0.0.1 "GET /socket.io/?transport=polling&EIO=4&t=1659238186.44132 HTTP/1.1" 200 289 "-" "Python/3.10 aiohttp/3.8.1"
INFO:pethublocal:SIO: Connect eQCvRE0L4msYK9NSAAAB
INFO:pethublocal:Client: Connected
INFO:pethublocal:Client: SID nHt7iRuYOMnnEXwiAAAA

1659238172: Config loaded from /etc/mosquitto/mosquitto.conf.
1659238172: Opening ipv4 listen socket on port 1883.
1659238172: Opening ipv6 listen socket on port 1883.
1659238172: Opening ipv4 listen socket on port 8883.
1659238172: Opening ipv6 listen socket on port 8883.
1659238172: Connecting bridge PetHubLocal (addon_core_mosquitto:1883)
1659238172: mosquitto version 2.0.14 running
1659238175: New connection from 127.0.0.1:50507 on port 1883.
1659238175: New client connected from 127.0.0.1:50507 as PetHubLocal (p2, c1, k60).
1659239972: Saving in-memory database to data/mosquitto.db.
1659239972: Error saving in-memory database, unable to open data/mosquitto.db.new for writing.
1659239972: Error: No such file or directory.
1659241773: Saving in-memory database to data/mosquitto.db.
1659241773: Error saving in-memory database, unable to open data/mosquitto.db.new for writing.
1659241773: Error: No such file or directory.
1659243574: Saving in-memory database to data/mosquitto.db.

more interesting stuff from the mosquitto broker addon
1659356121: Saving in-memory database to /data**//**mosquitto.db.

don´t mind the timestamps. log from pethublocal was captured earlier. but mind the double slash in the mosquitto broker log.
any help is very appreciated.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant