Unable to store data in DB

[Maciej Nawojczyk]

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? 🙂
:

[Maciej Nawojczyk]

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.”

[admin]

Hi
Please go to your device in logs section remove related config from MikroTik device.
is system > Logging
all logs with prefix mikrowizard

in 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.

[Maciej Nawojczyk]

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. 🙁

[admin]

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.

[Author]

Posts