Home page › Forums › Technical Support, Bugs and Fixes › Unable to store data in DB
- This topic has 4 replies, 2 voices, and was last updated 3 days, 19 hours ago by
admin.
- AuthorPosts
- May 26, 2025 at 9:07 pm #8476
Hello Guys,
first of all, I would like to thank you for all your hard work. I’m really looking forward to start using MikroWizard 🙂
I have problem with logging anything and storing it in DB. After adding first device, all I get in Device Logs is error “Unable to store data in DB” from Data Puller. I’ve tried installing Mikrowizard by docker, docker-compose and also manually. Every time I’m getting this error.
I checked connection with Postgres – by pgAdmin – I can access database with credentials used while installing.
I checked config file – credentials are all right.Would anyone have idea, what am I doing wrong, or what can I do to get rid of this error ans start collecting data? 🙂
: - May 26, 2025 at 10:32 pm #8477
I looked on logs from /app and found out that all logs from routers are beeing received, but repetitively I can see error:
“PROD ERR -WORKER@ 260525-22:17:07 syslog.py **device id mismatch
PROD ERR -WORKER@ 260525-22:17:07 syslog.py system,info,account mikrowiz: user mikrowizard logged out from 192.168.x.x via api
PROD ERR -WORKER@ 260525-22:17:08 util.py Invalid input of type: ‘bool’. Convert to a bytes, string, int or float first.”- May 29, 2025 at 4:59 pm #8478
Hi
Please go to your device in logs section remove related config from MikroTik device.
is system > Logging
all logs with prefix mikrowizardin system > Logging > Action
action with name mikrowizard*wait 1-2 minute and it should fix. if it is not fixed remove the device from MikroWizard dashboard and scan add again.
- May 31, 2025 at 3:09 pm #8483
Unfortunately, that didn’t fix the problem. A tried deleting logging rules and action for mikrowizard, and after few seconds mikrowizard created new set of rules and action. Error was still not fixed. Then I tried to remove device and add it again. That albo didn’t help.
At the end i removed action and rules, removed device and add it again. But still I’m getting the same error.I added another mikrotik with arm processor (because first one is with tile) and everything works fine. I repeated process with deleting rules and device, added it again but still same error. 🙁
- May 31, 2025 at 4:53 pm #8484
I don’t think it is related to MikroTik device type. The delete add should fix it.
Is your MikroTik devices behind some sort of nat or vpn?
Check if your device don’t have duplicate Mac address in MikroWizard device list.
- AuthorPosts
- You must be logged in to reply to this topic.