Over 10 years we help companies reach their financial and branding goals. Engitech is a values-driven technology agency dedicated.

Gallery

Contacts

411 University St, Seattle, USA

+1 -800-456-478-23

Home page Forums Technical Support, Bugs and Fixes Unable to store data in DB

Currently, there are 0 users and 1 guest visiting this topic .
Viewing 3 reply threads
  • Author
    Posts
    • #8476
      Maciej NawojczykMaciej Nawojczyk
      Participant

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

      • #8477
        Maciej NawojczykMaciej Nawojczyk
        Participant

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

          • #8478
            adminadmin
            Keymaster

              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.

          • #8483
            Maciej NawojczykMaciej Nawojczyk
            Participant

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

            • #8484
              adminadmin
              Keymaster

                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.

            Viewing 3 reply threads
            • You must be logged in to reply to this topic.